# [17-Jun-2025 09:43:11] /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
# [17-Jun-2025 09:43:17] /finance/root/bg/invoices.html?from=&to=&keyword=sofiare 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrrCisKpw5vCrsODwrLDrcKtw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [17-Jun-2025 09:43:22] /finance/root/bg/invoices/2461.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` = 2461
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [17-Jun-2025 13:53:57] /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
# [17-Jun-2025 13:54:01] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [17-Jun-2025 13:54:02] /finance/root/bg/ajax/clients/form.html?_=1750157642599 167.99.142.201
# [17-Jun-2025 13:54:56] /finance/root/bg/ajax/clients/insert.html?_=1750157696563 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` = '81', `Language` = 'bg', `LastUpdate` = '2025-06-17 13:54:56', `Data` = 'hlIJ8_ePHh5i1iWEvsWfEmVQqa7wnjxSWeF-XTanc_zYSbexsjvN40DzEZX7vYuJ3a_bPqLoibjxGHZ5-UJzLk5dv2ZqJ3OSZqsFjdUKbiD6BpfR8EGRXlU_5RUnqpRvimEE18mKJm84z_PlScJyVrphrzo2k4TCjwRuAWgiuqpBZQFcR9rN9d3UG3Dz3tuvj4Brw_HGiXsXvvZ1xVQUO7QpUZy_SwoJScMjZLaijiw_EonoucElhVyXpTs_QS3qhYGWWtRti2p8Iqmi94qZx1jTQLeRRkDgsGZW4qR3EkKxfHflE2cWPYWQ6dI1EGfz7W-SkZZ8tn1W-4-6_0Jt_SsEA7Zg3UnSR8zPOfuVUdY', `SearchKey` = 'wrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDn8KdwwqTCrMOJw6XCmsKww4CpMKhwqzDk8', `Top` = 0, `Visible` = 1, `PostDate` = '2025-06-17 13:54:56'
# [17-Jun-2025 13:54:56] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [17-Jun-2025 13:55:01] /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
# [17-Jun-2025 13:55:04] /finance/root/bg/ajax/invoices/form.html?_=1750157704143 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
# [17-Jun-2025 13:55:07] /finance/root/bg/ajax/clients/select/type_0.html?keyword=pet&_=1750157707564 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCn8OGw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCn8OGw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [17-Jun-2025 13:57:50] /finance/root/bg/ajax/invoices/insert.html?_=1750157870843 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 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` = '10447', `Language` = 'bg', `PostDate` = '2025-06-17', `LastUpdate` = '2025-06-17 13:57:50', `Type` = '0', `ParentID` = 0, `Data` = 'w7NDCr6cLKcywj5AbML_G9G88DSU49f5L3gthqO3Iit1fP3AOrsif43neVh6Rnc1IMEFfg7AP6D5HLDB4sVyh7BerZ3rrCvKV5BENrVWpL3DkfMtSnZJ3jgaPRi1sYyBNoARb27NxdBB3Xwjk7PYFgEJbxKiq466Yvj7gzU7uOS7yAHrDoVYuxH1vZ-gv-7_H_ikg3KS5JvhEPyLlP9qfNv_G-fyw6aqNaKnLCo3dnmHn8vwC55ln2iNWxLZ_RYuHqM_sas8pHFOldV_Ylr2Ga6sQMhAMf2RTyTa4FxnYKuCDxHW0afKxf5sNpCmu1E6LEV05O7I6kAXSIAI75xjBQ8t6PC5ZhuJvN9UIx-Phsk02eV96VD6fjMmSuynyX5s25Y3jQdwoh7_f-29BDu_V9mRzk0vEHV-hW74v3gqod3lVfj2jQLJHFM_wc4O60V1HFJ4FcIsTuQ-ZAvF8FkGjn_UiQtw9j2yEUFITdzLpQfOGBeTW2eJmTcN9HLpo-Pq_cIXxubj-Sw_IUd-N9oTNhM5gOk9blksWAHvHbtXNq6NSYJd9AIfIYyNrpyIDBkn-oHe5LBYNXdwivr1Oudtm4y_XsrZkKl8IKZ07TBLVs5TLdq8P4feGdQGjjQkW6oJy-7Sq4CRncnGLZmuveOvD4Vn9hqzG8HJvVoCtLTgzdQlJWZgW9g6zZpG87ZL6WZcCdFMS9vdM1MKE4EsuyqNCldX0BqEQnC1kE19k83Muw3V4c9KDEAlOXo95Yp77dgHOdVmKzajnp5jcqaMqEyvTbGKzPE0weotVFtzXzAQAioBiElXByIlsNj2TBOH6BrQo-73dgEp989y21qG6KgdJMq3dhmpgkdpu9ySTOO0B0ALLrpbC9ZISmwScUDtil2F1XiIxTldwxH7DWO7vK4VlQHm88CNkcobrUgDj8Zmh-WtUJfbZXPP8d9Nr6yB4L_YfSYmW4Vflv634-s6ErO4UlbM3oPU7ZU6DmaUjXIdXOPZj9eAr_2-r7lzCn_tmWSXlum-Vd2xwnm9mdOLdTGZV8vLgNN7eyd3AUthohuhgsuirFzOxNAdjNuc-cCFVJD1_xyFiAoAUriT-OIYGGvjRwTylVScs_DskVXdLeNmMz4f9xK4RYgQ2fzD5pvIkPIkWY6xEhvlnAH8C-5CBujMVDiYl7Dr_YWIrXkHuPAD0ThPW1gTqta5I-sEP8kgaPyLWCGNLxmgu6V_d2ksJCWefqBokxLobA3xuc9izvoODvo9LzeTmpWctLsiYsp-eEVc1Joe9pg4jws4re6gMeSNxA', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHDhcK2w5jCp8ODwrb'
# [17-Jun-2025 13:57: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
# [17-Jun-2025 13:57:53] /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
# [17-Jun-2025 13:57:55] /finance/root/bg/invoices/10447.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` = 10447
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [17-Jun-2025 13:58:10] /finance/root/bg/ajax/invoices/form/10447.html?_=1750157890833 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10447
            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-Jun-2025 13:58:15] /finance/root/bg/ajax/invoices/update/10447.html?_=1750157895675 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '10447bg', 'ZsjFMJXNoO_lLQRzm4Y8Bd71s3WMPAt02E4FMV_Z9FXXUCuq1GyJELsjF2eqok-JyMsqxCJO8kMcKg4p4NygsUfkcWbtlH5pCkk_TQI2txFfJ7w2YwNYx3j_7KdnNE2BA-QhfUIuYfm6gAUhNZzHb94Qbn_HfmqoO0PnZhB4F2cRKGALiazXDF1YlEi8TVAEZcwF4LTSzFRHKSAdMjIzqONFBekF2kJ6K2Y_rzl_5ycCeyfuA_QNvHsxkbifam_nezRy819CWMeIg0YW6ctjbUyZr3fDVBGH_wUCoWlBJFgnx92EN23Oel339DIIhQ9lbRsd8298pJoOA6DZ1RaAbIIB8OlZ9v3_-fr6mCH2roRw5vUI1hK9Lz2ZRbAP2Ek9bp2KSCf3gbsSefVo1Kgb8ZJH7r5BVbzSfEhFu6nfkw8EhSG9i7b2U-76nVyHFS5Tr8rTlJ-55hSLFbqfxArkcVb8KH3vCyapeSiYJLcrRw_TxV5q091Lh3JhlAJsiJ4sgoK4dDGU6C8uLIfbo1o7TpwvaNM9DSvgebc7f_HLZ3PaX0EfSKpIb9Z_NPyJdrggUbmQKHferNg8T91D8kDAbsetKxUfuxarztvhVlLRpNtzuavxys2WrLrA1g28wH-EfspOVUxj0-hIEGnjN2j4j_WdMSZG52RJGzqZA5SosptydrNRpq9Xs5R7A94u3_Wt7EdMRHrfR8SqxecDCJ43clmYrl2NHWvia5ezczsaDKowJJ5mx9LbaXParrPUanmHuFHWs5LzuFkNf4Vb0pgdmaZTvenM5AtK_-4h6UXC9vxpfYtnNXeEqXZ4IUwDEEfrTy830fJ4ThkQgcoU9jqZQYCZWG0d38apRVpg8Poyo_mHjiS_SAHcGubwxD4uzSsa4MLmmbFp0F8Mtr1MyS6a0xxwj2XfEgb0wMCmGVsQ95tKMlnEDIhwW-gK6PPSCygrdGt_Em8UkJcdJioeLRwHfJFGVLEwdC8RtX7yX-THalQKWktj35ncfLkKg3R0shxBEoD1UwFLRpR9Ewy11EcpAN2skCO9LPU8VN-UoMPm2zzSZ0Br1NV7C5Fg1YDqzyZlmPVF9_Xnqpg0NP5dVM_GOM7GpSmw0zHe4EIOsBQSLoWUUjrUlIA2EKWXb52_yVHR5f21YzLOO_xm88QHYHuV1TeLX5p6HnrN564Jq3XPdIeIoTV5EIiPneznGpC6hghJznS057LGbRgeKoz2NbcwUdbLMX-mKIDF71KvDBkKuhQIupf8jWXthnGLu4_Xrwx7gCTjLLQJe0WSpQtWAleaA-lC3h55kGzpJmK4_GVec49qVNmgvj4op3QGiAzT5IdI2iM5a6sDOlhhjV6DfUPjNevD6xYkGGwqSLcyV6HwjzhYUyomaQIW8EiRMPubXiVgrS8GrQNFqir4UfTSSMqWrBj-9R1vQ4blaXEqLvk-bejlZKmF-pK1WSGFPD7v2sbAO3YsH4-MLKL4-H1BeRX87wRbrCNesQtU1uo5WBFqCXFr34rQgFVq2O9fcd9a4iO2VKQEfJ8qblk6-ACAHV7_E7lJFCE3uBeKFWefM_nXMQ_Y_wcGN3_qQvyZd73RrurgMnucAesCRZo9YJgvNEYXEM_vr9l8XnI4Od-Q3otPs4Elaxt4UQGcb79oRrLC4oTyvEeScyxA0lfRebMjZ9BCrQkI2KAqn-efgqMZyYsxqcLTKdEU1D2GGAcQQ7SSsI0O7gMSdQg_QcW7oZkcKNPxcQu6MLD4oL-TwcpEDFqWjqtpxqqca6Oxhl-UQX_SxYRjd1gznrmSwuCWfphkDL-0Na2xFiezZHI7dMb1FUDzDO431utfNBtK1QNT8DKbhGXNrD6k9YwsO1LFtuziG4F2r03b3wU2R2fhTgvVBgdD1APFQuhmgn0GYhI7gEyz-ErvvmfwztNWRFst3adJ_5Pj8io53T425MwQKelkZ5FBpQNojN_CBEYXixmmx-i6mgHZF_gw-AtX8p6soFpZajqToLT2O4NnX5LG8Gn9_GMUtJ3tL7H0bzMoC97h0zTCqm1ebkikklDIj3be8w-UXApYa1b1pQYjEA72TnVE3wS_ROJ34xd0x1T7fyaVkfFnXD_Jswrosav0LVEzDS3DRQz-74AZqqK_1v-sXWK-A1xrxh37Wya-hW1mCY0Tb9V1WO93UwSrg6WkWe4JXpgPim2nenYOvPPL6C7l8cUOjPeFPLRwKHsEuFA4m8HxlpRyO2SdWNtRyPBvY90Tdn02ayx9dBO52aJYNxz_zQsBqLDf6-tZZpa3O7OCCQmbJkQ_D8XXbLBiThetm38xF_99crvh-sGNmV_Mks3DgLa2DSV6mNg')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '10447', `Language` = 'bg', `PostDate` = '2025-06-17', `LastUpdate` = '2025-06-17 13:58:15', `Type` = '0', `ParentID` = 0, `Data` = 'xszBW_KvHB5F2ajmSJ2HZ9hDeIFsbhtHXAmTKAQrNro-mdmzp4rqLL5sbkX3TnD2eUEPd0mkFDHkbQVb46iFlckrK_WmiVk4CdFEbOITExud3IcOxgwujWEBIy0ESE8LbUgj1qjssQkDdO_qb49nZVs-h_-LQmT-LRPvLGErxxHJoIaG6SE1vrGm5v6XU7pD-SF1RM7CDzPOkowiYYlV1uUmcVvJKR3K0M2PxhSZOxu7WKgQUSta6iGPCoT-HG1s-epOdky_hGm0YrOHkptvtf58-y0lBTHpv9HFaufALalkwj2Wd0kfWhqP0oZkgjvXWKe6C1D3f39wovoBy4WS__GJHwvafQJqvla6cgNnBNr54OSfZDkGuQFvvyFSCNiDQvjwyRmPrwzrtH112PA--tHovwncoEY0lKLofq4hnKFiY_subG2T7bz787SQZl2Kx30h_SCOX1rEEVrSIlcsHahyUkDW2oy_3T1XDzSJDO_tgwQVBd7mK8BMZRSWRw9_aL-G9USuVR2vG9CA8mZ14WhvWTde9IS97CaudCbWQMib930auxvX7BDEWWUcOI9qGxgr-rZfM5ncCV8Cn2pAiUtWtUEmddwzvh42NaqJcDkH0upa4ewwAUF_Dk_BNIkoHbttj0e2euAM23cYkSDaz2jDaow2V6OKCQIwO56ohwxyrT1D9gSHjOvLs-IhTrCsHLbtSX1RJ7v9QddMqC93uE0FYdNym5avm39Fvuxc8lPn2y7BPVtP1AMrDaFC-PamQt3D75gcyjbTSoOTU6V734tcyQbZeKV0WedsqouhXGUhsLF59LfsWuyOGE_2y4-nlE3Rx1yJ_E11eZ5eiR94pjquRUGAZz554d9aXV-eipvNHSYwaFZQPysY1E9JvlB1NKcy5rSBWz4Ly9Ua7twWl6KxztTcys-CEiKWjxIQKEP11PMVAgxVVy88N6I7mh3t36cSlTYZK2cW8HiRoLvmub0IteF3bssgbyMbOlmOJ8mFZCrvFFcoc9UXG2_Ll4d-sBFnj2PoxfG3iqCvm8YSvb-qcVCIQTyDOaLLm1y2Jei0q3zaaEpJ84Pd7XJN15v9TNw-SyVkdd5YZtVgexttMdZeLm1zjAJ9bORCNi1QCFHpt_6g7WwbPf4BUco7OPzYbIERYjrRjFvsiK-B1_Zfr4RSvAQqCHfI7cw8BsYcFS4SBqcIfL-n2_5aR2l82MtV2DktgnGg_P1ItgKROJnaN1HkFIBFucutktAtYchtSK8oqP5HCtfiqhDH3Bhmjkx-XWG37lOfvdVZsuVH7B0qTQ', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscK4w4DCtsOgwqCp8KDwqTDgMKrw5jCucKdw6jChMKhwpbCvMOXw5TCiMwofCpMKjwrDgMwrHDhcK2w5jCp8ODwrb' WHERE `ID` = '10447'
# [17-Jun-2025 13:58:15] /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
# [17-Jun-2025 13:58:17] /finance/root/bg/invoices/10447.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` = 10447
            LIMIT 1

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