# [14-Oct-2024 12:12:55] /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
# [14-Oct-2024 12:13:00] /finance/root/bg/ajax/invoices/form/clone/2347.html?pid=2347&_=1728897178706 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2347
            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
# [14-Oct-2024 12:13:07] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Oct-2024 12:13:08] /finance/root/bg/ajax/clients/form.html?_=1728897187601 167.99.142.201
# [14-Oct-2024 12:14:05] /finance/root/bg/ajax/clients/insert.html?_=1728897244412 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '70', `Language` = 'bg', `LastUpdate` = '2024-10-14 12:14:05', `Data` = 'gSIiE5OHdErb-7dM7ozfj60fpqMzWtoSLxjz8562hML_H0Yqgu8yuAK48atuv7spoSUiIOe_6fbceeYV70U2m5NHeP--IVJkWer_T7a16V-w7x5CspXfc5A3cYpzuD_2G_n42jR1V_h8Zhis7QKiMPNKHQ4nfoCDp6uyZWZGhaeKNvrNnSv3M_2LekudJZekCNwXBtfUq2QlMVtJuECmzUuGk-sebTUHwOG4T7UDOZyp7xXYrjBogzqgY_32M_3JtjbEM7TjVI38_PrQarwoGQcqHtQ1Tj4Aui36b19bqotbPJ3zMCsRSOi8u2LT3w4ppDBie1rYmzgEaCTOxmiK3g', `SearchKey` = 'wrjCn8K2wp7CsMwofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOewrDg8OgwqDq8KDwqTCn8Krw5rCucKhwwofCpMOqwrDgMK6wqCrcKDwqTCsMKrw5rDn8KdwpzChMKuwwqbCnMK9w6bCmsOWwr3CpcKgw5LDj8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-10-14 12:14:05'
# [14-Oct-2024 12:14:05] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Oct-2024 12:14:10] /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
# [14-Oct-2024 12:14:12] /finance/root/bg/ajax/invoices/form/clone/2347.html?pid=2347&_=1728897251625 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2347
            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
# [14-Oct-2024 12:14:16] /finance/root/bg/ajax/clients/select/type_0.html?keyword=hats&_=1728897255102 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 70 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` = '10432', `Language` = 'bg', `PostDate` = '2024-10-14', `LastUpdate` = '2024-10-14 12:14:31', `Type` = '0', `ParentID` = 0, `Data` = 'I_DO9EOJA-G3LI8KBjUL0kFyF_uiE4xQFwzeAMPN2Tl7pqBtzTjJ5X4UWlG7LFvg1HKGsAWhGQbQfu79KfsEesFVj-rhvePwDTvyfOs4xU4uQs7-qpcigL73qBh1bWwNFnXJjukrUrAuQrJHG_WH7vHTyiK_PF07HqO5MdN0pAL8Nrk9aTVdfL2GzR8OEwAokJAt0wl4MQ-t3kWpwEgsg5geD8ybaIrASQPXIj4qLb25tcIlNiNhpFJKMZ2nYpF_S9UjNldhpQxurswUVyrTr6XRzfcYP25Mbu8JR5ASwkH5bXr9oystmHIhuf5FNBgXlUTivq-cEkuX_erm-vNrfB2lzyZ2EhVjIaV5cbDAp4rkN8_xCuhVneINYyBqi_USZn3gfUEYAmUNp5ArysSWWVM86uGZsmwTzPUOCziSpSAGxCUOxbbjEYn8TLEnoMKFDN6i8bwMk6tsf2KP4br2jOJ31-MiQx9GLfu5ZpqhNDPhqX6c1bWnAjpw-WV_2IL1DWZl4hwZTHqFiR4h93J6vRhOGwGGVVZ4IXZZp0mOGx5C6_Jzr3ZmqHVe4A9U1nuunm4t2PEkmoZcxFnnbsRmOH6hSWX5zFa4_yNBSCfUjdTwspfcxJ_5qTX6di-a1k3HV6XMLg_TF2JpOmMs8zlibv7uAtV5UG0sIllJs4xeC_qFv5BD4uvUGZUUrfzejyhMGKLi8dcHZ6JCGCHl49BTw2q6jyYDrcPedezcNC-oTyQ7TLrWvbpsit0O8oJqd-DlfDbprO7ZjDUm0XvNX_967_CX22nUqwNFwIOLsOuEuFNLpcfTrZ_fu1NdwDQ2y6slg554nnx_t4_zem-1v2eN5tKeBlXewzN6AKf2BPynE-0YDp0F7xp4vZMcPtV-vWbgEOttf-fdG1bkv2XDcuE6Jh5kFP7ZQPML3pRenHxyNOU58NZ7s0j8BfauJJYjajlK_-I1wISftjQGLdC8UGfxq88RrpjnwUjHOrQTabfSaABrrwUzT-sbP8TmofbQ6kclpXyvx-yvehoNOQ5Td1RDC278ipz9b3_SdlFKh25UmG7WBx_pQFPnrCnoWWiM8L8F', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrCi8KwwofCscK4wrDgcOQwrPCtcKDwrHCuMKrw5rCucKhwrTChMKhwrzCvMOWw6TCiMOKwp'
# [14-Oct-2024 12:14:31] /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
# [14-Oct-2024 12:14:32] /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
# [14-Oct-2024 12:14:35] /finance/root/bg/invoices/10432.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` = 10432
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Oct-2024 14:41:07] /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
# [14-Oct-2024 14:41:13] /finance/root/bg/ajax/invoices/form/2351.html?_=1728906072359 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2351
            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
