# [14-Feb-2024 15:45:39] /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
# [14-Feb-2024 15:45:45] /finance/root/bg/ajax/invoices/form/clone/2182.html?pid=2182&_=1707918346802 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2182
            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
# [14-Feb-2024 15:46:03] /finance/root/bg/ajax/invoices/form/clone/2182.html?pid=2182&_=1707918364545 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2182
            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
# [14-Feb-2024 15:46:10] /finance/root/bg/ajax/invoices/form.html?_=1707918371516 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
# [14-Feb-2024 15:47:12] /finance/root/bg/ajax/invoices/insert.html?_=1707918433780 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` = '2185', `Language` = 'bg', `PostDate` = '2024-02-14 15:47:12', `LastUpdate` = '2024-02-14 15:47:12', `Type` = '1', `ParentID` = 0, `Data` = 'ZPcUMxjvTmqjEGyRt9BFfSaWv-t46slzqk-Zed3LTtBOD3XOifxkIvJVuG1yfuTP-UdhnUxWs6qnjCAnGXcIDxuONzZrVxU9Riwb6k-Jp8zZX9YzwcO0OjYGz3eSa5uWkWo8LyMpMVsqBzgM0qzH00eGC4RSuvV1SWbZsnoZOM4n0aSS6x4k2D_eDj7lPg2WA1V7O_WCIma-9QEtUiouekDsYmm69BwVBpwI6Dlpalq0sZCDvug6r3iJsbr8UYJTxITCHhhbmTlPvs2ciZoHYbDFTnMMeYqPgqLtAU7y_m4JP1flm1SsfnE-wPFfsilB6du_axr7Am1Hv2KEcGBPS24mA7H2-1Ks3TglGRIKrTFGnSjSIaKxOVYzv6gifDm32Or522lO88mDuQwsqnRbZQn22D6x_7yv7OW4WkkDrWknFjLUdiC2m3WLuKQ3lzC56oYiwXkjykf1vqhYHoewmkcTdCIlxKsy3pQzROpp-EQVeHzMi76lNgqjxMuRtlM0LQz1Ofshicodac6u1a5mlwhh-342La5j_0qPR5i9a3pZcKeA-aGbROev-JfEoFejuxRFAVew082ioYzmwtB4vSYZOnXA7LL0euU97JSOAnsvGk8mMur5tNgdAiMw-Z1-kyWAGJZDbH8PiqKNDA4d847nWi61r4Zw_eIP3mgZEyX29s9sVwcbzpdxVdo-uuEuYc4Df2uozDEpSNlyDxRPhLG94cFHtzkJb88VTZv0J3SLDcc6XpJ3dDfFh3DQ29e-9mXp2XY-Kx0pNnNXOgjQxWDnEODbfTTehehH6oKDJAy48oz-LiYMC6FAWci0QKyBK6EunKVDhf4sdKFBM8-YQhzvVqIpuZGV1kGYevpz1TGgL1F07ZDVRONoPSvJHNFb-VGF2c0QLttdBTmzZnb-FeIoEbGauyz5WApjgh5Koe2Ta3z81cMf8j2MZTNe9xAfyeq3C46mea7NPSBei53d5ukttIsKxJXQDKu83xLi7zd6GdiFualr_HlffwbwjMGooEoaA8WUugSb1CuPMu_V6g', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCpMOqwrDg8OgwqCpMKDwrHCvM'
# [14-Feb-2024 15:47:12] /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
# [14-Feb-2024 15:47:18] /finance/root/bg/ajax/invoices/form.html?_=1707918438994 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
# [14-Feb-2024 15:51:15] /finance/root/bg/invoices/2094.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` = 2094
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Feb-2024 15:51:44] /finance/root/bg/ajax/invoices/form.html?_=1707918705297 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
# [14-Feb-2024 15:57:42] /finance/root/bg/ajax/invoices/insert.html?_=1707919063004 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` = '2186', `Language` = 'bg', `PostDate` = '2024-02-14 15:57:42', `LastUpdate` = '2024-02-14 15:57:42', `Type` = '1', `ParentID` = 0, `Data` = 'PWpiEhtbHLXbk7rxYbB9Xevn46ceFXeb0wD4xFY9pyi9EjdvPco-Sj00mjZ9zuE7zUMKSWIvYM70jAAUAcNm_iRRuJ9J3aS4OegnHB1Q2aeValzO7neCNdRbSwBrrHLCqPugc87jbbA-hbfeaxNDigDj8vI-fwq1xkqJjfA1gRsyxwPtTy3WoWrhADAzgqtjpKVh8fcQ78ph3BLaj4R1SDBSmZrGLAbV0MtigGkkPZKstdwKQ2HXDkECj8KFbvNwSnUQ0H3yG9lm4CXuOZuAJd0aewmgbdKEHJnsbpyJjlQfwohOHmCDMz12trWupssdZwxOlIOti_Ob1-ydgju9PFN2qQOS0P8pRz6klm6gKtUY9tWIEQZiZr8iwAOogmmEI59jtpL1PLJzxRoSKMAkpIIPaDpH2qsoUlw_8s4FrbQEoEsVWjohZ8lFuudKLwyJzUOMuaTpzwqiXZfH1LxlezwwoPX2pM5YFLQBOYCyrcWOPSrM1KUi8UsZeZxkV-jB46fUDPzUDkCEnX8CDZpURBZcU-h4aUu-Ti9431QWohSSrf2u98W_CU2g3Kl3wwK3K0aE2fWjBcF1EITlZDyorTeaOhMDqJuuoNWxyEyEd2NF_wjXuaMJuALQLAsRGGX_fCXsS0yxjUXSgL6_iL0ilALHqnXsdSS7JruQju-x15bHEgsps53BuYmR2l6-RlVf6FF1nwdPNNW_WoOAu1WCsXpY5BYhyPvS4vJyV4j0rvqxRV_0d9UHtV-QpRm-yJnXUW1VjIw5_PqmVWpiX-KBTNJhrOOkqay7NxyvKhfcmDbNwUw8bvCm4PS8u83pnTdPyWv0TXdEI7JZoBGtXW4g1Q6ZX4LJkAvJxwU73FdNi60f3Lk-HyJRJuJxoV9bC1_1-9oKHVqhQcQHMfmycyXs5B_trX_A-OlOnUQ6BX2RhV3KnVUoQNNVgThvwPU2fTylS91mJHPpJJqt7BtXRPF72zD-S-hFnFuXbqfPn0e_MAVwqfjanpIzheM93emh3d-goc0tKlzI257iX1NzWZCDmZrVDhL8593SRkXam20SjKI9pGntm4kHscv13dHGpKDtOw3IS6a18W7yPja-qCiuHxdz0xcUMRh9EmgTKVdlJ6EKa_PBn7Y2bWquz2uTru-JhjSZtyKZ0VuIHycjOUkzzfFbKx6ThMtgLkK8EA-BJwQao39j-wHHqa3e2YksWhcq7qwuFPGdsoD5RlxeiHHQ23VRwMAzkuTiRU3xm2TOV_XN4xjFX8OjK3_mL0AXQ6VI0aGrcRKuQMhMOm1MnARYPmN7Okx0k4ZBct4eMKH7uUPm_iosiJdqhncX5taDgmBpGzxBXQ04h35yleYP4Vn7uOvXcXPZvJJhoZaIbW5Nk8z6aoof2nbcjeOlk4XNv_GR', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKdw6fChMKhwonCvcOIw6TCiMKJwp3DgMwofCpMKjwrDgMwofCscOAwrDgcOQwqDwofCscK4wr'
# [14-Feb-2024 15:57:42] /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
# [14-Feb-2024 15:57:46] /finance/root/bg/invoices/2186.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` = 2186
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Feb-2024 15:58:45] /finance/root/bg/invoices/2185.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` = 2185
            LIMIT 1

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