# [06-Feb-2024 12:19: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
# [06-Feb-2024 12:19: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
# [06-Feb-2024 12:20:27] /finance/root/bg/ajax/invoices/form/clone/10392.html?pid=10392&_=1707214827801 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10392
            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
# [06-Feb-2024 12:20:51] /finance/root/bg/ajax/invoices/insert.html?_=1707214851620 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 16 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` = '2183', `Language` = 'bg', `PostDate` = '2024-02-06 12:20:51', `LastUpdate` = '2024-02-06 12:20:51', `Type` = '1', `ParentID` = 10392, `Data` = 'uGksWPQXrRo82ymZ5Hioh37_EhlUUkbUN9BgPMu9ENHWeKsHvPTfm3pqcZYqe2O7W1K3hMVMlMVznvW_G_IMxPIDDgAvvgjCH6nx3mjVsBCD84f0NTLiiIVlAib_svPxOUzrttDEkSJWZ5RqM8w-MUyVWny5L0wcZfzSp_w4G98JIM1xU-Me6-VDiXLHulj-Q9DLr7ubCAjAwgblHnvHPmBpVQV7utdqojEcPzZo6Cpzr7Wr-apB4eICJZIqhi8bg39HhDSX2QOYJcGqpxykBR7Wjynxk2tDO7198I6ig9lR2Sr1i4up46duiJTxVh01ZKGZvhjfMQr7U85smxGbEYS8-srAZGeBDCSzHDEsNvrVbWEsf4WYQf4YMEr04hVjyDU-39xB3NGBErnqcsyku9Ehw49GZIihxjT404cdSLxiJMnftAk4ThydvQIfzaTcuK-lCQznWAKiorjnJ9ukJSUfYTyVb7xTBTiu6443ikFU7S0TXo13kF2G3sPrA4loFtEn13xBusfyHxR5nhRS3dfmx1X26aMxbwZWr2BSXFSevzXT4JAfXSF86VRuJfd8tAzLJCi5ehHHEXj4V25L1M824MziCItsRJH70UMb9envBHcVIjWmLDbu_ZGQecUsNIIo3551kMPVyix9GzAtOHAxkT2yPDKjxwYOneFRrpH5TlVOOPgl7RpI3tSMYMGIwwilghXTNoSdoQSDrB3i-1gQ2EQKTmdjtEawSJNTgqrem6DU4fEiS11fjBByGMnzuYbrVpkb94NYA_vT8KQUT9CaiXjDWePbEFcDf2Fsb7qK_eDGDHAPmtTUzzHNfrOPvP7RqcLWgSWlBz5SBPJEQKWopJZzsG6s6a9AgcYLeJjR-VDa9mRglOQll7rREYChBvRd4qywYplbyAt1UqAPVd2pO13dWRhYlv8raFLy6_CoBS6w8jCsRSys0fqY6-5T4yeMN5sTvTm5GKwQ--11v-uTqmRa493uNGPWbBI0hHzwxQBUblNC0-CmZRjY73xvplLyLNsmuhAYF2PzkUGh2m3V6g734KaNeCikGeje1O-j1VRMJqpH62DeDjhEwQYIVhN1rG_oB35NhZwRAIRIBfjodqGEvF5RXyNygbV53n06Xl50qbYnCWl2nmNAnL8g', `SearchKey` = 'wofCscK4w4DCtsOgwrPCtcKDwqTCuMKrw5rCucKdwwofCpMOmwrDg8OgwqDrsKDwqTDlsKsw4zDj8KhwrLChMKhwrzCvMOWwwofCpMKnwrDg8OgwqCwrrCisOGw6fCscOZw5jDnsKtwqDpMOQwrCncOGw6nCuMKcwr7DwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrC'
# [06-Feb-2024 12:20:51] /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
# [06-Feb-2024 12:20:55] /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
# [06-Feb-2024 12:20:58] /finance/root/bg/invoices/2183.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` = 2183
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Feb-2024 12:23: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
# [06-Feb-2024 12:26: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
# [06-Feb-2024 12:26:03] /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
# [06-Feb-2024 14:43:34] /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
# [06-Feb-2024 14:43:35] /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
# [06-Feb-2024 14:43:39] /finance/root/bg/ajax/invoices/form/clone/10393.html?pid=10393&_=1707223419442 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10393
            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
