# [26-Nov-2024 12:00:09] /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-Nov-2024 12:00:13] /finance/root/bg/ajax/invoices/form.html?_=1732615212467 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
# [26-Nov-2024 12:02:37] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [26-Nov-2024 12:02:39] /finance/root/bg/ajax/clients/form.html?_=1732615358483 167.99.142.201
# [26-Nov-2024 12:03:40] /finance/root/bg/ajax/clients/insert.html?_=1732615419134 167.99.142.201

set names utf8

SELECT MAX(`ID`) + 1 FROM `clients`

SELECT * FROM `clients` LIMIT 1

SHOW COLUMNS FROM `clients`

INSERT INTO `clients` SET `ID` = '73', `Language` = 'bg', `LastUpdate` = '2024-11-26 12:03:40', `Data` = 'ocUuaFxm_AK3XxujkpfB06GgoGWNs0-f5ghheHgAXQim80_AL3RX4ktd9iEsrbWeJ6DHsxO4Wtr76ezKjFZlbG0-iYqMJVJIRZnELAbhn0GAeGwou-a0v1fUSEU09F468sQ1TeGJtp8uISgifZfOUkxfb5i4quJ_FEqH9E6Z83EVSuW3NtxFZjaGBPEpJP-q1ejSIF9TUZtiKYOGMtESV5SiNSAcDryPpq6-ZSLoXj_bXLjBSHj510uBSMs9L0BpgczHelBPinN7jOsR456KwAZW3OIVQa_UYPHI1oEpWacE5NauuRTwHSNE1S02f0UYQZi-Wmtbkpbz7TmyCAHxUc5pTLjzsOhnTYvzCXT-RXl-LhRHCnJpabsY_tCs1hpd', `SearchKey` = 'wrDDhsK6w57Cp8KzwrLDp8Ktw4XCssOUw4bCssOGw6XCtswofCpMK4w4DCtMK6wqDq8KDwqTDmsKrw5nCucKdw6bChMKhwwofCscOEwrDgcOQwrPCvcKDwrHDnsKrw5vCwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK0wrDg8OQwqCpcKDwqTDosKrw5rCucKhwwofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDn8Kdw6jChMKhwwqTCrMK1wp7Cm8OWw4CqMKgw4LDk8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-11-26 12:03:40'
# [26-Nov-2024 12:03:40] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [26-Nov-2024 12:03:43] /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-Nov-2024 12:03:46] /finance/root/bg/ajax/invoices/form.html?_=1732615425235 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
# [26-Nov-2024 12:03:51] /finance/root/bg/ajax/clients/select/type_0.html?keyword=бри&_=1732615430398 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wofCpMK4w4DCtMK6wqC%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'ofCpMK4w4DCtMK6wqC%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [26-Nov-2024 12:03:53] /finance/root/bg/ajax/clients/select/type_0.html?keyword=bri&_=1732615432780 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrDDhsK6w%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rDDhsK6w%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [26-Nov-2024 12:11:13] /finance/root/bg/ajax/invoices/insert.html?_=1732615872266 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 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` = '2372', `Language` = 'bg', `PostDate` = '2024-11-08', `LastUpdate` = '2024-11-26 12:11:13', `Type` = '1', `ParentID` = 0, `Data` = 'PPnlBh1EOJJQXIYgG0zAR3jR1iiAvaE53-MJCf87qVl98PwdG1YpBVM8qZuVuqImBL56ovMSLXPvEFmHpyPfMqTogVL_bAUKjJlo94aZaJIGiar-3iDfjeHi2CULfwluCIU2VhMk8hcvDyeoLYkGLZOkSsjwXqz8o3yrezen5UMW6V0rGUkWGF4uCD3sYWaxI6h6a96AMBrk3zJRZOa2K0Rutw-GAo50VyzqcJd99ky04L3DTHFX-GH3XyyTygZQNHFdzhMEinIngAidFx7WCL3XcJsc3Jt1NVxiaRdrzzu0-r3XXltzVUwG2ZKCZ5lZLaa38NW5Zrqyn6Teo3E6biSISFUlcC3rKutEjWJMFEoAXPudskmYhGbSi1-1QF8ebS0B_lA15AAbd5VjEKP2ouqMoGnLfMqGpiUAIt9Ka6BKhBW6vx2iYKJwK7h2_U0eoJEakwcq48THf-GBpl0xEWNEybNO8y_VxdIDt82i7OC1DKdC9OBXcqNflvrKIT-aqpj4OVWvsmoew71PR5O7PXOxWN0cnERorL4cF0FNKONkgdTkL7eFVgYOch6zjPtu-Vzo8lPxRPv2l1EsrWrT511HRvn9D8u4Z38pBpdEikrF2agIkkNjY_u6p-XQmE_M_2t5Y6IdrP_M-HBIUs-BtVMv-DxHnmwXYQM6rE2oawze6Y7S-OwFbUi2cxiEKOtA-B_Y2qoL77LyWhG65r8IY7Vwri20jmFTBJDGjqW5hwg23l-piz42KKm1pJSZ3yWzhqScb4MJXKmoc2_HNuoMttvTqSfJKSqrMKYAH9qnw2uiK_pkAa7FOymH_BwLui3Wt3hBqzXYFeFsPLrR_n1uNp0lOmyDye8bNFsJqW_woLn_PwZL60fa3MeiWJuQ-JEeqlJ7r-sHDXdrJtzqCK3KLLUB560PCFQeCGZD-X2GW6zTbVci0F9BIBEL1BGCocPQRy7NF83VQ-bgfKvoq7IezcIp94g70VVt0OUkRracQtbsGKQSdjGdSXTYDLv_ShH3JZNJflIZ18czPG_QDfhCDacXFCWhO8tuk6jSZ_-2P0o', `SearchKey` = 'wofCpMK4w4DCtMK6wqDq8KDwqTDmsKrw5nCucKdw6bChMKhwwofCscOEwrDgcOQwrPCvcKDwrHDnsKrw5vCwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsK6w57Cp8KzwrLDp8Ktw4XCssOUw4bCssOGw6XCtswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4'
# [26-Nov-2024 12:11:13] /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-Nov-2024 12:11:20] /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
# [26-Nov-2024 14:45:56] /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-Nov-2024 14:45:58] /finance/root/bg/ajax/invoices/form/clone/2372.html?pid=2372&_=1732625156619 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
# [26-Nov-2024 14:46:00] /finance/root/bg/ajax/invoices/form/2372.html?_=1732625158955 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
# [26-Nov-2024 14:46:06] /finance/root/bg/ajax/invoices/update/2372.html?_=1732625164614 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', '69sXQbhhziuyKyG6SaVseT8Bx8vRyFFDu-Ci2Gnvbzob72tcfME2ze40dLia1tIA9guoYKpPPj7Vts9cVQxMX74Mdlrp2FrKSO7-4Te3P5Ydl4UftpvThznO13ahtEhZnsY9B1uiH-72LlHnlp7i3Wps4v0-YJN6ePKadbraGgeJ0V0yHgcIC63OjNsMumTo-uicIkzuUI1D6MKYw-O7VFzOCeTffhCs0w-TF880PLJ9X8pC9hJJnEFSgeKm3D0FaVBmDN8ZBB-43LgoOyyxFiI6C5coGb5CYFwhD4kec7DCrLNUdTwtH0SziTsMkNhaeNnEgidPmy2Kc2pQ2R8QDv0iOgwL7hDk5O_bqRbLjzNhlAwBq5rol44TA6WmIM69irajXqxLjDOvzHa3zOiqPk0LHw1KfTCflQUfSgeKK2PepEin7VtAQYuPmia7mEH-3d2cZpFnPyOfwZaglGw6uR05XiiH56scWVoyqdt5QcSQJJmRNw58i6Qfs-s-Vc-6i5Uq4rVLiI4TxOu5JZk48HeAJkA2koiO5kiYnR41atETJ10TNQXJzHc80dzM0SdgyI4c7yXMKZUofQGAJ_rrB6jvr67mlH10HokYavDFihL33t_KdrlsjK6hhKEPrrS9glAw0oq2chRGhVHbGqNZRw0eJVizLM5KBHyuLTjGtE9_rgbvVirupjkmvETtEtmWSCHPHpo6qKu6S1-XK7eM86vAQndU7_dZ3qle5HR9gbVK6wKI1FnIJ6W5eZ2qKsOfg1GCQxUPVUDe3_oj6_xIUoC9PraJ62iCUFzOGMdjPROe3oEn-9CV4t3rdExEad4hyA_b_7PuJqWFyGflwG7E3dpIucnJqPidDVs9zAl3R-MYSZMKXMGuiBS1kgL8Qr8ZPVlOF7JU0VHwEnzg7--qXKKgnBwTBNLv5Uvhofg9dU0ty_OOcqp3hXKEYmXUL1Dns_8mBlLk509HseB18BiUhB9Mqylui6sjfdjp8vXnBqaZPtwPdyk588g6qrlfPotwxOqCL7Un_0vLKSzRXZTzt009OrPNqWltznI8RRRkkE_M5EL5E1xKevbY92qXGMp66akzE0g9OL-uOb3qLYUckfv4iJNJC77IrVnpIKrND40-2FknspxzvSNCXIK7bK-SyeK6ceaQONJjL5e1a1nDd7LapkR1u20h9R6bBe5D0IQnolQcpwXAYhRUL2Un31W3DA6TVEJoYzNv5CA6xjkrNi1nBGufGsqwqprFRwmKFifHGnr97NOuplHh8xmTGiaCtVq4WHci-QoH7b7a42mgLUrfK9QpdsUnyAVE9CRhZmcf8_fn2XRKKNpV8qn2Ib4rAvPxUaGz6vvKOEJ7tQ8oZn_Sd5XWiaO3ABXicsSLmcCCj70hOiGvIo7O7VIRV956Ke52NMYAw7NP26sydxeEuFbntbLWYM4d0QmfKgqal1Gn3OGhmTZCrJ7W8252ouTH7GtlWrvta24I3uVmbmnzEzychV0dQj-BX4_W2sCLJdCzND3PskIQ3vcmT6QWUSjY4ImMWrWzvoVQTY5ShI6gFDv0QSi5ZaLgFgZwOSLEkwdRYascqMBvAB84ywRZaLyQnO96lgDZdMDRXvWvwdBSKUDHXOI5NshPgpConXEOwxc-GgzlQWjKtfuS9IW5v-seQVY3brWUBJdhPxOLlXr4kkJZJhPoM2dLbjPM7EcbaWNZBlj9yuHE8hJjpD51FsELf2j6mqlLc8hcOUDOtCzUjYjh633rTXQDnT3g5vHY3PEY-dbOq9gfsWDgiqyV_mw29DcMUQ0uxFzIhuxofuEuyMue4E680tqudcEjcfOZAimvf6sBSXgR_fUsBB4itegHAdG5afAosvk8nsuF_fW_VhvPM-NCO_NNO77VAboIIJgfzLfr-HzJqiNwTJQxkciN62D9n7JlPmL0h9l0Gir4hiyPlsXpOItEnTvShCDie8HrbXgwqvucKd3ngrX8FKVw7ZtxFl5Gz_8vqXgDBYVP7rBb2kHPhq6BVPkPTC-d_7g')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2372', `Language` = 'bg', `PostDate` = '2024-11-08', `LastUpdate` = '2024-11-26 14:46:06', `Type` = '1', `ParentID` = 0, `Data` = 'y38vHvzWOEyYTgZ7fJBaepcEenMTsKKoDlWPtikn3fYjmTYbA-sR7Jp_CRVBee8Oua4ql1hqG1AxrrfoI_2JH8DnwxUHlSKlvyUimTJ6MlQDK1zLU0sel1_mMC7BAka6V09sVp_bUTSKVBgkKbazesVNGsJaszltrjhu4m8fGcUpNZBteMZhjUXzIlBO-mDn4geByiTVxGj7jId4FiH5Cq6y_7Ny3DF3ulVvYfoTxh1eMTIebDz3fxgJ1wNX77pQDOmK1gZLEEVAwLJB4v33QgVp-5c12-61EG8c3fkhidPWc0JPNsqGmjjDThGSF0jP1YW1knXhYSNnHzjKgL1TVyAeRaVIAjrq843s79wqlF4kttndb-g4dLajPcH4WI1NYGh7gikw8obnN665FOTZru5QrpdP_dMBITJnVoH8YbTIXmu4CGo1tPjpwnZgLT0Yw0eLdII7tpc8knhlZqNqA_rq9lZ2XeA4YB2NIjajDnv4YJM-9FY1UDoQq8Op3qkUZ9S9wr9XuvpT4KY5d8KrUZJdPZPYd9j8aEx1ZjjDYjBtxz1eGFX7yiHZKeA1sfnAZu8IGfvpw70Joc7-JCfV8AXY3RXhLafKmFEv8XMkcpsDSnr3aCn-DKAWiV6-kkELfD_kTxzvfbVttd7Sz5zcljurGDRqgtbqD-6yOHUU_XzaO-0ERC3TDmzGk1dQgLxwPuthEsxzJw8MMX5sW0HAeTUc6tNqBzBbm-CjF_65USnUJvRR1AXbcDneEHa7JjZiLiESxi0-QInl__AMh7k7LMJ9OS0c7YFtyxnFFzwIHZJrE2x8P2UJA2xH32-cN39f-5vh2pbVsC8LX6DZ-VX_JuqIdfPLTpQP3I-SFpkkYULKfOHlShJ6D_OAZby89PgJG3VMmI5rCtnJZDUjBEdLow0CoeUhvMyVC1MFGUYS3WvbLtEOsFNQEBsFH_4rtCePN4fyh8rBtdy0yQDI89Ji67bzS6D0IqYeMmCBatFVY3dWpmEaNua3XplL1ACDB1eV2k1Kl84wDDgQ-7nGJnRy1Wz16lzQAFsDQd5zFfVIajU', `SearchKey` = 'wofCpMK4w4DCtMK6wqDq8KDwqTDmsKrw5nCucKdw6bChMKhwwofCscOEwrDgcOQwrPCvcKDwrHDnsKrw5vCwofCpMOIwrDg8OgwqCocKDwqTCwrDDhsK6w57Cp8KzwrLDp8Ktw4XCssOUw4bCssOGw6XCtswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4' WHERE `ID` = '2372'
# [26-Nov-2024 14:46: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
# [26-Nov-2024 14:53:21] /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