# [14-Oct-2024 14:41:34] /finance/root/bg/ajax/invoices/update/2351.html?_=1728906093218 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 = '2351' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2351bg', 'YB7bSTltzDcgm9OMJ_fdUQNSMxJuGY3MucEeul2BhZwSCI5Tp4dDYHJdD5Qu-MSk4mwtMHF2jn0wVaXLnIfNr33OgBPOJBBM_Hk1L4y_Y5h_jBa6C4IsPFhGGghQlaaS6A0ZU_nE7qPEy_qeDruQ-_Y5FwAtpQ41qoZiuqNTg5aH0iIoYmAGGxrb3z7tBaXRh5V5NryE1ubuVroxZy4jjg7gjnXGjSC0THHdkDuxuJTzywQURc0e5hqM1pjTmRoDmkZt9OOZTz2M5eR-Ndlad-lKxm7HT0gtv9_hV9STbyoLJFH-lsh8mpCKcd3FEDweZegrKvg3mYWiYt6KvX7nRcgGZa-hgea4-Bt7WK2tzTUuSS5u-Q9pRvzQ-Tnmf3fFGbE89WTuYtGdHrluC-VnA4iMSc73EIKFL8ksRNEyiIwDBic34eTuKE0-9qv0I6CmG4YNyhGnhejTP2nQ33iilKJ7xT_Tql_srhQfGzp5oMiugOMchhmIa3BQalJNkCPLuk8rv7uaRnsAxBMJCDBO4GlBId2_EZmhaJq6ruudR7jjqDjiB_vZdFkkYnC9MwsmPB5cdjMbt9fUdU1VZERCSA7t8GCyCtfytkVZbaO3aSVKGtAo-pJsxP1-yaXow0GKdbOLZ_1ZyUnnOVmYXGDBz_PJDRiO57rFFC4oZk7GS4zqwTjKfERrOLl7A78dzZKXg6K3jLb7iuf10lpegQqhqw71Cp7pWb7ARoEiqat5cMtbp1CQVffeuiUMS4COKFGFiA2-4v_78X4piiJP_9mvZftU2nnXszxSh2fZnbs1aRX5Tfw5JMIIlfggJ2Xs9lrCKR2dnKJFWaJ3W1OoZJyZWt2DQxDO5smtXG-oPR-KKVFGDLQ1y9FnkIpRslYMQjyl-3_1yGzZRvyOHX04oSjSacHZEBZnfZaAnuU66SZ_ky-d52A1m2nhnQEiyaa_m2T9LyQBIMJ68GQPTfl0ssewREEZNvlZNWOnk5frRKNWByET-TMlkUd3R1q7O4vyJ1nwapOxniZQC3f3ZASr6nHepeFQ6kcgrfcvPRBTYVBW9aqTXGrT2h8p7Lf0pSgK5cf2R60WqQzWpXbjBR_hCSLf7Ln4ZmKsNHKpYeCrJ4DOjzhdVkc79yu4YlwPBp5jW_tL6tuGIYW2EsPP9IiVJgoF1gcDhuyrD1-0HnlF9y_8cAOukQwUO9lkLbCqLJ3qQGxA-V8zjjAAsTxePKAYmEOwZXlYUQUnfv-p_yXwfakvwVLsp_3_rud_GsTvaBVhc4hTrpryLnWchr7QN5GpvCPSVwSf3aNDKvNImj6RkC_eHmjIIcyxUkpkwTy7QnR2uwjuGyhtqW5Lwhh6eaSKsb8OFymqjpvzo1RQVIZn0ka6H_vr3S9OqBmPrtsTt6TvDRha7nQR59WRXDywZ2wGsrn-V7cdg9GSg-ImywzGJ-hZLWUCZZ8aRVvzvNyBoxNCi_HUusTBcRwvbrGn4G4YhkvSD9lxyYFc02Tg2MT59Ti3wQyJx-p0Uo6EnPimfOYukkwduQYXpJZWFZQ5sS9GjuDR17aWsF4claZgF45lKMSaJS56lLtj-k0WX_dK_Sg0iWKDE3YVIE-B09ivUjt_H1yLy9jTVxod3CBXfqnFq5gco2fka1cmGHYUriNRIAUqSdtneJbBEEhIXIDcZUjRnFz02MjMB9Zmb4WS9hlSF44sppamd3Aox50jHsXF6iIZ26rY4IE1JBtJ2hBA4CPQJTFmMHhMGzPK6Q80c34ykaVEMLmWNV7vbgUki1G5vzwKFTV-XklGKfdLpIkZNFkhLcUIJOR7wUyJ-a_24rdivfGRwPNuMMS6N7CQUeFHoaFsgdEX5eKhvXatBtzMx3-40G26QSvtRkWP_YiIuYLQXC-owNHg-5pn0ILa4_wR_kxUebX2sN6sWVDCIaPVelyX59yadQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2351', `Language` = 'bg', `PostDate` = '2024-10-02', `LastUpdate` = '2024-10-14 14:41:34', `Type` = '1', `ParentID` = 0, `Data` = 'EihaS1z11AgGeJ_uQGza_81gZefF7HGMUEUGDi6qZrmnTgWtsip3py973NhvHIerFrOSnLmEzlOVd241EUV7ups6pr9wpkR3W57fcYUN5Mc1wMeU774f1mkBm0prtTkjZD0e6rJvfUv8qO_5sIpCku3GHFvTZiOJPnVjRpIAwDDoClnAN4A4o8Y8-DPVtgJW8xEm9JiX-FFGTC-ZyXzvCWnmutQXIMPyg4DT7ppbpRYmVJHhCTSCFRY2cqosEU1BKH2MVCKqZBELJZK2Sa-knAqvdXpnb1as0xMEyZgZhYscB7NwTBRV5jh5rpuZbRneOfZD7-0y-q0qma1qXr7oOBj5YWWjvqJJtX6kWR8_zXfgDT_NglnGcKIo9NXu4fmfHKLr9Sl9KoDOjBqZybwRfbJLEPiUnyIh6z0GAmwQjQVMGVPslkHZDKw1M7VDj8zgtJV18Ju-zXci_vke1Xe2h69ni_KzBFLAOD14ev9FwjlfcTsmRr_-q-C4zvr3y6m_ec2yxNcx-bt9oum1meTzL5BYjsIw08dtODwg9ZrYUYLwO2nZnN5dtkMMSNy5sGVwX5cD0qs-yAAvVohcpmkWpjGXS1AtFiS2_5F3CK0yZy90aSEV7vk686x91MijHzlfQucA3MaNcLoS1A0zUo0Esf3-6W8hjuzeovoT_C4VDtjHT2N0cnFtsb3UXfQ3vLZNjv5MsR9-stIP28FcfnVQ4atqQcb1YQ5_MJWhQyHmbyB3BQKCCUG1RebeLOEi81GnoFHU-VV18-ACgMJqDHukizmIWXUdpY7QZXnUJ8ko4e4MIH3eGQbTZJENmBzODDsOWosl1su3ftZBw9IXcsglm-KTAlf1eNyo0J12aMqza5i0b4Y140jR3eLjAU46RISpRhBGYXoQFY9HpcejVQE9gUpKpRYnuPO_yQNK-WJ8cpQ_ZFg9B7YkfV9G2NMj_pvb7Hq-wrRJfEbxjmHoufH55FV5qA2lJ9heUZuVlOfkIfw', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM' WHERE `ID` = '2351'
# [14-Oct-2024 14:41:34] /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
# [14-Oct-2024 14:41:38] /finance/root/bg/invoices/2351.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` = 2351
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Oct-2024 14:44:48] /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
# [14-Oct-2024 14:44:53] /finance/root/bg/ajax/invoices/form/clone/10432.html?pid=10432&_=1728906292111 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10432
            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
