# [28-Nov-2023 10:16:49] /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
# [28-Nov-2023 10:16:57] /finance/root/bg/ajax/invoices/form/clone/2115.html?pid=2115&_=1701159417967 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2115
            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
# [28-Nov-2023 10:17:36] /finance/root/bg/ajax/invoices/insert.html?_=1701159456498 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 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2132', `Language` = 'bg', `PostDate` = '2023-11-28 10:17:36', `LastUpdate` = '2023-11-28 10:17:36', `Type` = '1', `ParentID` = 0, `Data` = 'sgZa9KDUS0ZewxIwxMPGnPmjIj5KOdYFE__XjQW8IKp86xj9bnpYrWYYEUUALtHLtXUngcPwXDtI9vgpsPf1YPRIR08Q_eRhXIscGBfyM19uVQ1l1esGcI_Thin7akO5zgcHjXqZQFVnv4hKIkTeF0xMlE4p2EqIpUuMftCUxGYi35Ofj-Lbvoq_b0xnGCbSwxNLBMxdUGmoBEdzEh51Xn-Pr2cXOchKz1pciaWVblM8JZd4lsoGW1_wuFgohj6V62I-jYIfRhb8b2C6yNIZT7N3t4iOeI5MUKHNNEGrLW-VGKnzX84Hx0lMe2cDyxtxlzqdTbdwJeL8NP8t0Ln58RbxHi4CuOJfL-x0oL51roz2MH3lLNUZETbWfojANzKTR-WvmVx7tRz3FiKS-2Ehq5bBBrHaSzy7r4tyMOejjdn2EbOub9sbJRxkWdK7hb-jIbvBmJ_x5aVhrV_bHbMsMWbngQYIjk8v9QTVy7yn7Jlmi1oD95jY3_bZg5HIzl--X1gkW0vhL8mY-Z558IdPsa5co8AFBZICi0Ko5UNhSKA-7EYXo_s7uihyzN2EeM1tdb8Jwl91IQ_2FesUrbX5SovVrU7EQnFSPq-SPI7QaVy7wZY2NExkbn8gh4ExbJ5RzMp-GQTP81p0s4IPqgPBWcdn-8OS3cFF5VZkOAN55ZiBVSqbBBIz35WIxUdaqJCnDSqHpBLtClWYW3xmthzC2X-6p35YAxDM2jrYWasyNBKKPS2MkJbY1U_EqVukNQXvO4g7UFxigHWJL3A74hL0VkVgw7KLxGolxx9B7XLGYH_hBxcGdfObnwqbmtlslReZD9RjZLQcCdL40bF_2yk3K1MyT-sawjzkeQBQ2dyqm9qTcmbqPY-WdHoNeLUWaILjqqIAw8HOq3fBFuJpgglI6WWrLYL8T4D4c7gfyG3TjbdHMi4PBtnYdhyrPFOWwrdXHygqn2Bx22V1xGqR6NSBaKU5rLkZVe_5j-3FPXfz_07cDt90CVUXBk9zEPX09cOl9xJS3FIORe_EV5KJOSO-2NoxStfVG04j5Xs3kG_3a6nW0wXKxTgb4_RZOzp449tBJniGBrGddKLgISuepHG72eBJp-iVQXbnbKpgb3WVl5p2ZiToWS2rbp0pT8AxiVtttAMViGvrjKLSuaSj9aPIRCDsyTtlN7RLux8M3BifQ2_KkX2tnqr3HOSS9MRfeHvuzsvkzpSBytsl8smfi7HEuZXIeeE7FpMuIcy01SGBtRfIVVIZozsxOSHHo7BtW33M0M_UjoZvMpJycYy7WYTWho0ga3b6aBvLHO8LiS7UY1XxgYaz5FWkrdwyUqnP6pVADyCxySfTiIz4e7rYVWrsBJHOSGKjpIypsZqHsSxa2BnYiOE_G1BuMZ7u5hkzCKk4QD3TF_Cu2OajIHfFZOAscImjjgzms5sg_bUUaAWQPJUuM2AiMcSV4cKRSfI_du84cydNyy5Oa1ObR98wWO8liZewYz7OQymjem8WO9OuhugKeY2x6h7VlwbANKmbmTMqIarFVK56LQ4fAUc70W8NUdnALWzb7wi3vul1nr4wCij8cGKiroWzlqMMoyGXrko0YSN1mmRbhRXHL8Et4_yn7Qo2JfeGl3gs_FMYqBuJ1SfDzbsDr9qtvhzkilsEZCzz67USf0bXvCn2ETlZYtKgHmeT8lTGJkNBmAW6eB0YIO3OQn3brfTaIH_Tf-BqrHWdFl4fVJtIp-rCS_l67HfjNJ13_pQ0cCfMqtmuxH0zDCfD1DQP2K_9Y5WiaTYd3_97X95fK5YPFVPV8lNj4kSqfSQmlYsPp7kkewhuvbsDJ_LVsHBfS5XzLWuNbuM7DUts', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [28-Nov-2023 10:17:36] /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
# [28-Nov-2023 10:17:44] /finance/root/bg/ajax/invoices/form/clone/2116.html?pid=2116&_=1701159464831 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2116
            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
