# [05-Jan-2024 05:40:57] /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
# [05-Jan-2024 05:42: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
# [05-Jan-2024 10:04:06] /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
# [05-Jan-2024 10:04:08] /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
# [05-Jan-2024 10:04:11] /finance/root/bg/ajax/invoices/form/clone/10388.html?pid=10388&_=1704441852515 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10388
            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
# [05-Jan-2024 10:04:15] /finance/root/bg/ajax/invoices/insert.html?_=1704441856542 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` = '2163', `Language` = 'bg', `PostDate` = '2024-01-05 10:04:15', `LastUpdate` = '2024-01-05 10:04:15', `Type` = '1', `ParentID` = 10388, `Data` = 'ULX6i6_DxmulHyvzJhfEOdqn83_4G7Du7xLPU8Gyt1hZRec0UM_QHj7WQGxxq2W6UusrIrn-6k11V_lsHru8FTZrZDINU-b9vhIuDqIYra1rkfSi6HIAMBZv-a-UjDposTWEjqoiP503qiJH_F0yG9P_YDehjLmNDMVUpPw1lOxhNxInSIPP5ZEOGH-XWGVq1LIdtwHNjjvM_gvC-nJgn1bO1a8J9BPGreg9FU0PHseuic6Sez6YBdOYidJCIl3M_AnMaj0-ycuxEIFbqLIaDMNaY58mR9cH51N_73F1BNDwcx9cM7W3CPH-vnOArseoq3fzggKGJMJNeYBWrN2ITFWst7hsWGhZotWvzikO97zuW4TSzyKXoh2iNsBQ1H7Nn84kzrj90cd5Xf1SMY4RrRmQUmdz_xoQsLj9ty8gwpf_37wxh7VqRwS4-YMuz7tZcL07531rgfJa37OiHl-APt5uz5cNTm-xyeb75XE3qwNAbSyXrDPecuSejNgWCUw76gllW8uS6wprFo3zWw3gNk_fkodYjrShr9hrsPhb1_tCnK_YJ7ymUMB6pDtpBH_aJ9duz4smenjRN6yE1nTILQf3OmOCc39hxKJCpI5Gqfv0dxnx6douH_TDuUvFyyEnkC96B-XJs8uj37F7UggV-1yZrhy7HJlJquAkrcqkD0EexDJtuwaB2I01sH6j6R8W_xbRZsnUc0TTmVew4sVO7-6UKoO-mLizqJXP3Ziq5xLMy0ab7QDC9wbdwJoXKAUDL_4B_VKXcLZkCc0zbUw2wY8ibM9k9BSkOBfL9ds1ty2R3g-SdKRtxaVSohgQqvbjUEHdPDAfJN6ZJrUg5_pDo_4RnPDl64C7GgMzoZWR8Vk7OFRXJJ-Eux3RPaEeWsfVbiQGaGJfZczplkznsyYJ0jJBhaHQUSPn2tTVSJRicLFOl4VVXjpOfobumanXlAlW-IV1MeiODySR6lMre73Fvq5bLjudVMW3xM-PHe6Fzu0FGr1Fn33X1a4APvAuQMGQ7CotSMqMpLRbX2ajEFjHs3C-nRyIOjiGhQ5rqALUlPTxDdptmiwJRO-jyMvKxAxt5ph_B89TXc-Yc6iws439KLjyicv62hivj5Ma-P2hyul7iNp8j92-35WasYHLlNj6qLp5MEyiFdWn4p5SeLougr8jJR0KBRbvh_w9zn0iataxJu2Yjy8QWXevP4OC-GWvTF9NEEARs6uS2aR6Znh2QInc_8_uh6hSaWwJkK1HAEtjqaaV3G3VwobHqAG3YwckMIxlfLZQwhFA0xaA9SEVbbwrPOTODO6wG0VY2FmVcYiNTEsmOwI3CcHRK12O10LgfaGnZdP4DLgP8-tQ4lkFXaqNrQ036v6mrJomENQDlE1Ud9pwdDuqiOx62nMe6u3cZlcxlS79Pnl265Lqgsr37whESQ8IeHZ5InRg2qhbTcJ14-aRvSXhzzkW67nckG35IOFCOPyFt0buDC7aROz0lCOg7m5I24z7LNxd-SSQv-cb1-u44Adawsr2gC61JHkYBNHvSnbU1mtV4KOv_1QSt_G6aUhZ3van-MgjzjyjUG3LyomFrpu1JuVGI8K70qAT-IDs_OHweuyri8oOVETrZVETcgl83dt-VGjAKOXa5-cuvZAJtXjBqjorCRClTzQ4w8rxSEC-TOW4bYExcxPO_nitJu8Se_SV3kelhxHxMCjryofm5H9F5cosCwe8l1vMlAPGFmDE3fh8oTiLRg2zIrNKm5FrSH4_UWJKg_scKTc', `SearchKey` = 'wrDCr8Klw6DCpsOEw5jDwrvDhcOGw6PCscK0w4LDrcKtwrDCwrnCoMOCwwrvCn8OYw5rCr8OZw4LDrsK3wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCuc'
# [05-Jan-2024 10:04:16] /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
# [05-Jan-2024 10:04:23] /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
# [05-Jan-2024 10:04:26] /finance/root/bg/invoices/2163.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` = 2163
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jan-2024 12:05:36] /finance/root/bg/ajax/invoices/form.html?_=1704449137114 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
# [05-Jan-2024 12:05:42] /finance/root/bg/ajax/clients/select/type_0.html?keyword=rem&_=1704449142768 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrDhcOGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrDhcOGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Jan-2024 12:05:44] /finance/root/bg/ajax/clients/select/type_0.html?keyword=rema&_=1704449144514 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrDhcOGw6LCps%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrDhcOGw6LCps%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Jan-2024 12:09:01] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Jan-2024 12:09:12] /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
# [05-Jan-2024 12:09:15] /finance/root/bg/ajax/invoices/form.html?_=1704449355966 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
# [05-Jan-2024 12:09:19] /finance/root/bg/ajax/clients/select/type_0.html?keyword=re,&_=1704449359741 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `Top` = 1
                ORDER BY
                    `PostDate`
                LIMIT 20
