# [18-Oct-2024 14:04: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
# [18-Oct-2024 14:05:08] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [18-Oct-2024 14:05:38] /finance/root/bg/ajax/clients/form.html?_=1729249537118 167.99.142.201
# [18-Oct-2024 14:06:23] /finance/root/bg/ajax/clients/insert.html?_=1729249582847 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` = '71', `Language` = 'bg', `LastUpdate` = '2024-10-18 14:06:23', `Data` = 'emuXdCrtG05BZOQg3bQQxZVy-BajDTbDpvTYokZxwRnk48wibM4n1_1pJV0fzCY4q3JU3n52CYNatH3M60a-dF_US6sPnzMuFfRWgTF4oen8gEzQyhQDvcr1NmfcnuZEcpYqaqgNDb6S9hB9xAcE-F-j4alrXxvaq1xZ46J_wnA8rmVEO7a6cmXDe_m_WO0WhtD2ZrZ8T04FsbPGFuY_4L1s5X2gryRIQYQVI6rSNlXtea6u4lIafPkhMh9wQvFt57Sx52BgrSX_awmaJTb3xE5AEX2LOWITFqkVMqi4KNBdKr0-0psueZep0HBQq1hlgx3UK0nfFPEv_w1vtucU1G-3fp65D3FaQ66UbKUstccOq-eCuwdfyZpqZjTephIn', `SearchKey` = 'wrDCsMK6w57CpsOEwq7DnMK1w4XCusOJwrDg8Ksw5fCuMKcwwofCpMOPw4DCtsOgwqCrcKDwrHDksKrw5nDj8KhwrLChMKhwpbCvcOIw6TCiMwofCpMKnwrDg8OgwqCwofCpMOqwrDgsK6wrPCt8KDwqTDnsKrw5vDwofCpMK0w4DCtMOgwqDq8KDwqTCn8Krw5jCucKhwrHChMKhwonCvMOUwwqTDgsKxwqHCmsOWwrHCpcKgw5LDhc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-10-18 14:06:23'
# [18-Oct-2024 14:06:23] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [18-Oct-2024 14:06: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
# [18-Oct-2024 14:06:39] /finance/root/bg/ajax/invoices/form.html?_=1729249598030 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
# [18-Oct-2024 14:06:44] /finance/root/bg/ajax/clients/select/type_0.html?keyword=aria&_=1729249603195 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 71 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` = '10434', `Language` = 'bg', `PostDate` = '2024-10-18', `LastUpdate` = '2024-10-18 14:08:29', `Type` = '0', `ParentID` = 0, `Data` = 'BZ5JaYvwNpuo_O-3W9fuCm970qYcCkhAIYbdsPjpY8LhdBn_HOqWl-nq-brQIl5ZLiFAAP-Ch50s7gUUaCRzrwGA1fesp9TgBgdVbW_tVS6IhG1Xj_azXKHi91jzbPtsHKzU3Hag1yY6FH18tzlOcF_wRONcJChsr4Zi5pCsXB0Fj_CrKARruJeoYckcU__rnIzmsks6vxOPZV6gD3HLol73UJ38uCq1xK7PoBAHKsRYedz2ZYylWwm_z4eH18AfMShphhhMfwtt_dTODm4tOTz8rXS4IxXlliwhsw_wV2W8LBC0t1zEuofdCZebDYaWM7qWzh6toP5PHAnowx7a_y5syJwqxwZiCnDoGRQy5Zu4z68-C3_5T9iyyHQyEEnrzZcfI4g-WozLDaP0DSbjK-7yg5c_UFfqBW21mtZqhZNi7glzFJYYBhCyA7csoOiqS_oquGQ_Qu2nf0XYraErge_ko0AETSn2ejF44VZ0MBNhSo3PCKUjt7ZQJ_HanT7JDwGJj-cputRvbPxcS2J3MY8_2n9rN3TCoONW5lbRFBQGsZDdY4lLDQAtdto9i8H9Bw94yvlP3DBifXoDnvg77VdXa5DeoeelzwzynGYELzR2nzBnMLmZCYnLjaYxyyUy4OFAP1-XQtgtSTKZu3yNmxx68au3mTlHf95cVBkGBUvOxxgAeuJ0_qMf-5YqexbY963cN8eHxrK5qqspuoWFu-yhlHWoI9fHb3NrrJOjtYIEehMqSg_xKQE5c-q0b73fFnUFck20RljJJqcdu5doU9prtiPf5fLWp6pZBqAI7NM1k0gRbOSXUcphnnWk2B5Nu078aXUZ6-a20m8pFMRBwQHio3KawSxme0C1RuZDsYWUZCmcOy4vahCeH27wuRWqgLV5S9pq2YfBMlW8XrdSlJBPIRjgv5-ms9-yHwTLY5HlvSLXBDFQ6S-s6OUJApMFGcgYqZS9zMYcq8ytP4PRHOtJ4B2hA1AKGvlBXTCMcXClB6xKiwYLVHGlHU8ATmy_cpq7M5VldMp1GPcco-MW-4LsOpzDYAVvUFKg-77NopMQJicjKcpJTb_bEPuAPWX-Q9waE4iqAUp53jisbmWOZx5CKCZsnnk8oHEvi0oyBJhSrZgjigX_OBDy6WwVruQE', `SearchKey` = 'wofCpMOPw4DCtsOgwqCrcKDwrHDksKrw5nDj8KhwrLChMKhwpbCvcOIw6TCiMwofCpMKnwrDg8OgwqCwrDCsMK6w57CpsOEwq7DnMK1w4XCusOJwrDg8Ksw5fCuMKcwwofCscK8wrDgMK6wqDrMKDwqTDosKrw5nDj8KhwwrrCisK2w6LCsMKfw4LDqcKtwwrHCisK2w6HCpsOEw5TCwrvCn8K2wwrnCoMOCwwrzCnMK1w6bCm8wqTCrMK5wqLC'
# [18-Oct-2024 14:08:29] /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-Oct-2024 14:08:35] /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
# [18-Oct-2024 14:09:18] /finance/root/bg/invoices/10434.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` = 10434
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Oct-2024 14:22:25] /finance/root/bg/ajax/invoices/form/clone/10432.html?pid=10432&_=1729250544822 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
# [18-Oct-2024 14:22:38] /finance/root/bg/ajax/invoices/insert.html?_=1729250557510 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` = '2352', `Language` = 'bg', `PostDate` = '2024-10-18', `LastUpdate` = '2024-10-18 14:22:38', `Type` = '1', `ParentID` = 10432, `Data` = 'tvnacc9j2bvKYOOhZWuTaxn1Q-d77un7Lc0srvPggoPJtKe-qBydmiYU7-dD6vWHctV961Yk0nW4cGC3FUOo71I2UfmYqEav09vl57t4KMmGJDhsdaV2W2AqXkuP9PLXOdR_qUOJhs_F0Swp7EjzstBK4IdKtBAG80FyUNy_oWOJ683hVdRmoKPPiE6U55EBxY2RGd_SXH_QBrLCiot_He6zCWllGGTrrFNtwycVFXf3yzuZabEsHnMacFtUQtNQG8hvEyn564xW0iOQ5W81SLywRER6KZhhllYbDWXC5o4Onoa88jXEnZtRKhbaDdNF2nSPXIWLiqSjuLf26dVKlNms6igN2Ljntr_RtqJlIXxuBxxiA1wGrukPfUAAep8JKOuFSmok61kMAw4H35NL-p9OwPfSEkp7dE9fqZatE6pzFHomz8wVGpxygnKrbvxFse4PHTRMp7q-suOvhhE-L4CQH_WLm4z65b9bV1b9mFtGH7ptNhxhrYvzsvhjelPEgMM32PgcCM3V_Kf_wkOxpIaxqoKOEJok_kcNofu1eQzSRXvLmCrXf2soFkWzxkwE4HHpPBD__qYqKEV2OvxS560OQZs4ZaQcFJmM0Pe3_kLTxZfCoH4_xfvYhh18L6NFWtQB4jO8M7HTeaEH9h4unaUIQBdX6PWbG8nRpdctsKZ4R-8cdBPf7tSyPiP7Ay2QIy5QsQ4kHTf6AedwEymFQAQ_We2V18xWV6XHYXZVdCB4jlzep5tQtid_zguBfqRY0VAGRE980DS0hXExL9F33zvQBlMUPBhYRIpwe2zRzijRR46ufm1wirt7wa9F3mwM0pNS3qUYaH8TjXQYVCKtb8cbj23TClcowicbfyF0xtP12JSNzlQMrCTqNOxDtHpC78kAyjByTQi6n5TR7Pya67Pmb-pM0mYMzROsotSUHoR81XHXOiIaM4cAUKkUucjqVi0tHaUHvhGHDkikuRzCvQhmUVIQ_xGj_zCC7Eny8D7hpg3vlBmap4VB6FoYH_wnO9QEOZznYg_FCea8e-ogpMOZRGQgkCmfptDHdRWZVZE3MEAYvWy11A9cWxeZioW5', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrCi8KwwofCscK4wrDgcOQwrPCtcKDwrHCuMKrw5rCucKhwrTChMKhwrzCvMOWw6TCiMOKwp'
# [18-Oct-2024 14:22: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
# [18-Oct-2024 14:22:40] /finance/root/bg/ajax/invoices/form/clone/10433.html?pid=10433&_=1729250559635 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10433
            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-Oct-2024 14:22:46] /finance/root/bg/ajax/invoices/insert.html?_=1729250565063 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` = '2353', `Language` = 'bg', `PostDate` = '2024-10-18', `LastUpdate` = '2024-10-18 14:22:46', `Type` = '1', `ParentID` = 10433, `Data` = 'i85lAWlcznVuHraDExWZ4X_B-U2J5EaoZq31y-uaCABSD5Cpnkug6UYLyaDGQmIfwAKYvL46Xy_KY_ji1rKLxgi_iRAMuGTNG8dqSf1JqJOk0aXPJNnZONyh4H-Q0HFdH8GPKENZCoQoXrXDyOTs7DkdbbT2_G6EZlm-cCs9nmwVfnVt5JyMejHJPqwKSvYwFKmRx0EAoYxqS4eqXkNC5KlIQV16Uqulc-unz9nfC1KtGIH-s961tK_9A_G8yNZBuW7t6Jboi8Z4NrdxdqF1xL5HfRMj-AQmZVcr_0RPCV1tlIziZ7N6l98LcrjngbACu9kB8ejyKMNYhLoKMWvNuaHqwl6VXoddEJxW4Vs62GS6gM2Bt-1NZq5xV0ljmEkOVIQZ5VExIGtwh-3dfuG9qMYwi_QMb9SdkVsyeqkt2g7KumBtfINvnG6nsxQBC08ZtjUrI49-SQP31euu79EXvVGGhwq72B9xHK1Uz46E54GAs-DkSOuQLpVg5beK5MrD2h5eyqFbHLCYVWeeenmtBadHJSmYVE9t7xQ7DEIPNEBrFuI_zsY8DfRcDahgXimPNTzI2u0xGst8_Ak_SEwyvElgP0JT0V-ONqmyxfWJUEh-KI78YFnxg8AY-bgaRuRFb06StWVdf8LNLABbjXLksmVhYEt2jbtuCGLt-YWCBGUH76d3QDswWQZsILz3BY5OgYcGf7U6oj9lr3b6JXZeeJrVs90am89KOqjrc35wn7ceH1BgL11UP-Uer8DjmFU61TA8gLfD_q95BMW97Qz_bjNHm_hBCMfsVOUHcwstRZhzk6-agZTVX2b5EclpplYTDimS2qZ8CLaiEfDFmA4swodpAIOc6pzhXShsXuzKQzeg0AQQOfZDLYNnzTfUSY2HMDVaJyPar03liO6IfDN7shC7N44y_q_D3EPvIaPjIQpKaJ2_72FuvC_4OF2YXvE_', `SearchKey` = 'wofCscOIwrDgMK6wrPCt8KDwrHCwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrjCn8K2wp7CsMwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrjCr8Okw5rCpsOEwq7Dp8KswrDDwofCpMOWwrDgMwofCpMOPwrDgcOQwrPCtcKDwqTDlsKrw5vDn8KdwwofCpMKnw4DCtMwofCpMOAwrDg8OgwqCpMKDwqTD'
# [18-Oct-2024 14:22: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
# [18-Oct-2024 14:22:59] /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-Oct-2024 14:23:02] /finance/root/bg/invoices/2352.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` = 2352
            LIMIT 1

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

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

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10434
            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-Oct-2024 14:24:58] /finance/root/bg/ajax/invoices/update/10434.html?_=1729250697664 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10434bg', 'LnZW494VC6nYx-YCvgAOu9yUgsjVK4vdiQAJFU4Owz7GVXwPa7xnNmS0CxY-I9_rFA_0d8QKDPEHi1oDs4rvn-f6QFWcAh3CbnSi0bfEdLW-tjDdAXPSmmfUcJqgS4L-BcrcKcdkou7KANRR-Yx0whBVq76zg9iqdP0D-B1N6ciNtY2T1QjXzl9ZB61_F1lysIfGNmzoxWBMc-mZoV5gRKFzdN-6vQ02D8nL59Dy5XOpIx5YJGcBeF7NXt_QOO80wc923Qtvdl1vZ5-ZzHqC6nHE6z_zSQHbFy3NDTyPgtSq6mFSVBqoxqwP5nfEK_QSm_HBcucEvDCdyiSJ_7a3rgIsxzfVwubv92KxZ3zCQGtmYBofAmlgnK39dfQ_VLNAZOmRxVEtcDPi36sypkY0YG4hXhKTA6brivWqfjGTCPFXYG7zBvWht5R_O1ECVxn5-SXdYv3DtxmfWDW0x8uN41hHy_tlg3vypnlRL70GeBceLRx_mub-CJoab-h6TCtka6YKyRCgsFEc_65wwmeztYafB6EbbvjvIHk6VOTdyzvkyZuzpyo24ZThBkFUPJ9jmntRLHpj4L617ZPv0M5JZtCw1Vhr37O8gUuM3P8IeHrEdlMM3TOs-dtG0m9TSXd7bFqfGeBA_FRfL5YfvGK9xK6Ao0NP25hmWr7CQqZPQAQWN1KntBGklkUP-ZlZF4frcgHmZvOZFGph1BRj5hl5TQUgXHK2NtYNeplce0LFQnq5WhSU4k1hO3kVE4pr1bPgecPIAQQFhaSF6xfe36ztn-LY-XYFGyfz_shsvG6Gf6pSMA0ZmpeZlDt2Kuno6cYupy3pq5ZrtzKbbX-4MDLR3gUd3k9bOOSiSsYw7MK8K9tZA04auy8jHnsfL2YjfiLGZKnU1szSMeJHN6JFDC8wyeb_D0vkV6VnLzHh6rYk3-XhgVbALhfhJxhkasOwfkrX4e8SowgikTgwgUKfR-TmomnBOqVjXCrATsKShRRKtA2tW4zcb_PJUkLe_sywDN2W9a4WjwPHPD_A4kjeZmG-QzprREpoktrDMGrzbYW1YolW737uSS6Zmq4492r97wTrofP9qI7QOdmFbsze0VDS9ic71YYAwy_KdCr_X8CLN5VygsxDtFcd9Bi_Qv_ho_niXchOFEOFCgNGmg7MGFcXVFi-sWXAt_UmsL6qs-i3PKCN2osk_CInvcqXi8Rkp8YWFmL3cWt5kT2aFdhnEmZDzCulLknqL-cirkbWyyaRTJ-hzTci_kTkzb3s7Y-OwFSbIzsiW8P7QmPps6vSXHwaSnTYAZdTBj9VjJOUMJpPVuOKAFhuUQrfM6JVrcB7CIVO9i_pLyuU5l5lozkbFbBzPzq2rQDM_TM8kCPAwq2magTf6JVvDk5R8ipf-hJAu247ZeCpJ0Z3CmapJPBv0Cq6AB5kuYMEBdWLpw-Ekq_vcgVuxW5skBuoFNAC_pI8Vk2fb1XysLIh_C26-iv8mXO8RswperjqlnEVwCRHUCsh9HNRQYBx1TjPh-INDsLMrc5Eu4PswKiEjMR41xeEOrTeRgLAE3PjLmurPue1bcy1lD7KXkzXX1uYGSSyE9_wJqG8d8ts9D43xXApaJsyYbQ8_9D1ImU9EwwfHCovFV4aoI-9XfncJ4pFmtvrEGthqjnjLGlvibh22DzBuY3HA-a11KP3qEyhVWkrLf3pyv_b_52KWBAGQDlx25i1TQI1g49dL6TSRoeqSUfMqhlZ2TyWtpUSiqcXHP75_qanXyHmJZFz4Ib2AuDA7PNNFCC3JPq4HZSkwYRwZ9r0WGygbeIEBBoZwzTCrr8UBzlHftot3s-UAME5XoPghelZ8pKgDz8bA7zmgCcgguqlgC3LODAiNh8yIDit8Vr6V4sdBah0W5kR9EeOAgVhs0hfi1OKN-1eklDe_aXPOaReW-7oklI6-K1NbIk0_J7dFbkUjXagm7Lv6UChiiRm9hcplno92TKxfE1VZiHS6LF7AhNYAdDh5M1UxnNMDPpMjgNds0l6EW-OVh7OQk75oqZJfFzYtdfSYGtMpCj8TP1Jjt2ThKy2AXf2wS2UF04jE_JSl2Gby6yDi7NKwcY17i02VsQcMctBZYTgdBBbpSSizq3WaViDNA')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10434', `Language` = 'bg', `PostDate` = '2024-10-18', `LastUpdate` = '2024-10-18 14:24:58', `Type` = '0', `ParentID` = 0, `Data` = 'UoVDPLSk3vocEjjQCmZmPzkHR5bzivfMWlaF275kH_g0aniZcD7HeOG4cox3k7_zhozrGXYQ9Jq-D6moViDyoo2bS0byKup31itq9lmq8DfWi8SDJdlHk9ZeZmhkjiuTsL4_NDYwEfN9PGsY74RTtfJ4UZewp91gAgN1knmyYNH1-HbpF0s5Uw3TzRx9uxVlFNuRjXT2GgZo-Sc1d860RfnuCXsCjHD47R8oRxoqcCMkLPBevmOu0oesvFiZ4bpc8dyhNOcI9UGdZ_U_uD-jzRQqA4tlGtnBVWRzs4Ug5TOP36IHKykacVrWKezpvJ4roxaKOW4aaN0ppXQyYXzyGo_FcMzMsDemHJq4l4niuXIOsGw6FFRerb0cwqgwJ9zdnIas8aJ4dljVUmVlQzqZlokjK9XqCVErH5o_Uowmz-9VYVFyHPQ6T-Km4kinrKSthj6j_fb9ZaypI2w7lafSdbzZmctjuUHuQhC2hnxi-wJtyw9jwdM5q7fVFpypJYfT9_jen5xM6_96_JkXNb4mW3yiaOvqCm29gkmdz2Z3dRs38oFiiVKxsjN5VYq9G89IjmcxWd8Ba6DDlF7S9ECO1SoJL-auoX0ZGTk0_Q5WbDK80yb90QkG2u7u5fsQqstQhjTIkIPxYh5CfrKyV3rdxt8xJwKoDSpa2qGROw8_J5Is9dU9O-n85KwiZQKUhVeedVu91qOMCxvSR9jnEhuL_mqfqBkBY_-ME92vH9iYRv_ZKpNDbmcrQch2-bE5ZyafJmLpDu6CMy8WD9ruXP_2yfKO1f3KLcg8k6Y4JSUCe3gXOHR0Q_9oQ1haheAoXeiby0txU2FmpEt0T1AA3AhCLOvqCCvG458zw1ckcAHwf7FPlmT8cbUREIR1wr6DmSUP95z1l_cF55ygMYQfa8lLmjr0sxGQzLwBKTQw3gEcR8GcW0MLJF_XyWlNzUg6ds63_Qw4bWkX_Ej69CHfgHFI_1_cZWAkPiVInbqIWhihUWcK4-J0DeAB_sPl97mWn9e6ykcrqnwKVGAr1rt4FKt5QNu1-q4c1wCd9l3NTJOoi17CJlGRTqpM1LRcdpIRAb3Eo_F_uQRBSywZYeN9XVNifuyzof5ESQVt-V_sltouEAXSi5FJOTDFtxc1PioKh6tpgCBJk2dzW0ocvGILL4DAkA', `SearchKey` = 'wofCpMOPw4DCtsOgwqCrcKDwrHDksKrw5nDj8KhwrLChMKhwpbCvcOIw6TCiMwofCpMKnwrDg8OgwqCwrDCsMK6w57CpsOEwq7DnMK1w4XCusOJwrDg8Ksw5fCuMKcwwofCscK8wrDgMK6wqDrMKDwqTDosKrw5nDj8KhwwrrCisK2w6LCsMKfw4LDqcKtwwrHCisK2w6HCpsOEw5TCwrvCn8K2wwrnCoMOCwwrzCnMK1w6bCm8wqTCrMK5wqLC' WHERE `ID` = '10434'
# [18-Oct-2024 14:24:58] /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
# [18-Oct-2024 14:25:03] /finance/root/bg/invoices/10434.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` = 10434
            LIMIT 1

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