# [28-Aug-2023 17:08:58] /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
# [28-Aug-2023 17:12:25] /finance/root/bg/ajax/invoices/form.html?_=1693231946819 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
# [28-Aug-2023 17:14:00] /finance/root/bg/ajax/invoices/insert.html?_=1693232041750 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 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2073', `Language` = 'bg', `PostDate` = '2023-08-28 17:14:00', `LastUpdate` = '2023-08-28 17:14:00', `Type` = '1', `ParentID` = 0, `Data` = 'YNBGxx1sdmmm2FWFATYF8kNH3G_ySSgpctXbjSKxyZlFhIEkHdhEU8kSHIMNNzCUSfBaWqU7uNtOvTv4H4XQm3yvbJ7OUDZO4-IETahV8Y-dqD-VwuKBh2zginY6GkvbqCZZCwymOixgCajk-QdvPj0eZWimJrbPw1phX6G21Tt1bMfVnLzGsI315k8sQXArWaRls2KF4tWiUd8K3C103ZIUI7SUwxf2qBlfWasA7wyRLbH0bMeereLTURx7raQ-REmiF88n8Og893WJSWXFmCNGp9wAr1d_7KuZKII-CzlwG2sVF8P5IzunFB_6Z_7HzJMX7rrPmVKNJ6C2CnsNgq3eD3ypQYszCt4TE9ZMpbqJNQjhxaTgaM1vtxGRRVVGv9QcfxBFgSlm8XEFQ0QpmjLUmsZ_GO9mq4-Ug9Zz_Bhyza4sbXljoQcUpt1LGG7vt2Vx8MpYtUlIhfkcULQnKpQLIQ7ETF0J75SIA7O5n8e-6omkaEhmkNAy7nM_T3doj9I47TaBYI1KrzpfNTaMpQVrbjK6VnI2iTsnW1oYzTJ6zsP0pNsI5mRxDPIsCHUf5uB90pZMCZAX--y_xYmK-bqHzSqWxepehVVDMkkNjRTYW4t-A70QIEZtvxzQb7DX3HMnvpahvqnzczhglLy8nyiRP2UHfH1EPkIwoql-nn2QP3KxghrGcsuJFMb3B7cz-yD4-9S4A2kTDajMF8bmu7PJs84a0rNzupbJUhC0OOX0ctLZU9RHTSywtjOPKmqSwQlYF9QVKBr2hJnHjhbBjX7-JQmVhSgHFtCBEFYLy0jQJ_QAH51wqIyZsQbP3Fc9Fy4XIJWmKxyZlJVGeam30wUJWU9QZv_17wlvLjjE_6DL3Fq5ytqmL3BClIU8Gsex3MAKZ6g-f_H2zSpDqi5GE14r52yENfpi7mo25ju-NiYpAuXGFfegnbQNmJaPueCTDuY6GBmZW5pPJ2Z_B8knCN8WKZLnshPhtEj5IXVUlSwyFUQKZ5vc3kugN-4rkGjWCvEHSqS2YFx6zCqRtoPeo-drapP6Jy3g1CGF3obD7WIOxX719krsLiO5_tq-3bQRXFMVEhhk8D2rEzk7NA7N4unQy2o5H7rD2SWr03cxd0aEtZdiynhBc965PJTUxY17vbxnT_sIRB1waiYv2tviH14-FfW9Tr7LCWuG1uLgCirk3ML71OtD95CZbO8pY0TNE6l_dgbVUzFcVonhFPmW7X-EYlEV5ogHOYc-J9Zdinr7ibNHC8RQ4MAsHh9o42lLLa4Nt5jN_IgBf1w6Uxn4GCnj9aJWkwI5QINz4vLDNPI', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wr'
# [28-Aug-2023 17:14:00] /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
# [28-Aug-2023 17:14:02] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Aug-2023 17:14:41] /finance/root/bg/ajax/invoices/form/2073.html?_=1693232082722 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2073
            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
