# [23-Nov-2023 10:34:52] /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
# [23-Nov-2023 10:34:57] /finance/root/bg/invoices.html?from=&to=&keyword=computerteam 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [23-Nov-2023 10:35:03] /finance/root/bg/invoices/2097.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` = 2097
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Nov-2023 10:35:19] /finance/root/bg/invoices/2094.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` = 2094
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Nov-2023 10:35:29] /finance/root/bg/invoices/2074.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` = 2074
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Nov-2023 10:35:58] /finance/root/bg/invoices/2073.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` = 2073
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Nov-2023 10:36:44] /finance/root/bg/ajax/invoices/form.html?_=1700728605859 167.99.142.201

set names utf8

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
# [23-Nov-2023 10:37:44] /finance/root/bg/ajax/invoices/insert.html?_=1700728665734 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2131', `Language` = 'bg', `PostDate` = '2023-11-23 10:37:44', `LastUpdate` = '2023-11-23 10:37:44', `Type` = '2', `ParentID` = 2074, `Data` = 'F1vNqU74B6QP1_fxARI9UNLx1eBbQgm-rLLcpvE42ZWeLFvWx7RABdfQedGATE_d3y5nmP_DwMtrWVUI0QQ8PdFIAHm3JtgPdeeYKnJaJL4JQyCjBsZ2efzjWq2Aws5yyWm8kIYMAXTyLIcuqy42JmEUgroaj8oK3dbllvtzskCTB-ckfu-hHWSyDQgP2xQXWZe6gKlYgeNQx21hsPJ1jfDoFMFVoQiIGQQZilv773VkeJyrPFBl3fkZ2hoKYdLFkcvnHH5EJvKSCvp8kBDt0BA71or3f4audT4rZEJvLKDgowThhapIU8RV-H0OQ0CGAVoWoJ30KUm90hJMaipaMZRCa9_wubK9fS80PsXcd-o2fvdhhSrCih7YamqaNNkqeXOGzgwDHbNG7Vn7Jn6SoTbgCIgcdKmg1k6dC2Tmco8Wquqesai3B96Y8J-ip1LB3oN5ziPDBWKtu4fusRNaBHZXnkBpFlgvV7VmdzAf5SLZetkmq9LaxDn_4DKe5bFVTl0e41qxz_DUzuPj9sZo2XZMC4nEssoXLOGsf9GE9-cu0RTwAmiu9bd7x3CHfi1Myp2ch6mA-yfxJIlDEwUIlwDgbh7W-4qZNtF0nr3fvA04xNHFs8lxYGPcMhUT5d8q-MB5ZysYdIIqsSOR1cgnzAgoIBbIAzd4Nt2i2t94pRS1ncLw6XAc8_X5IzvGEfPjlrvLgUPwMkGmznOhVWoF9wwANILYzsaM3VON1tcWCcbLwmLuR1NAoAyMIg9yQy3h2HOVGbNGQeKdoEH4aFs6iuKlRSIOIp6igpp1bvOhC9FpZaU6hYwUzl0hg-uJIWpMNUI-yZBbW33qprBgu5fycJDrc3JI-_FYlXg9Lx7SD-FcYZcm8EZIh1O_pFoskIaknOL0UThV1GI7Hu6IyuWkQFt5ULSKZ8xOeJfvRspXOQfOCra1kAhsVPeQ_T_272uDivozpkTUY5NQwGtLNl5Hev2EjY35Pt4hJiV7oUHB8Vzmaa3tAj9NH_a9H2D7JTeD-RJyYLuZZAktNJmZ8a5wo3RiVW2zACWuxHsvzbOi6B5-aRuglXleUGkcE3rGtiH0K202erynUaeV5mv1OrNvFg', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMOawrDgcKlwqDrsKDwqTCo8Ksw4zDn8Kdw6jChMKuwrHCvMOXw5TCiMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCuc'
# [23-Nov-2023 10:37:44] /finance/root/bg/invoices.html?from=&to=&keyword=computerteam 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [23-Nov-2023 10:37:47] /finance/root/bg/invoices/2131.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` = 2131
            LIMIT 1

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

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