# [17-Mar-2023 08:19:11] /finance/root/bg/invoices.html 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 ORDER BY `ID` ASC
# [17-Mar-2023 08:19:30] /finance/root/bg/invoices.html?from=01.03.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-03-01 00:00:00'  ORDER BY `ID` ASC
# [17-Mar-2023 08:19:43] /finance/root/bg/ajax/invoices/form/clone/1953.html?pid=1953&_=1679033991950 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1953
            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
# [17-Mar-2023 08:21:04] /finance/root/bg/ajax/invoices/insert.html?_=1679034072538 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '1967', `Language` = 'bg', `PostDate` = '2023-03-17 08:21:04', `LastUpdate` = '2023-03-17 08:21:04', `Type` = '1', `Data` = 'AtBKWkqdpLmb9lBKNqaCrLBtU2lUpaz48CKCkDjAAGEnkDtUSzTH-juk4r3TAsY8dfR8qkMweK8CSLD_HO9gKGfeVLMjUcGyhkvzmoNboVuKStUHQBSM-oZvlCwU-FreX5MYJ-qCmHLBU62oSjey1P6JOyb-BpzA1XuhKYi_-VQe7cUxG8EbiHyaDwJOmfdW3uGAmtl3A5RkbEVhtomrSTFr1SE88VA8T8bUfT_xRn6RymkYd_N6g3skycxZOW6JM0eAUqLmQco2TiH7IWnC52XpvI_XWg5cMF-1gx1MzpbgIkgYBhayyR4XWHvTiW345Tk8DxScb-_5JcZlSg4B6z3KUGWF_6GSCWjYEAQi5MRYRD4DUMkcRK-h6049rncctyJVt0jCL5MfM6-gJwRfiZF8cFaxfamDOm4gVgs1kv6BDiU0Yhn_gs6LWFM9ysKuo7H8K7MOEIa8YVBe8qEYfUmZ_B0Ze_xVdrNT6xuwdP0pkJaWxZj7wqN-UlvEcNK7cONf776nOSoGFTJ0Jq9ugvllSinXfGzWRAQ7Gtlaq8HYznZmnVa8f6KyaijOvdUIi3WMAfQy3FBnaLFdxo6TCjpDApmWmyWQz5-rxa2odG-rUIEu-gQifJu6jBsv63o0W-X1EG2cDs4nAwJXLr8URI8ZIbVFYhgk6MLDo16D149caRDVywvlI_oYFCeG2pixF1oXOEztcC22lgCeTeOJtMUM4LSB-U9QTnwm1RLPw8R5n-zy8fesf7taovq7p-i5xbuV86g0wHDihjU6L8B4ObcOKK9VTSV45FVBHB0sXs5uLafwE3L2lGata_3ZbZRsa_cFqu7p7pYjSD-jxn4-watd-RsJEU0aKTXH4DDLQe6DfCHlc1vjlOIJ0WDFNdw7Gae6tmHRM7nhTmUIXzAquRDXR4ZIteTAas7VmHkBQMi75kWaXPxVGcRV4GdKuMV9t6w29ngNpbaa7dg9pxRHgoB4g6Ek3QIEXpnhbpvxNKtiQCq5_kDw0l2GfL1q4xVLegN_AGCIUiMaJtsXTX8qH7MsQjkfGpO6onptDf3RpHo', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jC'
# [17-Mar-2023 08:21:04] /finance/root/bg/invoices.html?from=01.03.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-03-01 00:00:00'  ORDER BY `ID` ASC
# [17-Mar-2023 08:21:17] /finance/root/bg/invoices/1967.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [17-Mar-2023 08:21:49] /finance/root/bg/ajax/invoices/form/1967.html?_=1679034117557 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1967
            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
