# [09-Aug-2024 13:39:40] /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-Aug-2024 13:39: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
# [09-Aug-2024 13:39:47] /finance/root/bg/ajax/invoices/form/clone/10425.html?pid=10425&_=1723199987320 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10425
            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-Aug-2024 13:39:52] /finance/root/bg/ajax/invoices/insert.html?_=1723199992051 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 69 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` = '2310', `Language` = 'bg', `PostDate` = '2024-08-09', `LastUpdate` = '2024-08-09 13:39:52', `Type` = '1', `ParentID` = 10425, `Data` = 'gtEtcbBzWwuk56ZpBHi3Y-sgdJF91u6kaIWZDOfYMf6WO87Glj2RfTUwDCOxEZ3HFXw2oTqEdvykM05hnI3LTGUmQUBWoJOm0wmACHJUNL3zjGhLWr9bJPE0IIrepjFYFRCD_E9mJxO5lYTYGBkSrbK33FdiJR6_hCkhCgFEJzEXB6ENO7vmu1atAUApiyt9nstD1FIPVyTABJGmmVYzudS5gwVECOzeN3EoNqg-b-70HQZunPqOQQweuZ_lpSqoR5lP7bhchHLkxuyEuF-OEjf_jd87bw-VojzPHJW-yEwGjFOx5Sxq6VL00gngxNCJU7agK5b-MyAH0am504vejH_SqrrfUNVrgrK-6Y4H8mZENDVWFPOajYQYmc12PfS85CL-KzGUOMopifh1ctCta6N5zQ0e0a0zYR4Wwtn_2F_YyfZcGAiMX-aVUy6IXkT0j6QM7MBZFaympD7zGbk1iu4k326HTkY63W_-nfWUK0fD02eOyiqXOfHFWjLSPfKi29RvJGPo6kwYC2CrVFFc__O1ob4XgDHD98D49SlPV4S93fHVPl7Ix0YQeoLp4cIqxtdUS-WreAed3JCgmVaILaRFYjx7Kymrqy0q9eU9OjQfFk7n3vjNjr-wdO4zkKrdtfkYfXkK7mcivZvsSy9upCvnYKWg2hdMTTc2EsMCKEb3UmGIUCsZrkNqaQnw095474VoJtRj3ECoDu1XPuY_vHhn6vueYGj6GFH6tXl8ElhVsb65TWVFof4iv3LuIAmhtNtla6ozXGa6OnF6hiTW0yLU7_EbzCjuoCKSYuRzitHj3uS-vkRNi_9wUp1Ry9cdlteeGC8izuBbny3Cn3oOnYXO36_egL3BsIhk9Rr5JcviMz-tU-DAL9Ozk8JdPCBF2N2RYs6agFlQVsq_cndEX6uXdVurFSknCJanX7hmrz3gl_qph7oNjBBqDngorw0uSSy1Wh9_iYa9mItjEuYX9Gameutcx53Q5-1uioVNlXvQ_YMU7LZAsyHyEVluu8uhzDeH1G_LwgFa5zAhVG93rB0p9bM0Menz-Re7jfJRFx8eXLsuZwR2zEWdukyt24w5', `SearchKey` = 'wofCscOAwrDgcwofCpMOawrDg8OQwqDrcKDwqTDhMKsw4zDj8KhwwofCscOEwrDg8OgwqCrcKDwqTCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrjCr8OKwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5'
# [09-Aug-2024 13:39:52] /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-Aug-2024 13:39:53] /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-Aug-2024 13:39:55] /finance/root/bg/invoices/2310.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` = 2310
            LIMIT 1

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