# [24-Sep-2024 09:44:45] /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
# [24-Sep-2024 09:44:52] /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
# [24-Sep-2024 09:45:00] /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
# [24-Sep-2024 09:45:14] /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
# [24-Sep-2024 09:46:08] /finance/root/bg/ajax/invoices/form/clone/10431.html?pid=10431&_=1727160368073 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10431
            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
# [24-Sep-2024 09:46:18] /finance/root/bg/ajax/invoices/insert.html?_=1727160377914 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 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` = '2329', `Language` = 'bg', `PostDate` = '2024-09-11', `LastUpdate` = '2024-09-24 09:46:18', `Type` = '1', `ParentID` = 10431, `Data` = 'hWk3IIp4zJQZ_l-E3Lt-DljGpApciLy1w4TaSmjIUOCiLCqNiIQ9yUnxTgLw4KAb_WhcmfzC12HYToj_s4xF3VClDTfnnuuqr3ScU5vZwIHug86Ar96qnovzgoPKFmpLg3icxAxUgGC2wsfS_q6tmW4tpeEBr-L4FJ9yy2IvyzD4HUgtLY7-g4RXSKKDovjBhtaFSq-Z6suhBMXymfGrpRkVgm8Yl_OIUkj__qXCYup3RJkTetOSedbQIzEG_3DP0595E-laVZyaTFjkTVm2bpRVSksYhoUIDZqNamyRNNatyDLO-PjDdW9MGdJaK9fli92cVNEqWiI_k_1D1dthBZH-8MpEb1H4aka7SajjkA3VUBq7LKk_cS9I7f7PbCzniQCUU48S65_HvVuO048CQdj67JwHn2KXUHjknYCURTOGmgkppISq_kY7y-TsrhBCr9p78cAl3viKb0dN7FzcHXOuvUbhoZj-s9lW21Inykb0y6mnY-ONBWio-SSJeJbW47tdfbrBm6aGiheAbXnV6yX_f0cZYUEva_dTrtzzRWhSlILbKkQoAR_VmXxPg-zyWgQHQJFbKRifpkDcFRmmPxincrGBlmlJVoJ-0K5RzsD71b5g50U0xY9YpZmxtM3Mdr_Jtds_nndX2dv4mO4RcjNFToFFIBode5qKTM1h3THOc5XphogtmXgpb80me6J_nPAMC8MdrD7cAj7DrD_7RXGOWy4Ji5fvUnbf_UZkvUz6uf1qaRK_ONT91rRbVgwxeJjuXoThw_iW5nnofC-daG84aLmsWKDbmjagL16w88WrO0chI4rv9jjyhQ2RLL4M6CNTV4vO9ABcadn4L1T_FBc-O9DpI5n7QOsic8Lp9_Y_MQql22FlycF-by07dfz2qVArI2Y8Zw4If8oi4HlgiLbDnTAJDMfir3S5gU7wxrLFuZyAdYlefsmRDp8IZk4prBK7V4PElYqu6PMdqbCs1_oqLgn2nrxerWRICg-R3Jc', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM'
# [24-Sep-2024 09:46:18] /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
# [24-Sep-2024 09:46:21] /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
# [24-Sep-2024 09:46:32] /finance/root/bg/invoices/2329.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` = 2329
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Sep-2024 09:46:46] /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
# [24-Sep-2024 09:46:55] /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
# [24-Sep-2024 09:47:01] /finance/root/bg/ajax/invoices/form/clone/2316.html?pid=2316&_=1727160421392 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2316
            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
# [24-Sep-2024 09:47:35] /finance/root/bg/ajax/invoices/insert.html?_=1727160455636 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 5 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` = '2330', `Language` = 'bg', `PostDate` = '2024-09-24', `LastUpdate` = '2024-09-24 09:47:35', `Type` = '1', `ParentID` = 0, `Data` = 'AzbdiwWNfW6HuxLfpLF_ZQLtfuzGrM2dVlwjQFjic0041oCLr-aWLKP90rUbOV4Z73_o7TBSs75Yphn1mNieKQMQhA3UchS8yKBp5L0rolm-JlHJ08tSSmPZU83cSw7NIhngTxLnN0YshLksiFkleD0Jo_PtQat-7COZjOtHTta7Y4VnaxMCScK0_PFDx2k6MQcLbUBzDr57GvZL8ixdNwDMrAHXGAIuBu3bjzS0GijGgVvRHj6KYHTX7tWji4Z84hYTrxEKS2BBSInQg3Hh9r53Q2xrAavlCuWpIRQ5pktCVx5jafzUZev5LEXC8SfvvtxAIeBgOMooFptXzoLTo1vZFqOMKpWxzI-EUgttJbZMsviedWUxLDxxWXbXuiPORPED46AwnB3LyuFMZcdOA1v84YR3M07TVT5MuflKW9O0X9hmNYkQAEabyJRjdAXiy4hoV3YxOYg1iqOo6tp1j_CuL8W58-GO9Wsxox0tmshNFO4GEhF2HsADRf8cDGf4KoNIJbF0bJUkZ1X736sCMchofjK2SLN4nZgmxBVvUOkJd01Ad_AmITMhobl0fW6nWiyqJk7grvDDCqP2Cxpza30fZRSMSulILrySDqZPImEq9dTrS703ONdjA-1OK88gs6Cu2gMCpEYN_2XhLlEJPVmj5CUqkeku4IzmmIU3W2w157jlPK_gxdmyDInA6AMIVPd7j7pS7v4IYGE2TZ-Bht5DZyz_nbWpZpKooBt50mM65ZINSeHGgM76KpXbwIZoudBGjPAtpwhKvCjnDrnu-nmHBkxLXf3ao3bb97x3FUmEZEtlASDZuKb9oUb3C5ye9VXuOs3GcTP_jg8g1S2I1IXTT5JoGAcE_o7T8B9s6iBybVgIpKHfSgqHRQ3xDP3R0LyptwNyciDWtRnRE69Bl811jJWtZLdHRfIY8PdO8HL7Yl-B9Fm--8D95V_KfTtnTnz9nn0ODze5HavwgP35Qxt8Wl31_O19nQ5QacCBIePpvWja979u2PQSOvwT5If-ITYHdvBl0FZLWB1eaZoYxQ', `SearchKey` = 'wofCpMOiwrDgsKlwrPCuMKDwqTCwofCpMKnwrDg8OgwqCwrrCi8Kyw57CsMKewrLDqcK0wqDgcwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMOqwrDg8OgwqCpMKDwrHCvMKrw5rDwofCpMOWwrDgMwofCscK8w4DCtsOgwrPCtcKDwrHCtMKrw5nDj8KdwqjChMKhwwofC'
# [24-Sep-2024 09:47:35] /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
# [24-Sep-2024 09:47:44] /finance/root/bg/invoices/2330.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` = 2330
            LIMIT 1

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