# [10-May-2023 06:32:41] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [10-May-2023 06:32:47] /finance/root/bg/invoices/1986.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1986
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-May-2023 11:14:40] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [10-May-2023 11:14:43] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [10-May-2023 11:14:55] /finance/root/bg/ajax/invoices/form/clone/10362.html?pid=10362&_=1683706501914 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10362
            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
# [10-May-2023 11:16:34] /finance/root/bg/ajax/invoices/insert.html?_=1683706600531 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 27 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2006', `Language` = 'bg', `PostDate` = '2023-05-02 11:16:34', `LastUpdate` = '2023-05-10 11:16:34', `Type` = '1', `Data` = 'R9IBh2emyoJRkhz3piztANJ4LRWlBpp4roT8qNBReZ8MwShSARREs0kE5pJpgjLr3xPvT-oCEl3ztIVMTP7nfTPaZ8MMPxVxhuyDqLP-QqlqkslrYHZ8x5PZw902jG8Hc8DdJ92LUtKZoTriICC9stLZeIWhZu-_Y0GlQmeiLqidfP3BU4VLf7mL0c3QNoUyNyxzDtoAUsKyGbkypXlXM3nTfX7MUFfD7afgEBUDB0fY6yUQn7uXm4Gvc-zs-_AgSLmRRVdkC-YUFmniBbCeW7ud-X7Nzn2Lq4nR9P5JfasbYDgp7aSbH3c6kSjXHsmfm0_3NneEKbes1oV29Oz6HnA4QYXBsIUNi-qcurCtPh8ROQh--Cy7-BOc3Zbgu4RDqhHy_05qmaucZWdVXqvUixYh4JWZmesdLnlAhyaO_gtw_9UoEZ9kc6WQvpIb2YBsmVUjILEDppLmdSnnU1ikRcd2eLkgSW74tOKTcFJr_M5Eabv9mEw_3qPXbmdb4qQYRFgVhJM4xPEnvBpO5GYD7A0TxFZ9nwtIg-RR42vcKmv_bVUiMNd_yhKoW4wZ0z7nAF-_87DhTXCcWpOECpUWSNw5vOR2LxLQy7iB0QgpUu0JQE-XPrNdhCrx5OcwwFnsaAvzv4fA-gMFCrGV4rFG0pisJmEe6U5ZTE55k3WyV_IbCLMxsZBY8YhPb8Wu9a7Yi-4QIdzKpNc3TqfhWATXJp7cn74QfT-XJPcvb-vUmLiDrfk4z4YKu_1OVrFQOI-dIiHC-3p5sr4dn7NwTVsi1hKog2mM0nLAR5Ss4rn9KB1J897PPsFXCiC9Uzm8VrOnhFZi8M3Yp_nwXaIA6e1O-P5hjO8o4OmBrayF91pO2J0kLbYqM7sdgD0XLO6Gypt7enRKtbTW69jpvUkGU_gc4tI6tIVElaFqtelvnHKAOY-G_6GNblGPuuHfZ2dshroOmwGQQLsw_YWxq9TRDW_3q4VEgQnuqSjH7nbvdtK3YfAmlEYiEb6gNncDwoj-V7_a', `SearchKey` = 'wofCpMOWwrDgMK6wrPCusKDwqTCsMKsw4zCucKdwqPChMKhwqrCvMOUw6TCiMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCpMK0wrDg8OQwqCqMKDwqTDpsKrw5rCucKhwrDChMKhwpbCvMOXwwofCpMK4wrDgMK6wqCrcKDwqTDhMKsw4zC'
# [10-May-2023 11:16:34] /finance/root/bg/proforma.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` = 0 ORDER BY `ID` DESC
# [10-May-2023 11:16:35] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [10-May-2023 11:16:44] /finance/root/bg/invoices/2006.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2006
            LIMIT 1

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