# [12-Oct-2023 14:01:20] /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
# [12-Oct-2023 14:01:31] /finance/root/bg/ajax/invoices/form.html?_=1697108491218 167.99.142.201

set names utf8

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
# [12-Oct-2023 14:01:50] /finance/root/bg/invoices/2106.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:01:54] /finance/root/bg/ajax/invoices/form.html?_=1697108514817 167.99.142.201

set names utf8

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
# [12-Oct-2023 14:02:09] /finance/root/bg/ajax/clients/select/type_0.html?keyword=япа&_=1697108529457 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscOPwrDg8KlwqD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscOPwrDg8KlwqD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [12-Oct-2023 14:02:11] /finance/root/bg/ajax/clients/select/type_0.html?keyword=qpa&_=1697108531468 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCsMKyw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCsMKyw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [12-Oct-2023 14:02:45] /finance/root/bg/ajax/invoices/insert.html?_=1697108565725 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 37 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` = '2113', `Language` = 'bg', `PostDate` = '2023-10-12 14:02:45', `LastUpdate` = '2023-10-12 14:02:45', `Type` = '2', `ParentID` = 2106, `Data` = 'AhOxV2zFi9sqtO4Z8NEdy6mulOdGl0BFgZ0Ij0l1XXmOrKLDXEyZp4NfqQMMaUlcNcAneNCuJrcwALfiztrX1gdmBpwgziVUv5rPRbjDFt3McUIUoXD_xDOTBTnzp9TJgs3vWBCe72v93KVnGsQ2xrvEBfvctfubC-oFcE_xztpk3qaeAFvxv3EkV0B4QGvGGyWr6CboUeME2G_m0uBMs7pakAt5hAPUFX6mXg7Ou8vP0moTRc1lUn0dpC_PDvsrP8Xsw1JFcWvSF7rR8KnWuWYVxzkGYkWyKE-qDKqiohBCxhzlST7QewyCkFSU0OiWbSPS36PGfYGvLbP77CBRPpv-truN2_PpUyiWqUoub-AoBrA3ArkSKqZfBBR8I3-nXmqI-TbVIfCdINOFGoDe6lwhC9bnHWt1qWLm4eA1TLD18_ExwuKmPhmSITsxnAJgGc1y9sphxFC983T1Mpt_JqpWyt3cons6G5vaTTU1EC-kHL6pBjmF-DYWCeGt-NokM2DQYIXE-GT89BJELkY6tLh65Zt2jvV8j3KdgqkdAd9PJZNlD0jqbB4SlTfhutVY-pLpWU5k6K9KNmlf6VH-PI9J8_SC9h5rq0OzcMQCTIuGqrWhcfOJC2u1gUyiT7ih1O7_kxF3Rvf8C2tmykn8lh8cz7o7A-PTHUM8mBz9jplVyItFwo4tZVO8Mf0jrKinvyWp0nQf0N-LAMcL-XSyI2gMfVWZ_A_TanmFxnN_xi7Z3VWOMI83IgtImEeQy4WKdUHPsucLPMgFNeDLlDdLpB14xywXYtFWI68q3bN6ZCOq3r0XJ_AmSrP_dRL62M3Nwvo6rVy-LmtIybrTmbFQoOleMv3lf3yJLvOcscBZ1-gWgi-zx-LhRnqipqFxAhh1y_jdSTEd-WFpN4JfQhNV4H8_bYQivXG7Ii9Tq70B2GeswQ-XDHmin_WI4n_0ILjiZVnQkOqQJDRWhAn4hzjns3uB-o_gl7T1KP1ELbWOd3zoEqN3cQfwnNGE52bHjMrb0f2mpFE9t0FX5Yi13lOQRQylVIvPHOHhc3jwCKD6VKU', `SearchKey` = 'wofCpMOiw4DCt8wofCpMOPwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwwofCpMOIwrDg8OgwqCocKDwqTCwrrCsMKyw5bCsMOawrLCpcKtwrDCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwr'
# [12-Oct-2023 14:02:45] /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
# [12-Oct-2023 14:02:48] /finance/root/bg/invoices/2113.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:03:29] /finance/root/bg/ajax/invoices/form/2113.html?_=1697108609747 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2113
            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
