# [06-Aug-2025 14:46: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
# [06-Aug-2025 14:46: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
# [06-Aug-2025 14:46:38] /finance/root/bg/invoices/10453.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` = 10453
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Aug-2025 14:46:43] /finance/root/bg/ajax/invoices/form/clone/10453.html?pid=10453&_=1754480804503 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10453
            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
# [06-Aug-2025 14:46:47] /finance/root/bg/ajax/invoices/insert.html?_=1754480807883 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 36 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` = '2532', `Language` = 'bg', `PostDate` = '2025-08-06', `LastUpdate` = '2025-08-06 14:46:47', `Type` = '1', `ParentID` = 10453, `Data` = 'FIwkVRSw5zk7fcKRIjfHwkI-LuV_wQMRjQydQLex7II3TsLM4Y71RzaYgC5VEu8_I4qX0nzMVNQzIz3RoG8_SmfT0exSVCuoZ1kUIjz0P3IjIc62UZyfTTrI0u_Ru95qkuQkXZ2U4890KxD0Ffq7nhpt57bA8p8BeS6caSHyNjtU2bdsgCzATmEHAZh_wOIxzx00Tfw6580QcdvqPu_2wq2L3ngzqiqDAWCTpP1eVGI4ldruCVFLbmPpXu4xsvAFnyWkaIei67OrjopNufghEwKl3mVDmj-JD0FHoco-23xqYLBEMuIcEnPS71zYKHtiOonBY9ceZ8J5F_7ClxRF73qpOa_EoTC8UczFVUWnch3aYnNBT80X_Gy6yn5e8U5d4JXyfudTw1H_1UltfTDrG0sJqhVZb2O--VJhPcWPb7d4E6JiiU-2d4MKUed-XQ91AxqW9u6YBZP7q4banYKdoMIPiNDTJO6dLyrUrabszw6FvcU1Q2NaT3O3NaAw39dTYwqDqiKSXokOSkXNlwHo59Gv15HEpkk7X0t3AB-NQB-Otu7hAmUDokro5E7Q40StH73isnFYHRJ6yXhADVLeDZjvqylrQ4wTL_U431VZ7LHy0KpGNagZMYsSBkwjBF7e_7_g1GVcLKBQlo1_ByAEQJw_qOLfik-D95NzZAgnfOLXa_-KSgL8GKdpHhaAXk6qCgewt6mWqMID_bYXGuH4_8XO95Gl_eWEiYf2wqlyqyH2t5vfZSjl0c17WCHHLLjIyVr02dJb4cLyhDutaloMR4O-4QXxwpl29uTRB6f57wjTMTkajIV5xbHQkKtVOPF0Rooj6eBXIS6IKg2pKrSeCs7XhtOJKkf2zf41sDfNzEPDI78V5nLRizySZi91CY7fNRXYB4NIUDmfHqdOSFNTFIjnGuY2u3PbAm_rugsDRRXScIMZfnRpcly0r9vNx7_guurnws630e-9coinCogidMUwjr_g4HFlfe06TeI0_lFgLovsgKDAQa9tZkIT3KxXSjn1xt279yE0Jf1Ss7XqYjHqo-HJMDLaUZ8ECtod0Zk', `SearchKey` = 'wofCpMK8wrDgsK6wqDwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCucKdwqPChMKhwoXCvMOUwwofCpMOIwrDg8OgwqCocKDwqTCwrvDhcOcw6XCscK0wrbDnMKtwpDmMOPwrDwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3DgMwofCpMOPwrDg8OgwqCpMKDwqTDgMKsw4zCucKhwrrChMKhwrTCvM'
# [06-Aug-2025 14:46:47] /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
# [06-Aug-2025 14:46:48] /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
# [06-Aug-2025 14:46:51] /finance/root/bg/invoices/2532.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` = 2532
            LIMIT 1

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