# [30-Nov-2024 09:03:15] /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
# [30-Nov-2024 09:03:26] /finance/root/bg/ajax/invoices/form/2372.html?_=1732950206556 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2372
            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
# [30-Nov-2024 09:03:30] /finance/root/bg/ajax/invoices/update/2372.html?_=1732950210366 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 73 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2372' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2372bg', 'LxAbqC4X8UHQh-hQVPwyq6HlLwcGVQxUTpCudC-pNhyFdf2kCzUZF6tcq-hZU0Rr0QoIvopDSP2HuZGBZtRv6MnwCsYLiUlp143em_ZYpykF8l-MRwLCyE0affSr-I6tCn5GAuxveSSejQBvJe4Dfy8ibMmVPG69oJjDr7mqWPChfoXbbgfwQQ1sp0_yW8rRFSqjnihWtmCYZ1-2rSQdC_IBvfwaQYMRpJCM6xStcO0EH2jW7OVSO08bXuemSxqxR_fCfZnILk4PaJznimf_nWz3s2rutGiYefyB1v0O8PCRgFQaMgjC1iIXVosLc3ZVYITnjzqVCZ1zyQ0oc-l468qaOB1lNpXDgqTd2MPBO---aWNOVEzfBFFynHjEcy96EwVLLs1guLkOOKcfo-he8y24lc-qRek7Nyz9HlGBAGSh1d5HsBAk-dq5e2zzOAqVrzZHM5aWM_5rr_QmGwZlWzLFe8IcsRhpQ4mBz4_dHTicu0W-7LrDoiqbcTRUlri1Vw_q3d22CiUjPFL0BZck3dYoaD-5lYtbhdDvCnnZAM3bb1Wmcig8Vl2ZyTzSi-zCt83pMc0jWILz6qWIYP4U6r0HEQOTugmagRKX4dvcta5CfW2eCT2OltqGVZ0bdp1Mjjzz69VSGlQt0UaDIVm27_COO2emJWP6VZCYC7Kik4qRrV1Vqz_4Lo2Y9WmSKDEFHUId2r3nKBNPJngQy0-tGwDqSm8_QzC5uhugkZDUluT74z8bazy3Iet_UMXE_vJAZqVq_ttwF8YGh5NL4G_IxV65R7yt8TE43mXIVYZIhV0e_tmj_wgXJzkzWbdxu4eXjpL8UGtySE2bazoHy1ItbR87cWhoTNisM5kVr5wud_Dg3vC9j2ZU9VdwFVs4BuAdZ38pnEwgyiePgQeTO3VAws9wnEiH11v8bXyClwdGfRosg4PiaLyXoQ_poWQ74a6ZYPvM1G6oJKPB1Ti0g59tSLux-IRP0nI8617rjHPAXqIKeZ3SqCIh9DUCvXbVn-lNRIKRT5T2CIRp7LChbTE7ZV446Bga1IBb7qPIymXV75WpBwZdj352AhdZSyq_HG1-rAnjo9NaPSGiuJ3xmVpMCmgLp8Sc6aFdnoEF04BByQ3Ozcv0US2GV2yPjbbA7teDekXb6rf018SFWITb2FbmN6hjWu3tiv7O8rPt4JOGYacmuJH-jz3-YTMqaR2VBbQYXFBZNSSkP0-w59j6mHD14U7wHhwKHTjpE_JgNOaCjzDztW1K-nDoWbuPIucOO-aRxtaC0J_adL3cGHb8MDMtL0aaiomee8JqU6sbURbbub0bKmYD3_ObbGbFwCEhjL205tSZKD3tFEZPfdwBofGZLtEWvSPZJly8Mg6u44A_w5V8nDrsBQqaNTIkyyAKm7yIl7gW8LKzulXdszWHD_7j6MtdGEOe3K5xhk2smmY080TFvLEZRs2UKhtkA4MZqhjpeBApwRMCXuCC85ATAgFAT8vv1uFhqCt-sKEmNo3lbFfUFzY2GvBk72L4cybcNwUW5BU-bPi6Pas8t4bBb-rskXHOSFcthQRt8zkG0Sdc2Ab8at6icuQHpl5LTDOE7nLqcehU2t9E7xX_9jzANDaONCU5rePI6kBhEX8kGKbG65r5pApgEyPhYBg_lFZaICOHcAZpWZUhXlrFnNDRDUavzVuSCWrKJEGKczdJJvPcX0PWfAyP6_-YbQDsWyQx7ZxXDl4DdhS2oGcyByMId8Q4uHUHt3iyP2rvt82PEsgmATe46sjW88opd66HAHN6xjto9noLNowpL-gBx-kPdODSIvbs2NFYdCFSzODRToOy0L6Kl7ESdOgJjfgYDXGla19SkJxWasUuXDEW_cArM83jgxxDeCV4wgeiy7TweCB3bZDfJjftRuIQSkxny6PuMJ_S1xcVHKKyzi7emrF0loJXo90CoTFGFhiJPmGs1dOnGb-UaOrInHVk281wjZhkXcmSUqJSPXywvPOk0FjNrVs78OCaUqYuENpq5Us7Nnyx8Og')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2372', `Language` = 'bg', `PostDate` = '2024-11-08', `LastUpdate` = '2024-11-30 09:03:30', `Type` = '99', `ParentID` = 0, `Data` = 'KvJd3kpEbi4bPlwvNU-lKK-AoVx9YeTL57OiRUPBmVIe3NLMYawU9TdBmqY7Y2_IVcV-7QMXCeyncoVcbYcuh8zKsj-O7f6wRr-sqpHfF30rU2A7-LKt8bN9sYLZ0EdgIh0B5Py1ShLGXhn9uSZSeQgWwO6nyri5odPyR770dVVCoqxPNHe4-qFBV0GwiTVO8VcODH7rwxCDSHp9-6zYcsigsDB-L5toDLZhPSnCiEjW979qa5nU96Guon5yLsVkl95nFCMemL3VjwLo4f6nds0ye5vuip_FhFhKhLBNdFj54ls32YHEAK-Xa5XJTZwdqyBpK0zfHAtUJJlmD_0y0AqXwbVwLFugdQW_MJyMjKzskwFi1eFzOOVeos54Nm1n0vuvkImlfW0JOnzMYcNP7uchjqr4dJ8SyVWPD7q0UXDct_Oe61uAQ6_Cu-B1F9Odl60ogJs6oexxW1OBdUEX_K5yUYl3LYXXnYkHZMQ_Yqm9btPpJlHTo6T4-SnNzMcQ5ejjZb7cy6813w3MHL2cdKzxCIq7cCFvfxDGoflGxNEyD3AAyZ2_WpQZLO1CJVdusaeTWrmWuNvsgwScTJnHbyd6WX-8lGzwK5c5Ke7J0jA0hkdXc9e8gp54pE7QxPCMe1Sk24IWfHMElFj2eum0kTJ7OzmwUiGWbkdIlcwh34lETUdnGVkGIjhxECMM6lpnsjh9_KqsmpsTmHtgTh2UvthtFV-O074VLuO740kLPTuts-j81kMYrcmN4c26GVrWIIswH9EMJCGwBZEXD_vBdB7HHmGey5hv4g957UlF04Stw4aIo2KHRNi0mC1hYyjD4OyadGfL0OT4kXXQ4agdQS4f6VhoRa4OM4VGkEB_f0KBAjyRnxWdZjmcT_T2Wc0AUsdEopK2ciDGsDn_MHY7KuKtHYTdd95LC-KobeqtPFjR1jmXstwwWCvSxT_pjD0PZAncde1q6BsFp9Uh-mtPG7_V_UTdsbrwRIezFKkWOMkxsApiLqOwHOavBehRVK_4D0qDRvEbe2bzdqlsgWVdAdOGaFuewROBtr4qmBCWRds', `SearchKey` = 'wofCpMK4w4DCtMK6wqDq8KDwqTDmsKrw5nCucKdw6bChMKhwwofCscOEwrDgcOQwrPCvcKDwrHDnsKrw5vCwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsK6w57Cp8KzwrLDp8Ktw4XCssOUw4bCssOGw6XCtswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4' WHERE `ID` = '2372'
# [30-Nov-2024 09:03:30] /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
# [30-Nov-2024 09:03:32] /finance/root/bg/invoices/2372.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` = 2372
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:04:00] /finance/root/bg/ajax/invoices/form/2372.html?_=1732950240635 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2372
            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
