# [18-Sep-2023 09:40:50] /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
# [18-Sep-2023 09:40:55] /finance/root/bg/invoices/2087.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Sep-2023 09:41:07] /finance/root/bg/ajax/invoices/form/clone/2087.html?pid=2087&_=1695019267381 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2087
            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
# [18-Sep-2023 09:41:58] /finance/root/bg/ajax/invoices/insert.html?_=1695019318377 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2094', `Language` = 'bg', `PostDate` = '2023-09-18 09:41:58', `LastUpdate` = '2023-09-18 09:41:58', `Type` = '1', `ParentID` = 0, `Data` = 'ltxsln04i9hBgdt8zzIM3bRZAxqHuws2BVjDogeODXspj03k1rR_-7p_wYy8rqBzz92wLE-GtTmkCvkKS0czaitHWZtsUCyflrR9BvvLx3slQ_m9ypFDNdbso7t0_sSRV51xLFGMcnwtTGybcyRoQhFQfpIcDOmaV1K_cICTy0UfeEFt5XA2-TxE4h01bDS4R6OPOPz-q4PDGRSHvRT_gz5VWPs5MZmvmAkC-9_k_uEug9qXuKtBrXnE9GaItm5ORbsAQFyTjZRsfwhV1G6AZXxU073ejpBvGw_48RtVsXCyRfLRH_3N4_e8p4idynyJQiBbo4Qe8h9KWK4aCvFnfRvzB_Q1VApe5VZJpruFcMQGgxdoVihviGjwCWJb_veqlKJrlbXBP7YeLNQOZFbRPZ_nozWRUzTLp5F9nQW8FPOsBzKb-8Fzz5URZ8mdF8NNWTSl5Llbw36A3URabNHRanIK1-Gx8huJJKC4RGkX5gh6meTaW1XQKrDeg6Xhna-kz_yj_NGn1z4YzfzOQQkmcBQPbaEZ5UAEj8PlmODj7EFIU4uJJ6PDTvA0q67crsoIJW_Kz6bj1Gw86lyMqv4vKbW00bpz7eZtf4ZiFGpN-2xvvBx8DlT9BuKGJLGwEXAw6jIvAhXWriaMIE_LAnaUc_iv3b1yjo15N3-zSdNX7WcCgXhXVw821NdVlhbteInESHTHZx0LuJo3cqBMtNw4esEQXpMY3tuFrUImLqVUjtR57bJ72bRTiLDq8eBy6YEl3YzzEtAKr-La-iE2zZNxqgkUAWrpNGPJMwldMGZzQL_G79aSdQ3X3gjI2hKBXKUWbfXLNwyh5rT6ZjIBQ4_4hq7HAV8kU5br_MpLIcPut0M1PtexG5JEzdyculpZqVBBZTpTDgKm8FmVBSiJNzxMPRFCcEo1ZqMBzM3keO6O_m9e2bebeZVo61l9sOGPwzmyMyeBr_7Ox7qb2S9OeWsuKGGzgvvP8D_8BASm0A9HcvDamEOnJjoNDgzro9euggxtCtsJ6mfhjQ3XFvoi2mihroy3dT_ORNnRkymdscgP36c', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMK0wrDg8OQwqDrsKDwqTDos'
# [18-Sep-2023 09:41: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
# [18-Sep-2023 09:42:00] /finance/root/bg/invoices/2094.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Sep-2023 09:59: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
