# [24-Jun-2024 14:00:28] /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
# [24-Jun-2024 14:00:37] /finance/root/bg/invoices.html?from=&to=&keyword=ацтижа 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wofCpMK0w4DCtcOgwrPCt8KDwqTDlsKrw5nDn8Kdw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [24-Jun-2024 14:00:41] /finance/root/bg/invoices.html?from=&to=&keyword=activa 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCr8Kwp7CrsOEw4bD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [24-Jun-2024 14:00:47] /finance/root/bg/invoices/2108.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` = 2108
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:00:59] /finance/root/bg/ajax/invoices/form/clone/2108.html?pid=2108&_=1719226860873 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2108
            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
# [24-Jun-2024 14:01:36] /finance/root/bg/invoices/2065.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` = 2065
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:02:03] /finance/root/bg/ajax/invoices/form.html?_=1719226924637 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
# [24-Jun-2024 14:02:08] /finance/root/bg/ajax/clients/select/type_0.html?keyword=activ&_=1719226929167 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCr8Kwp7CrsOEw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCr8Kwp7CrsOEw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [24-Jun-2024 14:03:05] /finance/root/bg/ajax/invoices/form.html?_=1719226985973 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
# [24-Jun-2024 14:03:12] /finance/root/bg/ajax/clients/select/type_0.html?keyword=acti&_=1719226993551 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDCr8Kwp7Crs%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDCr8Kwp7Crs%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [24-Jun-2024 14:04:46] /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
# [24-Jun-2024 14:05:01] /finance/root/bg/invoices/2191.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` = 2191
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:05:08] /finance/root/bg/invoices/2188.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` = 2188
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:05:27] /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
# [24-Jun-2024 14:05:41] /finance/root/bg/invoices/2148.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` = 2148
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:06:09] /finance/root/bg/invoices/2087.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` = 2087
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:06:23] /finance/root/bg/invoices/2074.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` = 2074
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:06:29] /finance/root/bg/invoices/2073.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` = 2073
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:07:54] /finance/root/bg/invoices/2108.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` = 2108
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:08:08] /finance/root/bg/ajax/invoices/insert.html?_=1719227289683 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 40 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` = '10412', `Language` = 'bg', `PostDate` = '2024-06-24', `LastUpdate` = '2024-06-24 14:08:08', `Type` = '0', `ParentID` = 0, `Data` = 'uv2z6o2oFIcXU2O_IEC6A9Zr1Cjfcjch6dzuioLs8KuGRZLmmcsAzkqKiSYgixs2L616eraYXPrqyc0mrTxYQL4a86csuRk50lMqjuy2k-IxqQNkVqDsqikkeJRvw78YiNNHSS3XKegtsBk_sFdgLccoSwenN5NzfYSL3TfOSg9P5G7qcJzfpJ8Qd7ZbBGpuIKtZzqblm3CbQ10fyoneorZSFIH7OI9lGGPZxN8SD6zB4OkPGcAnXuWtSb9cD8uIUHALfB3P9zihjQcF3zgeys0EtuPT1kzBVJDvHy96LYurbcKh1nDDkHTudbNE4br0HDb6R393QzPtLP9XKATfDeXKgkX875cH5BoPyd8GNdqYmjHTsAfI_UTSmyd9TT8TUx0L_z7e6Ntz3vj9uwYobqgFbpj5Vu5kOPFBmIWBAdz5SGj9lXzT6hrAab1RxdoQCMIcTaYpC8y3gPIQY7-W9pvN-BbOK7A4Ce6x734uX5nU5rZeKuyL1y5VSZwn6m5cNxgpVLmtQZg7dKoPn3iX_7txu-vVwkcNqgptw7Qi9xLL39ZHqlSbvPXPjdBt-qTFphC_ehPKf0UxfZP-ttU5INVc3mAg_6WKKh7T7cxT3ZwrosCUVN1IOksx8bYjA1iEQDvCzDNQa6oQCzaG0o8hRLbQyAu9drnqgDuh2R9oMCZBphLO9uqm1fwr2noyT0DCN8Acy3IleKejgVugRslhMW1giTAKgRrYejG6RLHhYm9ZQf2aOj0AWxbC6upRNDkta5mGSqD9w88_rTpRdEEIMf0h1XKOdPApSPkKJWry4IxfMG6IanLjnlmfDzLBMhgLOdwlznXQp9tYoMu9jLR_BLW9iQPPqqaAvPRuuks8-pKxMIxMOphQ1xU8cc_eNNKOAxEodlgYAayT4xwsAPkC1C7mOJk3DxTh_-pV_wN8aLobFNQev-aYdYfDWsw8wc1kU0BME06avdgGEq3se-MPssjnSjVSKq4fVmtUKoKnQ48yNknwxfcZtXeOEDNFJ1FUhKYA5s5RgtURSdFO1-_BlKL_zVOTnF1V3pxTvpMihimZR5w6eFPvtKn35S9Eopqst0cJ7EXYwpYxxdrEY4flmRFhkjC43S05DUctUhHsJD9BR3Djd23ahG-KIQJQkANsw8S6VPRKOlWPEqOS00c_QLdcUizlfKFogtDF0Hkj2Cm2_wwje_D2O81yyr1RBngO6E3pSMaHUVFlEpP-gYskw9XkMo_6MVDPGDAWPmMPWuBFMcvoqOt4ei5bzoxBcQu6EN0RgVzJg8FibyyD39uQj2ZUlypI-_n6lrEM6kJa6xVsUMIihBTenjx2pWc4moIQ', `SearchKey` = 'wofCpMK0wrDgsOgwrPCt8KDwqTDlsKrw5jDn8KdwwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrDCr8Kwp7CrsOEw4bDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscO'
# [24-Jun-2024 14:08:08] /finance/root/bg/invoices.html?from=&to=&keyword=activa 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCr8Kwp7CrsOEw4bD%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [24-Jun-2024 14:08:11] /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
# [24-Jun-2024 14:08:13] /finance/root/bg/invoices/10412.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` = 10412
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:08:30] /finance/root/bg/ajax/invoices/form/10412.html?_=1719227311765 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10412
            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
