# [03-Dec-2024 10:38:26] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2024 10:38:32] /finance/root/bg/ajax/invoices/form/clone/2369.html?pid=2369&_=1733215112774 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2369
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Dec-2024 10:38:37] /finance/root/bg/ajax/invoices/insert.html?_=1733215117953 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `invoices` WHERE `Type` > 0 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2383', `Language` = 'bg', `PostDate` = '2024-12-03', `LastUpdate` = '2024-12-03 10:38:37', `Type` = '1', `ParentID` = 0, `Data` = '9sqIgROyLeswgDNr-b7obpKrxdIUqpGEUh5TychfDxjVB70uiOoRWg-IdNi5m61htJGGZ2O-MRWhWSJ0_MITail0Fc9WC_09KAhNFtnASaeVZS6MUl4JQ-3Fp4ywPVzHN-o-3pJop6X6xZUT9iSbnIfbG78XURFSAiM_CnvdGKJ1q8RK_KVCcQC64EvupkG2WtaH7gxw6ZLTi30szuj4zKQKWBdzeszaQpSkIqk2t7qaTug6jO1q1jEoJT7T5VBrtCRxfDRPl78VF24xaFU-YM216V7cC4_bsfkXjyAeXJEW7XNPbJusM35butLW6m8mlRFZkClGEKmhy53yd9wwpf3VGYIiqk23-G35hBELooVZ-XbsGN-EEIHvXNrh8VqZUZ8x8GRXgYPeNh3MborG2q3-Z6lggp1393EMe-6ITkj42KA_yYYE6JJdx1UkFKvKhfSBrlu0YzD7a_PB70fFU0TNdYS5-ptD18fGW7N2DDvi6ImqzzTS7o2rpKuW9l0D2gxmLrJ-9Gmc19sEqU6gUn4pUC7xS7GNvF0qTqH4nmYLgoG4QV63hObjwsIEQZkJdAZTVGTxUbtvgdLe03sqflOS_vf2oXlFCfs7dnEzWVlkaLB78b1fjCit-1ycYmQwG3QJrRPcPGyEoHnowjMAucmtq2aAEOCH1IM-88bi-8vB2a9ruCCtPEu-Tc2DqvjMqFpMMZBTppyq36wK-W-t7ECJ-cp_h5tupxKUyyne9rVLIZ8_e_J8BSkXGPhj4mA2F1eaf8rHgKmX5uCepSjv_lxKrG7XmH6Os7JK0gTQpjuJkd6ELV2RyYi5_hQFYXPEzqovb0Cnxcp-MQU88daJppvN8laMp8x0BANMxWYoOXB6AyMJQseC9z-zIUzMtpZvhr93Uf6UZe9Kcx3MeTB2wfln4xL3U8MKEkZdsWssMgjoIq-xdAFjw-HQRKJU59YJp3PJnBW1ATApXzUKyo13aRLXiTXmrF-_SV1h6LXBFbo', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM'
# [03-Dec-2024 10:38:37] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2024 10:38:40] /finance/root/bg/invoices/2383.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2383
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Dec-2024 10:38:51] /finance/root/bg/ajax/invoices/form/2383.html?_=1733215131662 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2383
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 1 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [03-Dec-2024 10:38:58] /finance/root/bg/ajax/invoices/update/2383.html?_=1733215139023 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2383' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2383bg', 'XTcmdUJ2Z-ClhdZGFDpGur2hgcmKrZpSyH441c6yhZjlRruVM9qOz8Bi-rR5RmY6BshKAebZDpaSVOot1MoTKHu4zGFM0HLJ-dJg3TxPAC2eoEeNCv-amF3aRgpcilFVqgLPevwTG_AlInP7cQ8lKfK7ufZBWllRjE35cDebm3T9GM06JjlWoXahMATA216R_ZGmCL0ydLWvgQMocHIn6wW6CQtjwGqtl8Zohho-SXWvwjeZa946y9ZcVqdbkkl13vBJFNakR2NMtPVMSCdUaAdMlgrJe-opfSZKYoBt3HG8b75_-6vP2CcMXfTNqdJdD30-rjItyKUD8jnhEGCD4vjaod2efZx2vPTWYjLrGgoUGNvcaULr8hlaG637rPhr4bVZphh6jNbP7cO_R3lSAMS3lJVRWQm2Bfwo39st9kRgQCXzJ0GQlCF7JcI6kIbnOPFsiQq9DTGRCDDA3ubEOdtnmKrwTm1J-F-Ms9Zx0NPS2ioZV-UdUOBdPwgmPJ8IwTlFHXTU92_fxrlvXSvYXkoeIAHV6dHmBS4Aa6hs90F9yu2ExZkYzqhncuY1_Pt_lAIzViLk_nbGdkNHR7j9A3vMDxjKkgwcN7YLqrTo2YCjqbLVUJXillpBmlRokgnPAfOdF6jijDs3JiuokCAmhBfaijpnsc_3aVXb3hqaxA39GkBtev6io9fFZwffYSBOlIyUF_YJYBY1bdtsZdsYmoLHcXJ8NNWhvZCjILWEAYa4Oi3Pc3lkC1YEK2D-9Nf2-QOL0wgCdvP8j_pknp8nH5YZDxpxMlEM-2Fa589u_JWWs6-aJB2RrCXjFIITUiPqpbkPewsYnGMH7dGGlL5ybL-PJYB0JbO7xj7j0YKGYOX84VSb2n3xJwgzgrK3uBshlipRNHPEvOumfvTvoqmJy6D0DKFnfJtl2M87Z9YETQgxguB_nokxskGFuC5Rk8bCXHgkii6mtioDSOXyICMh2DXU4bt9dY_vd2V-HZrWyPzVC59Kfa65VRXN99y5RaQyvjzaHj_gZhTDpmSZHA0N5-8Q2QFq1K-LkJcG85cjfkMLEIH9hDT1LMexMnvKF949lZX3MU_gNIq7n7QXhL7X3AXaZPUPoXdiB76rBy4giWV7GX6VCZFriqu1h5y9Epoy5fLR344wjG-ikyxmK0fhEDURvxbWSwAd8QKPK1hEkoZ7q7b5n9wCvjRapO3nxU6IUV8wnekLtcQAquqclmioMoa76-Lnfy3OvwjJukUVmmbDjF-1dP3iF0R9jHDb5nwWeKWx1mNqv4_859fMZkf4nzRxo0qVkvTfI38osGvLZxTaMHvRgkWTMMgga6ZGzBiYViUtsCODbV-yQtchELMk_8uaJNuDhpQRHNVxiRHy99t80c4mZZ8rnz6CDqidFcFp9SJIbgg_smhuoPb4_lRURB7H3tgJaVSgP294YbQ2khfDpaWwFHN8EI4RenlgwXe3FbsA632TO7MPs0hYqBNaPC5-v5SwGfyy_jBny4aWWSGN-bb_vzZu5K8Hv3sVUwcEcH-5-qhY_z1jj3HwospfNqBf0H1NFtRQqSBpoknAvXnhIZW048tA-RFXTN-O1e_FL2D4mqeJ4ukWp8wOxCNR5gMRKkG5mAlLKh_yIZhzkyNNEah9D-tK49jflO-Wk_KkqFMWLdO9hlxBMAWovYRozmd_r3lD9VeiKV4RWR3HA_m1ieBgLDbdTY26IrwYOohuQnoSw0-_jWDx6CMv40iw1X2lPMLacYHNMSHg_ia_qgllOTFMPsoVk-eKYVpyzb7Nt0YzPxv0WhIBDg2YM8j2IzADmf71z1jhBL4lHFM1nBUZgDqarjGpiUN-QaBE2pYOHmDOF7sBPuHslDqMXgT-FeKy9-v_Dm4vXU2-Vn1LTW3FRA1JFb1IxVzR5fWX9CDcUoMGc06gH_ZX0U8Liv-IIA')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2383', `Language` = 'bg', `PostDate` = '2024-12-03', `LastUpdate` = '2024-12-03 10:38:58', `Type` = '1', `ParentID` = 0, `Data` = 's6L-_hiZe1RkQc6-wSHrp7UulD_DBnBOkcQS9BJqGzW_RYEF1zV9A8ppR6deL_l914mW3Uyhc5YCY6EQ-KpZDqcbH3gLoK7Ndsbdm9M09Gg6g7WrL_Zi0jjocJSPoS_3IPYPzlJH9B34Mk3xPZ9uCpO-MiJgTkXx1YBzjbETWaTu9C2Mvjq2w7UHSl0j6Gi0SQeSLZnFwj264mva3AR9ypkLttTtPzYeTGK-_eTZb3nOiltUvpqKbT0MIW496Z15mJTfZ0V0QSv-J8yXjxFTVNyPfQYkNS1tngHGnSxzJgJ3qNBHHvNDD-uUnlri_xfdxoOLzOFg_fj--PLp_dCSKlW1xEwvztFXIi4z5wsa-emOAh5qYcdCWtuGiM36woB8JOBJJfTBEW0tSGC_Cwc1ecrQymixHEoCYu0Hqg-YyKGH6AIUkdPLdj9n3OmGLtk1vmtGtdwP6TFedMTDnISpTW_bZrXGLpmjzTT_423hs0eRwUWKiQnOryu_bmtfMsDkMbf8kKR-T-vaA2q9A4qA1xn-6hxvkry2CGteSN3L3McUwB4woaLhVtbILUNY5exrYKj3P5JhJB8M5LINNcJdrMy_jdhkZYsYjKCqRGK_PsqRJ_en9AaqkRwWL18_azS8r3j_-zJPiMymJzUkUTqjmuop86JH9TT4inWohJPZGW9BwpiDfcpzwzWYy9Fr1bMMU0FscXyU6A-fHLPR8NvO7Z3-iQIBBM3W5M3zZCeJ4ItdAYnMEqw6yhPhIQM-WWPl-Mn3FGSp_a1zIg_1IhFVv7NlyClD5VpRXw-ZywJtPcIyjbrWOo0QIt_UQQBfn4fPZNTamAuvQ_gJht7A8s4LOcNoHSszASPcMLEVnGFzOQEXkfsz_j1jNll8A8keiruifDER-Cuio0KGFcZu643Iq4d6IVV9mCgpglSpT_AtyRtc-6MleoqLMKeKyCCmsj6TWXVqpJe1RoZPNk3jBEabsHGn_cGnql3zoP1PNcPZmJ8', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM' WHERE `ID` = '2383'
# [03-Dec-2024 10:38:59] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [03-Dec-2024 10:39:01] /finance/root/bg/invoices/2383.html 167.99.142.201

set names utf8

SELECT
                `Inv`.*,
                `Original`.`PostDate` AS `OriginalPostDate`
            FROM
                `invoices` AS `Inv`
                LEFT JOIN `invoices` AS `Original` ON `Inv`.`ParentID` = `Original`.`ID`
            WHERE
                `Inv`.`ID` = 2383
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
