# [27-Aug-2024 10:26:25] /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
# [27-Aug-2024 10:26:29] /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
# [27-Aug-2024 10:26:31] /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
# [27-Aug-2024 10:26: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
# [27-Aug-2024 10:26:37] /finance/root/bg/ajax/invoices/form/clone/10426.html?pid=10426&_=1724743597323 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10426
            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
# [27-Aug-2024 10:27:19] /finance/root/bg/ajax/invoices/insert.html?_=1724743638989 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '2311', `Language` = 'bg', `PostDate` = '2024-08-23', `LastUpdate` = '2024-08-27 10:27:19', `Type` = '1', `ParentID` = 10426, `Data` = 'IcpLcYFbMO4tzTE-SzsS2oif1rskphYT-V2aLHDeVfRo380uDMNQ2u4a5YrQHKkMYZ6J2oKkiyB-2irxUdc10blF3aSJs7PqxuUorYMDmUNdef9LiUd-naAP0DQDa2EhkSslbBptPu9WvNZoGg1zvyjzL21UbSbnCxzejik1sTp0503SCKLOQlHDvLvEBuWnIWPrOANCu-2H_XqVG-vmXnVdpUb86QMOO0FVeoT3G4cxw_mWtirljoIRG3AdVNRjRDGNHfP5__hqqyfFKm30M2Z3WF8LOU-ZhkcVoe10p9iyYnuta3zC0G6vDIzD1kKmwdUn4KPKz-TsaJdzgrWWTYig4GWWc9s9QZuz5l8uiHtjwjXlADR2vyM_nbJife1BQnJREdSr4X-UxJ7M6SW5j9uHNbn6Q1ok0kOFojY9_gXqw3bg-Myplq8hcb5m55ouyQYsCGOBstrwo_ODGR-2mebdRia0aoAm_gdgqjreB52LJUYCRMcO4p9m4eTE8k1dIyMBDy-tCg37t-KAf1OzbkGdTi3vO7MKVpxP0nVvVpeikYDoQgW1VBJk89o25lBv2DwMjO8tafDg-n09vYYpHyFjMdltDv5hPBX8UiusvDDf-9xCTmu7JhT867dM-se4Psz7aJn1-xB23DLkbourH7MNKOzZBP9Y6o1xHNwnrbegASIpALvchlXpjMXZuGNqCj8ptFgU2Xq1UKIwIgnVvSSOwIBmeQiZJYut6-Q_njdR7ItP8vD567RmO0fUgyUiuT0i25c1Rqs63btz0BYqhoC3ScR5FCe3DPPRAAbMu47Q8hUOVL8GRegQ-yu7VM1M54lUhPbzSPh5ITYkc7si5QAtgYa8yb9q6QMb7a_pIqj9wWycEEog7CaoyhXR_7A8gtyYQp7WFCDhbOBfZhOpvVFhSifjvvnVXoc64h_95amhUKUpt9KNbZUU63R2zwgG0b5aTEicowb1hlJpw4F9SBpBp9KiKRnuHHR1CDj0wrAtmPj2GAcmseYGLVGSYOfR', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMOqwrDgcOQwqCpsKDwqTDgMKrw5rCucKdwqjChMKhwoXCvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKd'
# [27-Aug-2024 10:27:19] /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
# [27-Aug-2024 10:27:22] /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
# [27-Aug-2024 10:27:26] /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
# [27-Aug-2024 10:27:43] /finance/root/bg/ajax/invoices/form/clone/10404.html?pid=10404&_=1724743663634 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10404
            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
# [27-Aug-2024 10:28: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
# [27-Aug-2024 10:28:50] /finance/root/bg/invoices/2311.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` = 2311
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Aug-2024 16:42:12] /finance/root/bg/invoices/1000000065.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` = 1000000065
            LIMIT 1

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