# [17-Mar-2023 08:22:15] /finance/root/bg/ajax/invoices/update/1967.html?_=1679034143640 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '1967bg', 'pOK2ddZy2JY_vNfMnOz-cjl3fCLPmNDcjk-HDXywYCzJAThYDhLwqRUWNDDyMUbFijVB7FLX0aoOszdj5zFicJyFfLSjH2VoMzgJqxWxdK8kYHhBJcGouLDpMO3JnXZbEdr-mvRZR95NE9yLuxOFMzIIJJjF9fB4rXzDGwY7kQoiTu_uzVxRmIyq_9GcG1j62QfME7h8n4oXBaNBi2tgSu3gR9f-AH6WlYUZNny_BGjR8HUa9EIHDCLt3RThd3nl7uJrj3wvJzppy5whIf_2NCAmfjOrIzD9cNOmjCjdIUXMBKvfDoPyPT6L8N0v7TOFMYHfK6srtJXK69Z7IP6p7uk0_i92GkOhvCDVgPAj6DK5UI-gfG8t7DQoQ3o8HBzPl-y0ptOO2v1LN3fLQhOFKmoTcetDx79LoRO8QMQoCGKf_B0OAGDTFCn5J1B-DLYrClX7hZNd3gJOTjjCIS64ezkC4t-RP9pbpQRYmahW2JhWOh9sxln175Pmq-edpJWnbF__8DP19sum3kWYVK36wEcTlGuejWSRshMhr6282GdAnGVomesyu2wlIb9cla7CCTI6CXUx49vt5Cgvuwelmo1WPfhOxIUKjZ3c27EUHxE-A5BQHzKEcZ9x3xkzbFcmrcEsUWaw4XLwYu2okvfS6eGpM3l4FRryhd5Wmi93XskYjyC6dfTZ5olKrwsegCw0k-rWprQOiDtX0RDNZo57-HvuxFpyphQqTzuhXJhFHbzOVETamio2Vry8B460TVgq_65Qty0bxSbrIx8T9nerSjcEnxfVP_LZBpk3QXi6BsVGc3Z3frJd6VfePTzigOjgyHpYvCkN5R2-xRcd96U-CphAApULV2NRzBCaG-wUcTd3Ihw4PwHPZytWVx49hA71D7bAA-fwst26mFu7u9xtFRwvV6bMtK01onNGR6ooVRBqRT38k2DQlbvB0cNSCuzzZuS4rkZvnz1_gV9xPN2NHWpWNtXYfbg5AtrjEi_I8sEeTTVLdJXC3nsiEs6iogr7INUcVKPVNPuBHh0Jmv-l9vZFqZSiJ2eulrqJBABtcB3k_0-szz_AxFuMms5mO2PSMC-BKxQouMSzMgnT7STHV9NxOlge0aMEGFLXMR6_cJGXfhJ-XaJJfteFQvz8ENtb8ioEUhWVh-nfVqHCd8k9r2cawmfZC1zjtg6Fs_ef9TzUyncARt9wgH6wO7Z94HszHENDPurepQLDjdqnHRbKN7EQk-uWFG9vuhgIAx4IOD3KG329K-5jUtgcwT-eEcZbu9pA7EHhUuo8sHqZAeX8k4QWrhA1gRk5Gb0kSE6KzTEuzuXPvZJPJuRTQJdNxG9zwAq5dLgfmmH836U3TwGovMDSpwjFtU3m8-PSSMr_q5OZ0wPf5moQgvuAoASuDlZqB31q3sBJkfQCeONGLIjioxAJZ05CAXkVW85TlnYQB4EQHc0DUOETOfQEJgg9oF2g-KTblAslsZ48Y5RFVO28HOIK9RQM-DyouJFpEGP7kV8lqGQTCCDvFJodI2AkaMCuWLoVyIGSz7mRGkE0VslOKsUo6jV5-9Aa7YxCxZ-_oCN5RU5ycOPvZRjPxn91i5Emz0D8rZPIkZssBT1ajJm6VFj7SLsJI1v_BlXRo4NczJLkzSsaLHl1qsBcmNKweB2GwvBN1M1CzWN1ZuZF6JDVPhVs7Wt2lO7YQuDJYzdvxvHVGZ-ItlZdFj4oQVFlJfWihOegARZHiWxgVQ4ntVOOhhPNhLaEkA3_bt-61dAnwLLVOO9DC0ke68hkAqZV2lG_9XcRrsVUro3bsZUb7jQ8uDEgfKibH1V6e5_BJqPCQEi6LM6kdrvZNm3Juc-uq1f4aww1H4pV876hJeokU7PiPnlfPh8uL3p_ubMuOkkZmfC1jt9udLleRKKQVToy0WsTiq9uAyCmAJsJrM6ipfsXmCjGBXXSHyaU1eOj5PQQdnzbYX8HBnzm1ulQ6H7mrvzFNHx-vnHPFVjTsEPfDvkj7TnpN5urQ-JUXjxYbqrUKKk')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '1967', `Language` = 'bg', `PostDate` = '2023-03-17 08:22:15', `LastUpdate` = '2023-03-17 08:22:15', `Type` = '1', `Data` = 'b3pO1tgAtYI0LbTUEDEoKtkScdx2Fb2Ecur9T83gyZkFmQaVcwk7d7COX6ktgHuLyP2-SKtAhLobn04OrjuC0xYi3I4HNTzABaXBoPojxUOEYdqY43ZQ4uoCPKusWHYSPjhbW2t6wlDqn-fhPdaMcxmxs1UhUf1NrAcqf8GO4zx7jO2bu0viRTHqZkE_lvUJ5GM3TruJIJz_n0tCosC3aLbhYqly1kLA3wLiy0mfd9TcDr0YlnLr8soJ9LUmwT8ZH-CXYkwbUIBaASAIiLnsg1xr_PSlxQ6MDWwpvz3fX_NAOAkn63DoAjLcEMXTFBGPjUhWiU-__sgYykjDvuhSwHbOg5j0NyC4oGbONSJlQ7aY5oRpVp2sBEA_fo_PqMRWUP3SsbE-V_epE1wUcwJhxWey6kZjpt0trXT-1YKkwMHrUg_pUqWBZBjXAr0oE_tVMr4f04JTDOHOLRwnnTxJEB9Tn0VjwomE3f_i1wVlIFLz4kHygH1auu5KNj7KE4BjaA_iPlOyyTf2iu7MJNF5B1LAfOVZGlumwhtBH9D-d7VC7rYba6pqi27aAcC50nhKg0Pg4kVCp9qv2QnmgRM4fcoFY09YRFdWh-WtzBpVrJd-hS0E13yIDcPmMQrw1GYV9fNmlc0wXIhOLboIVwiYkhnCAMUPr_47t_eDj76yEJlXqOSitC5HKXb7wzpFjct3F5LOT8v3E7cu-lxX9HIfURJTsJtWaB6w3tFOk0yM-L1k1LFeeMTHmN0H8OF_9Jsv0zTnaN7El-F-Am-788GwTIsFBbJ0G8yZ06MnEBYLPkQjFtj-5GXblG395poyyMIK6L5n2EW-ZnpQKNU45Y_wkvqTI4kkvHy-dGw-M3iyRhPeo9icb9RFTWsf4F-mD9jmbcUvA6MuSKV24kQ_QXIyUO13xq0BiBDlw-4MIn4J-9RBNXzGHKuTu3X0clap63pY0Fiz0UIsxF_RmdyUfTZOGREN3a8VRNNU7JV25ZmnDfeHcHwvo5MbHjlLafr8SW8wNBg8_-tKsMhuABjTtpFhpfpwZsrw-jpVCI2MISSxVQY', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jC' WHERE `ID` = '1967'
# [17-Mar-2023 08:22:15] /finance/root/bg/invoices.html?from=01.03.2023&to=&keyword= 167.99.142.201

set names utf8

SELECT * FROM `invoices` WHERE `Type` > 0 AND `PostDate` >= '2023-03-01 00:00:00'  ORDER BY `ID` ASC
# [17-Mar-2023 08:22:22] /finance/root/bg/invoices/1967.html 167.99.142.201

set names utf8

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

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