# [23-Jun-2023 14:16:15] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` DESC
# [23-Jun-2023 14:16:36] /finance/root/bg/ajax/invoices/form/clone/2007.html?pid=2007&_=1687518997031 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2007
            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
# [23-Jun-2023 14:17:06] /finance/root/bg/ajax/invoices/insert.html?_=1687519027450 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2030', `Language` = 'bg', `PostDate` = '2023-06-23 14:17:06', `LastUpdate` = '2023-06-23 14:17:06', `Type` = '1', `Data` = 'XcJilfN0YIm5wxve8ARo79btV6g6sCeQul4qqAZ5Cdqpb0q6mBewTuNqej4z81AhO3JwQ_qcZfPMAYm9x48UsqUPzolttkR-kRcAtseqeD2GFuODW0sfScQe1TNQ_Ks1oP1hqk3F3s6utRFgv7B_wJhIlT1u3IIspMRozco4CbW2eA2W11YAMQ3OT16SL74YNS7gDRf_Mhf_e2JJX5u-Qexv1vOhtuQgvPgiQ2sJHU6HY7fn76uKJc-UBqt5jrS2xrgyRNELb19DbaqVcFKoyXSLW7O4l1qfDUNMmhw2JLHXUtJ-_p_OVbgMzT5KBXY8CzZHTCtfeKSl4XSfr-ji7bWwIYUQZcalHIBuIerR5CY5CiHx9RVs-t2R7TeMM5Y4XlKe2K39aUaNdvUfNeY0924PLBkP3RgN-js3Vgzhy71SjmhuH200OV4BlY0RDTPIRZcSgKPeZygmfD3LMlB6EvEAnHilDxMzTxp349mU0XepdyF_kLtM4NmMnN_9L-7DyQMQWtRCOX-Unre6HEH1ypGjcfPIDo0QXoD2ZjgDHM80ZeDol-t1WhR2td0B4KeKF5RuqHnf6MhXaNkv9BaYvaJ4gniYW7jTU3SrapIHVQ6BdAaiMA5tQyQ2riVlryBR7hfEdLCbTHYWdVD-XGgp8mvSrwtXD1_W6VCP9r6MunLg8I7FL8o1kYjm-myUpntzQmVEbLSCZMz6KuOigf4BYGA4kXLADCY6Ujy1FVzWSaduNQLugtiJ_Rjod1sdLGML6TcgGX5smcNN3DIVqKEtxA0h-URDosy5shuDtrL7Sf0nA_9-kpFKWKIhVcb_Q5TJhayBKCAKUATlpC7I00KuNcsQidRizYWlIvOHTjr948GHmUkNCCS9AlZMTqX9yLzUObdhCQaiSrX_rVtn82Knmpzp0WvGU-0GSBI0lNHSvk57LhCTiFqkFNBMvxk3RbHSj9WZzRIr-ogB4P0_1jAG06-05WgnUX-catIzRcv5CMU4azaZBip4RJM-9ynVC47uafKdc1ebNuiYay4_AZo-HUJhSsvLz5YYANI-qZR8mY_rT_xh5TAEbJLrusLOo5gin2RgzaavJsYxQNZpLquLQ7TEhwsepG2c4GVIT9zle6-hAy0Qjb3txWnAeIn9zo4thdYEpMMvTVEOO43yq3otbgT1ksO9om8n5pc6yyG28UuX8pcSeoCnyhUJKujUH1M-nIWJJl--TX71wJfeV9AOCs_kEtWQxcgbukHWKm3ooLeAZKXeNzlpJW29KkXvpnPxpz-dnWJAjIFkjIHMkoMnm4bYHqNGGtmrog35a6VUuL_ium8mkjxXZDFkssqaQSWvB1Kuya7w5r2vZNIreLi6TUFacastLxGuWuIe-C-2a4DugQ1aPy_yUObmzietWQMPH3GiL2CbNoIP7AIXczg5C4rPUxORzUNd7jYdHzdwYskZl8JMlihQt_qm7mnvukjC-p141os0QbnFiqGJseDMfHTFLIrK0kYptvXc46dXI9ltmgGcnus_bsAnuL6CyF-BEonX-MKY-7_EdNfEmJinVY87qHHpB1KHkuhgwKaLLkgFF4Qx-NENO7mRDX-ScSkRs1MjyfanaUMI1ZL-NANX7H5VZhYVD4auM_sEq070uySzsnqG9FyHuU72LI0srF0hjSA4LCsLBU6fqP7QI3kOBIbw-zODy1xhzW8plwcGXKXDtJHHFqONxIKdtrIYWBV9aXjDqsL0_FOhC6GdUCd7la-_HO2cs_jX3V9PKAqXIrZ8LybVCF_PwxzbED5DUGzLb_zlHhQ5_InyttQmGYqW8w', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKdwqjChMKhwrzCvcOLwwrrCisOGw6PCsMKewwr'
# [23-Jun-2023 14:17:06] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

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

set names utf8

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

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