# [10-Oct-2025 08:54:41] /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
# [10-Oct-2025 11:53:56] /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
# [10-Oct-2025 11:54:01] /finance/root/bg/invoices/2568.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` = 2568
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Oct-2025 14:35: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
# [10-Oct-2025 14:35: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
# [10-Oct-2025 14:35:37] /finance/root/bg/ajax/invoices/form/clone/10472.html?pid=10472&_=1760096137212 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10472
            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
# [10-Oct-2025 14:35:42] /finance/root/bg/ajax/invoices/insert.html?_=1760096142371 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 84 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` = '2569', `Language` = 'bg', `PostDate` = '2025-10-10', `LastUpdate` = '2025-10-10 14:35:42', `Type` = '1', `ParentID` = 10472, `Data` = 'bustTkcMCw2qnT5Ix-Zwp8pTlGO9JDPXcBc2tDysZW0qlCwHvHWpM1gryPWWF-Uwpbg5PqbCkriSgAMLQV0sXRimNw1Mxs4CWEn8vImhYQuNpm61QAyFh4KVbSoKNOwhsr5GMFjXaCB5WTHiHC9nOYexJ1YpcU7CeBU_Gfs_C6dt8MYC8wmBxs-AWsYYg2shS_GLCqIP7ASFZc0M9_Xr7PlRqLIoucpTCwyGhJPyuy5ipFNFWFOnS8kFAyn6YqNL19LXrKoHDLdl8VRtThv-ByRZAYkrHl2YuEG3uu6l3W3fuwjTcdCyzBzA4LrT3eOLeyWmmpK2XPhcA1ZZ4o_sf-iWQQ6b9A2kyhVJxgp-cmCLmu-AEpyiUG5Dww-50cWMfvCGwgs_rMw8TV7yfWEJASgSuVfkKH-Vy9M7gRWBp2sd6h2uWKPhosbCBp-LhajZoL1KcyNHreBquWKucd-BKWkTV3xrfWqO18N7eTrMipnwNRBbL6_BSQvgiy5HpiNCM1MAPScnK9VdUp0yJdeMeAGx297DmFOzp1M5OcdYWXaKlqXc62XXIZY8IFgupGZ5aZYzNgEajeI8ZYnLGGXSQ8veVPii0IFOaVDj1t7yYJDNd_iYdNeeyu50vhqUcJNRl3nJH9Yxie6CoEeTmJeDgGbi_zdMTJY7dCHiLCmZOwES5iMO7hMQIX1MvnEYTCYWk2k47kymp82bBXK8q5vkRcIafidAw7Hh2k7H80fj5v8oTKDyRI0N4A4EXh6c9_-F1FekzpEj9BUZi8xA0bBW-gTSSaklzjzPr0noPzaAei5No0qLAkWaiU5Bk69grUu0J-KkkTFWxnCKShMgRr8vzJx1An4Z-f2qSWBlulprI7otpSVXadZ6drhJQaXLdfqlc6z0ivAEgL8qfw02Jvem6oyJrbOi6JKPEPykVEeIx_jZ2ANr4UNdQ9uMRXSYCs3c4JeoW8DF9WmDwyy79yF_dmktAmzTMJ_WgJHGknREcWME9aH-aqlexUzccA-wuGlFTnHVNIE36pHlZkAhCbt0_RFAOsg9WWnDkrVY8twVAARHNIsuc2obXql04K17D44uUvwp6g_WQNMy-ZCtz-n7auBOSuk4wQk-R-Tefnkoo3odUg2IXXq88iM3pwQMn1gxYZebLsXSEOIIDvx761HHIFTy_ONBlxrxK97Mp7FK7ZrmcbD5K_F3nPawtdU1KAOqwaThbYshojEwNbN3_pQXmAHL734LKZuFjppUvkYujCQ_BJeEP8JyN9cVxMnVrmqK5HRPmgAYEr0AqiwcmjaApA', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMK0w4DCtMOQwqCocKDwrHDjsKrw5rCucKdw6bChMKuwrTCvMOWwr7CjMwofCpMK0wrDg8OQwqCqMKDwqTDpsKsw4zCpMKhwwrDCr8Klw57Cr8OEw4LDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDg'
# [10-Oct-2025 14:35:42] /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
# [10-Oct-2025 14:35: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
# [10-Oct-2025 14:36:55] /finance/root/bg/invoices.html?from=01.10.2025&to=31.10.2025&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2025-10-01 00:00:00' AND '2025-10-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
