# [22-Oct-2024 09:27:52] /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
# [22-Oct-2024 09:27:57] /finance/root/bg/invoices.html?from=&to=&keyword=ppm 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMKyw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [22-Oct-2024 09:28:06] /finance/root/bg/ajax/invoices/form/clone/2263.html?pid=2263&_=1729578486247 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2263
            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
# [22-Oct-2024 09:28:09] /finance/root/bg/ajax/invoices/form/clone/2246.html?pid=2246&_=1729578489646 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2246
            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
# [22-Oct-2024 09:28:27] /finance/root/bg/ajax/invoices/insert.html?_=1729578506978 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 63 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` = '10435', `Language` = 'bg', `PostDate` = '2024-10-22', `LastUpdate` = '2024-10-22 09:28:27', `Type` = '0', `ParentID` = 0, `Data` = 'VwaokEP56oU1NlSUN6tRsymwH9ksomfZ42Q8FTOoALdQumLRVgf9H-ZPZWj4yGVNWSDnrxkT7E_q1WgTZMNzf7soVUS8L4xzyix_neJ_ozMHQO8Gc9aLgcxDn6C8D15B4ZrbRPtBJ356EDjIHmYjOVjShCj3fTfv3BUM1Zt-MwjS5MH-s67bccyYHpX53wpiyNZkdkDAoIsdfm55SEumIGe8NyZ3VMa93o1-hUecq26GOWQ-vfc6sb1-dmfkDYlho4Z_MLjXLG7V_kPfKMLBWb06cqeka_e9ZNjpajQRD5-6HjjA7bdiILZoqmPk64W8r7BEGgRRVa2ZVcwTrxeKMRmSDNx6yILBVOrKt2aQvifWIaX2Rd9bK8M61R8lfIUCc3NtBKGeg-dLgH9Jmb3v82dGO_KjPhWCml-Mrdjv7J-F-E3x8AUZRA_zN2TNPff5n3TnUKJI90zAaLIZDdWlga1GviSwgute6eu2q52kWxhh3h2TMBKRuNvtx1eX2cTcemCIuKgc-LiZ0gYUeB1u_QEpvGQfTWY4M3RqK8c3_It0lNE6kQHNFhI0wE2mwO9MXU4Cx6pZJJufFD9QgZ-H83O6NZhut7B7SHEZs2T0fTAXOBWDmoaAchy2AZBiladLWBe6O01z3SHhEoN15xFlSJlwEQ6dYua7s3OMQFayowSkLdNsdEOVFqwGTjOi1XWeV9jpgPYOhc-di_IJIbrYOPF8Bf76XmpS-BH2xCYiNKBP1dCG67xJMCv1Ws_xLDxVhusffm-RtPVFp5mXSL_ZOvJw7ObVf73MQEoCuXD1Jd8LrwxEOeV97NpLRWVQewgxVarAlcqAoquP288ArphI7swcGBDFW1g_DZMUnQ3Rmt7NWADhT_FORkPXsbkam_ZzIdNiXyPF3fOg9_bJ0Xe3g3gTxu6vB947mMm3ygxArv7HHNsppkQfr1Kdqi2pd-uRtMoE-q6N7r8LE5aq8B64jBKm6jD6ZzZHbaByghsRgsCAqMCUTGKnbLCOTGxlWGZIWpdIN2XAAToReQSpQRD0Yors2lflceMYXzuXfRr_1SauGqE6YJcaKODB7jHKbA051z353gl8V3E4RnzDvo3X9mMFeIsevjcfWKLOQuUyGxqduP1Bx_9Keje-g12cq_lkV3B4Rgnd1Q9WUgCj5YUlvtzUM_ckvRA2C5yewfMUF1A7TPwsSbpH6AJgzfetd_et', `SearchKey` = 'wofCpMOPwrDg8OgwqCq8KDwqTDlsKsw4zDn8KdwqPChMKuwrjCvMOVw5TCjMKVwp3DgMOTwqPCuswofCpMOPwrDgMK6wrPCtcKDwrHCuMKrw5rCucKhwwofCpMOqwrDg8OgwrPCtcKDwqTCsMKrw5rDwofCpMOIwrDgcK6wqCqMKDwqTCn8Ksw4zDj8KhwrLChMKhwp7CvMOXwwofCscOWwrDgcOQwrPCtsKDwrHCwrrCoMKyw6LCp8ODwrrDwo'
# [22-Oct-2024 09:28:27] /finance/root/bg/invoices.html?from=&to=&keyword=ppm 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCoMKyw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [22-Oct-2024 09:28:28] /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
# [22-Oct-2024 09:28:30] /finance/root/bg/invoices/10435.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` = 10435
            LIMIT 1

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