# [08-Jun-2023 16:08:36] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

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

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [08-Jun-2023 16:17:51] /finance/root/bg/ajax/invoices/form/clone/2019.html?pid=2019&_=1686230272430 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2019
            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
# [08-Jun-2023 16:18:12] /finance/root/bg/ajax/invoices/insert.html?_=1686230292553 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 18 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` = '2027', `Language` = 'bg', `PostDate` = '2023-06-08 16:18:12', `LastUpdate` = '2023-06-08 16:18:12', `Type` = '1', `Data` = 'gJfquaV7lbAtdoriTcF1Ly1VyZ7czcKzAHM2Alx4egCXkuyo1cUGhf7dFtVoKkKl-9S8hcoiyuhhAiVB7YI2Os9P6gWlQ5lC9hRFdnixQjnIm4twSiwwfW1IdAFNNpfxrLzAhRkIU3xR0tQc6V992AN7jOHaN2D2KJ1hcfIyzAWboMZM4qQDVvfDN-saV4Mf8rKTjS2saP92RDslZAUkkrDsGVFVgoeF8QpKqv7UQoL7UGlcBIx4sd4r1Py1d5jrEI8MBeMLdh5OBYP1Axe6yIya2BfKcXTO73WPoaicTzD7RoyQQ8zxWHJYsXLn-g4MHy1TveEKvgCR_SVnMhrcZbsMVT3z-zT2BSnNHUZljlbIaGGo2N3lme1FS649rQrHw-d0ELqzoEVgNmSLBr8mgqa_ildxV-uKeUIbmWa3jM3cb5lXLZIAlMFTkkxUWet8FBAJxcrtTSzVuhlXlov5_Sh13oQRmOO0blDbvHNfVNhfmz3RLf0jyoW-zRfSIwbh4C53mCLM4eB581mFN7cIqJr9bx07fYT-OCk_Nlkr2V9I98TlIn24n3g6QppLXhcvA2TO2ZQlK6Rrmf_4PlF85aXSPRv0KhhJ5R7WC-8uBfoqkQWBc2N2Bc8kbnvoWSlwDXy81rgjfwDdKAPH0-h22I3fmVD7xz46nVlrlMqc930koVT30QlUbzeddkeLg2VqhizSbNltwTG6r5rulpfIQRMZG4dxlbHJzbjT9upkj_BCuvJEeemczGa_aHqvguCvLZl2VJv7tHpkgK-MTawFamDFzupjWaw94dB3e16JanGypRObu17TwgqX1XIhMPT8B8s6MedB2PDsL9WyeDHYvo29E9ZD4lcU1DITMyX9aQf-Xrf9x_kZY_qtkVGh3Pxg5S8DaAD9_tq3P7KOY9Q1SHYMRWZcJicWd4XDs-TfZJ6pcOsbEyKs8nheuG8C0c5hshhet0Ni3Gfl_KJdF04BkRChjB0rZ8vPLhKxGhr1jTYbx2vcjlVv50dxGvuUtVE3EETCdnqF1j2APzfKQIEXIg5l96JCGJ1JEN2briyjv3zzDLm2sKnh0eL9BP9Lc9Ql', `SearchKey` = 'wofCpMOIwrDgsKlwqCpMKDwqTCo8Krw5vCucKhwrDChMKhwqrCvMOXwr7CiMKAwp3DgMKUwqTCrswofCpMOIwrDg8OgwqCocKDwqTCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6w'
# [08-Jun-2023 16:18:12] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [08-Jun-2023 16:18:15] /finance/root/bg/invoices/2027.html 167.99.142.201

set names utf8

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

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