# [28-Aug-2023 17:15:04] /finance/root/bg/ajax/invoices/update/2073.html?_=1693232106077 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 = '2073' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2073bg', 'BDi4G0u-NYlqAN2S37jSx2ph4Ea2WvQ-qYU-GaBA24DUQ43tWIYsXzE4ywd3h_kjrIGYyRRTxamzRnLuvOQ5f69infpZtfv_MiM-ejRjkgwHyYtSsCvSrZ2nlyj-KaESXnEceRCz_unU8tf7VffaWmpgRzAcKE-5WFALudZ9NPvQ58E5UT5JU5kSCRrCj1wMfvcgg5pf0hIEnjL9dmOidTGdPrTRvVe2T_bfb_6VfaY8RvAi18XOtAtO6Mc3MAzK1u1p5J_lC9aBqdZZBiTSffdDgKQ2BjT5Nj-JtvZX7aPy69Ciu2T7Y7UQkVYhmNXRGbvD5KTEjjIPoVWlMw0MH64hRWiKf-vu05J26ziTdU2kRz9Bi98J-jWUx7aI78bumgMlkqjwJm0Swpya4eHrHTG_F0YdczmVmZrq_CTzbJ5yZFUwjSjIj-L7wQ1JTvBl-qmtcQ0Rj0NZMXeiziuINQvD90TmmR9sdS9cSP-fggoos4lHAk90bUJvmjGTSaplUesiWMZXxdBvx4a38KS1h9-cYjhEfaeCWMAb4L2HaSpIKWN8J9WARiJzt5sj0FfeTSmmCszNswlD2FWP3JZy3XDjNe6kQc-0gmB1y-tPrWXOspFzibw53DGThgAZkco8Xg2OXdXle3UUXDqcRTsTXV_va5-thLdk753KWVynK3VSzVm8oSdwLaQFNhXpsniaMkMhaRSrvqgYqaT2-n45Eaw_gsoQ9tXsYjBDgMTc77cC7O6CGZQKE0FvwAgyfImwSygkLGc8s7db9MFjlaRmUkHmcD0D_WeGLclW_c45ImI0URJTq3VOPW_t0qtoPcq1-B6UfqSV9yHXoYiv-r-cMyA7v8lGd4_PGvfzW_eoIO-5UVpbNGfq2hp5czP9ZgUkRP2BIGqpA6Q6RoFMNHcGXM0DiOdwx5d5Jm3a-P_wWEIVpDkaZrCixC-72AZwEF2lAxe8ZKn01jcbo0qWDmSdE4D-UfVD-8GQzAis-kproo7uQB36rga6yxqi8sFHgQmNzupqKyvmK6XW_I_JglbAoz5UHMT530MLmcfC9q1Mtu9_RxJNzUdDKms8trsKICL8lih3Fe4cX_zd3tGY6dWUYr1N0FEQu0EfXR7JYcILxLYcwSRRrHvcjUHi6AD0_VHSUAYoxq9GCHyuVetJ1MLcLgEDBO4SYuBsgL0Mzm7cdTHCVONGXniSoijCBbvr-0sqRHj26__fM_02muM5kSX1qb0cJlPt9XFVuPTEh4Q7JujJLoI2g-nn7phV8tFgx5J_fvrELmxhp11zSdDqhLlHFNqx15JigDq03qvn3_OEO42iV1qTkGG_U6oY16wo3KQaorbxpoH3Eg2b2ko5zx1KID9O--dSYji4EYIltXEy9Cz2ObLBju9FjmYMfoqJtOLTO3weu_2tbgVkb6D1iIqcf3W5S3TcRBGusrTG2Y6BoXxNU5gVMfsmo8eALLo3zJ-OD0Sa0GFCvFsQJ7_5eZ4qti-3SnFMo_iTzVApNhBoqmUVHXy3O2x6B8MyNUdoaERGECwsrnSh0i6Y4W9LOgTCZE62FG_uhFSt_jqfoZVl0155glCI7Kc2FDqLlucR897N0Rri_3ZF_Nu65_kVaHZHDTbHUhysBwDvt_veg-exnq8Z5agavGf655NfdGVZfK2FuBYs08UJ5KRUKVsWHikoVGuIEINK-ugZ16Y6RLlez9FBXtA5sF0f23I_1k9O9jfEoCAYxC7xpOZmFPKUnVW8Md_FuLSJyWjylsX6rnQLQA4BHpZyjx8X6mqz95v6JGq5r0fLUvew0PkFLWdbOWHllpavcBDxJhSmbzWzAyc6PRc-2DjdphYTSv4OEYtnj-Sp-ZmTwMm2w6vcjDsWjlfSNLA0rayxvgi_pilzlOWm-QbuHc7uIHxM5LAnZAjyqjexMcR9t25fr_FU7ImPni3hVR-crY_dLULFd0cv9vGBB8zAK-QJ9zm3sEAPQCzx1XFVr33DbzfgrNipF0RB9xz7H_fJ_N6y4p9Qfk0TML2n49gTrI8JKLVMlRhShF94gKltRp2pv24jsaOMMurwCzyU0v9sOVPDjV5rImKJHi9apCraKHVt-JJO-SubO1lMdnoowalkq8IPdf3R0yJKGlNMKmooCG5ZiSyLk590C4w4W8cc7sYyLTn7Dnhw962rO9bljWUksVQN7-Z89cyaSBj2u3tZRqYN_35IHtaWZFu5Xed_gWL0iniHfm3h8TBmkYyFq76rcdUJGCvXSjLlEzSNdCLUw50fXV2AdTMWvdJSD9gAxQeWb9xSXBTI-wXLGjKOCpUjS9eOCOwhRVRFNsuNsc_ahR27aDqM5VQH5lETxXifzRBl97wNovBT6QE25Psh')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2073', `Language` = 'bg', `PostDate` = '2023-08-28 17:15:04', `LastUpdate` = '2023-08-28 17:15:04', `Type` = '1', `ParentID` = 0, `Data` = 'Hmy2D1EPblAtMcqx4_UF-xcxUtd_Fmcdtef4coUrio7UgkD6Ix_svAISQNCoVWn-aEPYO3pVPozNaqdLmyYwLcrN1LKeWhvNlpxcR96TNexr-2FUGQwJLFI4tXAdIj5V1Rm_VUXH2uxWWMqssgMYQtesNdH_qjReszlUWvcGz0H7W9UGfmqGuEe9so_n6t_tUaLCBIjcaQAqkIzZmx-F_SIa9UxHXUjR0rQLPity0I53v8kPguYcTmRSkOFi0XY_F1Bcb5CWlvu9mk38gk9gCEwSnUKYbXhUzfdNyug6tjEP-nVDMQrXtKyz4tbs5nzfgAOAlCxRegWjjF23cxkOXX09KuBlVP-RNx9Xjz9dPPSscmFuxgF2XgYhtbuHI-M0loldxq8EuSBtAd7gLlco9kWXRF4_Eb6wknZcwCMjUZc74HCw-ssco8qrJvukr0lFClhLjBcGCyPUnSGYsgCdghGg9jRnZNTWTttn3GdtdcMtoWNbD47Qn07oMbvyp1mbm0xB6krmxiz5XVtGwk7XjPLtOqv3hsCeaSYtQO_Q3iO5ruSnuQUgBDy5UwWIudDqKZMVH0GAgRSvqqH9-wpsHtIB89agAl5Yec0P94l401IgUEmM7Ce1DeXbeDbZDkFuo_0oRtzM4-Wr4efkM06IyrCd1BswNdVilXCpldURXxojE6vx92_i5XpxJFAK9vxwHvSEy93sMepb_mw11NOK5ma6PYtSODe6BS22LcGXAzJfCUjNlTe7ce8OgCZo37Sgs4B1oFdAt7a9zkaJMQMYmhUSvV8boNHaD9693Jsbr8QyVg1HNQbnOpUMsEmr0RISz8VYaFvLBYjZIpTo-GIEIS1Sw51spv-76AxNb2HIpBu8gMgaHVqghvxNE6pATnI8vNd19dVtxPuy-xy0XCr0aYGiEBoiqvxvs85zvlmVIRbeNBRjUYS2w7XU1b06883MButG2BHfjlcGq_vzUZfExmE_jK8dlNvyx52nTuFK3xvLR2RmUpkWO-76bGZgP7uGHwmjhNNYk3iMtSE3U1wFxuCDe9Y7utWjPd7o0oYJmZExD8FgAWjUX8rmRhENbxH9EWBH21C2cK90xs6-IxTHJZjXqFf_ev8tRFlWLaHJCwfqDVa8nLKldWihg_ot8Z5cJ9Ea90Q8WbCtHxwnjfRL25wvtnWOL4HP5-vIDJlZd29q7OP99bZeMQ6bTONSpvIuOnxfICRw1kTZAzRSxFuo59fM9ujCCBghNxYEuCkRr79d4fvzFA67ea4Oy32U68mtFe_tz19uw9R4lQGiyZqCNQ162N_myjPuscvRHTtAMAU', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wr' WHERE `ID` = '2073'
# [28-Aug-2023 17:15:04] /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
# [28-Aug-2023 17:15:10] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Aug-2023 17:15:34] /finance/root/bg/ajax/invoices/form/2073.html?_=1693232135434 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2073
            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
