# [27-Mar-2025 13:43:32] /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
# [27-Mar-2025 13:43: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
# [27-Mar-2025 13:43:45] /finance/root/bg/ajax/invoices/form/clone/10444.html?pid=10444&_=1743075824292 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10444
            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
# [27-Mar-2025 13:44:22] /finance/root/bg/ajax/invoices/form/clone/10444.html?pid=10444&_=1743075861005 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10444
            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
# [27-Mar-2025 13:44:27] /finance/root/bg/ajax/invoices/insert.html?_=1743075866082 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 78 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` = '2443', `Language` = 'bg', `PostDate` = '2025-03-27', `LastUpdate` = '2025-03-27 13:44:27', `Type` = '1', `ParentID` = 10444, `Data` = '9SOhkTUnssPsA4IJ7hNA9k_WI3OfyEgW3UGHgdts1qkN_-VcT2W55B8t-Io_z5KilFDinm5YC1LTUOstN1gjnV_EoHoQIs_UNPUL04XdR7YFXyHQ_7-DHsuqAFMV49CrWA7puNrgLrm-WroFVO8NF1ryv-Pc1yQnj5VuMy7yVFlAAtFoTOBqUlUkrZm8myHGT_bMcDDkrekGKtXijkJCPvFrfC2Uj-wETiOKdCVBzjzVDKwBp0CkHAr1EUXzNdeWYFHz8d2iE-9t8XZVFuh5it5oRRdqmXF17CD0Z5GCIPDXJvdHA6YrrVW_Z9DW3sFNLdyTFnmni025QUa1u1rSrT7-obnSLITCBEdULs8boUKJ-_e-7PZWSUzGSouW7aw68E4lomoY1rTG3fkESxZzWoWgoRsAt4_gsocS9-wTjY95WGh7-_H1j9itTiIc90x1QPU8tVh21IvVi99Iabv-mQ9xCosWXP7jB7pkWDQz5IF7b-gqTb5XJmqHmpzbabwals1xc0QGZLClaGrzCiw9iY6Bp6a_1H2nlEwwdYmgiWFZQFyGLalJZMvfwbMvT0HlL_E96ifD6dC4VN8C8OqdeEwfIncq8VRT8Tc385dg9C-oIaNgRXPhYKiwMbq7-KnqoTDdzq8-TdM6ILEqbJmQnzuAqhD9WKr2i9tgVrShzN3o5oiDoaDVE0uDwR_RT_vH1vCF2TJQwZqWnxdbO8-6GljmyQVYyuPg9atXlnrJXjOwxrtQYZTz3owYBYBo2Sa05pT5BLEme1fFJSu833WakCDKCpRb9k9fDZ_WdAqhrSg80PQqDTezpjZiVdFTY3SL-mGaiRBM3jBEhGq7BD8m--3sRF8cHPHx6riwRGVaJZ292GjWqDKC6bbgiPmJ2F20pz_iBFQ3CPr_bgeoQlzPLOcFlbpXFQnxS4D4owkDie6rCCrHVFVJxd7tLU-2SFViR-5mOJc99mkOfPi0ImBTDPmjTy0PWc9qK20mZbk58-nVg8Nb6Y7EUyxySr3ZWHK5ERjWAxJ-MOrComsVbfZ0Byq5No-Q1laM5ZfTMFYy-OLrSmkxSG47HrGcAiYHT1tBK5Tz7EltHePrndbO0pR1YA', `SearchKey` = 'wofCpMKnwrDgMOQwrPCuMKDwrHDksKrw5nDj8KdwqjChMKhwrzCvMOVwwofCpMOiwrDg8OgwqCrcKDwrHCtMKsw4zCpMKdwqbChMKuwp7CvMOWwr7CjMKUwp3DgMKlwqPCvcOYwpfCwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8K2w6PCp8KzwqXDrcKswwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrD'
# [27-Mar-2025 13:44:27] /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
# [27-Mar-2025 13:44:29] /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
# [27-Mar-2025 13:44:33] /finance/root/bg/invoices/2443.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` = 2443
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 13:46:28] /finance/root/bg/ajax/invoices/form.html?_=1743075987112 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
# [27-Mar-2025 13:47:47] /finance/root/bg/ajax/invoices/insert.html?_=1743076066099 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` = '2444', `Language` = 'bg', `PostDate` = '2025-03-27', `LastUpdate` = '2025-03-27 13:47:47', `Type` = '1', `ParentID` = 0, `Data` = 'YNdXK0qLlGh7nyOpR2yx2s4VfnykQ0GWAMFj0fA-9AoTKXFZ5jJ2yawMx3Af-ZdpkpoPbTCLpf_jjDeYaCqD9MOWNFB8uNixupXUyMbYB3op8x_fN5kTvvYtXtA44ZZCpKW8f9Da1seW69c3BDxxhBcwsFzgEbGVCTZ82Ib6rMraU4qcgYtJcQ7f10NUZXtUlF_pAUyn-qioixHh2Z3FG8mO7TE5MNvDgpuwmFpMxn_Hi5OX6_lEUspri8PxvD2NVkK9wxoV7bH_tkQhElj2zfDIB2iQCi6O34u3IJaIqI73MHTPcu0jfi-lC43jXV_OX-8QAYbnA6Xd3gZOflAdI3i64oplXgxVic6YhvwtaGt5Xa3MDsZNIvzYssUcXzmGafzTQ9UnOCW-EKqWjYyo596oQ6ZEFQjZyuSoGriSTgQpcP7YWdwXckB1wyiIN3fwGZodfkHnFp-GmaA-ARpaYTzu4k5VLz4f-KfY-ZwSr3JJ1fM1upST3DzfeuHO--mkbhwlY7ueivXDy2yUxoDtrEqAZpfdnqhGIrSqqvAht54hvU6307U8q1t9CB1qUd-IAgdyjZnXhOlW9l0Hc5m3t7GGUD4AcLZW_Mh5tlEuEftIYsG8CnnRq6d5SU0qFdWvvP72iqckAJlFxrcUR_J9DxDwC5XMXCx_l8uUJ3CkC_ZNncT7RGo5TGrgH6LnkhYIIRyGc8gTcxYrYBmf4jJrxCGLmv2ywZvTEIMsCF2TyiOqxdlo7wbu2mjHmKTkBxEhpkL8mj4L7bJKxx2BM4XEF4llSBgdbr8l3c-GoS5fNkJSkyQWHRDE3e5WkxwdP85zTE4fuqMbpEN5pFpeD1HfSl0FgLFnTHlU1r0Hfo8e9n_K4xrM-e3-pG2_S6i0CPx2X60ZOQzOvi9tf4UJdgx9Bfu4cDnT2BAyHLCkjQif3YuIHSR58Z56d2tiKIdm-2ztzUOdq3Pt8U9V36LjFgxRV60eSWh5fWZr9EcWxj43uOOhdAKrh9PdlfR_8IQV3ffORhFiKiSqQvrGrk921rkD3A', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMO'
# [27-Mar-2025 13:47:47] /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
# [27-Mar-2025 13:47:51] /finance/root/bg/invoices/2444.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` = 2444
            LIMIT 1

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