# [28-Nov-2023 10:17:51] /finance/root/bg/ajax/invoices/form/clone/2116.html?pid=2116&_=1701159471814 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2116
            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
# [28-Nov-2023 10:18:27] /finance/root/bg/ajax/invoices/insert.html?_=1701159507314 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 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2133', `Language` = 'bg', `PostDate` = '2023-11-28 10:18:27', `LastUpdate` = '2023-11-28 10:18:27', `Type` = '1', `ParentID` = 0, `Data` = 'DXLj9FuzmhvgEiq6RGS-FWe29EGXfdT05zoGSnzH42tHEWLSBPZ0gXa0849tjj8N1d2k-W9ayGnSQvvvbSNvI7VCw8F7d_CT3_Nridaa3mYlXLgOOzZKOYOxhfPDTjaVwVLLxTWyEdjqFrXeimwTUqbzRBKokCRuxVaafk0p598rUAggLus0DHEvCkxKfuBDa2Ee8h3P2zRTIE0MBljkyz-0jiMO3MYwO3-9jvsN7kGpMCcPkRis0KNg7vBTyil_WCa5au5eJ1nnHArbOxZTp2EEUqmNz1QhHCcJ5vXOf2guUpVSLjCd-2K5h6hXf8tne9arAsWw8WfVAGRbOnnThTaZb14NapAJDEawVCZOfCFVH5mmIySm5p92nDSGqmE14BA2sDQNo4ZLy4hiXVrjL-ZY2Sx-sxMSaKDCyNdwv6uzTR6JFpIHfX6n5k68He19lOTTCROH0qX-f4QA1_zwxfty5cP4Y9dOQ1alaDX-q5d582qmiQql6ltUNdU8xJVSMa5YePlaLcHzxcueNlLQCnZYMi1rs4bJjgmwf9sngtQov4zlNtTez61IQHvNH5tSm2MmyakQVgojQ_d9f4sIZALeTALV5hEvLqH7G1_nrblqSoDCUU9kE0dD935WCsQg3LXDucoI7TnBZ_BdP6NVt5qhurrx2puGwfAP0ze9qmt14UKoKkbotapjrD-OORNRvs9aKFpL_xrSsif-tnmENzvN7-YHcJYmlZjZhndAGaO2TJMU89MCB6YelKlojbuQSMHRIyeO7BCzQVZLtb_1DAeVUXlcxd_K31QMm9NimmZMFW4l510q57D5Z1hvX4jZXuUUpViJU_0PFfdmOXNFLTsVJbrE26JFAL5oPUqFOBWeUmKkCp8BAMsgdUOOKJQIpcdriNDoHTpcBqbh1t6CtOuLN43pFap8DHBM2hdqVZtkN64R11OUOanV9PbneiMgsagGc5jsAHNisIXmVNgSzVPkDde3A97u3gVIz_-nBfQ', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCpMOEwrDg8OgwqDrMKDwqTCsMKrw5jDn8KhwrChMKhwoXCvMOVwwofCpMKjwrDgMwofCpMOqwrDg8OgwqCpMKDwrHCvMKrw5rDwofCscK0wrDgMK6wqDrMKDwqTCo8Ksw4zDn8KdwwofCpMOiw4DCtsOgwqCwofCscOAwrDgcOQw'
# [28-Nov-2023 10:18:27] /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
# [28-Nov-2023 10:18:32] /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
# [28-Nov-2023 10:18:54] /finance/root/bg/invoices/2133.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` = 2133
            LIMIT 1

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