# [30-Nov-2023 09:12:28] /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
# [30-Nov-2023 09:12:31] /finance/root/bg/ajax/invoices/form.html?_=1701328351664 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
# [30-Nov-2023 09:12:36] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Nov-2023 09:12:38] /finance/root/bg/ajax/clients/form.html?_=1701328358106 167.99.142.201
# [30-Nov-2023 09:14:57] /finance/root/bg/ajax/clients/insert.html?_=1701328497265 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '53', `Language` = 'bg', `LastUpdate` = '2023-11-30 09:14:57', `Data` = 'q0IQbdz5ovSyvn70I_h7FmFHq_247kdD51o370ZyC7tcdQfOUsjUS6EHjlcjOmxuyI9IQWuNGa_uIa2sbaR8_92HVrd2hKT0lkmO-8XPl8qGWSANbj6wri9UYLAimmH91T8sKn_x1WH0aY2vOy36F1I90XsSfEtfVaYcI8R8Z5rT2hz3Andn9kVH7_tLFD9eqBl2a5C2Tr7sVs8R1gVEKw8Glq5bvMgXJzs1ParjCMos8AbUVGmElRfQX9HUuDEQixzBivr5CXdaRKJi69yul0fw8EYoaJ7BXXJeRCPKCN4sSigSHRU5hffk-LSC9SIGUjxQTdavdikw_hXyfk4oMw', `SearchKey` = 'wrnCr8Ocw5jCsMOZwqXDqMKswrDDwofCpMOqwrDgsK6wqCqsKDwrHCsMKrw5vDn8KdwqfChMKhwpbCvMOWw6TCjMwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCwofCpMKnwrDg8OgwqCwofCpMOiwrDg8OgwrPCtsKDwrHCwofCpMK0w4DCtMOgwqDq8KDwqTCn8Krw5jCucKhwrHChMKhwonCvMOUwwqTCrMK1wqHCm8OWw4HCpMKiwqzDk8', `Top` = 0, `Visible` = 1, `PostDate` = '2023-11-30 09:14:57'
# [30-Nov-2023 09:14:57] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [30-Nov-2023 09:15:01] /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
# [30-Nov-2023 09:15:04] /finance/root/bg/ajax/invoices/form.html?_=1701328504368 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
# [30-Nov-2023 09:15:09] /finance/root/bg/ajax/clients/select/type_0.html?keyword=micromax&_=1701328509069 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCr8Ocw5jCsMOZwqXDqMKswrDD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCr8Ocw5jCsMOZwqXDqMKswrDD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Nov-2023 09:15:30] /finance/root/bg/ajax/clients/select/type_0.html?keyword=МИКРОМАКС ТРЕЙД ООД [micromax]&_=1701328529846 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOqwrDgsK6wqCqsKDwrHCsMKrw5vDn8KdwqfChMKhwpbCvMOWw6TCjM%wofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nC%wofCpMKnwrDg8OgwqC%wrnCr8Ocw5jCsMOZwqXDqMKswrDD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOqwrDgsK6wqCqsKDwrHCsMKrw5vDn8KdwqfChMKhwpbCvMOWw6TCjM%wofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nC%wofCpMKnwrDg8OgwqC%wrnCr8Ocw5jCsMOZwqXDqMKswrDD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Nov-2023 12:32:22] /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
# [30-Nov-2023 12:32:43] /finance/root/bg/ajax/invoices/form.html?_=1701340362832 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
# [30-Nov-2023 12:32:49] /finance/root/bg/ajax/clients/select/type_0.html?keyword=маь&_=1701340368707 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMOqwrDgMK6wrPD%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMOqwrDgMK6wrPD%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Nov-2023 12:32:50] /finance/root/bg/ajax/clients/select/type_0.html?keyword=max&_=1701340370299 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCr8K2w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCr8K2w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Nov-2023 12:33:06] /finance/root/bg/ajax/clients/select/type_0.html?keyword=mic&_=1701340386219 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCr8Ocw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCr8Ocw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [30-Nov-2023 12:33:54] /finance/root/bg/ajax/invoices/insert.html?_=1701340433376 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 53 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` = '10381', `Language` = 'bg', `PostDate` = '2023-11-30 12:33:54', `LastUpdate` = '2023-11-30 12:33:54', `Type` = '0', `ParentID` = 0, `Data` = '6aShRx1EyBDQtNQTU79BBuTeVwXMh0CaQonqcGmVLiv_rPBFQv23JdGJzpEs8dopB7p2RLfcRaEhDKZgORR3OmpWXMVBfaCSXd5YuO1jNbXtSL1l3qfDGDDfAimAT0ZAvjm7j3wAyvLWV3m1ndwPwheBmpvYWBCFgMr0w9XpIQiFOoompmPJLlQve6k5SBpRdFyG4PS4IxmNua5D3lAK8clnh1M_65r7QLkcatE3xt-L_g98Ddd3awkDPM15AaZ1A6-7JkmhydJQcFcTyyeRPmxOQIqf8BS0R_q8gmkp5W6RaNjiWq3JB0XkrMMkMno74llKq6WfUDKykPj-4u4K1qHkPQgnSgXYbq6x8q2Eh0Ff-oUhBto3TtXfcCkU415SiBVv5tww9aKGIQgp9uvAmzK6WjteOd4NQxRW4zAWgyej0hKQGychhO__yY_LLqkSFrUhUxWKB2cw9xEZPeC6WHjy2Z--9MiW_KxMv6fToWwqXqYTdgz_nik3Pqivth-a0R0MYvKnuUmDsROz_BBPMxIpRr8QjDvsTrqoSqTFQE0X6GFzw_nBKY1qRVRAQS_jTUBDLUEoIk8bOFSBIAHyP567BteKnqZCchEQOlPEX5lcNbd6D2_PaswjZ0omV0gdaVM4fe5d4OeH48mHlDwTPAjXu7W1xcGPhYCOc-nlzJtKvigecO_PjlS1AJCnnzmT15_ZzwkKgwxRk-XTWNI_W28xbbmRSIuY--ursIOqQ0Hr6nYOv8r1b9H5YD8V7jTP0FS1wvF73zVkYaMhPqV5hncTkpZ2P72YhlZ_WphhyMwUMUT0Pg1WFevEZl5JUZ1EJeATHfnKcj-JOgoyFU7p7qmtqSdOCdwsFHt07-rQoaAKw17S3UKMn6vDgq-GEJdiDZROw00pDEYvhifex1J1VnSZaF8lD6U_V3i78VSLVOLa1q8zTZTnKZe3go8MVGtsLwM5YWoxf1inOBxs-eHeSHjrAK1j-0t5QiilWfzgO17kl4m9iDqzSL41fcZQ2C5t', `SearchKey` = 'wofCpMOqwrDgsK6wqCqsKDwrHCsMKrw5vDn8KdwqfChMKhwpbCvMOWw6TCjMwofCscK8w4DCtMK6wqCpcKDwqTDmsKrw5nCwofCpMKnwrDg8OgwqCwrnCr8Ocw5jCsMOZwqXDqMKswrDDwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDg'
# [30-Nov-2023 12:33:54] /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
# [30-Nov-2023 12:33:56] /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
# [30-Nov-2023 12:34:01] /finance/root/bg/invoices/10381.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` = 10381
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2023 12:37: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
# [30-Nov-2023 12:37:41] /finance/root/bg/invoices/2132.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` = 2132
            LIMIT 1

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