# [24-Jun-2024 14:08:34] /finance/root/bg/ajax/invoices/update/10412.html?_=1719227315311 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10412bg', 'XhSxQ8YCx4hqy4XtW1m2d-gZX9qvyhcP4lzahJH_AujbiJ8e2xxxRSMnOkLefZK4fALbpI_8NVTxNhWtX9-AqJysUTZKQy_1oWVEmXO3NnSowaMXzMM4x9Rd6k-GcGJ6JQm0vtlJHBizGpJpyuaM0ta_NSFrInxb4iRHKRS0Ool2CTZAB1HtZ71GLXW7kPsoCmBoeG6c5OaK_YeI88D0SViafRx9V56hf3qBJmstPSyuaShVuylA7rc9axqryubyatSYGjA0IUK5saPBfGMMeIqqtPbOmoJOUbeglXU6sAF5QTaZVsyKJYBwX0q0_lqaZmibnD5y6h6YVdkgv5c73EuwiZhEgCU01hjtYG2hcmF6EGD3JgoQJ1-5OlUAnQ8iUmcxlThjFhCrJTt2NWSJze-Ny9cANaAQdiQzGeUiDIIQKb8shvl13e5L1KDh7CoP-N7BW3GdVazrFEPrVBv6Yum1cFwXtF384qr-haDrHidNuQin7oduotouHWKu14mnJW2mD3DE76SOV6B1DnEwbTO_ZzQeCqkEC2ylz0Yp-eh4H4nFSl7x42w5jwIndxoLcjh4MfPVwjPiGBhAUAV8DQhO_cVPy1mT-_cJ2N_cj72DAnYRdHhbzgc9SBg0YZ3xNzdFAgABterDOkxvG3J9vgMWvi5IeEasCw9iTDzBm_v7uo4i-x84KDYoSCic6_MZdAfE-IfMTC0MA_nTljdO0tvko9krWIw5L1ZpqOq9tyZVOVd4mdbIFN3fmnIKRHBXgmZ-IAIkaUR7dVGC6oV1UKiXDcWL2N7AQOstcm9CDsU4CG1hrC3ZRorWxxKQ2WoazI7lUkVpxcq2r0AB8vJEjZVeGRaQ0KGsSdl8w7vJ70PO0d4nMtM8PtOxAXKeGXNGLKJBaeKZ2-aa3fK1eSJahuynaJsajDTPY4RsLOeX91nSomlEt3nOw8kbobn234FWkj-9NVjTGAK7OOX88mSl_NT_Byu5JdYwRRK9bvWBY_4S3pSXxVPiNksxV0-l7Ethu3Aprbwo_nQ0UKFKx9KtFoEAXTYJb7V0xQChrkz0e_UJ3geeEyMFBeaWDLjPEj6S-kLZUkkVpNd37FNf-rR6NkrCI-zHReHL7ysKu3yIT2vEk4Hn28ECHBjOMBN2wPJqpbBCMmTynUJyjDlp8Uba2OwkFnztwVkzjku_WJ9E4Alkz1HaIXi-uyGkFevIIIZ4aYXORdBSZBhxX9AEfK2TG4wDdIYnc0Gmk70N7F0KgFPMGZs_lakPvQLxxiQXblgY7gLoDxdt5n9iz62pQOgFyI9meNiHHuAEbpS-kvZ13StwNZ2avyJZwGpLD2eOGI5fx9d6STBimUpLtbTjU1Moyc3Qa03_-nQCfQkbJRmSOi8FbcjsHVOmhXc_xiMjQYsuWcAktVOphcaPNohCLKFL_rPMhKgvGWlUHfe5j15Qm0h7wcqtYXrZ1LCl9UcJ6FPdQ3ak4748pUImQSXmtWMGwyne0-SA2eo2r30hfzrLEufha2UamMGXhd2GFAwKZddv4Nb9iH1rBEiZw5OV3pgd5RIcu4fo9wYd4VKg_VRPg9WAez7oEJ-jjNUUJ1ofq7ExVn7YGQl53-sfsZvfwkkpuKLIfezxAGTyckoQQUCGR5JeqR-7qrmFEtxkGa3C2DcADzcI6iUBfdGtsRJAOcnJILBoXtf7oixbSx60jgorbnb1TmfGSEGczBAac04PcCkIR1s-vULvZWG_To8Ywvb1hHnXqW5MGbBmku3RC0lEkfpmo-l84Ylkh6bx-XM17zNxNcOU0nbC7xiFVtO74ZuivXSWLFCQXvFpbGTI4jKH5voBklGNkkS8waSFuY1wJEFv674Ekd-oWQXkCoriOXT4sVjODrQdsATLG07-mdlP6a0pmCrS2DZlD6b_EkL-c9htYw0z-BTrrOs_tSejnLzl7EDZ5-y4IBR15tMUaNzwFO1AtY6lBSrgShuRO5m7AVbAGEJitygKiPsSZDdpgvP1jF3Y5YajEyhDfqKrTXnI9m0BqgnsDHk0ATk_7p38PUgqvv0dGQ9Rl96iyzUXc1bQcu3B_kNgqwRrbCwaiDAgdYzFTUS3rkUI29bNyw7ZmLnwBQIQ1HpjGqjOwOtK8dFo1V8vNbRN2dzApksWiLFjuiIykGH9j5LhwPMK-dcjZ19DEgj7uYXT2KP8SCPTpHbvhxMzen3HKI2CSteurlaaOpIk1uq2WVhRyf0Vy4EZW8chd9y54_sfdnzs9TYuXpHMaOctxirC1HDexulQvjJSKfxMIZvHPMQe7wJkzC6YdGMRUG4QfpnPebRNQ-S_nrx1XeQLmh6OoCHuG4xsc1e_jAUTsf0msnMw1K6PEkWw-Wf3LPcdhMnaC7_NmqCTB4hesQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10412', `Language` = 'bg', `PostDate` = '2024-06-24', `LastUpdate` = '2024-06-24 14:08:34', `Type` = '0', `ParentID` = 0, `Data` = '1B2K0bHrnA_uAmy5XF-BU19V7VUCBLooAx4ZIBmD0wD7LnuTglpnKuZEZOaFhguCH-prIYPdkS8nNkH0ZeSO7YbvTLkKyGi6myWU7PJGiW_nQHmNpH5LnLaQ0T2eOfeqVHbBMpegIC3-LxZCSpe32OyQjl9Lo73hqlLMfrNksBChSN8IfIDy_8PGXBXKBvllfMJnzGJIMT1NDlYdmu2a0Qag373Kg7LltzO8SFGt_dA4KtIpKEkcfvLpisf0pKo0yFzhU16pTgZGR2DStIW_m91VObavkQbVoxu80bXJWOLiOfhWUbsF9lrsW84lLZ1VVquxgZK5e94a-RND8_p8UDtXGQ1Buy5fz619DJl6yVJE8Qzg5bl3wPLyo6s_ijI7S6afKxKgHTSBrfRvt3GLeBPDJdOdUrQXA-31OHUVql9b94r31WWqmMQ4Ez7DwiJJ0ncDHAnxBdJlgKjlIBRGtmX4mBJOtRJbSKcPUrL-o7bemarOuIcj7jYEQ-HnWRaBhmY5k5prw9BCl5AmcTYfCAeV4JP8ttFBOLT2ich0Ief0E1vC0AuoUHO-IJMco8MqPAKIOABLV2w6MeWWXfj8_LMn3cbLjiwtGGLBRen5KpuIWH_mBX-Adte6kQUPwEmtSS8tJI7_mEhSxPQrtX69VZRMyPIRaxQpjXBvFB-MrtseAufr95iliUWTAckehhYoIAV6mcvfRqW75uBKuJXTGzUGDdDDIssvcRL3-MEBLY-Q6QtGiMOXEzxciuNyiq8z7QRKgyADNKdfnxvoh9ikXSBTVA8gb5Z74zvlp_GCnOOWWRAff8IRcKT7JhtTepS02NDugHfcmqpPmkS-wAlSKhGHKEl757r1K1rmQb_gR8Dh6VM-mUEkfOI4c2LCH_NRj7S1Lxl-YSSRcqubwm0U2TH17JfbGqYDYy8-G-oJ-NmOvgBGRcB3KXIhoia0LVjHLATzyy7GgqMsFXgnJSCCBl0axls_tyY8aaBpfM_g2n_A2hs2GhaOQN28GTy0R-ie5OSzPCw1yNsiiRuuD2PEHNUUqKes4QCUfmcpR7W-IzugNzrpowrMy0u4yib-w59FP4OsCu32prIAwRvytrwmwXISbrEZd_L2qxTfZqI70Z_pikCNwdqLlDqQ_uYMe-Zj1A3ZbcqTL0hbzwCXzOnrO4spq0L_9E_jd-c2Adp6GPw', `SearchKey` = 'wofCpMK0wrDgsOgwrPCt8KDwqTDlsKrw5jDn8KdwwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrDCr8Kwp7CrsOEw4bDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscO' WHERE `ID` = '10412'
# [24-Jun-2024 14:08:34] /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
# [24-Jun-2024 14:08:36] /finance/root/bg/invoices/10412.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` = 10412
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:12:41] /finance/root/bg/invoices.html?from=&to=&keyword=efam 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrHCr8OKw5bCr8%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [24-Jun-2024 14:12:50] /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
# [24-Jun-2024 14:13:37] /finance/root/bg/invoices/2066.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` = 2066
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Jun-2024 14:14:09] /finance/root/bg/ajax/invoices/form/clone/2108.html?pid=2108&_=1719227650892 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2108
            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
