# [08-Aug-2023 09:17:19] /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
# [08-Aug-2023 09:17:44] /finance/root/bg/ajax/invoices/form/clone/2053.html?pid=2053&_=1691475464069 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2053
            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
# [08-Aug-2023 09:18:23] /finance/root/bg/ajax/invoices/insert.html?_=1691475503335 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 3 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` = '2069', `Language` = 'bg', `PostDate` = '2023-08-08 09:18:23', `LastUpdate` = '2023-08-08 09:18:23', `Type` = '1', `ParentID` = 0, `Data` = 'QNfl-h7rJGQd3NcI_bcRAY9Mmdf5TXtXOm32CqEWn_6g2G2-L79U03LtSWBXVHQh0Y_oIcyXj_ZlXeAh8t2a7_6wN8HLizgPnT0gWy1OUkSZ1reY3kYxH2ItyGegdBhZn9gWpp61tNEMMAwudsz5bIqJTPhgRX_C6a3qka_tr3J4KyvzJSYp4E_J8t-2YnH76KH5cmZcQMr8K1Ygt_vxb5hQKedoBh4Wx9r4MZ8bCjOsjSc2FTXaVcQsysy_I3tLdSlChhhB8slAlmLcUcgboKwcRU6WUfcn3iGghCd9S8FIKd3XgLNPC2cYHaL-u1PlAorEXCg4J-YRwMQnuNWIPvLWeRfNvfUPsV0nkAT_nx0-lXVQCqVCbsCeQ6MRrDKhHVUqx6DnYDpaZIF-UiG0KQHbpbXVd27nBqhCIbL5LDg1Nj9MbRtNY19CWjrhTlTDZuyIL7UdlmnTBncmV_S6PYqS2cy_GOZFcF-EtMkValLTyoN3zgHDlFQJzqfSPGAVuVdSukvdI2NY1jdWnO9ekBb5xgiwkmxNeeNUUGEHcU-ALtt7Xc-e6F8giZyqhKKWeiFqy9wwOfzoy5qCHhYtpdK56GydI3IE3ui4d3BahVIV7pLtq_9fThS3bcllS5nhgdinipksAZUOF6GIkvi4gE3EDyjBDqeFS62Dre17n8FxlY02B6zmqcrP-icrMK3x4KCUVk1EqS8jHi-uUBz0gDy0j1dEMZ6h0tSY8Azy6Wa73_zuqs7TnknIhYZSacFQ8zB0DRZbcdCmb-dq3-nNuWGWYsNVuDE8Op_km7HYMo1KcTbDbyQKiJ_onRcgoibv_ojihhPzX1GrHmYwrdu2JU3hRkNKr33LQq8TFUsOyiJR4g8LMa2oL5gpFpr3aO71_a45E6uEg0tVYX4OTFhq95sa4sRcjfWmuUsVmmqOKbA', `SearchKey` = 'wofCpMOIwrDgsKlwqCqMKDwrHCwofCpMOiwrDgMK6wrPCwofCpMKnwrDg8OgwqCwrHCr8Oow57CscKzwrrDnMK2wwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwrHCi8OGw6LCrswrHCr8Oow57CscKzwrrDnMK2wwrDCisKpw'
# [08-Aug-2023 09:18: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
# [08-Aug-2023 09:18:29] /finance/root/bg/invoices/2069.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2069
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Aug-2023 09:18:41] /finance/root/bg/ajax/invoices/form/2069.html?_=1691475520885 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2069
            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
