# [26-Jun-2024 11:48:08] /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
# [26-Jun-2024 11:48:13] /finance/root/bg/invoices/2266.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` = 2266
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:48:36] /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
# [26-Jun-2024 11:48:48] /finance/root/bg/ajax/invoices/form/clone/10412.html?pid=10412&_=1719391728351 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10412
            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
# [26-Jun-2024 11:48:55] /finance/root/bg/ajax/invoices/insert.html?_=1719391735162 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 40 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` = '2267', `Language` = 'bg', `PostDate` = '2024-06-26', `LastUpdate` = '2024-06-26 11:48:55', `Type` = '1', `ParentID` = 10412, `Data` = 'kUa4YVZRGU_aNk_xt3gUpo1bOW_xvkxFZ_obc514ywJ_JfMVX7wWouwrOQN-0Cqb2dNmquMoSy7cQDss-ZP-PB8e5kCoUSsNEpwWKBgUuJ-PqPGVOvosYDP6BJpeUNi6O5aIU1vO70DqK43ZoFU7aI9vmmF7Dka4ZjzBcMS8lrgAPz-EyLazM2XCZ1HDjJw8FLfA0XzJcxIxap8Olquj6zjJ8OGhc1w8jl1OAX1SNUvnG0VX59C4tzO5C6JGzd-qquVhkhAGH3uh28uyBEB0uLc9u07G1l0lDbbPWrDMDSLpTvm9Ll_pwLK_zAzP0SL8biBCj0g7hlGaPs3iyb6uFc-uZolvpXT-fHE-3p4N7ja_zCJbk_dQ0sSp-7apIptY7smqlMxiM5lKGR4TeVjktGrjtCGRBfGTgzGtn27YiJAam98izjCQaz24Typuq9-7IvAUcupsgQyp9v3YqULMMLLm74aFqFAPhRmtd0u1dYY2nR_sHy6GTD5sTlxhTaTZoeuSiU9o4d9DfnSNEREQBviyVSkYnI13h76khHNyuie2m4ZA1cUxipmAlHMMEfvPYh3RJVVUNdJf5GztJ_0R0soV1Yw4VayaeLztT4mrR_r6wEznjAQyQvfM9I7wlOo1mZItm7fgNhJtSLgflNahyqw0kzUOqPfBNkVaYoXc1km8EWg3YsP8eJxywmXIIEhLBQWaIzAOZHUNpfuejzx3y4Qp3RtuJR5LFMpwyY7Cs4e-Bb8So5Rz7NVE-hQQEu5hw1iKgtzx8lONwZbwZnEfVC-rTqKIEEKAAGPISNqdp_IrRFVISRM6y4jZbEZWliw-RHV2aJhegsckVSX_GDsxAQnIHmkdDdXNVRYSs81hAL8taj0QgnDv71UKUrNoAEwBUsWyEH8SPg-6fShNBpL2QpBdlUXW5LcTtUg9a2Gj9UobGSJKs-GrLvZqcM74pYpgLG09D5aTJe2nw_IWvtL4dogACr4nS6_3Ycn_6VdWdlWP7bqaKsY3tzR9ccmJrIVg8Jht-59oIQP7aUZfCm5lNjjllFJh1V81e7h_b9JZRjYfS50bOphNnzqxi3kYGhyBWOya_tecd412SsIQUChV7yGhVvKpr1LU0Tx5R-6DG3wgN-LKq8M2kY7ZWD3Emxfth3vCFB8iCMUKlp_paKc6UEsxJcUiIquzYaKsqqio8hJtZllMTqPTVnK8WNEVA7hY9Gae03OBpGr9RzJk5FDKzjBR5pmuWSXUG0Ypzt9KHaozhZGQonhs9aK8UVxpB5mISGCDOPbsz4Cm8Zjnl1jRtMYU45euvaGedchWNMRFxKs-OqTNsyG1M7lOeiNuKlEacL8Qiy295_PjlyKxn-4roX2qesWg86dJ60zckxgYSVW-vg0S_p2B-hZp9AV7tnB5', `SearchKey` = 'wofCpMK0wrDgsOgwrPCt8KDwqTDlsKrw5jDn8KdwwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrDCr8Kwp7CrsOEw4bDwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscO'
# [26-Jun-2024 11:48:55] /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
# [26-Jun-2024 11:49:00] /finance/root/bg/ajax/invoices/form/clone/10413.html?pid=10413&_=1719391740103 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10413
            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