# [28-Aug-2023 17:15:40] /finance/root/bg/ajax/invoices/update/2073.html?_=1693232142108 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 = '2073' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2073bg', 'z3A5ruIZZzcraCC4g1RXCZ5eW0iG3B3V0-ForUuu3vcNZlDjMb1EiOsM7sK408HY5BqB5sKP4-l1LeUutcPvMpNK9eQeZNJ2CeST2uhnKrCGXnyszjnfI7N_GkPqKMFGaP3c8DS1E6fqNGCWKv6vxHWIqVzJo-lduZoMM8oMA9BuZdxZQ-akP_FcO4f7v-20J51RetHxklsGOU19MdGzVy9JCnuYlLFtax3sqDcx2DNCrrorBYDRy970zuWRLoxlMpO3jjZH-B8N10-4oDUSoSfVxQVDq0h78yCCdtUALOx9IsLThngo3q64aoe4NpNNFlpfvHIjRFQer3HLEBtQY23fBYJqIO397cgdGMw2nNz7r1mL6BghFYBKMLc4RgbmCf-oq0Q1ba16ZjfWVgXIYmoLM7AprLAwFERpQ-qLPKIOnijEC_My6vvapdU3-qL2tEbM6ZyF3H7ZLw_GjhW-pdbUCKljSCS5MJU0sIElnzT7rQnd1ogD6wCXesIhow6MIHVPvYm56i6PLzlSBu9-i5VeBuauV7pNVas3MKmr9_bS3F0Gb2fA2URuw76j4gUCmruPLT7FehPfoqrNKqU8_ujun5Vq6CkDvydezcTwY0MaRu7AO2obfhft0gY85r-zD4xBAuIk42v04aQq-mzTVIRVqwBOzfOACpqaaSdGmtw31yj5SiTM8uJsnPU08dEb46oOyLP4kHwjIdAGD_ewLwE0I0Sr5dFBagIo443dXFTZnur9BVaBnUsDEBR_qiH5IRL71K91IIMYcUrO2f4X-ZoM12fcdiBvbdKI5GEKNZvsB2dmsaQskNre10hvjUL16PAXHNPy8APyfUj22is4yDnddId4ymxPcbgFeRs5Q-YFvujSHWZSuIDWwsTQPN9zHEur7m1fdsdz9uKLhX6Wx9GDSrPiL5bg0pb3t2Muuhhr3Y7pDgmcxKTvwEEDkxzQy5DG1f8P6yllN-wo86_-qb-0E6LwrjFm1sxevfnWLFx4eVN7M2G8jqX8nAMiZO0XO11S4-uBF0hbz-EnrnSmbyXYeZzccIk3j9QOLz7l1oZ80LhYfNupEXYWQTlpDaE2RJBzkNrf8G9qfgtQe_B3F3a58ZGx1BAvd8WDON2RLbid_rx-eTgQ4SSdqv4CExrcweZrdEuP5woEfn8IN6mxWiPa8Vz2OlkZtY0jD4kc8vrtfmEd3K2BaUu8KRml5FtAKwt2gEa7UNwEMWAOxLsXPXhv2VvXa497-rgCMDJCrnvnXeGmDLv2z1hU2UZMthYTBAt6Y1bmvy39bWhCErpdpx-R9LkGNflaRRlGvMd1Em0kfWrvcWVSWOFknG6SFgbucUHgiwsNP2VYXIWLmMPj3QXDMlyFvBWJCdmnc4jsMfn0MjkEACko_04XLpXr92ABOHT9ac_tzMdKnTjWMDHjBsno8jpVBFEEkqrgzwDebGwP7q97-xb2sOVfInaYfopWzLHXyEJO-D8TrsLvaiK6gt2BW0ZA5ld8BjSisdZJGzXPOXzIoY_xwFLqpCvIz5BFGbpT2j5c6d0-8YfUkp7m8-yXfhkhWs3Ot5V-KsbENpP0ebmc2f7QdF_AwiLJR6zTz6TtDwitKnspgDjpR1aAFg_tTC7VAFwC4jvROX1ecInpTTnzjdi3qtoTyRTjoSc6PGiNJjJQ11D5oSStFV69FJTkZMTj-Z87laAvz6En9tX2HYiy9m5FXkFSh0mWStP0DX4IyWIuFGxmvOsTqKaJujkslUUgEQ8k7zQ6_zfmApGNi79RZX-STS2EwI2uK7RGZY1nXlIrm4zd-RRHEt4ZaoE9fYrPzIDcNI7daKkKtW8d1go9nlISd_Y70kDra6HdaY2y8WoIzKwGFniL9vkMTC-EIWHHTATcbp0_2WsTuSvo2AH9zcCX2rEzRfHviMlk0yic8UZKAEY2fFKp1qrBc9SyTZYR0VVstC4xGw8Oi7zrz7E5flvh_ryhwCPrFh-itW10Mk6536j0IXq4jO-RErzwXQUYq3824GEAqGOEzAb3k_5rV43SBBDmcRr5ygZQvmfuLgs2kknSFnAp898-CyRkk_SR0sveJl-UEQ_Bhc6VoHgz11FH_YmeUN6bv2OWbnVYQbubG9JRBQQ3Pyv5Q4YzI0I8xM6CH4MaA5JWd_IVThNKFe8Ew5QgIOpGr3z4jSkqfMBDt-PdIH1ntsfCwraYoZa9kOeshxZ_IjZNYwf3JtAgkUzsfFPo5fob-u5PU0RNUl0yzfxjznDVUaDR7CSEzxe-seLrasQwyj-bK3BMsMCKTyWOXddgwjDcNW5-0AA3VbcNESplBhHpK8TVNfm3NRYknlbO8j_hEwbuqSriT-9ejVVFmDk0xJJmCP1m')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2073', `Language` = 'bg', `PostDate` = '2023-08-28 17:15:40', `LastUpdate` = '2023-08-28 17:15:40', `Type` = '1', `ParentID` = 0, `Data` = 'QsnKu6cWe3aqKvO0J_arwRLAbHFivsqO9TVYZi7GJQp4pFcDv5MyhUZMLGxjvQUkOZYWwVMS1I2FpCe_f2wlbcz9JlN_UZOHnTC4prNoUsgtE6Tlmsb_KwJWZNDxfWVi216G4xBf8APjhLXTmKFldQFpfi8vuWk13GFb-j18Du8otHtstWJybkbBQWOCS1jaFkA2iqUUkHS4LjHaOQoJzPZksqemxQ5RbrWO_cVQHh4rRmj8Sj86w3rCatCA7Cu_o4KMHDVBlypgKLhRJwCzVJuMxJNtjzYFw7rFBNwR_j3FKMkpz32FNYqv6Zm44nUhZaZCyxCT_ZI9VV2nk5xYRw2Gu21klHouq__qPqmvtLfLEBDgvkMETanbcLH6fZXcp1BREb1ZQ3QgDbNKU6aTBg0eYJOYPS5Hv4VvsCpIXBXz7jIBMHZpKdIPzVeqb4d_8kPX0Hydtar5H4tiu0gEnFnqz0kKJMynCV4Efd52fcbA6XlG54G881q1jwq3uswLxl8E2X7RihssA2N7pcx99QQlMHc8RmpIzTGEpzk0ddNwoszRTI_UedgTj2NGxZSsxfFIqUBvx8nFY9XusEw3gb6XzUao7vKADt6S2ngpbtCicUiaW2uHzhtqAboVXMO95f9RQt4cRwSnzXflWfiPjt53pNp-dH4GAmpZWgWW0HpHNU7RGMGyQ2AiIigFc2n3HENiRIBRYQDK4PC7q06JEGO75e0d2dunEfpW1U02WE8iWdNin0ikLjd4NrE0XSgg7EoxPx4vl4MJoxjP7-cz4bFCc6gvGbMCR9Trgx3EwB415vkOil9QfPEGcDs7xHG5L7W6QOaqSDchQjfTp4ce0GtiL_NmoOMJMgVig_xXL2gdyAYVEES4gSMjbTyChGdWlWbg3_ukiiD6o-GVT2bN30YbgkY4MzdwRzi3gtyheo1nLxpo367S_pZ3OCwWYx2qt5BpHH32D3L5yjv7HdnHaQ9V-5VmZBB5n3pYynAaG6OfHlw1WUIGQ42oQjYdkwz3ipinePXADAFMMNoYb5laybdqUibHUbdldx0noA0qwTc5Q_jgCmxu31ZtltlFPFbglcsF6oA4I3iQrr4i6OkJIUwfA9pmOqSltdV86g76M8hAVUsqUizEZwHLsrlstoTomQ0uVzSrnTvMr69PXDeWNUJBOuD6NXtrIw7STWQBbtM', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wr' WHERE `ID` = '2073'
# [28-Aug-2023 17:15:40] /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
# [28-Aug-2023 17:15:44] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Aug-2023 17:16:23] /finance/root/bg/ajax/invoices/form.html?_=1693232184818 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
# [28-Aug-2023 17:18:24] /finance/root/bg/ajax/invoices/insert.html?_=1693232305861 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 AND `ID` < 1000000000

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = '2074', `Language` = 'bg', `PostDate` = '2023-08-28 17:18:24', `LastUpdate` = '2023-08-28 17:18:24', `Type` = '1', `ParentID` = 0, `Data` = '8vYh1oTXd_KaHdv9ECEbTwbL3hU_zCf5jGdZzuaSGCJp9kBT4MTOfMhG5gYvcW5FXEb96ScNy4rcepKX1naA1mCiPbitGV7D7WxI2Vp_DXe31I4cOWmwjqbI5klLLGb78Q6G2TMo8hfbJk5tE4lr2XGOL9NS0ZO4Txp9HkhHLuM8SWsP9foQVpgjmJPFj5pR6CV1nMcGTeNtjFfdyZvQpXzTDZ6v8DUjnEH-ATLHJZor9phwJKKRIHTy1RxNGzRDMcVtlrEGv8D_VfoDuwGOOQdO8Y9C-3noucbJSZ8UMisALnc-gwspLBKiL9ALv6fK7-QnBtE6jKiFrfoTREgq1eFlC4O6KJ2hd60s4URPBd7EnyKrG-AymD77UOkIjFr0CM2ii--DF4lQ3r2032_m5RCQUqArf9ftatFrwVimoib3ErtrBbq_-WZ4Z10NF3c77ILtNefFrxsHj800r6AVsGOlIvliXRzWPdPiwYGtC8i5r4mPD0jXWKjOmDuGGQ2tf63hJfJlR7cYjHr95Lx55llMJ-FrdxwhRbZLUSUTa4DJwm7-BWhTlZ2yPCRHVyukIx60-Mekqe8KGK44HBlEba2jstu6-hoxCJcwWuJC2ybVzMuUghvm2hmO8am1-6EOibZkb3nML3B1dyYoE5KV8Cd0Yve_J41yooXtUBc2TysH5gTlcJZ7cfysEPf7xB1frT6UQ0xgvnYOb2Lu_mgfw_8nEPmWgJS9N39Mw1XD43aliZrBi3AmJDR8g7xa-Xaqrd1BqgBB-hxbivmTCkoyZ7Qz3_MjqWYbSApIz-UJfK23NPt48mCahytl5moOzfx-7zC8Ew9sdayyqknorHFdUtGPO2s3wrgUOEHiEy23qXYSzsmxZ7Z0THqHs_NvKh3kiaDhoVyVPG1iVmGjofc43vJL4Ne8SJlsFpkp8R8GfTbVNIs23GNf-27qZgfwby1UhnZkj6gzZKpxBSG9sqyWUdzKvomFuEc4G8nSTTOux3U5Kd_NDNT1dMnJxHWMvVJUnjYGkjeUJJD3F52Xi27Gcq5PUUvXT6IPtzxB_8EB1FKdrrTKiUKi-o4hMVU7Mu4axbk-U-__F_dw_rKLUGfp2g', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMOawrDgcKlwqDrsKDwqTCo8Ksw4zDn8Kdw6jChMKuwrHCvMOXw5TCiMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCuc'
# [28-Aug-2023 17:18:24] /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
# [28-Aug-2023 17:18:34] /finance/root/bg/invoices/2073.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Aug-2023 17:19:05] /finance/root/bg/invoices/2074.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [28-Aug-2023 17:29:42] /finance/root/bg/ajax/invoices/form.html?_=1693232983825 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
# [28-Aug-2023 17:29:47] /finance/root/bg/invoices.html?from=01.08.2023&to=&keyword=&sum=1 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`PostDate` >= '2023-08-01 00:00:00'  ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
