# [29-Jan-2024 10:15:02] /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
# [29-Jan-2024 10:16:29] /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
# [29-Jan-2024 10:16:32] /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
# [29-Jan-2024 10:16:47] /finance/root/bg/invoices/2149.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` = 2149
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Jan-2024 10:16:54] /finance/root/bg/ajax/invoices/form/clone/2149.html?pid=2149&_=1706516213929 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2149
            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
# [29-Jan-2024 10:17:23] /finance/root/bg/ajax/invoices/insert.html?_=1706516242676 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 9 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` = '2166', `Language` = 'bg', `PostDate` = '2024-01-29 10:17:23', `LastUpdate` = '2024-01-29 10:17:23', `Type` = '1', `ParentID` = 0, `Data` = 'y1xerFHzf5nlPuXc8JKzT2B6hUHARelfv3MhNFPhQG-xT1nt81oq4fjPKhqq3FCb2Z1r5sF-32FAx6ixd0VFsnw7KHcgTuPQxkkB9g2PU0gQYxbvq13rW4RZrrVqvGA0oIbUOpV8er1Hm8kkYntPhbvXgXg1kBrNoXPOp3yH0oHZ4o8dR__Kc_uVKvXAax6YIjK8MJRqiiPH2Iof6lKib7zkRdF1qNqBpDGyRt-ZBoVTKVZhcpNlfLTwiTL0Ias7dJRposxtk97dI67CVXYhT7bZ6nDM1TLR3odXsm5axPlJkKjr5y9v_T0d_YU5AJ-6aZ9wA7avzOyJrKYJnp3uUqgXnISOSGzEM2Jnl5_O0oePLrTgb1Zr1JjGL6aL4l_IBO78GY2DxQ638Hr4b1V9QaPqc_Z_lx2ndv7Xu2iP0aIbtGF-FHpADwwfbnkTnhaioA-fWyWeCmFzgkMvCWHlC5qHa-kTUtN3V8gZSKSvbnbni4a2gbSehrU1jy6TaACNB_YaVpXMfIKqi6FEHNBSNUx1lkHf-XkF6BwhjuT7bNOzbNMLZj43SeCcRAMDnkrtCMLbhc9RcJof3GaMYsbcMHM_9OIgAF0_uBbL7WqjQoEb9AgV3MFMBZ3q75vzbDAedWuFuLJ_0VgiUwYsPdMoc-a8eXZEiSfh1tkHnt5y7kjksem4E80UZNF19Rmc_AL3qRbO5tX8qyzMjfkphgNfZRJns21smBfkP7vAU_jlkrS8vJvDr0IU07DPmcJi1RhDAM2MwBJeOpEx-DA49U7LrCV86pd0D7S04d9hpKZZ__qtiIXG_b8Yk3_a4bLlIsC7N7-cqdYiYykWM5SkEZB1k1jrBYLkGLmn7eiC6gaumboj5ayJdhn4eYvnPrOQyUK2AYBCfTLtMnb32NhW6FZ8-9uvftSNQae0o6TzwM-DpqPDInHaLzCtC3SruCunwu_6O_GxUxuwFIHJpm5hc3GRzklYPf_fEsenmpkH67dzl6FemxIT4ACiaaGdAS7sMUr4nKC2TK0WaYRE_gUOqmGmLzjjz5J0BDy4YhBAWkdAsGuZ5cg9u4BfesyXohG7t7WlOuFo0Lz3q--n0YP2Sihgb_Ol-953VMyevGwcjZpWNHOiaNCrWUNT-jb0GCDk7IiFNqBbAO2F2EK7VQJcJ4otSussTFJ2oCTiIzqS7exgh7NfVkahlRmcAy6SSbtyqcoUUVM4Gc_OAMpVanUro3g9p-LPJC47DBWHzUkDMzdzlwNftYmrICrnB_SKojQUBS6v-p7YDNkNm2ZHKm84ZEPdcxjxHbMGeEpaQTAZ4mrkpsSN7D12B4Ha5bUdCBtwYUoeHIrAu6aQ1tC2NjSh-FBksT4fDz_U667C2FJC6NE2tp10M-WDMKaNtV6hNsWxrRci1_ZWrL89yAjwSnQTQoZeFcm9WM0V_TyMIPs4H6JTNJaPzyYXDQ96ACz4jCRcRUOsskylWjwIpRWbUjRvdJ_vT_iIMRVgioqj_YTjXQLUNJzNrQODPPyWTmO7XRJOnl-D-wgqknCQSpfygQUR_JQGTnxqJBrVf6qFTiyVLP9qSKYcewFFj5YK4POb2XqJMMK4Uj1JxTzriW7YaY1sRfMVovGkiuHXrdS6lHVRZWHIHgwNPTV2SkmkSTOUuO0Kp9fvzUiZPEQNFEGooje1L-1Zr8B7gke4n08gYV3l5QhiggbzWyIsGzNygRjNNrvWUvJR3gRdZaZqBeZFcWc2errJzWM1UTGLsEX2cf3-GPM4kTUsH8IdDAsNIfiKdqTm6wKJtKEySrPQRm5_MR07duyt2PnuZqfAL9lQc-3P8XiE_VUjOTesHseFRut_GNg-5ZMBMInUIOPtkA6cCrBZ_APUqw', `SearchKey` = 'wofCpMK4wrDgsKlwqDrcKDwqTCwofCpMKnwrDg8OgwqCwrrCisOGw6PCsMKew4LDo8K1wovCvsOGw4fCwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOUwwofCpMOiwrDgMK6wqCrMKDwqTDi8Krw5jCucKd'
# [29-Jan-2024 10:17: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
# [29-Jan-2024 10:17:26] /finance/root/bg/invoices/2166.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` = 2166
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Jan-2024 16:32:08] /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
# [29-Jan-2024 16:32:12] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [29-Jan-2024 16:32:15] /finance/root/bg/ajax/clients/form.html?_=1706538735841 167.99.142.201
# [29-Jan-2024 16:36:46] /finance/root/bg/ajax/clients/insert.html?_=1706539006916 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` = '58', `Language` = 'bg', `LastUpdate` = '2024-01-29 16:36:46', `Data` = 'E_msTF10Obdehwl5_ri1QfL91mBvpLn1cSkDkXNLyMI8JJqb9uceErGYnRlHx_iaFFIY24va2z8UFqKYfsApJrEHWBFparOm0NLWUxP1YkdnZ71qAorOr31vFG0u1h9WS0uSJi5qbJIY_pdJuatrNEJEpXsaPavzQPJ7pBvUU1yw8XeOgGiHDwZvXEmQE2GkxBz47LLFps2y8GzaUIVnEUHA74C6m1goffQhlWlD9SlqrZ-s0ryS7KH7XeC6iVFGQ8K4mas3qTpDbmd_Co0iYLV4HdKcD_yfGtj8XVPtJ0FZos0AHZ7Nfz9KPhCcPCNKdc3uOOe4OXTcEyRlDv8iNE6jPO7T9e5z0rid1_Rtbnz-K_T70-3xnkeN4epH-Nd0', `SearchKey` = 'wrrCisOcw6HCscOZw4LDwofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwofCpMK0wrDgsKlwqCpcKDwqTDnsKsw4zDj8Kdw6bChMKhwoXCvMOVwr7CjMKewp3DjcwofCpMOawrDgsKlwqCqMKDwqTDhMKrw5jDwofCpMK8wrDgMK6wqCqsKDwqTCsMKsw4zCucKdwqDChMKhw4jCvMOXw6TCiMwqTDgsKxwpCm8Kww5PCqcKgw4LCrc', `Top` = 0, `Visible` = 1, `PostDate` = '2024-01-29 16:36:46'
# [29-Jan-2024 16:36:46] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [29-Jan-2024 16:36: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
# [29-Jan-2024 16:36:52] /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
# [29-Jan-2024 16:36:54] /finance/root/bg/ajax/invoices/form.html?_=1706539014353 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
# [29-Jan-2024 16:36:58] /finance/root/bg/ajax/clients/select/type_0.html?keyword=sil&_=1706539018866 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCisOcw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCisOcw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [29-Jan-2024 16:37:45] /finance/root/bg/ajax/invoices/insert.html?_=1706539066052 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 58 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` = '10389', `Language` = 'bg', `PostDate` = '2024-01-29 16:37:45', `LastUpdate` = '2024-01-29 16:37:45', `Type` = '0', `ParentID` = 0, `Data` = 'rashV1d5JT7Z2DE8egKeQGGR9TvarzMsEIEWBwyZbugWBPmjrGXaaxgAr7l3k3yyzmWCM2go7qtynYI-Nr3La8FDFrX8DB9-qcPIMKL56sptCSD-AqJzScXr8_VKyjPENucLyePAAQruWGu9lU7INqz3UO2ntihK5Njz8KqvMFv7BJQHnppEx20BWuww0NVCyrbXBJNruMNyZEbk6hd3KU2VnHloq52SgFKV84pjRggYS0ACc3F422PDqj8O1zkt-RYt-VMjy3Hz7GwL20EZEALKfvXaC3dg7f9zvXUzCwjdW-gliXv_0cWyvTOF4tYkB-bNj9wfh_8UHmeFnqSoWhkSpygElLb3poaRSlBwsxLu9MpHB2LpnDIcMANevUHr42AKE2xzvAAqTsa6z2REMwlm5LAJo1z5-gnjwyjs8H_OjP47-INEAMbMIz1GspxA0ZwreQ_-AUbosJGYM2cR3qNV3XBb8_C0K-CVoVf4cGjT03xUH7O6nPnVnKVtGLX9Gq7_vMDL63kmcGNFp2XowJO5FG3IwSXlig8dm2c7EE9Zw7bzRTMG_T_5UOTBk0XwvL9SbYfKSH3jHH_w0j0uAwXDRVqCSUk_kCYIy4boDznVr6ze5gS-8od4yvL5dtZDVx4oq4-sCuti3l9MZffcDdzBOWlFVYFrU4zF3zQvJ2SFDWZ6k-716kPK_-qAhATRhwi32r77mymlYklkW8boqIeZinIN97wSlCuReKAa_VF0w4uMWULWCbBeIJqMTpnWvXBNZN15opF9elNxlgrVBaB7YlMX2OAa3l5Rx2DyL1yeImE-MwrDrsyzSYhAnip9VmdDCejsnO22I-diUnu5nh61AI6n6NF3gscjXvJB2T2lQSIDQdE9cLb63_Z7T0pyXPUpRf49hKFV_8SPkEzohDnRE7Fecb8yScE-tP8EQn3zZxE1i5Q60xsxKYwAaHc3GF04GKrbxBhhnqxSJWW8HMJV59Keccb6eVn_iMBlXMNl2DbBJQj0BOu6_jG0MlPfOv_W5Zb89C2Q-HRKpyNiyB64t88YzvyhZ-a-kk3GyuY', `SearchKey` = 'wofCscK4wrDgsK6wqCq8KDwqTCuMKsw47Dn8KhwwofCpMOqwrDgMK6wrPCtcKDwqTDlsKsw4DwofCpMOIwrDg8OgwqCocKDwqTCwrrCisOcw6HCscOZw4LDwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwoXCvMOU'
# [29-Jan-2024 16:37:45] /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
# [29-Jan-2024 16:37:49] /finance/root/bg/invoices/10389.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` = 10389
            LIMIT 1

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