# [06-Feb-2024 14:43:44] /finance/root/bg/ajax/invoices/insert.html?_=1707223425165 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 17 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` = '2184', `Language` = 'bg', `PostDate` = '2024-02-06 14:43:44', `LastUpdate` = '2024-02-06 14:43:44', `Type` = '1', `ParentID` = 10393, `Data` = 'HZZPZSbcfxcu12FJF2v5Ze0Ysp0x5pX6Ue4C_J8RthUtaHt5XcIbvW8guYtDuFBHT56F86yF1dELY-o0Wh7IY32wAY7aw_59KUk8dN16b46ImmOlTNHwBXQsjXLUfINT-iw9oaB-cQUCoGnHb-G1pFHX8E3igT7mZgNZMD7mb0UUn911gHHS_06xoRhw-fpGbduEOsizeUnfur3_ruckUJ2mQmzr1zGGYGUs1ypWbjIXTeQQODhxSOyfgMJOPA1tH3afjuP_z1Qmejan7NumTjcjEQB1HLv7NJ0oNfeIbndgYIL0tVpztCi_1OFniK8q-RopH-xJsEbHHBEE0yVpRkZiM8d7zr24yoHXJUlKHV12gaWDmRGknjVnQDk6hW3B5g0E9nXwtlq6tmH7ugUyk5_SJXTyn9EP-03wRbib7xp_A0ytS7xWqlPUSuk6c4nbpmJAkbDYlZTLDXHcJ5r7fidjGx6PB7k5UFDwdU_ENrx5zGcyd-HAvU-W9hGv542LFto3BEDtF-uXqPm9l78vZQ3usClVlzeh9oSzoAPRB0s1jgMBSyPmNNSusuX9Nm05Vs3M2_s1nPfF_9jTO1UIX4rUxTTvCd5Qyq6Bgj3vgbMSK0OPqG2SJbwBWifUNACOYfsgrli6qkk6W3WWzBhrJoS77d4DY1Pkw954fGMpMirOpbFfk0onSdFSMGtBa1JFNdfRLidrgaZ5pHNDgaT19YocGxO9B49s4ZLLbfvx_DeSg-Ny1eONSt4YVcrdfEfrAPK_IKZEYCAxiiqIksBNy3qLvBHBOcOKuMmT3MpXGvQbewCi2IbWArW5Mn1YY65naG_cukRYkqtARzsUVWjFOKA3oPPkJkToJxkIyov-Z47XFDHFOHTJNJzmmKwPkNc6qU7gjInSyJr3VLmPtgL98K6cFzPtFJOPOWhRrtYPuqbm1W0t_FFR9awQTQ4ieL2xRPgDIdCmHTU4AIjmttFCyVX-me_ssHlInoMGl4uHmEnRGUNh7fps5aaweKhPy65EQKuODvLMeoTWnItOmXIN_59Cms1NwzSdhXeezIM4umqfg-XVB78T8StUbVvWnKwWMnaquw57AkIXwCx_ZDkzE-jr7Jxog84CJkLagOqVRDOBSkEU8Pv_EkRwOJe9n_FK', `SearchKey` = 'wofCscK4wrDg8OgwrPCucKDwqTCsMKrw5jDn8KhwrLChMKhwwofCpMK0wrDgMOgwqDq8KDwqTCn8Krw5jCpMKdw6bChMKuwpbCvMOVwwofCpMKnwrDg8OgwqCwrrCisKpw5vCpsOEw4LCpMK1worCssKMwr7DgsKPw53CrcKtwpzDwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rD'
# [06-Feb-2024 14:43:44] /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
# [06-Feb-2024 14:47:18] /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
# [06-Feb-2024 14:47:23] /finance/root/bg/invoices/2184.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` = 2184
            LIMIT 1

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