# [30-Nov-2024 09:04:07] /finance/root/bg/ajax/invoices/update/2372.html?_=1732950246829 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 73 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2372' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2372bg', 'Ao40kE-F4WC_3mFcFxw1cJuBoEb6W4UfkVAJOf-hPTBwsgJq0zdS2TdNkc1noF8UhTOW-Xk-SVmzMa7H4Vw016EFFG8cvVDdh0JRW-JzacYl4ZxHR0cAYAnv1Ho2D0gLk4QMFbOxV4Zo1veIXWTUooPEApNuEtFJcv_XxZKDHC-ZZDFXeXqUO3ysV91d9uOb0gO2iSKajn8zbeW3kbb-li4cXwG4NuskhcULYrmAKGL6BdYjSB3w_Xfgo8-Nq-kos9oK8pZSgPLRlNmc1H2hPtfvnkJLhzQgv-jS8lgwjTWFA-AoCve_pX79dNj8SXdMvB97DBSHzV8AfqA7xKDP0PNsDy1B3z9NOLmUJq19WECXOyRFmhNOHZm1Zmrzg1ATqQ6-jq2VdgLyC0Wvw0gb6q2kS4iYU445rKLl0IJQB1w4xoiyMNFEtHaJtPPRKGwsLqFeRF4-s5MwKIC0iS3T9OzvsTxJ0E8dJF6-GRebWO_hpcjGIz6Cc8bQG6Qh-mruQoLc5jZ8qw3mwlRXb8NVpoc-umHVxgNff3cZ7jeqEqrVRzU3OeRAB59o3zfAnIIsVDyNOifzWYQQ07Lyy8jwVHLOgEJYMZnWyxpUmmuFOMGjcfoDlXFg8XBa_HzvtcbbWPOrnVBmYyLcnoZr9rr8tM9Mhhao58cu4556XaFp--IoPxTa4srqLXds1Ne38i5EfJp12Pnl1mpGQCA8jJCHIuG6JLM2uzTWuqHZR0gm8CuQy1K1rPFNElBQbDMLmoT4qaxFD_DnSmsOCzOtST2hzeI36Dp37n1RivW3PEKp3PD80slmvlLcL2Pd8fn5T4qrmrftMKlieOIFiuP4p85s8Ski1t3CiK6Trkn8fyP83Ci_uPUu3aZxjMzfvhTUxKFbcbqO4AiFSp83xZqjdZtBeD8YLO9LiPqwqxcZ7wsKboHfWc8tAwLWafn2V4uAxOySIcQh5ly8EZLTICro4mOq44kWbitoSP3SBkId4D2Wj1eWUXXImvid0QJFjOFY6mif_w9Qir-B9cchc8JJX3mQ4gw6t9ImEbPM2azYo-QTEh1SDUCA3xlAzMHqItme782WMKePVWF19mIaXEpxoBpOHkWcmiE11QyIufUNIA2ynxfFAcpFQLiSfesomWhXPNDl2VwoiLSHf9cYsEwJrDwQ32UUnCwht6LzZ36vdKu9K1O_Zd24oV5E4awSx43Huy3xPq7oSY22uJN-vdBiet7zNbU0iaBDvyki_WvgNZNFamHvdVQAkiad3KkcZ-fxWLw3w_z7ZDOa01tT4-8DiWpWKd7ctzkR1vJCZOFQdysRlrXXS3BYHeUcPC_7KyAmtMY1K9ZpJ2ab5y2sCzpw-l9F7msNhJMyTxJHmfkyLG4z7fD7bjDp3Y60Tw8Gb-Ho-mL28k51yRaigHRBi-U41eZdioh5HKDNVgwHzZz_a700lu1nyh9CoaUI12rBLjcz0CNgoImLvDzkvPde1snYUP0RyVhz6zR9IojdpcCPX4FaaAUdJ4ji8TLF7cMV30T3BR7cV0Rczo8g5XgyoFi5T1KleTo-YePVaJFPk4yWWPTieJ3epw9TswsW_ZQI2JYfWmR65EoCNG8oDpx-CQdg447PmxWJmpnYxSvuAGvH80RMPVoKWqxGB7aidv2RkT_3bZLRwm38unGZxtaO1qJlLtNiWxHXMIbYwGPklcJWHiJt63TID46zaoOZnteSL4vM-SZCGdPaSaF2hegRbPNFLEZGQSOsZ3B67mGkhFfPA9vm_Tg5HFxkrPHi2ERiD52PKTtyjD7BEUYTnW0MDUegIcld-9hJqSOxhdP42OxCY1IJt8fJYjkDpdFH6P6upVBZNAAyPjeYKyWieztD1x8uCed7hK9mO3W8pXVfO1B42mUMIbfru3NaaXYywT0oWfdE8pbLtbZPoIuXF1C9xh60E-UumMxhTvxCF1kwoUVxr6ogufMJaNcMa3DIg7B4k9Lo-3sYcihmq-zrZjoMHrpBCK6VoO77h-kU_tgKHy9wx5aRrsY')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2372', `Language` = 'bg', `PostDate` = '2024-11-08', `LastUpdate` = '2024-11-30 09:04:07', `Type` = '0', `ParentID` = 0, `Data` = '-YoQl-ulZ8NnafmXoTXiSSOzGdfe_q_HsgBnPpQGGYNh-oUwYjq2CZBKa35ulL7NwDUKG9sEJA39094q-i_s8O6NW3v_WGIBODdfjs7lT98fPtVQd42kxamL2FcOIcm-C2rYdhTQGUnBMNKp65Z9rTPJ0iV-cxwIfHD7Slq975b3077pdmG91EdUQUfHB4YDNLH68JafmicXgy29Z-nF9dB2aFAdXRu5CmnqLAjjlKwv9FekmkTLcsF1QFuSYe8zw17UOXkSb6jib2cZ2DZYf3ijzqGc75rY05lNTnce_E2kYCkhEvA6IuJzwBeqgOksUXsk-NssIn0cjvadqiGIsUhNsebt2mVy5T5-oWU1aAQ2uCr7Op9IUxoFUw6CNplGY1uQjUwqxKOXgPG85KhhCbyByXEAammWUAZH8nyLyuJheugJzOLV_4x3eKI9c8uVZGBPrXguLEfNh4RgOI_6-fdZWtaDb4URLJUt0TRVL23INV_k9J_EhoIYtSIky_nLCXKhVhFaVO-5PV4yCxzCUH7z69hbUCk9rj-1FOdChTYefCiYXHU2XJbG0KPwFr4lOGiHmZD7JXHAJEMGLptmuj6gaDAkmmgUcH8RWrLar9RQivy1_FdGo_1Fen8byi-Vwv7erC3zLWRK4yDvGL8diT8RACVd7Ogt06VJZpSneDcx71As1zbiUdl-KxxZuNyNvs0DLHdT-S3twIexWG8O3a3n9xaEbdX-NI-N8uP0m-1iVawb48UCnaiR86N_uazakdJCJg6kHg6tfFNkhI1nu2sgE0s3Z-oUohP21MQxlY_lycQ2VqUx6nX9bY2XOAsrlZm2mliY68D1if1Q7MHhCmnIFdgRETmEsdTTmNXZ4TW7fYU5ExG20L8DsT8b60YTJwePGgtpb2ZuaoBHKrXpuzjR-lS7Djrun6NzNW0vfKHCXBZXV6TyGBJMcxL4iOS-NbXYveLHLIleiLbgY-hOglu1ShqVbVYFGdTS5vOlPbJNF0zggjO22IOIhqkPS9x0eL1d2oO83WOfpD5Dv5PU9NcoBSyZ0rms1E0hIvia_50', `SearchKey` = 'wofCpMK4w4DCtMK6wqDq8KDwqTDmsKrw5nCucKdw6bChMKhwwofCscOEwrDgcOQwrPCvcKDwrHDnsKrw5vCwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsK6w57Cp8KzwrLDp8Ktw4XCssOUw4bCssOGw6XCtswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4' WHERE `ID` = '2372'
# [30-Nov-2024 09:04:07] /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
# [30-Nov-2024 09:04:09] /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
# [30-Nov-2024 09:04:32] /finance/root/bg/ajax/invoices/form/10437.html?_=1732950272098 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10437
            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