# [26-Jun-2024 11:49:04] /finance/root/bg/ajax/invoices/insert.html?_=1719391744681 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 41 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` = '2268', `Language` = 'bg', `PostDate` = '2024-06-26', `LastUpdate` = '2024-06-26 11:49:04', `Type` = '1', `ParentID` = 10413, `Data` = 'oIZP1MmlXE8u4UaK5lDOJNJu0Kf925qkzQFMw3WUvvF7p1ECFV9ccXaWXhMp6vBdnCkV450KSezif7VIIlEduSpnXtcPcm9ZTKbYTuVZE0_i-JUSEeNPWEkyk3oTMw28b-NhncxlOzro93p2KwnxMYbrBPcUcDTn-DM9kJ_6od5iLC8lbD_xPwgEImPbxgG5g_HobWkIWpynY4iHL2SzmadAycrtzJunjq8Gn8umTClNVkcRJsJi738FpjeyHE71Pm_f_fW4Pk66TCPjr1MK0HeADm3ULCmRm6BufnCg137TyTyCLn15VuF3yKYqGEZDvKKhlc9dXbg9cvEk8xFveK9Pi3mDrAyAw64klIGu2GJJElnkq7KTPBLLLC9X1gt3ewQrg9FQ2rtIN_jFgYC7AbnT9nZSFvuzbXGHgv4apNQ4O0QVQT6lc4SyCjW4ZddEu7kZTULtOhdLEyHvbrW5r39xoRpTuFqvSACaTjVxO98FO-xNOJveHFGncqzjozr6SrL6WZSd532HNVX_mw-qsI1kfGBMYbLD-s1uzzhBdPeM6EHaBHGMUGrtqesWw6j5GhUSeKyK8OjlIIG02Bfv6HHFG1dM-0aROc2St-NFaDoDXs_aejYvIM58hs8a3e9mJBA6H3nEQFmpZ8cDrUJedjY82sVtiS_mjPAuiUuhcsEiRECrfDziLIdxujRzHbKqsZHscViLOwp0Rdf55Er8fkvbC5Eew5iy6QVN_2wSdW8tPMMnw1VRSetakcSmU6mPL0OHztehRm6KZwE5M06x44lRlZXtjo4R0D0Z97_M2_G2NUm30YP9FJ6Wrmx2EXr1EuFEw7wAMpk_QAF4I7Amqrq29os8G3Zy6Xzd2C-Roep9jtkqpNEnhUa7NfcPa33UgBgVziA2w7uv_MU14skmH9EJJn5Pab-Xxs4Q9dBwufjvl3NcIaXNgLzJgicRKeK6ADrEYx1MLlDh1MwXocKbtQBgMTYnJRPsvLFbr71YrVU3VCQ0Wh8J9yyqK5QiBGi4', `SearchKey` = 'wofCpMOIw4DCtcwofCpMK0w4DCtMOQwqCpcKDwrHCwofCpMOqwrDgcOQwqCrcKDwqTDlsKrw5nCucKdwqHChMKhw4zCvcOKw6TCiMKMwp3DjcwofCpMK0wrDgcwrHCr8OKw5bCsMKew4LCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrD'
# [26-Jun-2024 11:49: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
# [26-Jun-2024 11:49:10] /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
# [26-Jun-2024 11:49:23] /finance/root/bg/invoices/2267.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` = 2267
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:49:42] /finance/root/bg/invoices/2268.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` = 2268
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:51:31] /finance/root/bg/invoices/2268.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` = 2268
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:54:36] /finance/root/bg/invoices.html?from=01.06.2024&to=&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2024-06-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