# [24-Jun-2024 14:14:20] /finance/root/bg/ajax/invoices/form/clone/2108.html?pid=2108&_=1719227661659 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2108
            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
# [24-Jun-2024 14:14:24] /finance/root/bg/ajax/clients/select/type_0.html?keyword=efaset&_=1719227665795 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHCr8OKw5bCsMKew4LC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHCr8OKw5bCsMKew4LC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [24-Jun-2024 14:15:04] /finance/root/bg/ajax/invoices/insert.html?_=1719227705750 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 41 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` = '2266', `Language` = 'bg', `PostDate` = '2024-06-24', `LastUpdate` = '2024-06-24 14:15:04', `Type` = '1', `ParentID` = 0, `Data` = 'dkHUocE0NR_4Sd9I7XG1dpKVqsxJsVoMUNbZtgEl2mAY-jGmLqm3euMKXtnOkJ4b4KInN1n_avaUwDU8VNnbx1PRh2fKkk4t_4xuygpUZXZSuyq6a50MoTyxHfXV2A4QOUosd_ldlQW9K5w08IfWTEShSHldSSc2RuOp1FlBq7CY14_9XRowRT0RI6Tg7cb8ZhwLSlXAZ0m_nDlDpPHjFQEg3OPSjmk786McBDl1B4q02MsoEI9gtYZG5iTkT810TlgoaAQc9sNdtZi19mHqAeausrvI4nEKAp2RALpn3Vbrx7AGCluO3lkSsPBYcHcLHKN4pjnhnO5nYrqDdiCmPijg-Z7xG6XTgL0mkpE3V6sa1ZN3j1W0_ZMfJTr1CUiUzr5snDPmjydSuWTe0DVZN0bBYqvFMdyINAFgpqWG_j3ZrDSwKyXy0if5HV1Fp_1FbnHUQ-uNjIQwdaZ_wcWDakU5mgmu_vN8iNI_qaexqx0BgYhOdNxrSFPCEXdWKr7KVhmvMjxNvMyBYZhTNniRtaeNCzbq-ah_Z3eQeBV7jVVr4VQcHfD5WHTDrRSeTmKx2HQGcbAb2FilJvokFxAEZP2k_bnVRZfYg8ERR6RNqfAu0J2_SrDDFppcEeh-3WjBOXzfS8IZd_IkxUcZqIk5FM4UEmztEnjsuFiUzbmFTQ3ihkGPn0kp-_2HUXNGYdRxRPf7JqrtW2Iv-IS6HRLf44qWhYZSF6QC0Emd863vL65DgI6x8HgjmXZOceR7ZXSmihPbWd2JDyWiVHKQ7aNoIVT5oWUmu2lHJnhSSUVNTS8Tw4SvMVd8IGqw880mND3f9lEIPVD6dB08C4XcfsgfwYeDHL3XSfYsFuTVcJ5AxLt17Dp1q2EA4USS5rHPnlXqkGZiiZIS_q_3EPZF8KkqlaIn48HgXZHK0SAluTxLrK1vEL9dpTU2IGnvGKzHJkmazcOVmxYcaNZcMm5Pt0o9bsCY_sjLVjl7zIuhlc1APK6m0JhWJy_P2ADmd0hyxRZ0', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrD'
# [24-Jun-2024 14:15:04] /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
# [24-Jun-2024 14:15:16] /finance/root/bg/ajax/invoices/form/2266.html?_=1719227717260 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2266
            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
