# [14-Sep-2023 10:09:32] /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-Sep-2023 10:09:36] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Sep-2023 10:09:38] /finance/root/bg/ajax/clients/form.html?_=1694675377063 167.99.142.201
# [14-Sep-2023 10:10:17] /finance/root/bg/ajax/clients/insert.html?_=1694675416697 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` = '48', `Language` = 'bg', `LastUpdate` = '2023-09-14 10:10:17', `Data` = '7t80eD0RycT8bzP9xKAiVyGsBPtim-nbrKSUTPEozbv5PBRIEjU7D9ynmqOtsXJ8yTDxSz6sWAgHoBT1elx6J5jAZ7-k1s26c7mxFC0aXMsUYft5rWcDe8vD6wvwrSn9Vi_mJsfTrEs4wFPZnadm07QN76LZykJOk2iCkHrHFsXoMjydHAHcnX03ckFevWIOC8DuMTfEXfINbn_37EE3pKtdrCy_mvGP235kRQXrB0n3tlQXFBMylvjqjDC0taAR6P0zbCOD2ERS6FAV3M5x4ztMeVMEqQB4bcAAKmcaV1S_9l-nokZnPd-iHOW_KaDQsJDhEUUVLN4BWscr7lZL6bTNGfLT9Iuz0oqAcWxXI0W4e7flT-CmHbZykZfBdtvJ', `SearchKey` = 'wrHCisKpw6TCp8KzwrLDqcKtwpDkMwofCpMOAw4DCtMKlwrPCuMKDwqTCwofCpMOIwrDg8OQwqCwofCpMOAwrDg8OgwrPCwofCpMOiwrDgcOQwrPCt8KDwrHDnsKsw4zCucKdwqPChMKhwoXCvMOUwwofCpMKnwrDg8OgwqCwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwqPChMKhwqrCvMOUwwqTDgsKxwpCm8OAwrHCqcKhwpzCvc', `Top` = 0, `Visible` = 1, `PostDate` = '2023-09-14 10:10:17'
# [14-Sep-2023 10:10:17] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [14-Sep-2023 10:10:22] /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-Sep-2023 10:10:25] /finance/root/bg/ajax/invoices/form.html?_=1694675424088 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
# [14-Sep-2023 10:10:28] /finance/root/bg/ajax/clients/select/type_0.html?keyword=good&_=1694675427947 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHCisKpw6TCp8%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHCisKpw6TCp8%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [14-Sep-2023 10:10:35] /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-Sep-2023 10:10:38] /finance/root/bg/invoices/2091.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Sep-2023 10:11:30] /finance/root/bg/ajax/invoices/insert.html?_=1694675489361 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 48 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` = '10376', `Language` = 'bg', `PostDate` = '2023-09-14 10:11:30', `LastUpdate` = '2023-09-14 10:11:30', `Type` = '0', `ParentID` = 0, `Data` = 'dy6aYjkonKlsP23RaYjZ7FVnd_ZQSxL-PRsFEsYgQuRwocQm0HFiYkBBDUm014Jxdjef6tT2sdkro5o27FiHqMmh4PV-_mg0hGtGITXU6Wxw29hNH1dn84jdOg8N313lhxxWTELTHvjI4t3hoEdGi7Qw--s7AntwWBIm2HSgLNrRDyuvEQ3hR1It4xiI6Kmr5s4smOxupGuciZi63LGmZ5-Nrtt9znnmUmZ5B4VffDvljFTDovOEY4mIia_2LLzSX-znR2Qj95xV8nHWq7XXb0u8vRoVaJIrNLRFPSUqqAPOOFEGLHuAi8NAds_mxq0pfnaSXl4TQnUd6SDMF8TOsDrzHXtercHxV6d0l0YsY1-_5TOHwHLCs0i2jgYJyODqh_3rrsH4omLt1jvxpl81RmQdqrUmGE6csnCVrJ87GCql3TItoYFqsE2F32ozeGGRCY_2tbH0VbWcCb_aKaftt8MDo5EVqpbOebu8KikRhAzqXZwoaVVKVN37xCW8ArdTT8YSsz6TYrg-Gln08VZX3ouDMd4yphrd9Z3cd-wQZpGoS0mCg3xmlF9zbl8oNn8m60FRKoAefeZ2hVNtAUq2sCLEmy20q7TGUll7doQEmDe_YhTVvvzsp0sb03KJ-2bq-4M1AkZXEd902FvqtK3_TPrulhUJ50GqCC9BV0TFF_WaTWWG_2N__30tmjJvyee-Nq5ag3WsDgN8RtgrUCtz5hQR9aIsaj4i6qnn_UlGITfhmYVhR10Twfx1zOoGZdyBUNVIY_YHP2phoGuGLMY5x4a8Z8gEszZ1i4o7eRDjt13bYLsbkIL_RxRBEieypypdqIu7YNiZ54hW8Io5AytXd2xky4dEGuI3bnbbtMe7LibJ8y7XnGFaH9A1pyD-7ynq5XLenAfzq9-Dg8FnyOUkr_dVzVZRs2cY4ztyf9vSB6Tcq27ysONUR305poqg3lAksTbZ_wj-20zDspQtvZgvEBcIY7Nk6UlqBxKkZhFimhgPI_J5s1qb3BG0vR9Qo2I-yuY6DaGHNDRrIv3e7Brw9JonzLET32ep4HwQd-f4GNKQyJnqAzeKTQ8IJ1E1mOrN3SHaaqkmr2C65ASR1_0DzyL3R22ItLL_x5qzHkeJsAI', `SearchKey` = 'wofCpMOAw4DCtMKlwrPCuMKDwqTCwofCpMOIwrDg8OQwqCwofCpMOAwrDg8OgwrPCwofCpMOiwrDgcOQwrPCt8KDwrHDnsKsw4zCucKdwqPChMKhwoXCvMOUwwofCpMKnwrDg8OgwqCwrHCisKpw6TCp8KzwrLDqcKtwpDkMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8Kdw'
# [14-Sep-2023 10:11: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
# [14-Sep-2023 10:11: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-Sep-2023 10:11:34] /finance/root/bg/invoices/10376.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Sep-2023 10:14:41] /finance/root/bg/invoices/10376.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Sep-2023 10:45:21] /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-Sep-2023 10:45:30] /finance/root/bg/invoices.html?from=01.03.2023&to=31.03.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-03-01 00:00:00' AND '2023-03-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [14-Sep-2023 10:45:35] /finance/root/bg/invoices/1967.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Sep-2023 12:52:58] /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-Sep-2023 12:53:00] /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-Sep-2023 12:53:03] /finance/root/bg/ajax/invoices/form/clone/10376.html?pid=10376&_=1694685183030 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10376
            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-Sep-2023 12:53:07] /finance/root/bg/ajax/invoices/insert.html?_=1694685187192 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 48 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` = '2093', `Language` = 'bg', `PostDate` = '2023-09-14 12:53:07', `LastUpdate` = '2023-09-14 12:53:07', `Type` = '1', `ParentID` = 10376, `Data` = 'IgT3jhlPXjrKDvcSxbngQHLdUGw5MQCYsjQQBni-HPxgNDOB4SM0HymEWctfWpKO2oFh2hYVoqf_xO23sRBVHS0PuSvioQAAzu2JbqusJAWIPcOkrUlJwlpmXrIk9FF4VoirEJQqbcrkMvL7SpQaXOjJTUan7LKpCLOd6kNN-jiaWdsuvOxNUu9nNwUdO0fZRLmttZPibQZ9dNOGXhS6r_WXjnqXVanoNwO6DRJA039ZkIoy_IT3whFNde0IAdJ8REG2QrVIUamc2W-E90Y__1XZ0sZCaKEfk-aap7mV2xJqycjz7Nf8YotvoYQOVozPEIB8xmqzQDbYRt33R0ujjMFILBiZ0ppD0f_GhxfychFnc1yKc7S9sMDyT-JGUpflir82zOkredntdzwsKSWXJ5iIvvywkzOqVR_qb_2Pyi4w-kUncndnyNsMhW5sAVeRkvjl1gFD-_D-NQmLBgrxNzrtqNpZgeQGzfWkl_nqhtolzfJpF7WrtxaGov46GuUL93Al90rjHp5ozZ3v6F_z7yTH-1kIXxv3ljYRDuPGBOOr3P8P2qJHjE16Gk24-MX0YOl-2mlMBZEteW4T5MycltowJLOiRhT4rpCMr8DhuUiEezgv1pEybCPHRz1mZg8qvp8evNr4vQRLV_6E6xsZDJCcpnzd6yXta_qFLW3p1uBiL2BEZzA8qX460RX0NGE7Ig6UfNjSgP7xXB9-eh7eozPkTFqsduWo1AmhFrNKJWPgKuExRWUvsEJvWTsIOzcTpiP7ccMdJpcvrg3AYRr6-q8HL0XxqsKJsrMEbCTCR_Bin9ZAotl20Yzqi5r8hxICk9rNCrZaB8XzdLQaY32SlUZNlK-1IULYHDluCpM_dFr7leH4KhfTCdjJuZRPakUrWYKCOP8tlrAuJUV_9hvDvc6eMGOP_AjNZdqboo3ye3DO5bj8hcpb-15y0Wm5iGz-UteJE3Oowwpw6uO2KpMVcYLJydpqfB-OuDnNVauXAUU4YxRqjQcUu7IrXgFEsEA1nvZdEtNqqHna1t_rmaog43joOugqr3ve7JMhh09uaX5HImx-rblRv82bBuoLqIB1TQCethLaBV3q4Ngy-ie-amm1Sa63484nyvZT2Vja-g4', `SearchKey` = 'wofCpMOAw4DCtMKlwrPCuMKDwqTCwofCpMOIwrDg8OQwqCwofCpMOAwrDg8OgwrPCwofCpMOiwrDgcOQwrPCt8KDwrHDnsKsw4zCucKdwqPChMKhwoXCvMOUwwofCpMKnwrDg8OgwqCwrHCisKpw6TCp8KzwrLDqcKtwpDkMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8Kdw'
# [14-Sep-2023 12:53:07] /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-Sep-2023 12:53: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-Sep-2023 14:58: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
# [14-Sep-2023 14:58:22] /finance/root/bg/invoices/2093.html 167.99.142.201

set names utf8

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

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