# [14-Oct-2024 14:45:48] /finance/root/bg/ajax/invoices/insert.html?_=1728906347392 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 70 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` = '10433', `Language` = 'bg', `PostDate` = '2024-10-14', `LastUpdate` = '2024-10-14 14:45:48', `Type` = '0', `ParentID` = 0, `Data` = 'fHgdPREz3ZBJmr44qUy_tj09ypKdkLABNtQt8G2PW4QrWPnkLUXLedVwKC4ITtxbYh6sgPJPF8nIOGdftj_OmRF6PxOhhBgG0aIFvy8YrCGIZLSPxOMjt-hx4V2TmnN_tAdHSOl2GHdJBD4dLCDe1ZbSXrWPejER44TN_Iz89jmJEeXBNC2QXC2QWIGYBkSZkbEXOR3Otdy_3mUiCj26lXdxU22v-ZWHr8C99REI0R-cYpKguwqvCERijWVIQBgUzrM6qr0MSU5EHz8in9edo7-ygT5TwCXUerrk5pLUDspjWu2GJSHDgOAjMdVsXsy_FBTeVFw9gK-CgfSX4rDcb5J1E2-j2qAxhbNCA7iEM7kUhbaeiHQV2EbT8h7EETfnAAlABLjORTEPdMmYt9824v01qGE6ai6d72rR34XV2nPe8n8evBqBt9SrJniTp9kIlUs7ViCN7wmIA7KV7GeV4kwXKQ33QOScf13ew-rUYs4yYXHNeAye4edgfsPQEoJmxbdF8UX3FYlOha3NhQ_N2D-VSxWKTr-ku2YN5M4vfiLwG7WoiJeuCxYYFkI-Aco8HxY5LqKQ_0XTqpXuM3ZanLQZSwlNWiUvk-8BUPMYj8AUr6NMpgJ5fHihV7nSrKfYLV0o32yGH9E0vPeAAetHxdKAEplK6-SO9zlIWojkdEeB4H5cEterFn36ifsJUHDk5iM5JaFp-poRr6QqQrBlIhxa6-t4jFjsJ7n612iHqrWEfOSVHtgfmqoI9xbhRgD7WBT6fQ2CUxxUq4wZDntK2AwBxTQ4MqpRmcglOyVlPvPkABwxa46WWSRUADkE23dhJev-QTt00FY130vGSKge2Qggfxn78H-dDqjf0U5ptdDrjjXzKYf_8GWtsIosFiPCRsBMwrFa-T5LANrHAtyGQ28LzmjQpZVBlnOFCo-_l5t3NtpUchwAIxvXB_vN6Ik_', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrjCr8Okw5rCpsOEwq7Dp8KswrDDwofCpMOWwrDgMwofCpMOPwrDgcOQwrPCtcKDwqTDlsKrw5vDn8KdwwofCpMKnw4DCtMwofCpMOAwrDg8OgwqCpMKDwqTD'
# [14-Oct-2024 14:45:48] /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
# [14-Oct-2024 14:45:52] /finance/root/bg/invoices/10433.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` = 10433
            LIMIT 1

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