# [24-Jun-2024 14:15:21] /finance/root/bg/ajax/invoices/update/2266.html?_=1719227722357 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2266bg', 'vBWUSC1ur1YIaBEC4eaDxyVevLqaZeIx1pPxg_uSmuCp2JvbdEAlIXta7MFJdmWhiE2GT8NPprU5RBNmaa4OzM_jxKOtUko5F1f2V-8L9V3oFfaBdGSyfbyb52BOcJDVRWN6hws7SrVzAc6qGflR7KlBoeh5ZNldf10SN4D89lM9hzCQ_wMUhS2Bnl4qACO0wHVyEMOHyJEKCrr-ukg1nl3UOE76EfhVKdOe04FDbu4C2q6rCUuY26hWk5Lm8NdUD8QjJwiq3UEdonmSlCBi58O57wKKd_rrspVV1yS45YD77PqfKaocuSYH-Ooq1489m84Q5FPjtmc05rtWLm223VeTiHKMbcaLGbGf0C86mxrppaRKdTLAJ-iQwpf2stQFQ6WNDQRr_39BU6quRU0i0GPXpHYg4a1xQ5TXlwzd00xXpfYZYrx2MoxTDMSE7vK7rICNcdO0PyhBrp0ZG9ot2gbL6_sd_TTnkmYkpcssYO9pyIPijPUMtsqvtAbB8VUMqhSfseMdP3jofsz9QvDToSu0QOIVM7GzrROXommd4Jf8gl6S_-7KlPVQcEkdnJuLAsFUeZJZTm5ch7pdeqCyCEUsBINnH1KqIPk43INqUrDzrlG-gOAWoDrx0ZcN7DIL-fDM93K_Cg_MifyL8xw3PwGnCnQXacOlMphV3mGi9Ur_w0Mmgk7LvrwteT0zEnAlS4NaJsKZYmrGP8iNFveXaLwcwlU0wtGFardRA4n4gM3NA6A8Qyl5ZndXPXNGKrh8XL67KeF23nY4R-6PBqxt2TUTp7Z-j7aiiYFMfDCq-q1TTUPBFBdLFB6mQaN5Ww8ssqSnXaACtewSGlH6ccNeG3ucswYtUK0uVOAXJs2PGpNuo3g4-iXbdRxBCYDT2clooIti5_87Je1BZNowGqrmemgFXymK_rM2xVTFiOVWC8FAFMiXE3yu0alHIMdmQnVU2y83SvE5NQOxu4oxwwF7tyWdVgkGbB8aUpUm8sAI6-_GkzFfC50Tz6O6idWcpLNQluKyECC9wNWpDCXOl9_KudQtYQ5aoBDaBFlsU-FASiPQmyfpFMEsZ8lnduGZwjgcYHFOm0QvrneGudlMLLdG_ETFnCRRaPI3cJ2XLGL2D8RuxPK4GF8ik8DTLLkIx2iprr83d5mAsXnaSqS3LSD5Hbs_zrKqFzmvfHiXcTgmd7vuI0dDQmmSSzUEiUJim8m4mARV_io4e2gblFqm7prl8fGNMthuwPokPoalcdTYevYy-zIN89tu3xe5sMZJcrBhtr6DUPnXtzajZezAvSvoy31oe_LGWMuKrmtMmnpbxcG6cIWe4l3M9LSCVeQGPC7fCK69n9jxuKcsKkedTjEUIttgKZ_GZFzeXoWpkt7cuLtJT4fxDKt1wSS73xPuGsncGjsY6qPh9a0A9PS1DBioK9CVgU3EJJxcyUk7C1Ru9AcpRP5bI-OgWbGefsSj9IA0rLIE_9klp0uc8QqRa6kj3YU6R0ZvwvJPJlRv772K4aN668JSaD6UXThwKfZB4R0CXHzfdv8GqJM92XzYy5wona5V9pczIi9ECGpC6-M18W8Z_J53uQGA2ocA06ZfiewcIuGMgahOpOL8eFk2py7sVhZzvkLR7Tk6Z98jgjRTjltan0Oy5GB-36hEgKrh1CjtQVQis5-GIaec-hYlomoEW8Y_bEXirzB_rawM2g-npYjMfPH4OoHSePqqBuq-836AmUKd794FrjUR5P2y-m2umQ0D2mwqLFWRlCrf3YXBUhN6sd1RUHt7tMFKkV7mqDFx5G5K0gKbEubUv_ycZHFawtFl6SPNxSInivs46XVShyNGrg_rPTcNdhf0XPNw3J7-8ewnr3qYJx3uDuFabRLp8SYFIaJBmQmWc1cFH8a3n4vmY0KXLUyFtHJEFHj3bX3XI7MTHF9myUPdgct0R5lAL5ci5seMMrbO1WIPcL55MK0')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2266', `Language` = 'bg', `PostDate` = '2024-06-24', `LastUpdate` = '2024-06-24 14:15:21', `Type` = '0', `ParentID` = 0, `Data` = 'nrhJHAfQ6Gbbj0nMaW2klXrW8Oy5PzZGX7DFRCTS_0VeymNaDIn8U2YMm5vGoDs8ZqOlZ7kyYwlvGxJ-p8F4IYFXLcVAU-z-tvMOaUz81bliNIghdk0reqJgPRi7fGhc4Y_Ea68iwgbpJfkhOP0QQKWELlldOb2FAwgpJlsgdXm-7UgulIOyr6Ie09VxEtI2hJyBTpFOYsYwUGBb_cnAZ7rQKV31SNyLXGyuvdMiJ2Nz166VPocuAKdxvgBiwT7_TSVqafYL4rbZ9xVuvnB0vLrNd80v_W6q2UXpOSEPsEErMSIAnlpjYGRHuzaITAKISeeOApDwpi6pyadRemJG2aaioPRLeziY5EfNte2zrx5enPGAqtumwB1fsgxvbh6gz-Jl0xC9QoUc5q8zgU8T2P9e7eRMN-OdWin8Z_kEypy2nvW1Iez7ZB7So7cAag8wgrGdYGcczYmd7OY_Pcbi52pYyYKHcqTlNcx9M0b4QLr6KQBAJLtva1QHkz2ngoCQ7HfqBCdx2xCInJaiAnZOXVgXxR2eEqjASeR9LZvOr-kkpAX4jzHjxb5t58K1BvdtdrzRYwl-UVSbrqHa1cH6YyoMSZQTNuHlfqGrIScf0ts__S6366k98wjl0iVwIy8aBdUJK8HhbBSi4GWIFyh1uMDwc59FIiWHxlZEBViGUUK6Xob_JxwQay4mhoBVqI40TyHhFaAPZI3EXl9wxennK-p0YbSEmFg8QxxoVOE9hwRSlEcNMQaWsRAzEHHm6qqcy07hwCZUx9EG0xbjv_jv0Y0fjllCGwmyUpwUffmIKodn7pUP7_J7OvTah3k3JjHSNqIYyx5EBYdiYaA7oi0WnmqfoHjjEeRae1KRAriSqlY-WaW8aBDtkdy2MCRZ6d8x6aRpbJk61tJA-O0lV3vS0PgtPBhZvVK6f0vEmiMrsNPFaknUn5fYUu9IOCGbXLU0LuHX4lSNxTYjRITkgZlDE_Z4p-HTVZucHStyP1c8eCz804KQbVg-rtzPWLeY55Jc', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrD' WHERE `ID` = '2266'
# [24-Jun-2024 14:15:21] /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
# [24-Jun-2024 14:15:24] /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
# [24-Jun-2024 14:15:32] /finance/root/bg/ajax/invoices/form/clone/2266.html?pid=2266&_=1719227733420 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2266
            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