# [30-Nov-2024 09:05:22] /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
# [30-Nov-2024 09:05:30] /finance/root/bg/invoices/10438.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` = 10438
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:05:50] /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
# [30-Nov-2024 09:05:56] /finance/root/bg/ajax/invoices/form.html?_=1732950355938 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
# [30-Nov-2024 09:05:58] /finance/root/bg/invoices.html?from=01.11.2024&to=30.11.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-11-01 00:00:00' AND '2024-11-30 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 09:08:45] /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
# [30-Nov-2024 09:08:48] /finance/root/bg/invoices/10437.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` = 10437
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:54: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
# [30-Nov-2024 09:54:37] /finance/root/bg/invoices.html?from=01.12.2023&to=31.12.2023&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2023-12-01 00:00:00' AND '2023-12-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 09:54:45] /finance/root/bg/invoices/2149.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` = 2149
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:55:17] /finance/root/bg/invoices/2135.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` = 2135
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:57:19] /finance/root/bg/invoices/1000000064.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` = 1000000064
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 09:57:54] /finance/root/bg/invoices.html?from=01.01.2024&to=31.01.2024&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` BETWEEN '2024-01-01 00:00:00' AND '2024-01-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 09:58:15] /finance/root/bg/invoices/2164.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` = 2164
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [30-Nov-2024 10:07:04] /finance/root/bg/invoices.html?from=01.01.2024&to=31.01.2024&keyword=real 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` BETWEEN '2024-01-01 00:00:00' AND '2024-01-31 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:07:16] /finance/root/bg/invoices.html?from=01.01.2024&to=&keyword=real 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` >= '2024-01-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:07:49] /finance/root/bg/invoices.html?from=01.12.2023&to=01.01.2024&keyword=real 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` BETWEEN '2023-12-01 00:00:00' AND '2024-01-01 23:59:59'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:07: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
# [30-Nov-2024 10:08:08] /finance/root/bg/proforma.html?from=&to=&keyword=realturbo 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
             AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8K0wr7CpcK2w4XCts%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:08:12] /finance/root/bg/proforma.html?from=&to=&keyword=real 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
             AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:08:23] /finance/root/bg/proforma.html?from=01.09.2024&to=&keyword=real 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
             AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` >= '2024-09-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:08:27] /finance/root/bg/proforma.html?from=01.09.2024&to=&keyword=real 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
             AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` >= '2024-09-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:08:28] /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
# [30-Nov-2024 10:08:33] /finance/root/bg/invoices.html?from=&to=&keyword=real 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:12:06] /finance/root/bg/invoices.html?from=01.01.2024&to=&keyword=real 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrDhcOGw5bCr8%' AND `Inv`.`PostDate` >= '2024-01-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:12:10] /finance/root/bg/invoices.html?from=01.01.2024&to=&keyword=ngo 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrnDhcOUw%' AND `Inv`.`PostDate` >= '2024-01-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:12:13] /finance/root/bg/invoices.html?from=01.01.2024&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2024-01-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [30-Nov-2024 10:12:34] /finance/root/bg/invoices/2174.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` = 2174
            LIMIT 1

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

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