# [05-Jan-2024 12:09:21] /finance/root/bg/ajax/clients/select/type_0.html?keyword=rema&_=1704449362228 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrDhcOGw6LCps%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrDhcOGw6LCps%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Jan-2024 12:09:27] /finance/root/bg/ajax/clients/select/type_0.html?keyword=Рем&_=1704449367398 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK0wrDgcOQwqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK0wrDgcOQwqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Jan-2024 12:10:58] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Jan-2024 12:11:07] /finance/root/bg/ajax/clients/form/20.html?_=1704449467462 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 20
            LIMIT 1
# [05-Jan-2024 12:11:52] /finance/root/bg/ajax/clients/update/20.html?_=1704449512848 167.99.142.201

set names utf8

SELECT * FROM `clients` WHERE 1  AND ID = '20' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'clients', '20bg', '94kIhGfNrG_Bm4l0CR4GwtpQM24ldVEsLPuBlRzfo0TqdiGGj7pNSQp3tWtEZuF6k0kHMTbzxDfEPx28Z2TUAXrridA4WgmcTXj4FzjLA109QqFGCOt4opPubJ5H0gHQuAXq8s3LEdzpsYPPnyi6mBg-J24TA31V8HkpImQjGT_UWm0ir4Kh9ewOcLPMlixNDaUN8HkCP6dgI5xtKASvGEF8LDSLnXCftJ0uJA0Fz926j6eOhrIklefTXfhF8NzQkPMJ8qn5VL0L5PzMaNSnJktJ9bpWp7BVBhNiXpLVQz6_DST202w4fyIBVFSf5tM2tfnvlHQftl6jmIbbDXJIXHpHYIZrAYJMWKd6FFAwP7xdiCaVM-JupBEkES6XlQUpVWWUluzqBzX1KIFUzPDLmH9mlaw77niI9TpapS0i7ysA6UZTTOSRMBbPS68ZpPIgkAqdh-8Hwen7QCBuE7N3WzzbNcUQjrGOBTyigYHwLltqPx4EXiUWKTJAQ-Jx0y47AiDFOezJETP7A092RxASXycZfFx3NwQlCZG7HZq6mgGlDavfsQHo_cvUeIYJUDns15cU90hFOK-ksrGOXRN8FCUAQiZUzTawJpKwd8T48VK0Ka2TsaJ-bBgEapdBEs2QuVT1gGlcHu6158_leZ44tcoQzjXjUxo-XaFASN0j3U9qvXPBdOcB051o_5i7U-WWK5Sm8ULm5xq4bIuHFZl6i40Azy9R_UJZnekSxvhZf-X_i0Twecqh569sINAWTGsMUJo0xTs4Hb-7JEJUU8sgq-upiG9WsXFtqYq6he0n4OUfEcZxv3XLMjxo647vg1Bct0AZRwd7Ww88rXp8djU0xZD2vEK1pMbt0-WdK48KoMza9vIwBVSEPQiFAuprYU3CWXkbQqSh_XyTk2YXIh3slgWwutj_u4jHLO4B3wBucJc78syimli47P-N-04RMaOeQ7VPac8ZapoJcs8x9Ex1EynLP6iB7tR_hhmJXnl9Dra-NEUhVa7SuDX7opC0DV4jglAGlrwcQ19Ja5ymnb-3f-tpJYOQRr4TjleL2Pz54DY')

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

