# [04-Jan-2024 12:26: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
# [04-Jan-2024 12:26:23] /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
# [04-Jan-2024 12:26:31] /finance/root/bg/ajax/invoices/form/clone/10387.html?pid=10387&_=1704363992550 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10387
            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
# [04-Jan-2024 12:26:37] /finance/root/bg/ajax/invoices/insert.html?_=1704363998386 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` = '2162', `Language` = 'bg', `PostDate` = '2024-01-04 12:26:37', `LastUpdate` = '2024-01-04 12:26:37', `Type` = '1', `ParentID` = 10387, `Data` = 'zzNMaLfgYSUwOvPjyjXUu7936AIdfSm_ZPDnGfA2OmBPEnfGBrP4hmMOqly2F6E_AhOOZS6wsQALPO4Czl-iDU9xSirDggegqhv0snoyJxX4XM92v6Id_kAbtAdCcx11FAFLs18PAJA0zoVUStuw9cDweO_vVF6TTndhBwn7MdLH9K5j6ZQZQklAPtnMk_Qh6acapmauEAMd0zxkOdDCEmvq0637E0TxaxU1fHXrk4-_UwpGZr3Gw9xVrIpMhnpYhKyB7ljXMrpCh7BxQ5nhLGxriXTBpqHtGFNp1bVWg15zey6I1lH93ohcgMcKmup7M3RZOv0ApRWvkIK7MJZzvHSg20Jh-rRSr0BQ2f9f5IR9vaTVAdHbsGD1cjKPvbZ5arP1H70HVXzNKeKOlUOazaKP_e5GEIoWyLwcuHc0YZrXepXQqXW0Bh9eoIMcJBp1Pu5SBxdwEKSlJ8odixQYG6zwVDnSf6r80gtlypa7OvG9kKkYlcoDtlFaSXFXv1XkH-PkY4pKkBDhioWVTf8kkK2a7JZplLt0T4j2IQTZ7hiWr8ry4F6xHmS1Obz__eP3bKbmj9Df5jUwQn84ba8-zo88rxwnWlw4B8Txb0waGnHJHypYySZoVkJmvJIz6OUKyq08OACjwI2cNxligz7X04KNRVNHzY9Edq817F3OqEK5d3sRaaZJTwDneHt91xm5MUHpiuniTSU1X3abM3CN9uq6hlhLxyL-okXuNAi4_AVLtQd-JR70KZukQWr2HIkyyyCnU3b0qYv6JF6mHsan2oFp8wx4TKax0_REdG-L6-TUdJ0pHC-XjwTH4ADHe9kyi3VCi0APbFd0MP7dvlQ1HmF_wMpXQffYkJz3HqDU-MB6Vh-C5iMWSZkeTabpNE9acPM9QaeK82E3Bw3OX6fjnpNAT8r7Gy_aVNqDBcbxxaxMKB81triqwEidajnEhVYlrQa6cZRO8nGGtqYItIp9tdynNgYRb-LM5EJ05IvAkUplURWJSt3oKLWg4pb0Op3SlUhuOLzB_vDMWaNGPn8nHucrcFrp5DOr7NMFNb3nE4_p4-avzKnwixvlCVd5VfL0KAgJ0LGrTntfi9yxVllC7RuL6FaQavVcyNdPYjpC268-R1CA1H2P8_hLgjVd0SMDJ6VvVYHFerNdOpaGiW7GqNX5E1u_1V_odHZa2ARG0z-kbFxYYlE5oexc-F-VLi86jxhY538WoQjsBxAiRiBY_-P4vWYqdEqcHg495v8c3wb4woLGGu6WTEC7ylF-455qVo1zgEPM70IsT4wZpwjVhjC5-8_ZsyhSjHLROllCkyN6YUumWQk_5ssOxMW43QJ_aG0YELfOSrqh_dQ1qTqLn8awoZqrqMx4_y0dkWQ1DExwsSh8fe-7-r4yyyfVwG5uL82xt3QeTbPYvSxcFdyYEAnd4Ji757KUkGV62S2vxJk1P3cRMprCIr9Bp2CraPDt6kxWntwn2OlSOrj2seK07-PCNb5cCI3vgNhlFNqXFkoPqmHwz-PLK0ZT7aWYvCS2_cxBFxSZ0AbDVVw06wUr_sp93CZWhwzyj8XQbEz6RGKKjR0Kg7U8W4fyl5rThAAKq-WBkX2nsz6Lor3l8t-nzxDsrBCy0Kf4UQNgWlT8aShjRnBcEPUYmhVIj0xBAOtjYRy9GU7y7hbiXi4CUVT1cESdy6XEwYmkDXTbbtY527b869wyBvvXCYasV4cln7HXuYsU_FXjc_j3FFmcQVSILkmXHi_yUXPbGgaKobHXgiL1nmxnhI4cYQzlp-LIRXEwbfRQQc5X9-_towET0u1drFdJikPdlZl9vVfc8uhlczE_KlshwKK3wAqauJUPqcsxyumc_hPwsnW3oyMlhzZqQnMMxq0QFPT8nrJ7Jkc6u3xIaiHjk4pJ2hAnd-4cr5TAbMAsCPyvVpsYRcbpZKjXcbSWIjYKhBs8oD9iQYzWw0BQ2WMIIkX6CGUW1Fese3x8jWo4BTmwUqCnlp8jO0y2dbX5iOHSeYhM2g8Ioa-ABhPODrq9kqbHJ_zY3TNAExGRgeYUpyMIryU1FsMUAM7RwuO-0OiDalRepaMOT3Ou_XDFwyS4ukwL3xyMbkc6s7nHOCWW9igHUyb-qvGAsXhkDg', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCu'
# [04-Jan-2024 12:26:38] /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
# [04-Jan-2024 12:27:15] /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
# [04-Jan-2024 12:27:20] /finance/root/bg/invoices/2162.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` = 2162
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Jan-2024 14:28:13] /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
# [04-Jan-2024 14:28:15] /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
# [04-Jan-2024 14:28:18] /finance/root/bg/ajax/invoices/form.html?_=1704371299129 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
# [04-Jan-2024 14:28:22] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Jan-2024 14:28:40] /finance/root/bg/ajax/clients/form/13.html?_=1704371320784 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 13
            LIMIT 1