# [08-Aug-2023 09:18:51] /finance/root/bg/ajax/invoices/update/2069.html?_=1691475531502 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2069bg', '6WsKncAI8u9pksG2OyGT2p4KfG_eVekUeX-ejAJE02wCjlB33rOLbeqG8z8j-wvUx0anozsCcPFCT1uUwYUdkFThuK7csq5IAg1bY0l_VCvrNfJ1oV8e6F7tLGUDHLYbjArpxM3qA4r4n-UQkYGQFcPMB3_hXliy7PLvMj-jNGkJhE0Qo32Rb3TRgQ08wFpklJ8b8KL3M2olCXo_DgaP1UpAivLYKWiBX6-sZw6F5S6zvyKWNvkYsSczLbdS3Woy5UCsMCaodZLQcJlBPUCpjZ1jscEGH9bvqMo_k96ADOL_2J4nNAZ0Ssauw99a4ZJg2isp4A4KveibmV0TTQfWokBW5UV3QHdg19JN7jVGEsoQyhBA6n9u7sXh9377FQj-HsUuy-1cg1OBtbwl1QzzXrFMwU2CyiqVeMG1eQ2qylmXU-QfZSo26DHLjAvGaPZyQ_dcSuBShv7xurjOX8GS29IjyMPb3C63Y0qtzTrHgMR_BEnalnjTSDA8tMOT4PuHe9PumkYz81Sat03ZYqFTZ7ZAlBxHlCdnKua0NNEyM1wid-5j78gLY29RB6fsS_cjeWm0OyEsnWb7EdtDTDajDtY49DidP-hnP3NPwrxUww3JaO7-j9pCP64n0YtTjuGfTyEQ2bK89AJ8_K4CTTglXFPA6pcF5sc5yorwQuE5S6IF6iCkqsNplE-t0Xwd_oWLo2p2SFYMcLXX3VUhEJacEpszUxp4qynGpQHHZr5P5EnbO-Utv8zA5KFurolViACjPgVfaSEwJBkpQGtgg4mM_k2s2SZE3yf-lpxgkIWN11_v2Bnbgf8T_izR8PZrEDm0fFRRlNLz2LaBS1WUqi3Oy9kDijaS9chEisAPB-SyFC2U71POW3udeeGFU6kG0giYB3iz-4iDrWGa4w8ttCzgcWIhA_vFk6QUxFfFbzwXA_osu4ojFXU6RwcBnBKHBqf2nyoEW9gR6eKj0CrLIGPBr7HuphRGKu2TWM_-tIr3ddGk8TEbMHKfwdeCGznfJLCX3bm_YFQrKjPoFqaxIqxQrI-4WyoWMMToMTypQzcWh5AfzT_EQvNuC1169BEOuJexHe_vtNIZHrQNJVT7XAidLwtgKcbhR2rmqtX7M08oEj2codHNFLrtwVLoXrFFn5ZER6SYpJlDRuDzWMvfwBFCjIrfmlOI_O-r-Wto8YnARgwef1v4dw9r2EoJfnFqLX0KQxldNxcBg10A8TohVrdVFtWPTinsrcbwCGMKUPiRH3_EtJh-uPWIG5oSbXfgMMZWs_MDymsgcPzm-yYWgbns4O3C8AumrK-Rr2U8iq8GeOdGeq_cjsnV7nFHk_7ZBPqnxOfuPRzuH1z2K5G4pgZQGkePlU5-6s8XfZ9Zw5Cq55s7KuNGS4FkLSKR42ID7psavD2bkayss1YVkSghht95APfDLY-MTlyuh43z_NAthy38lFppJOEDOzTeMJSHIDlejleJHWmt_IiHnJpqGuJJaFROICffjDD_4MDK3EjgpJCaMG9Jy-B6hhsHjh7Ysx-sKfYm_--kegludFageg1qARmhxLQ4T_W2FOJ6vuPC9x1kYqeNfv87p69JqLmBW2gWwiB2XJnyOGTILBKEsG4BbEoFhPmLN22k2n4462_oKUrGs5SlMZMM3-ZLO7zbjJRKQ4dNEh5Uh1ehqgWtiYrrlOJ1kgtpVRGSu1rhQ0Rqmck5Am05txm-1slTP2QFqT4p0oeJ-_snxG720f-qp5NMo1XlkEFHP2T2n5IgS1owRp9JAANcun_sjIKm5BL_sgi9BuNYifrPqcc9La0iUBnDpg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2069', `Language` = 'bg', `PostDate` = '2023-08-08 09:18:51', `LastUpdate` = '2023-08-08 09:18:51', `Type` = '1', `ParentID` = 0, `Data` = 'XMh9JZPGXnxY68N6GfNzF5GAefTK53xBAYjyq5H0A678vPpRd5-AIa2kd1TSzXFNeNDm2KIMO2Upiw0eHGA9tiIOSyIAPvUqL9KApFgqXvcExDgaYmNy-7uubhzMoDY1n4MkkjgwMVnbFyr_SvszzLTjlie_Qc_o--W6HawlwJlcGMKkDY8WpP2novqNNFTPWXDp45ycjIBCjhfU27aJyCZxs8GTnsEalicstQRIa-r17Pmdgwfbg9TbsD-dsJ2a-w4f9s29bVLKxDDprltse8UzcYdLZXmBuySPEoMFkJPzyMEpuADO2VlWWfoPUSYUpPQ1uoleaBZRd_u8Fj6qnQ2NDutF4KV9yEqthX4IRG4HBMGDC730CVrhmOjP3dMXGkdowUVVbpoAp4nUXiGaLtyZBvdPgZ5tRvKL7x41erOYhD309q1-uzBY0KKOwNfsVLbwLFlMNl_JvlGsWY0JoI73QakeX0MTnALzvK9fZ05cSip7n1uq4KAijDUSukIEb4PTylvWCKiJhLdNXa8DcSo7cZVB5rcIAL3HqcDFbh2IQ5mOoJGKWs_7vjebcvlCq0DJ5e0gdZRJRG2cLPcEi5skHCfl4u9WyYElga71xhVGPmH2bmHMq7OkkUu1g-wfl_0XbdEX9SUsGQYpEaSCL2v6_l666L901aEry3L7qfKfdDHd-Mdz585D6k7FRSGEbcWrS5fkX11mmv1tCCLK614GL2cMq96QZBwoYPkJfPFkLBAp3E5Zw4d8PEjAhlB-h0bm4fOb7NeX_Q4urI_uJx-KPNa_82rZCKDpOyYF6lFhOU0s_bnfNqiW0_1iEUkTZC-HTCTwd4HFvAGEoaskiEuxK70Iy8UQfwcuQBG8Vu-e3AVS_i5HWAJuq4yLw8106mCL1DLQF79zKMrKzkfZVmNimXTq1lo0yi0FBZzt2DWRrinAVeduLTXercQA-rba', `SearchKey` = 'wofCpMOIwrDgsKlwqCqMKDwrHCwofCpMOiwrDgMK6wrPCwofCpMKnwrDg8OgwqCwrHCr8Oow57CscKzwrrDnMK2wwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDrMKDwrHCtMKrw5jCucKdwqTChMKuwwrHCi8OGw6LCrswrHCr8Oow57CscKzwrrDnMK2w' WHERE `ID` = '2069'
# [08-Aug-2023 09:18:51] /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
# [08-Aug-2023 09:18:58] /finance/root/bg/invoices/2069.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2069
            LIMIT 1

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