# [23-Feb-2024 09:42:39] /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
# [23-Feb-2024 09:42:42] /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
# [23-Feb-2024 09:43:40] /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
# [23-Feb-2024 09:44:08] /finance/root/bg/invoices/2187.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` = 2187
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Feb-2024 09:50:20] /finance/root/bg/ajax/invoices/delete/2187.html?_=1708674620364 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '2187'
# [23-Feb-2024 09:50:20] /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
# [23-Feb-2024 09:50:23] /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
# [23-Feb-2024 09:50:25] /finance/root/bg/ajax/invoices/form/clone/10394.html?pid=10394&_=1708674625420 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10394
            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-Feb-2024 09:50:37] /finance/root/bg/ajax/invoices/insert.html?_=1708674637111 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 57 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` = '2187', `Language` = 'bg', `PostDate` = '2024-02-15 09:50:37', `LastUpdate` = '2024-02-23 09:50:37', `Type` = '1', `ParentID` = 10394, `Data` = 'G2dHR8yajdva9r_QQr0AAjko1qgmcC-aiRuk5P5ywjbqFqKDnLGR4NiX_rcYiSQxOE40aBY8OZdHjAP-7lIe5MVYQYlb0CVIzPpOKhp5KkDNk-PpiOqLGvz1QJro5RX2MIGCTJnbJsuPNhozzIW07E5QoNjX68e9HIf10DyIJf9X30FHrZ6CdVn46yNDHBJR9Xn26FsBQ7sCi-QB4C2ncI6rmyKwqotPZG6r_37zhri35yXJFaKu0qshne5tCEdjnIscuLMJKG-DMOlJPblPkll1Lwb4dC4qmgydTYozFfdLEUSLhyhJctM_8KUsJXSGtEoeROymLI_zC2hESqfV92Rg8uGJzXoKnkp0iL0j3NLfmC29txcHRchKc9M3i7-OKUAkPB42C7kjRWsD1EzfACeYtluD704EyWSeX2kG1jC9mBcREc5o6dEUqQJVE_JqBrtYXOHc8CBPMzp1WW1hMvFYnJdP0DgPMZsThwKniaKM6GmUsMt1Ai8pdtkLDutAhPF5LWItc4W_a-FdB2GIh9fzhuVGNaebFrTVToQHmZ24ae0LQyvUucXmLvX1pvDb9PBDjO5kg6vwMIQcemYULEqPTb9xV7tg7_RXjScTog9FV8oVSmDbroF1kQUkHNtkBsbPS9PY113TJ7Q7kt3OASTGnPN-ysnPwDMvc67omCl22Z1NEX4jmobAOmXd-cJxjSNyT_Ng2tPEvzCc68hyYe9KovoDa_vx2t66DE5_LaBsQ_xL_ExQHomH83ZmjO5oAFskDd1dKYQZNYKdBHkapyEFu-OkPx2wZmCsLOKDIvUTmYxFiXfQtpPnvgH0MNDbz9ahGWDEjnKGoMB3m4N_NUKbZLRQLzUtzmD0zu28FbYs1150GKX_h2Alr6p4vtCtGxmMNFLVko48HgbLldAaGrqo35B11V9Op4LTTCkxhiUHxeBRdj5d2Ef7rpNYpAidFkcr3EqqTHQfep5tYh_h_fwx-OM-79fQZdSqpudxEMRNRxu8HY1iScpxzjOoGfeumAl4xyRiDxId4zDgPtVd-KYw7fGsBfqq2kpRH3H2-iRWccC788NrjhVhSzcsb2tdoLvtMS6FPIUHMZJdeBs3k8uCS-nTKz-LHH4-CL1nKY7HvzUKL58RTpaQAcVGnOokTIzwQMapg4t0dYbxNKb-n_kOnmSfojoo6N4nXqE52U35enEEt61sE-O_ZNquGb-yxQKu9ZoxGIjsi5a8srAPzmRDXNpbLv_eabUMlWVDjJXJByoRjSA7py9K8iJwWrorhquXoSTip7TpAkT-1z8JOGGxiShkGox6yRrA_dkJGA41ZTjBEVE1HExosRZTBGMkX_8KPekl3mu-aH0VjMVB_aGUottizRD2bVx-p8y3bMLHeQrwOEnAcy9h7OupUjBUbgNS-8S0zpIeiCazyXOzfVoPFE6tiH7nAIEy_q7OXehEN2f9_B1bmT32uQ1mZdV9KDmGWkeNhxL78I7cq64hAZ3bd5hqsEvwIYleCW3FenolpdeXvrmbMRprA2QZWXIYL7C7EI-upRNx30dbbQeMDEuelGrKV9pUZdltCZjX3NnDZLWucYSqs0n52PAswzczjjDcbASUrXyR_f6EGRHosol-eENxb4S-b8ycnUBXYbyppwYpaj7fRSiy3EQCm89ivVlLX4svYrycSEZhn_i-2CfELwjkEMbxZvb7O9MlRBXZ62k2yLAEX8dnwj3qEcls4NSJ8cM5aYBYO-3dJseKQA2kgT4-Vv6HLSZy0wHgpLer5AvqnLohbFDSDNTOkV-h', `SearchKey` = 'wrDCr8Klw6DCpsOEw5jDwrvDhcOGw6PCscK0w4LDrcKtwrDCwrnCoMOCwwrvCn8OYw5rCr8OZw4LDrsK3wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCuc'
# [23-Feb-2024 09:50:37] /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
# [23-Feb-2024 09:50:41] /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
# [23-Feb-2024 09:50:43] /finance/root/bg/ajax/invoices/form.html?_=1708674643596 167.99.142.201

set names utf8

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-Feb-2024 09:51:38] /finance/root/bg/ajax/invoices/insert.html?_=1708674698367 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2188', `Language` = 'bg', `PostDate` = '2024-02-19 09:51:38', `LastUpdate` = '2024-02-23 09:51:38', `Type` = '1', `ParentID` = 0, `Data` = 'cXEAm8hRnMYbi1mquB2Dlmnoamp2rI3Gd7wNcRtMDz0x3bflRRZ1XtJCESvS9ElmAZXgTSGgPnN44hJKaR9ZkAYLrDhrObcWpfonAmQM_qPTliQF7U4kADp09wX0_wOT2yhFI8z821vy3dgDhNOpSrOMAcTn4UqjWD1tW5UR4qirwXzSPWO75duUKhEOZssd03vI9RQy6LzETz2gLIKGhLeceXJC1tL065zJ8HVZHbHUSUyK6hnMcJdg45Xh5qKlFYd83gZaiwX1mpdxviUwykAWyEVwhTQknKjyaitBKSCq4DXJ_vQwtcXx0NVGm-p6Nro6IRj1b5a6Bh6WzrysSGH_vlGz8x1XVaxmBNrWedPZaTBNmOIal9gICy8iVn-F6FlL4kjk5uUXkV03IZV36sJ9qWzSibNtj_ii7lwNoMwUQyXzeNn9menEFNuANKEqyFELNmzyp5J8waa3Kdqx6am82v0CEynwOb5ZQhModpORl1YOy6M6r2DZFhpndKF3rBZC9Sup5YQ45dOrDuI9YBBGEl10qBhkzKjkRc5089E2MmP0uMfYiODxODQBoAYc6Fim-EfHzEnLqEccR9P9KTHIvE1IGV57l-8lQjcU-h18-3fn5PbLUfCKrmeRK02kunif9UVfc0bR1zobkJ16wJD7Fa2xFzuh1pmNv-Y5Qetq-o4mDkwT6XYxyZ_iurfDXl2dQx4nMfirOJfdPc22NkCd9y5VuBAWpvLojcCACKoHL6j27H28scj3Ig3gC0vz6eBe08aJ8E3jHk0rSyIhj01-r4_2RwPt_zSf1ZHEDoElM0YsKptSZXq2qJlzLy1lpp47r_ea6Jt3tEC7uwdSliRWrI1FwCPRnf_t1MG_e_dT4UrOdtYoVamjvRx2QRhIjvqglMWUiPh4iH6LIyVKcPZUjLHPxr6TjxgegbX6GTtJviiz8sz0i_APH5NIMMX6IkM_X3YLxF7NlMIRcmcgh0kv383o4jiTdnTHgUnJ4QkYM__ppjVVxDAZCzm7tyUtGZghjPOI9z3sY2U1nDeMt5Aw8Do97yCj5TQcsIyDaZI', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMOEwrDg8OgwqDk8KDwrHDns'
# [23-Feb-2024 09:51:38] /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
# [23-Feb-2024 09:51:42] /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
# [23-Feb-2024 09:51:45] /finance/root/bg/ajax/invoices/form/clone/10395.html?pid=10395&_=1708674705388 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10395
            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-Feb-2024 09:51:57] /finance/root/bg/ajax/invoices/insert.html?_=1708674716943 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 60 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` = '2189', `Language` = 'bg', `PostDate` = '2024-02-22 09:51:57', `LastUpdate` = '2024-02-23 09:51:57', `Type` = '1', `ParentID` = 10395, `Data` = 'PqqTujAmI2nyjvcrbWK66DexSX1U36dM-reihVX1u0AGB14sId_XIqALwsnCY3zazp_HcgOiDzMqkQ5yoOg82qbzjFNRQ4-zNa53vH0BaqReEBNd9HDwP2EOPSEH8LZsjNkRqsWh8KX_dt1X27H4ldkV3mMR40u8ny2h3WWFkBRFzbnIPj_sZBh4tagHVgEIops0c2bFHpUXl7C7rcfGuPpqnkFHSSJOkoneXPhGQXURnlDZvd1XlUYagNfafxovAjARswC4c25WKoTmspil1_1w9MuSZfUziD-xlRYTdJgU0rUT_4pXPhz30HdPg1Yk-ZEf-jdpvhkTspymodHIVkD2dfRNLFxidVUGjTSvPR4ocGn8BR_H0rxCbDRS7E-hOQwvxqDstvYN1_67GteUkfJurJ5beXG3V9ak5I_FDwLxVkLWAKpzUTrbB0gQXOb4EUdEDREeuXbiaYE9L0I97K1QoSiA79shOK_ZBYWW457_AMbpKmcjVDrBrscAvtmu8k0oc_7rH7CKt4aY8M82avO3SQh4dKfbh8Zuo5bhoaNURvJyBbmly5gyiIEuoz205CjghXQwy0nP5vWr07jEgSxePgvR9nLj4LAgh1WNkcLZv913t1OYO7orwpgaOfhGSlZtrDpXDhzzm86GmpCriKog9fC1ClMx_PC0s69HSNNEOLSqHiM0qqvgiQz7wKxc1R1AwY-oYH8Bc7xOLZMF3QxKHiiPfXRan8oJJlsvrxwkXSEFTyXOdLHmviUOZcr5xFpXlBIQZcGyI9V3MmRIbXJWHWAbq_U4Ij8aBbVhJnySUNnyev9kPv66ByU6X-wZi5abDyB8EAI6z--EMeZyOjT0WIR6CmW3KiadJsY664Irb2PXm181IF4bqFXYNhvDIIGsxJ9vdeube4OfT3_2ZprflsgY_UgVSojx38vNbEj6iptmfnfY6ES3TdMWbSUu88-1WlJZlSjjo-Pl93xvTg', `SearchKey` = 'wofCpMOIwrDg8OgwrPCwofCpMOmwrDgcwofCpMOEwrDgsK6wrPCtsKDwrHCuMKsw4zCucKdwqPChMKhwprCvcOLw6TCjMKcwp3DjcOTwqPCvcwofCpMKnwrDg8OgwqCwrHCr8Kpw6jCr8KzwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKr'
# [23-Feb-2024 09:51:57] /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
# [23-Feb-2024 09:52:01] /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
# [23-Feb-2024 09:52:10] /finance/root/bg/invoices/2188.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` = 2188
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Feb-2024 09:52:53] /finance/root/bg/invoices/2187.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` = 2187
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Feb-2024 09:53:12] /finance/root/bg/invoices/2189.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` = 2189
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Feb-2024 09:57:57] /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
# [23-Feb-2024 09:58:11] /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
# [23-Feb-2024 09:58:38] /finance/root/bg/invoices.html?from=01.02.2024&to=29.02.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-29 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [23-Feb-2024 09:58:43] /finance/root/bg/invoices.html?from=01.02.2024&to=29.02.2024&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-02-01 00:00:00' AND '2024-02-29 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
