# [12-Jul-2024 13:12:56] /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
# [12-Jul-2024 13:13:04] /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
# [12-Jul-2024 13:13:09] /finance/root/bg/ajax/invoices/form/clone/10417.html?pid=10417&_=1720779189641 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10417
            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
# [12-Jul-2024 13:13:16] /finance/root/bg/ajax/invoices/insert.html?_=1720779197283 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 58 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` = '2286', `Language` = 'bg', `PostDate` = '2024-07-12', `LastUpdate` = '2024-07-12 13:13:16', `Type` = '1', `ParentID` = 10417, `Data` = 'SgBWO9BinORDfVLoo7mH4gL7YonGQoNRUqSHzSf8E5sAP_UpBLgBG2w3vp5fj9DvM5_wSMEfylmCpBsF46SOCKNBeIGScWSasJdd0wtREdHRFyOPJn5PnTvP3wi4ikuYs1y_WuMimvXj7baijqwBujZVjeeN2sdoWGyJ5tLTZ3fzWMY0UVIUylNKfq4Gte33qDmq4WxXNLIJJMRG-j4IyDf_TywnpMtak9mMnVplT0pKMCXCr4WB7SNciV-rk-YQR1D8DTx7zdSsVxy5vc10HCHwleuKQKHawjZuWWrFOJea7wOunHtNFZnPU254gGh5oeukJszxz9TPKjnwgtUbkFOsFfzRhF8jla8BKoB510fxEpvMk5cWc5_8XY5m8UCzFFZoysEm3Gujtd9AI3pRfUi1z6M7v7TqHdj5zcN2vC66jmhi1YA3LG3Dc64S2VP-t0mttG0caoj-qCtJ2JuKwSUH9ijgSBhu2sG46QuNMKtCzxvlcAxphnMOv12QdR66v0LSLxaHZmH1bbnhwy3ln68V57GqzIY1U7h-ihupJNXZyhewoaIaJ2bm_90Gv8uXVleii1EGXTzbMfeBbAANU8Z3NKvOQ6FWP6sJAYfHnyyVikPSsohbtqxFzt_exd64K8XGeWwVCjegJ0QbIKLPmSWLMCfFFh7hE_Oq7MbrOqrX5a1lAslEq4YmiegfEhqwphj5QAZHFZYRJU8caiqEwrKffbF8F2fY89fzizgFLOXMKbcVpTSmtq8hI911U72fTZIdHmd6i70TJgVamOT1S0G8u51SlQmNEuQKpxBWyp1hR_40i5fnxTHxoatPgcgWGtc_pmXdvqSUAOYkFYA74UkyabfhqdBuZOwRXQ6w092ZR81lFLFUa8-UB6dtF5fvljk3fJDPxuoO47WZLKEfPzCbxnqOjBPAu1vK4Mok1OsjEjFRR7rg-a_Gj8ojBBxfRRFv06hFSuJFNU_nM5fY-6GFrQl2vxhvGdpVmx_8NbAmst0zj0mNNVCnLxCAWbLdSaUCAtN5fkkb4I3vZElmrw', `SearchKey` = 'wofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOcw6HCscOZw4LDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOU'
# [12-Jul-2024 13:13:17] /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
# [12-Jul-2024 13:13:18] /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
# [12-Jul-2024 13:50:39] /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
# [12-Jul-2024 13:50:42] /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
