# [19-Feb-2024 15:47:17] /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
# [19-Feb-2024 15:47:22] /finance/root/bg/invoices/2186.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` = 2186
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2024 15:47:28] /finance/root/bg/invoices/2182.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` = 2182
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2024 15:47:35] /finance/root/bg/ajax/invoices/form/clone/2182.html?pid=2182&_=1708350454331 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2182
            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
# [19-Feb-2024 15:48:46] /finance/root/bg/ajax/invoices/insert.html?_=1708350526261 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` = '2187', `Language` = 'bg', `PostDate` = '2024-02-19 15:48:46', `LastUpdate` = '2024-02-19 15:48:46', `Type` = '1', `ParentID` = 0, `Data` = 'C8wR89bgFZh0e-s9EQvdhYh9M2duyNzxdgTfRbnz9kRz0Zx5yIMmJESrkWkjoW8v5WADmr5qaf34gW-GYflmlpey3WPV4UcERsmNXhyL2MOL3tCowoajPAWXrOd0VqFI68dAzn98RqYk5-XbXy8cz_YtGpdas_sxAQ9wl-FGj2L6jpeXxOPPhrYJrxFAU-DrHufaUXyVvOXh6em5rKzvPsacHZpRiKLythMIbhwjDbx1Ujz5MJdWj09z8OE35pbblkIXC2BKgk9FOotDL5LimmY5byHs0t8x6ZD3cefmYSVamudQY0nhumMdteYY39L8r8qm9ZVGyTQNALmOe0lHnO-bH2BeKoJgTm0sUQNand7wKygArbqrEu37f4VtSZgRV0aI2iZkoL62kYgkk5LwwezhHEJxxXkHwEMNKZkMUw6ZH1xea42TKJTRxB8AaFgj5jIK9K1hUH-Ul3FmOIUektf7GVavoCl2de1O_64DLhP1Rg9y2yO5IGGNuKFs-G8WL538EgyoQa_7zksJmgryepZJkxCEq_cttr1di305oyivXK4aLJezfJ8jHDAh2OHv0_yuywSLGw0LBjlKpXprcdtea-nfQd6Qu13Yx6jZsdF3o2kpNxKRwRuZB4QFd7VufVkfVZUfqMhPPR-81PcJ_-0cn9GNONiTuKg5biQUw39hqKMCqJDLIRdEXD_0WYAA9iyN_JN_oyxQxH2tEaZZ3FZekQb_ocpDVvYIxQ4MZXAbCsLtLFK-a8H34AJYEennjNI32risxC8Ejh1msXh0bCwnQNLmrsuvkNxfXjkAc0ppXPdlkidsW73IWtf6g7gDHw_J7wBNdMgvaKPMGAAPBAqMU2zzvUvC3y7NtJJmAMSWL7l_gA34G-qg9OzPwLgtA6wucdRpjGK4xwawinv1UbJEYaBgw8UNgXPG7J8Yj5YMCQkAMhODd05DSh6v4A3YYEYoVbj9uNtTu-jstZqv_eQngH9dxADnbASr9lPn0t_UCnV842NI0OoxdWcilC5BUyJyyU8GWz2loQv83-tcE4E1QVHQWjQdOht1hBy1xL0', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMOEwrDg8OgwqDk8KDwrHDns'
# [19-Feb-2024 15:48:47] /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
# [19-Feb-2024 15:48:49] /finance/root/bg/invoices/2187.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` = 2187
            LIMIT 1

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