# [08-Apr-2025 18:35:43] /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
# [08-Apr-2025 18:36:35] /finance/root/bg/invoices.html?from=&to=&keyword=sterimar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8OCw5rCsMOZw5jDqMKswrDC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Apr-2025 18:49:38] /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
# [08-Apr-2025 18:49:51] /finance/root/bg/invoices.html?from=&to=&keyword=sterimar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8OCw5rCsMOZw5jDqMKswrDC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Apr-2025 18:49:54] /finance/root/bg/ajax/invoices/form/clone/2391.html?pid=2391&_=1744127395062 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2391
            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
# [08-Apr-2025 18:53:01] /finance/root/bg/ajax/invoices/insert.html?_=1744127581639 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 74 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` = '2464', `Language` = 'bg', `PostDate` = '2025-04-08', `LastUpdate` = '2025-04-08 18:53:01', `Type` = '1', `ParentID` = 0, `Data` = '9gAYTsY6TKq8QwcqkuCc4QM-ESGzckypoxWCW8LqfTQpur7c4SSJhn1XRqdOcpSBLgKSgc35D2CLlMOF6lR35dcqxfJeifwoHfSQ09TOL6R-bnE8tDUIZTdDML-ID0CGp5vp3PP8DLYZxOONmIogOzdKcbDZpSxuJ1CvNbIlf0687szHkGDIoKI6-1rxcsIXQYL4UArg3JmdLwRCJZftMELkU9FE3BWCiS1JRo7Uc-tdXNViAIDp5b3kBwVtmrBQnmLnQ-2CuHazasovm_aLYaTkTusGVq7zu53iayrWZqpYKO7Dokt9IfDTk2Sncdq3Sd3qPPALyYE9h40GPv6xMK5PQ8crCdmiX4tzvXePsIK8-DMSus2_ljqtYieyVcN-epZfIJkl7VchEOKBXX_Ws8f1spTY-oC-RyD1bIboTucuhxv4okTNTg26JYiCGooiMMJQWzaZLtSspKafqXEZx3z-Xhq-JO23UlgQcNJmHLGcluZjij6dvlVXeiV6MVJj-HcgJQegka6s9q0xlsOKulDoyxSDvoqUS4lZfx94vmVInuKInUsga75XYC5zd1XWT9kDYHO0Xs1KdCQiLGJ4UmdRpXxzzDze9XHsXNyJi0QBs9kQzE5l-D3ELEQ4CQJ3i94RGc2x-OrlLFH8kBiKk0WmaOwfG4YKVWd2wV8ZAPHF3a-jBnAtQDOH5aq6sCdfdUrS1gGbmHhluRCKQtLj3AriLlct30k5uPoeH5K0sYz6bWFUVtqHqC6jHVfu8eCEBj9Htlvs1MsmdD5W9zurCA9MIJh0TY3XMQCKzKdF51x-Ynq7w-rgICB1kHyTRyta1BVYysNoWR3oL6rLOhCX4YfV_IO0MbLA5h9qOQjQ9IHj51siIkWKA6axEiNEFw5dYrZ9AGgMT_oJtl8ClNFtxEcqFJaau4uNgdkU0oxxppc', `SearchKey` = 'wofCscK0wrDgcOQwqCrMKDwqTDhMKrw5nCwofCpMKnwrDg8OgwqCwrrCi8OCw5rCsMOZw5jDqMKswrDCwofCpMOEwrDgsK6wqDrsKDwqTDlsKsw4zDn8Kdw6bChMKhw4jCvMOVw5TCiMwofCpMOqwrDgMK6wrPCtcKDwqTDnsKrw5nDj8KhwrLChMKhwrzCvMOXw5TCiMwrrCi8OCw5rCsMOZw5jDqMKswrDC'
# [08-Apr-2025 18:53:01] /finance/root/bg/invoices.html?from=&to=&keyword=sterimar 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCi8OCw5rCsMOZw5jDqMKswrDC%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [08-Apr-2025 18:53:03] /finance/root/bg/invoices/2464.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` = 2464
            LIMIT 1

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