# [24-Jun-2024 14:15:46] /finance/root/bg/ajax/invoices/delete/2266.html?_=1719227747366 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '2266'
# [24-Jun-2024 14:15:46] /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
# [24-Jun-2024 14:15:47] /finance/root/bg/ajax/invoices/form.html?_=1719227748515 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
# [24-Jun-2024 14:15:51] /finance/root/bg/ajax/clients/select/type_0.html?keyword=efa&_=1719227752830 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrHCr8OKw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rHCr8OKw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [24-Jun-2024 14:16:08] /finance/root/bg/ajax/invoices/insert.html?_=1719227769663 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 41 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` = '10413', `Language` = 'bg', `PostDate` = '2024-06-24', `LastUpdate` = '2024-06-24 14:16:08', `Type` = '0', `ParentID` = 0, `Data` = 'uQwPI8Hcqb1Pnuu-AfQWqYn8xTj09VTgdrWfsPkqu--sOJN0LHwc-Je3jx5fCCAHOsFjF3lBK1V1yGXVT5NuvECWE6CLPAgm-suUAPaq3PuogZKCPhMS_f0BbMMK6F6SxMOkHFLBRezTKLw6f-SlxM8mg4DOVmgP6Pdatyi_LY2Fn8rznMfM5sjyo-eeWn-j2be5mrpU-IyksKsWqng0DM0uv0cpAYG7cEL1a8eOqqprrlroWFBgCih8JUQjcY2HsODyWsfFnCMwWHQ06J01CVIX0L5aMB-bNe3g0l_XbThoJ3m2hpMuQvSSQ3NBZ7BJA2bfCDEMASino7JEuIFf-Siz7MVYnBV-wCb09fMRvFHP6V_Pdk2w3GxmfTn_rXBV_CRk8vUIoGaSW1ljnguCXlF49kHnTA5h211gO4tA1cScctDncn-AuAmKDFxvq-KZuFAz5tU6etsQ2XuKocp5WEgJlJGEyWJL_lqWvh0JX6AnDKkjz8RBMavTjjK1ViwQmJGjOpprO7qDZR7cjUakb8imjjeEpAWTQITTycmvMT1ZLfAHriWpeQQUkhrTxPpL88J6KH5-pbCl2iDFVFB6zfNt3Vix5x2IpsQU_ldWIQQzvmqU4BE9ACoTziJtADsFwDZ3R8dFB3d7DtpWCCrahP28Kin6Q5H_QPqrgBQPDv3sIpoAUWv8A62Qq0XVymtk9DSWuFaIwUsjbt4y6-xa6EXt-5-gIkxagLwt3_O4lySsLfH_4_wb_uylTHT1kQRpIu1mSgsqgG2bxFbIHuzoGWyyPH_yphMok-2mtALpdv1Y1BBCzDQYh9kjSvaDOAQ4Pm7DYouLAWdBWiXyQCmf92Nh-xCE6ZRR9nrJVGXm_f0nMNzy1VgiHdTaCPkvqFW9dPHgOZgCc7U9kmRhOPUtfM2b6PChwI58PKNdGfefrhD9bshvKBI-HroX6UPSzzXP0zb3MG3mhZCFXI86a85hYB8KIsoz2wUZbwRu9gu9nOgQqjoQ4ueT-yIfuWTC31dp', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrD'
# [24-Jun-2024 14:16:08] /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
# [24-Jun-2024 14:16:12] /finance/root/bg/invoices/10413.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` = 10413
            LIMIT 1

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

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