# [12-Oct-2023 14:04:38] /finance/root/bg/ajax/invoices/update/2113.html?_=1697108678558 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2113bg', 'FJgl9-fzimZWAkabRY9DLTGSUFT7kPbSKLc09Wdoh-z0g_q3PHNL5LNruAXjs1R3tmWPb1yNFXKc1m1Rs5QTFeCdX_y91zGv5ZA-dZTlGLNW-J2evCIIkNKnkbvwCTZM8IVsdP9RH7hzwjkR03SiAiRkoPquSmeTrzcZR1gLqNU2Y1I2SQYONoHRC09gazIFs924ixxGg40kKa01A1KTB2QDM58G_s1NbZjU0kfO1_FxogbXYnAGzlL59lreYPcCWBWuBO8hM3j3EvUxMbv-LERy17_Go5ORHbwLfZlfjUKOIJq_eeMMooaCSAcPx5dmNnix8G8KmY67YvkuwV0lJyYKmRkN7T9mMJ11rvOqUeB6cXJvw2Hy4Q_lf7vQc_EL5r_xC762kB3-QUrn5YvnYyqIecCOgEcKu4kCO5T36xK_tn9gqrJhCKF7P03ik6zTxhEwz3kWt-6SlqvBYBCUVA-msCscAg_7PiZZpu9wKtdvQhvnHxT2Bx3OhjdJwem0M29StI0WOcBcDTmXUn1sCONrkJd9VTg7dOgnbQqbHhXvccfeVHMJft66BEpLhc7XgOGXmXdWfYhoBnchJcvd-nVoh0ZSEzRNCQmP2n-_x9aQSZNUy4MCuKb4SCZuLoM3UmUFg6QQPD_oUw23r4aQQhYdqrLMJ1eJfE_thecFS4Vdai5nDFMez1MOJtRbCGdyMClzQZJm2EJNldUfmMfoAJN1Qk5RHiELrCps7nvLEbVPHofTh6YkvKkTVQVc8VS0spSz2UU28WsW3VoqG0995jZBAk6dThXU2yfM00yAfXQfoVq_IFNEuWf9Q8axNL_WYmO07OPzliMDSJzTxu7NA_nxp83QmjE2fUGcSrNic7b4qFRa2Bdo2P_Hr6neMhEvnqpfjDJ0bGPiFTiUqDZmOGWfpNgEQ6Tra3ZffOKn3hbcZ0PobdLePwaGWAqqpzUhc_qggH9yuH2hkaKiV4CBQe9ucspqFcENe1oNvc5D7R9eM7Zzvv7P7c9RrQJeQS4wmg5qPl8S8pCy80HZa_eX9x4WUwG1qclcc_cjVKbZ9K9qHP0D9Ek-xhc0n1Qso-sLX8wu9KGXIc_bF6An5QwKh80RxwXQpQaoVm90zb4IBWLLRvY0glkv9eICkmnvU5DEKpE09VN4cVlhyE6hzaDZoMEWxnLGYE6e5Ub34uXXS1q79C0rsCxAV7f6lTkwVg3VFdaNUnL_lhtIzv0S5UVbuBRZ6qqv0P68MKtITMJWhHRVCNf6V9rJb0_zuzcSB8YRe4lr7xw0ZEkUussZrQlj2HlkgHU9V3704Ag8AvtqN5cObMyJH4mhr0Ds6_u5qMHlHfRZMI_rDS8WV8JQ7rkpoDfjrLV-SkKdapWrj0dzdLZJupLnUfX1Y9gwgTkC8RKmxAq7a8mg9VkNGt0fBJAEkRdCVWShn-p37UgJTKCl28Fpr_JhTbsT7hQTqcq6qC8fwoNcGiVAUYkp3L2zRTu5jS7iiR4pyfCQjRUAkjlYBNBFEVAuzxJKTJM69r11HwA5W0TRTMDKe4SAusC0T9FfGBL4ny44FJVdH0GVjHI_FjcfTwdEWN7yJPHUCDrNxj64jSZhpTccabtY_5vTZXlJQ2BMcgx938iMIdV_X2PxXop3Nz_mkrwqkH-0yzjVqxsWrUIMzSy6paxDbgGyvowam1gW_y7DzrpuJYixhOrZzOJa0f8rDS-7QNa1Zbpva0pv9Rf-0ne9QcjVwVe11ilbfzN95k0Xn38V22p0kGgUR3xShtgQF1PVswVL2K7lFSapRX4LN1vcXvGNbLYiTCgJRgDkBBG1f_tZBkTUqEtyrXylm6JnNXKnofoAKRthPjTIeNUyLrt35LEnHvS27bPuXgZAAQqIQlHO0e4PwW63tGVvSGaK-ufNgUSERFOb3kUW7z_ZBNtN32M9Z4E8NR0vPv6K02alUZg4a5ELsSxU8uVqDnXFN1hkE4KxO5tdTlS967Chmmg1zp_fCtI4URF1y1bp1s9Px6RRo4RrvPEuoBrlUq2tmflXxuiC4R26o3o6')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2113', `Language` = 'bg', `PostDate` = '2023-10-12 14:04:38', `LastUpdate` = '2023-10-12 14:04:38', `Type` = '2', `ParentID` = 2106, `Data` = '6V6KOG2HL9_izYTwGFCd0HFEduwgrAs1mWV1wLDLhZpjjc8WZ9_LN2usED6qTLTWXkBfToXEwpYK6IgY9gyPQ7j2Vog8OIihvOSMnMdZUWm99Ert-MHdaMqMMdzXS9uqM_GXvSn1ptRt8xKMHJe6eXzzKTpBkf0z1N5VUyrS-v0ApkPEj8XqUS-Sh28tnEzuhLaKRa74N00roWOEWoF7wXGlYamfdHWPDnLNgj-hVdTpvzXovo9LwNk3ad37TBX_jcSoS-oOZzgJ-tRpzCZhE-3hjn2nkBd6gNHniyji-Lj1Ev62RDRK7yG70T7ZkN7mJIHnXvCvxUr2HPOgcKRe4aA1N0LSUHn9BjApztQ9Edu-whGmDNNUIDMtLg7poClpccnvU2UmJOJ5YqG5AabGh8YWfAsZXptaySoHRHuJx7rVmpP_ygmSdCIWVzztxWeZk0iT1N42aKfsrZcsE-hcUvkA0h5C_Vzvkj030rVIEE7UADfrkhCfrdZt5hK4QKwSNj-g3ZCGLuxl3qZxdoHQCQl-2dz3CV-Cp0ObB3y2-qV0waljtaXjAActOKU6lP2ir8NAvNKgE6-UkITq3HUgMeDqQBSyKGqhyBvjm3sXT67ql4Z0YZ_qLW3pYx77nKYqu7jmNEL_aBZqjfENMC6410vFH4KEAUzT8geLt8ClVZK-gw7IAi2nxcdZWh_bF0u-xSPz720BY_28f1Zw2TutnMfqB99hdZUdA_BfcBJ8_XpfUCvl6r4qygHfyOGlhtIH60hGT2-VSSHQKRMZ3m2Kl54wJgPW77tgNX-mv7NEvIP7IuTw-GnxwZx6B3FqHk9RWkTaxFvCi4T_CbDdltQi3ERD7t4gd-9mN8IacCBqfwotfW8CZx9hvLHRnGUAYJqaosfMamxWqic6yYG3gDPUfDSICrSo5-yhhV9oLHgBmqnuG2giK1QIirGvbsq5CaUkdeAH3zZ0ZPz_zYj2bzFzqw4uTEfsJ7T5vaENuweHpa6I-1OI6wwAVNA8g45VeFlGJaKzEgWSTUC0byYajOlR7MYfq9SJQA-W9DUvOOPlRQE10u9tmQZHE1y6HqmF3bxODqDRUzSLO7rfa-TEe5F57E8r7ye--Tfa7bXVZbA2w3nfRQ_jQequ4xwCNoFan3VpCTml47TfU1zlQ9lq6dxMgP5WvoB_jCDZIWO2yGscmCqBAq7Kfx2LrSQ-vHE0zWlbhKwCeF1YLuUFsi1U0vkK6JLsLw_txj_X4bkpJL-mnJqeePrHmonDOtaL2ro_zq92tuWDh5bR7xTRpNXdzo5i4l0mikct3MmO5ueEQa_5b0kcjjFBA_S19yTEkcIJEgJsDm6SVIdhLAnOi9h3Jkx3pBXeHOm1zB5HCVNfmzECUaXTgAZZqHb2NF6LiH6nqiJFaWmIrXy5y7NowgbzMOF8oMB3W62sGKh-hJIIEqsV44RZk43Hn4GCZKzCV58iYjYLLQdhCrFetcjEyp7vAoAnzxbfgqNFGu6oTevAmrYlrxmkHJWIv7twGNDmEirLbJ4cELYD_P7GjwHukzSCAdNA4NUMbxOXL-NEDOaXvmmENKZhg1Ege6gNSf_6PYp0Os_XDeXy3aduzCNBaGzmK8t_KNyDJFCgwI2LjcFs8D3DYsG3dUWMTAehYN-IJFvSO8sKJmKo7HL_HdBUDHzRvEsoTqxMkcW_WCB2NVXmTC9NdKq_mKS04jysCzXQ9wyIKnnYdteL1G-7u1siQl_47T7DXQ', `SearchKey` = 'wofCpMOiw4DCt8wofCpMOPwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwwofCpMOIwrDg8OgwqCocKDwqTCwrrCsMKyw5bCsMOawrLCpcKtwrDCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwr' WHERE `ID` = '2113'
# [12-Oct-2023 14:04:38] /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
# [12-Oct-2023 14:04:48] /finance/root/bg/invoices/2113.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:14:52] /finance/root/bg/invoices/2113.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`.`ID` = `Original`.`ParentID`
            WHERE
                `Inv`.`ID` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:15:29] /finance/root/bg/invoices/2113.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`.`ID` = `Original`.`ParentID`
            WHERE
                `Inv`.`ID` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:15:33] /finance/root/bg/invoices/2113.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`.`ID` = `Original`.`ParentID`
            WHERE
                `Inv`.`ID` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:16:39] /finance/root/bg/invoices/2113.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` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:17:04] /finance/root/bg/invoices/2113.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` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:19:09] /finance/root/bg/invoices/2113.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` = 2113
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Oct-2023 14:20:54] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT
                    `Inv`.*,
                    `Original`.`ID` AS `OriginalID`
                FROM
                    `invoices` AS `Inv`
                    LEFT JOIN `invoices` AS `Original` ON `Inv`.`ID` = `Original`.`ParentID`
                WHERE
                    `Inv`.`Type` = 0
             ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [12-Oct-2023 14:21:27] /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
# [12-Oct-2023 14:21:30] /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
