# [04-Jun-2024 09:14:19] /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
# [04-Jun-2024 09:14:21] /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
# [04-Jun-2024 09:14:29] /finance/root/bg/ajax/invoices/form/clone/10405.html?pid=10405&_=1717481668648 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10405
            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
# [04-Jun-2024 09:14:35] /finance/root/bg/ajax/invoices/insert.html?_=1717481674874 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 32 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` = '2262', `Language` = 'bg', `PostDate` = '2024-06-04', `LastUpdate` = '2024-06-04 09:14:35', `Type` = '1', `ParentID` = 10405, `Data` = 'RJ6bYJjigxMi7Qw4fkS26KuiUNZnQNhFqSKVdnE8EAq4CDb_XYwLZu8FStAXVtR0U11njruyB0gTuvcW8P5uO-EhGHr-bfkAM8VA0nyNJS3KbZz5lcASfy_afsCNph50mJInjFykyeL6f-01VKRAY0eNMPdZRRZyyCNqFGeC0dXOXdJsGBAPApOrbUInMdMsUAOtpOb4OgUnQSHtytnWAQGAidCTL1mUpNennUK7x8TOqF2hA17eiO6V88hYbdhyOcbAL9kQiTLJLGwZCeNIUrRGEhEoF1kvnU5pOrjcYT2MJH-baQAQsFgJ7KguJrRa-Lu54AEo6BK714uAVT4vamrLUHU1IQiQGBVrT0zhbqLAjoW8F7izPiBrzjd21tFzaPdDO8K0LnKiQGKXZHbvEpNhRiYHuVE_WkeBxrCTm_q164xHnYSx9zTWXvccoYnFQEd2G-XQDQZWSngctxBjcZKGi0h9z2J-OJkIQoPXSqCI4beB37sktlcWHFXYi0lOdFvNK3Rema5p1X46h-eeLzHfNqmXyv9qO5Lisz1dMu7nfXAnN28nN9TB7rWGMMnkPd6GzbqvmHvsxrL4XSMYVyWzdpkd7W3yloJtECdZBUnr5KlXF2YtuTHO8v2Gkaci8iW2PHPtJOiBCi8ARYCs-sm3ef0PVadwzl0E6EDU_u_fnqCSxlvli8jQEYxIdFXeUohkNRBYZKtwI5EH623hNU6Y8fe9Z5msG--YgQcQavUPpa_VIfezwjyj5BWhggBuAImwWo9u_zgcFOX5TsiCAsxXgZpRx5OtY1bzh29WYsWtw-PdWR3C5td3V2oq01WyZsJU9ucnf7wDZVHvYka9sUjPt3XsxCy1AZGm1TAb9hJZ7Dx6ioBQYXM8P_NlRTi141QvJCYq1yP_hfOAo6x_rkSCfplC9iSug79g8Hvj0L8NZ-CDGmBG2sIg3FN8ee8582rmbD9T6eTlDxs6987tdg8ff5rJK6c8c88ZjPtQ6GZBrRN65gtI4lgZKPCAQy8Y0Jf1l4Q742FT7jFQ5ThAAnKr1PsAEN07dbv9sRXq3VrQFLc17j1YX2DLMU4du2FVCaaF9fHcjHp8Idj6gLXNtg', `SearchKey` = 'wofCpMOiwrDgMKlwrPCwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw47Dn8KdwqbChMKuwp7CvMOWwr7CiMKMwp3DgMwofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKhwrHChMKhwrzCvcOIwwofCpMOIwrDg8OgwqCocKDwqTCwrjCisOUw6jCpsKfwwofCscK8wrDgcOQwrPCusKDwqTCn8Krw5rCucKhwrfChMKhwqrCvcOIw5TCiMKJwp3Dg'
# [04-Jun-2024 09:14:35] /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
# [04-Jun-2024 09:14: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
# [04-Jun-2024 09:14:43] /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
# [04-Jun-2024 14:03:32] /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
# [04-Jun-2024 14:03:33] /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