UPDATE `clients` SET `ID` = '20', `Language` = 'bg', `LastUpdate` = '2024-01-05 12:11:52', `Data` = 'EdG_Y2G9EgxYY30W0zH5XnLV7rQPZOgLNAfqSG0hoXXivrmJdA3iSx_qzYqiC6SzQrnEWdvswjpMip0vQvlcB8bk0W3eStOkGJ-zk-tFYquTne0mZd_HnxHTurNSrYrmpWUaJAC9RGVZ6UXUYMn7F2Wq4iUrnZmcaHbcB7Y03OI9nlDtpZyf5vg8VuZ_fbEEsTmyjNPAdZJbuj8KOBOjdJg-tx643j3863uWB7xMjfXqqSydrb07aqa-HnH0vIpVsK6bnHmf04DyToQXfYJEzdThJtF7d7HVuJPupcOneCPUWkdDOVsOzbZRxUd-tnsBcGwgSyUvMrQ_0ID5TfoJwOduERKRiEN6Oqu8g0jvuz9684nF_NOwmCU3gPU8OSiy', `SearchKey` = 'wrrDhcOGw6LCpsOEwrbDwofCscK0wrDgcOQwqCrMKDwqTCsMKsw4zCucKdwwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOPwrDgcOQwrPCt8KDwrHDnsKsw4zCwofCpMOqwrDgMK6wrPCt8KDwqTDhMKrw5nDj8KdwwqTDgsKxw6XCnMOAw5PCpMKgwqzDj8', `Top` = 0, `Visible` = 1 WHERE `ID` = '20' AND `Language` = 'bg'
# [05-Jan-2024 12:11:52] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [05-Jan-2024 12:11:59] /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
# [05-Jan-2024 12:12:07] /finance/root/bg/ajax/invoices/form.html?_=1704449527638 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
# [05-Jan-2024 12:12:11] /finance/root/bg/ajax/clients/select/type_0.html?keyword=рема&_=1704449531905 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCscK0wrDgcOQwqCrMKDwqTC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCscK0wrDgcOQwqCrMKDwqTC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [05-Jan-2024 12:12:53] /finance/root/bg/ajax/invoices/insert.html?_=1704449573872 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 20 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` = '2164', `Language` = 'bg', `PostDate` = '2024-01-05 12:12:53', `LastUpdate` = '2024-01-05 12:12:53', `Type` = '1', `ParentID` = 0, `Data` = 'nQrlurs48TBHDcw8HhcpkMnE-WCbgm0xJ6T32sMk26IhwPwW-_LRbhmmQeDM3HyfTH9oOlnsnOG-r3lLyE-0QKRH-jbrisMqWHCnKGL8kDCAl0vsdM6UrvXPgInHFI2ZllKWm0tw6l7CsQ1qV8tD22mJXXRlXk2XSQ_Xn9l-qj-FjFva6G5LCnlHbfPizdAbsyqw8pp4_XQ4LKt8tLZ5JwF3b3mNkyVN3sx0Gx_6IomVb6acfFZYIuPEKQqcbk7L7GSY7ms77v--9eaqB2S5wfs85VBsoDV3K4Sw8XMBaNjreiylc_4EysdB6wME7dyGNqnwQltw10UTB8aR5UYvHbSiylqay-ymv_e_B9nbL-pQ3OYaS5fxCSHFS4rt-3xEAXla3Uas2jIcpBArZnjYDohe67RYwAk12RrLwMQOJ6XtUD89PubHozbfsLW4Okfkv3fV-akxYkmmzBb2XrO_Jq9iMffMemr_y8jt2DvSdIgN3C-LgEf9tWpffa5o-wHkdu6dPKuIv_yHaWX3o5l8sHJzlnHymQG3glGtYwqv1HXb-sfSMF_1aIDGTYqGlY_Hs2OBtKdVy6fo6czcqffdcUPMUlV-o14JzjH30ci4o_UsOBblHeJzXmrHG60tsTL2f3lhlU5BFmBEECalKYp8VJtJHoNxobpm8E_MqY12xQVF9TXDDdJi6K-feLHBffzt_QkrCNdKfnvqge7UvRc0oGvNCfHI560a9xXEp8OgR7AsGTL8UTwi6HN0ThrXNngAlOm3sau9KbmSBwO6O0HvBumSG8Toqrp1pk3xQBQzE9kivc4Q0rqwhuHYuEde_DyAZuaRwDTGX0LtWjV2S2vMWh3UekBsH4EpvsdJ4mXjNO0Dn-7WA_ktfGFaAa71hNTVLAT12dowQAKT-yUKQmkjgmOKoyw4HgRR54YbCLyl-2VseNVWC4cH_tzZ2TbAGHO-l1-tm53FoDrbBF6fO2b2mobbo1Xgldx_AxvlAIU4EL4rFco6ev8xtL8wkaDk6Cfw', `SearchKey` = 'wofCscK0wrDgcOQwqCrMKDwqTCsMKsw4zCucKdwwofCpMOAw4DCtMK6wrPCuMKDwqTCwofCpMOIwrDg8OgwqCocKDwqTCwrrDhcOGw6LCpsOEwrbDwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwofCpMKjwrDg8OgwqDrcKDwqTCwofCpMOmwrDgcOQwqCrcKDwqTDgMKrw5rCucKdwqjC'
# [05-Jan-2024 12:12:53] /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
# [05-Jan-2024 12:13:05] /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
# [05-Jan-2024 12:14:13] /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
# [05-Jan-2024 14:35:27] /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
# [05-Jan-2024 14:35:32] /finance/root/bg/invoices/2156.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` = 2156
            LIMIT 1

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