# [09-Apr-2024 11:30:01] /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
# [09-Apr-2024 11:30:05] /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
# [09-Apr-2024 11:30:13] /finance/root/bg/ajax/invoices/form/clone/10398.html?pid=10398&_=1712651413810 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10398
            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
# [09-Apr-2024 11:30:20] /finance/root/bg/ajax/invoices/insert.html?_=1712651420236 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 23 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` = '2226', `Language` = 'bg', `PostDate` = '2024-04-09 11:30:20', `LastUpdate` = '2024-04-09 11:30:20', `Type` = '1', `ParentID` = 10398, `Data` = 'Wuhwxk6-6VFAiBiEE6UPoDErpEjYCGzpbfWnba1QCXqU69ZJoNIJvea4YoP-IX6n4PLxaPfWQskVgKRrwNXmfB6iezV49MVijzAhhsU8li7zy6xO_cHXv6XU9O4dzme1yR7NGqjcYta-TBoQ7kfLtBLSRyFFQebPDwkVD2CmRn_5dH5ixY2bjZc4MAyRoXChREzQYHfkaf8xSE9Op-inUVo-iUix_8dGFME2LlXuRegCuqAng97xf9OyJ-PCerSXDengERsGstVr1yFebYdmq2DMmyntpH224Lo7tRK_minUaKl9EBO8nYpknidFH_1xEtK6dNCOsD6t9qjTy5CqvCS4nGTJEZ3xeiXNISNji83P97vJJkaD4e-W6VW1JlO3TCJPg_KOmgTTdI35-hp9p1pl-S49DUURMFzNEl3wp4FA5d5o8uF6bXJTlHI0VQxRxVSKSiKGSEdPvr6r3aPZwLER_vToaLt4QVDWqVHyXR39eu95hy5yXQGj39rNnHUAgrZl5lKxYcp2tmd6kXnxLzTitOmeJndkar-rTelwa5kzugsyHiCygCj5f4fgc2BT1ZJnq8UTvxK_jvAI6b8-nnAuPVPIr4TWaJBlSzwufmx6jY-Q5xLEA2Qtp0wTFxkmdyCnI-9IExk4-xJV7ykdYI4E4blNA1peuzEkTFuouGP3WIYBlNoHC2o2oi6iFHvKvEO_UNbms-Xx7V25z4NuDlO8EnhiP4I56bjHGQba6dfGfzcjz8US02Cn17jiVOFDlX1kjTNJ3I2G35PmN_8851ELISKIDYt2gR29ZwKQZFkR7UsXbVN9neBSXS6JI4Z-yYj5HpfZczNhRHSi-d8X5PD39J9Wil5Zzxof-FFCd5tutFyAWJYTTccvSQYJcscenP_pksI1kTR2U4R3O75pDhuE9gb7a5NTZMtbEh896tHZILS16c12p1oFS6P8I5PyWKE8VSMZ91vHICZ6-pyUeoYbR0e95nvJ8sV1iCM9dhU2M3b4lBGFTRdUhK0SahGZ8kt4MWRljQJ-qCO-ksYvVjfRIPBCMAzFut0k3vZ28XTjYkz3ysHnRcSP46DrFpCiecAcrG-d967AsYDIL103Hg', `SearchKey` = 'wofCscK4wrDg8OgwrPCucKDwqTDlsKsw4DwofCscK0wrDgcOQwqCrcKDwrHCuMKrw5jCucKdwwofCpMKnwrDg8OgwqCwrrCisKpw5vCrsODwrLDrcKtwwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCv'
# [09-Apr-2024 11:30:20] /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
# [09-Apr-2024 11:30: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
# [09-Apr-2024 11:31:09] /finance/root/bg/invoices/2226.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` = 2226
            LIMIT 1

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

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