# [04-Jan-2024 14:28:49] /finance/root/bg/ajax/clients/form.html?_=1704371330224 167.99.142.201
# [04-Jan-2024 14:37:28] /finance/root/bg/ajax/clients/insert.html?_=1704371848739 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` = '57', `Language` = 'bg', `LastUpdate` = '2024-01-04 14:37:28', `Data` = 'y-AyTXqKupz5nyZLLkfQZ7s4R_rrhxPyEThtgFAksE1-1eHmDXQjUV31svspOyTIDPeQFpbor0LaGvg68PJYkDPQor0Ojxiab_mFtWd1RM_RYfThJWICI9bEqY3fILV5ICwiea_c4j9-KxDgOxF_MEPRk40VjuQq8Bk_A4TjzTjpiPhePGkVquWLN2rkNv1VhJKfQ-MtI3Z03SoOMAxKCqlnVWvFAo_KQUN41pt7NTCcT2EYbPife-9MkaBwgKgiXb6_ySRJvNMtsLm-mpZbxS_lbYbterKfXPgh44ZvNilTaPTsh0gHZLthm2KUJceg', `SearchKey` = 'wrvCn8OYw5rCr8OZw4LDrsK3wwrDCr8Klw6DCpsOEw5jDwrvDhcOGw6PCscK0w4LDrcKtwrDCwrnCoMOCwwrjCsMOKw5bCr8wrDDhcOGw6HCr8Kewp3DqsK2w4bCusOMw4bCwqTDgsObw6jCnMOAw5PCpsKgwqzD', `Top` = 0, `Visible` = 1, `PostDate` = '2024-01-04 14:37:28'
# [04-Jan-2024 14:37:28] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Jan-2024 14:37: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
# [04-Jan-2024 14:37:36] /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
# [04-Jan-2024 14:37:37] /finance/root/bg/ajax/invoices/form.html?_=1704371858376 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
# [04-Jan-2024 14:37:42] /finance/root/bg/ajax/clients/select/type_0.html?keyword=the&_=1704371862660 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8OYw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8OYw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Jan-2024 14:37:42] /finance/root/bg/ajax/clients/select/type_0.html?keyword=then&_=1704371863170 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8OYw5rCr8%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8OYw5rCr8%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Jan-2024 14:49:19] /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
# [04-Jan-2024 14:49:28] /finance/root/bg/invoices.html?from=&to=&keyword=han 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrjCn8K2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Jan-2024 14:49:33] /finance/root/bg/invoices/1930.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` = 1930
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Jan-2024 14:49:46] /finance/root/bg/ajax/invoices/form.html?_=1704372586619 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
# [04-Jan-2024 14:49:50] /finance/root/bg/ajax/clients/select/type_0.html?keyword=the&_=1704372590865 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrvCn8OYw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rvCn8OYw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Jan-2024 14:50:51] /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
# [04-Jan-2024 14:50:57] /finance/root/bg/invoices/2160.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` = 2160
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Jan-2024 14:53:26] /finance/root/bg/ajax/invoices/insert.html?_=1704372807241 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 57 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` = '10388', `Language` = 'bg', `PostDate` = '2024-01-04 14:53:26', `LastUpdate` = '2024-01-04 14:53:26', `Type` = '0', `ParentID` = 0, `Data` = 'T9w6Ey9rxdvQT1hvbGlpVo3hn1_3PQe73CYhLqgBp8pQMHCR_QB3II1sy8_8KqHL4t289dPZ-J4a8aaX74I8pqzsFUseKPJy2I2Dj2vWoyNJKWebzXSeHKMgcC1jcy6nl7ppTsojodyybuKxi-zK5nEo8xIf2dSTFue3ZoKPriq0YRcMzOiEyPonx5PzP9Zo2PxQ8e4Da4ZgJtXH2Ovg8ydg_-a-q08jx2UD_gmFPZhdGliRVcoOA-W6Lpiv7LSE2JXp6W-lUbEA-g-l9Kqm9UAdjD5A5r1g3PONqJ7ApCjQMVasRQSvuHVttkzhuFWAFuaoNQk4cZmVt0D88jfdSzgbqe10k9xvZWa5XABOj2u1I4ABaAJn-hkuAZi2n-gWT5XFATgHOrDpgJHpRtLdV2WmWBtWEm9i6SDdEb-w3Y1jifpqVSVl_WjPnaTFpO-iuluFeIImaNmu9HQjQ2VF_KtcMEcmywlTr79-mDWz_RXpYX6JrJ-YV74DKdyNgFu7-dcoTykV-t2GDvuQ0_9Cq4j87iFo9hcwyGzPl0bwpRKcwV3ek_UT4WBSMaouw16kNVKK4r23LtizliHXIAxxnxD__VagAuKAJcI8xu1UDi3yRRGsnHpF3Oha-8wB2ImdiII1kRkY7Sv68Ozo85nz-wkZCXClKe8GHczobNHNZS6ylrMY0BTNbIpX-vVzCNyh0LN_B7jz5XlxrzTvm2nK-AEKhTh8YPLvh4kyK3mCtOML4DnhvqVlF-aHm2SwDBVX44drDhN86nRKYcyBN3JV5XDjJzfMTbbQalDw9yUjziXW7xJ9eoMlJH1RXrzb8o2_Ykja0HTcjUr8Pmi7DVNLxuymReVgAF36LRmZcAhIORFICAZlIBQwNAJHq1Gl7I0Sly61EThwZOzbAHOSV-GEoEE7maknGuBPNAOepVnFu0h0Nc8N5w7p5Udje_6H3ACpOb7ykAsyv2Xm16gtruZNp5G8g7-nQ4EctsvP59Kl1V2QGyFPv0D7axpbbz-O54zeDAqbME0a3WYwMElkd6LsJQRPH7v7aktCqv4OFRYrobZjBK0LCea-fFGCjtKXf1ElO21467UVMdjkn-i5VwSG7qGUhcXUWiGGo6gSDlhhtfyGhFvsRNHVicF0C2LhTeXmVt6NCUdO_flfpaaBQllXsYmxWszQ9_pl5kD5vSL7JaejGtpXArSAIXpt7PSGUMYuLg2kcl5L1m2ndAAQSy8vFVeb4RnsHefVMWWsliUcHopB4iib78Rp9kfN4UXYDfNlHDqAfhvq1o0Mq9yniSEh1dh0Z7u7VSnOUCAaXTNcGx1MdWWZl7Zb4vWH9iOMINiazPAVBCh0MjshYIAEGBokO1zhok7rKkY2KfFfCj2SSgjS66pQpozuV3mJQhXjPIHD0ytpnwEvp6Ms4onpucZOTL-K6582rMfvkJPp7w8AFjQDCc_TsBthhtOZp7VSp2MjHjBMrJfmiFJSjVxURfHe3A0Zf4si3nOIMYyf0c9j6RjCVu6AvZ-kSuXtzv_7nwu68qouQeUqooc6Fzevb6RBAUFFQhg0syho3Ot00-rQm7l4NEOCV3v42GMp9WlJecS5yzglyWVVosX_F33tDU-hQFkfDgdNtiHvu9QYrvJ30ZM9tKzLX8DaBCYF50Lfepj7CDQZLbFsq_bKottTXGd0jI0qYXMqFn_NvPcIyBNABuGKftIWaCfl-xD2fSIwMoUGGZHyLKd0oJmTzpGX7bfNSX9t3tejVo7sqRCHvmhDT8Q', `SearchKey` = 'wrDCr8Klw6DCpsOEw5jDwrvDhcOGw6PCscK0w4LDrcKtwrDCwrnCoMOCwwrvCn8OYw5rCr8OZw4LDrsK3wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCuc'
# [04-Jan-2024 14:53:26] /finance/root/bg/invoices.html?from=&to=&keyword=han 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrjCn8K2w%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Jan-2024 14:53:30] /finance/root/bg/invoices.html?from=&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [04-Jan-2024 14:53:31] /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
# [04-Jan-2024 14:53:35] /finance/root/bg/invoices/10388.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` = 10388
            LIMIT 1

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