# [19-Aug-2024 12:06: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
# [19-Aug-2024 12:07:00] /finance/root/bg/invoices.html?from=&to=&keyword=ooyes 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrnCisKpwqPCp8OEw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Aug-2024 12:07:07] /finance/root/bg/ajax/invoices/form/clone/2227.html?pid=2227&_=1724058427430 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2227
            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
# [19-Aug-2024 12:09:05] /finance/root/bg/ajax/invoices/insert.html?_=1724058544577 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '10426', `Language` = 'bg', `PostDate` = '2024-08-19', `LastUpdate` = '2024-08-19 12:09:05', `Type` = '0', `ParentID` = 0, `Data` = 'lubcJwZ34nNKVbzm3dCahES1ZsQq74lb8ceRI7K0k1Jr72No-Qtzmolc-NoosjbR6XT0KdD9AYCdegP8VvnMIUcLDyqMUBX0Xno0OTylrcKpfAroUcYIAnOzhyk6gj-ugKdupd_PsPdu8fUugraap9oEu_2GuTN1-w2W8UVrR4u8ZlEMl6lfb6PCdFsLL9-0IBrcoTthowDQ1HVUm1wA5Qx6rqo0IjgmmHqVpTTpSW_RY0zPKpsibMKsySuGg5_0T4ZX1AZiteL-e5ZaJGAOCdSkuHPjTOxJuLYyRGcSDrD5QNE0aWk30lOXB-MqEdDs3Lkxf5kunAPR-1s93dmKu2paJ0rMOHksLkIJG-emZWorYc2v7hxIAstoU5OHcaedC6K3IbndIlEKJKq4yWhGHzHP5wRjqditWrbnPdqEbeiGNEbXYBocfLh8Cup48qpxd4v-SicEcTQO9NJQZiXWE2ZX-yOMTuxA7QJ7PN4Z5wwWZ1jYuXkqW-BYsp3NrL1tRqvq-EX_p0ttG0_ZjhbDn2kp8kOjB2v0x5W7d-Z9GntS6AKCevv_RCkAVCcx7W2b38g6PokEFnP6eBygAljitlNwYgIAnmdtU9gP0qqTpRzpcpaS7OrdtvnW0N8A1BsOfOvf3OS8yi5DAaL31aUSq-gUza19BRiy7nrLkSEDhvd9ZGpM4IzYP2FILU0kjADP7TKvW_9z-RC3QxTG-hjFPL8CsIie51oObtizKitEctU31E0Doh3_hvl0CPhS4YbZU3f97OlLX_i7uQO3gT7B2ghJ1FiDm9PaBrJu2GUqvxt7ZVEINTXCizibHXdPntrOYWzzYWR6WfUt7SVpZ4v6SwvNZAe9m-3g7kyySfomRibuIFf3aEixh_YYuqWQUmq5pEgMNrDHiOrE_t022ek5EY39YUdUEVKqNowPWcydmnD5BF4M_AyGBciDUKtyLUMYWIPDDU7UaJQtlNi4FSxRy4tmzUAAaJcnhCemNCmioUIvTk2twphARYIEqlv3aq0F', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMOqwrDgcOQwqCpsKDwqTDjsKrw5nCucKdwqPChMKhwoXCvMOXw5TCiMwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5j'
# [19-Aug-2024 12:09:05] /finance/root/bg/invoices.html?from=&to=&keyword=ooyes 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrnCisKpwqPCp8OEw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [19-Aug-2024 12:09:06] /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
# [19-Aug-2024 12:09:08] /finance/root/bg/invoices/10426.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` = 10426
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [19-Aug-2024 12:11:49] /finance/root/bg/ajax/invoices/form/clone/10426.html?pid=10426&_=1724058709334 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10426
            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
# [19-Aug-2024 12:11:51] /finance/root/bg/ajax/invoices/form/10426.html?_=1724058711428 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10426
            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
