# [16-Apr-2025 16:25:34] /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
# [16-Apr-2025 16:25:45] /finance/root/bg/invoices/2444.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` = 2444
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-Apr-2025 16:25:57] /finance/root/bg/ajax/invoices/form/clone/2444.html?pid=2444&_=1744809956951 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2444
            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
# [16-Apr-2025 16:26:16] /finance/root/bg/ajax/invoices/insert.html?_=1744809976512 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` = '2465', `Language` = 'bg', `PostDate` = '2025-04-16', `LastUpdate` = '2025-04-16 16:26:16', `Type` = '1', `ParentID` = 0, `Data` = '2XxfMFJu74X5cWQR0eDJQ00ONiOMotYJp4nrQIlx0ZQ5ssjChtQXJOBVmwtrfOupTpKiSK9vAqBU1puqRl87tAhnzEX1cYupyiv7A3v2vv8W50uElBBPvwJQbAyKU77K_sCltNGhhfC9mYpzwAyLBxzgDX3ChER0HmVxvfinnXh8dgA-llNmSp0pOF2iOTvjI_ZR1aGUY7_ND9f2_2WeYaiwZaVZ7QWuoHrBlx9uJ_9CspuxeaPICrp0KWQLbmNhxB3QnDB-3VxSq1ko32vo3mpzW3AeZykEyvZlKtXTu8bJRMEHdmejSCi3L5PZYPW12WU0fr6MkeZnGXMAuLFRFK4oBvYMNr3gKeq7hmhNeiZ2JLDsnnxM6crFbi7EQw9pURhok5-nxvxCdufJAEnfivUIxSi9vJXQmeQBEP3tKz0k7W2sQedutwg9c-ORlKK4nllGtjjRZIBS7marXxbSP__Lk3A_eFV11K0yDGrx4_RIo9Qc8FVLlqfiN6_hWz9A_Mj4o7EnCKe4Y3On-zeXvImnwQrtbVDY8hzt8v9HuKNfokIGHmhOhfApdaeFghWytEth4934Ba7W2pgQ9UFO5g_1lSmRMFLUgeBJHgj0ttC05Qu58hoZ1sPtxlVTvOn6P3l8oiE1YJU6KJxW9yYs-CPz6n_hTJtTuNqPUz6bAo4Lg3TEJUtBb4eOPBPMPnfbRoGfzIW161dU_YM8BScTXbzaR1OxX94lH_bhL1w0B9aRPPB9Cbw6F2XUfSgFFTvprLXtjr4QWNKLRfjdHFQR-JSF1eJBH1kIjALCGH60KIU01wnJugKl9FfZCZMFGqlXaUFP75zfs3n0gINvh__VNfc9Sqs8RezvsQ0cEFv5BG2LtrC--rgzewXXzlppfi5njehfO-iI4jWe1yPsSMMFJaF3YuXmI9KeV25Ic9kSeKt2ncQShOh52IdUutFOSZFNIBCwLdWHEq-8-3BkTbH1Pf39pavAgic0iFmKOGhpg3aB2hcnuMiqMn4jrPGh1oyZqpOzCk63WlubhKkC7IVI1Q', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMO'
# [16-Apr-2025 16:26:16] /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
# [16-Apr-2025 16:26:19] /finance/root/bg/invoices/2465.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` = 2465
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-Apr-2025 16:26:44] /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
# [16-Apr-2025 16:26:57] /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
# [16-Apr-2025 16:27:00] /finance/root/bg/invoices/2465.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` = 2465
            LIMIT 1

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