# [19-Aug-2024 12:12:24] /finance/root/bg/ajax/invoices/update/10426.html?_=1724058743927 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10426bg', 'UOuBB8rrtjEJryYlneH9foAJrG6D8KF-aruCQ_X5qiIL3fhcSPlZBa4KLQJeG_vdc0zafZYApkp1D6rPVX2V8zuqv5Pz-IK19UB-1At33tD7bJ5bYuMRho7x3K3U9kWqeVyc0vTgGuX86YzIkRiJU1FqLjZYK9hZgCTZYERtx6zyiUN3wyOHW4CsM-lqEktcAV21Azz-IE7TeH9HBHwM_mq8anF55Pw3XmP3rqLxwbyfrjCaWHXtSMmsURCzaJz1SGYITLo9n-51QowJ2Zk-1n10nPCwHekzwezDaRibiukUqdABvfJG85c3EUStDSQFDJm840Scr0rLepYOmbN5ORuid83tisUtzV3H_KfGdQcasY5AYxF9qghLSpj0BlnoePyH0Uhjd6ErTMewkKtJahv-RJFn8KyYBWu5BflychnMrArhd3TJtsrdZahI1qFuGal1RN8IG_LUdp3HMrmG7Cao8K_p6mCTKz0td257IR81ImS6OB2nDBEPtOc5iECljCio2ZQGJTKF9_CYK9eAnAzgkPyUf1YM-Wax7-Z_cACg2EvtAb-y7WuBHFy1o5NpVRDZhMijrcnd9B-GV0GAayMgTR9RgAiUbrNBGilmOMDtcu2lpJifuAKXOhhvb-9g31f7Hhc8b9YrV0YbPn-rmW7rtYQkQX0kx9ugHyaH1qeZRZvBmPAaT7ooGUr0-ExyKcJt4aOGu_pZDsNP4Hx17x_1GESK6W6n_MfNGTy-DL0uIx46WfYExiuYPnYIKelnDPQiR1g85BUxUxGhuJnS5BgN0gkKf6uKM5688Vj6907XDTZ3mKAaYlF3yLEEd9mvHsLh1MIPsV5qj7gtJoC9OkP920y-f85_y5VicO5Bj2XQ-PQMGOqsfmXjEe1ZszDUB9qS30wFXHeyRAl02_lMSkqkCJuvJLEMSMfunlUkX7U9GopKFM_iX0ja5IZbfPuPgVt8qnaiiXdm56WE9geYeMQOFGSOjtzS0Yv462PXafMirbK05I7zhmnEs_XmDqAS5CYdJZGcKlrqP8PUytySqbg4CQeHr0zOmbiVEHd7mCjpmni9Fuea3Xim0FxRXzfkmQ-2NR_Kfv6cv9d_cS0rF5AeTMYkHJZ7GiCnBIK1cgoU1QoKoIFE_-g6KHY-DrW47iF-CpddObr7gG4TPv2FdSp4vPRkxIbbJeXgdclVdkJ83s5uyjSLhdOYiqgxVQOOJJSrefEcAp6dN38WHv19FOJXcFAEUmhtGqT__nPCOqVwKK0nxt1kqtmzOPRvkcLR0hLE_zr3XkDmRdtVCZ5jY6kfI7YTZJufZDdX0iguxrpHyQmPa_VzQYFE1IC1amZAaglB0Q7Aoy0QZuvnZgDfj0KDpIe6hdiW-EbL-KVpp9Um3KnM2CX26tHA_4ndiMoVgIBbH8yHFeJijx-YnLZnKBXubl3l0R6NmhIbrBExJB2cQQnc5_hzJT4SKFpkodF5HEbXlWuURWL6YZvG9tgP-cnzDDg_xUhdhMxS8gFcix96sTvZqdo6zwgLXcJpnwLh16QnP-BJq-Ab7Ip9suThJUgrHJglZw8riM0VhR-hJGqO15jlEhGBvAV4DemM5acmsKgj72Yyhq5sDOV-VIJxMSjj2sJh366xbxIfQSoGxTK7ef6I0x1WVmibCMEJvBL6dTWhHs8kAPGUB0x86us8F7Ms2bNnLeiVxrzNMS0vhNvWURY7q3JhI3M_KHq5jo-OfVrDish6qdKaf24ZO_5J5uzGmEjZhNVtHmL3cbd6ipoxI7WY7weayIezHAKqvbpFFrPNc4n0mqU8E1ty7jyndNaPtH9yRnmRGWkJXT7ou0aNCbcB_d4ad7XS9GHDdiW5M4cZnCO1p1FkzGNU1vMD1BXN10caeTxzgkeunq09iW_DhQPZ88hFUX3aowkeauaMYCWcN8B30w8Z8fC-SdvKx5XnSqEzjzaotMn3YpO_8S8')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10426', `Language` = 'bg', `PostDate` = '2024-08-19', `LastUpdate` = '2024-08-19 12:12:24', `Type` = '0', `ParentID` = 0, `Data` = 'K5ClVOer9o0whYh7QEQGG9afA4SBGXM_kazZlvBeRzntBuER67c1KrAivTVul5Ha7T2d5aYSGv7CvSSLsiFMjwLoigqmL36LFFZzJSeEjeIG-tEhJjt2a2gQfVfy4IP0j08ktqDOmdA8uLcwJROZT76c-baPzflnCA9rLq8nl22krY3rY3-S5BFrlJ_pQ8iY3BRQJzC37GJu2y87RlBoP8xhUN3r8e2xofT3TOI32SXivuUFIGNKYD6msb-89H0LF0-BkBGRBQ9LHoqvZIgnzi_yHfP-A5vSrxboszqbU6tu3OlN-MC5gNw0qpUP8fvWuLcmvkwRjHDa8NBNQBhjj0WPXAU13GByta1p-eCjCCDUcm_GWsUWr4aQntD7QmImriPpg4cca18mZpuDHTt31cckYEE5kxqhtdnt5WU_pL0TtWJWQmDR8yrS5b-RfAoPH5ghywWDVcBJCCdJPrwtM5OgyaQH_6PV7htIkH_ULsOgyXB732AuB2widQyY994HZy9eGzxrY5i5KR_gYMb9PfOzEDaacEcmtmQkS6plsOdD_SwHJ2vXfmIOMJ6QHbMk9JxJnULR-Q_kpYODhKAyhJMkpiuBAJx9DG-sSy5byx-4r1ntNqK53OLwE0D1QX-6-J4s51OtIg9HQKQn1N36JFry1qxiEr0sAqfi9UWELyH8ki2-TBWBB-wXmH-KrI-0R6YITMV2s5aaI2Nwvsctv3McTnCG2sTb-Myq3-ow11xB0JuiuUbPqFUt1nZnD0rFyNdOEn3TidS3lNzY-rza9Wqe_Y5cAfZcWbWCbAACVCK3TDi51l4ZaClaKT393BU9CrA3ykmVo_2Dkc324hsfo99eJbxOHW22f8N6NSJbTF1ricC1LxDIUJZJ4BedpUv-5sQG3YVT1GK_hrGApllPofBcGLdwMUATZMeuuND4Oh2okHvEK3JSoZwvMfdsnneP-P9JEYibjstDXE_ZqIr0d3z_JO3bDozkyOMNnFYFKCEavuu1t-RCr1NtaoAzFTGI', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMOqwrDgcOQwqCpsKDwqTDgMKrw5rCucKdwqjChMKhwoXCvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKd' WHERE `ID` = '10426'
# [19-Aug-2024 12:12:24] /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
# [19-Aug-2024 12:12:30] /finance/root/bg/invoices/10426.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` = 10426
            LIMIT 1

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