# [05-Jul-2024 11:35:15] /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
# [05-Jul-2024 11:35:17] /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
# [05-Jul-2024 15:23: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
# [05-Jul-2024 15:23:01] /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
# [05-Jul-2024 15:23:05] /finance/root/bg/ajax/invoices/form/clone/10419.html?pid=10419&_=1720182185688 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10419
            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
# [05-Jul-2024 15:23:09] /finance/root/bg/ajax/invoices/insert.html?_=1720182189986 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 67 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` = '2282', `Language` = 'bg', `PostDate` = '2024-07-05', `LastUpdate` = '2024-07-05 15:23:09', `Type` = '1', `ParentID` = 10419, `Data` = 'OK8tjFTbVsIeeq44WB6A9Zrjvr5K0_dCikDswUQNfKvDzSvxgc4N_Ie_xdscIOsUnKx35Fly7b1dbc79tGLWYgG5GM1ScAUP1ztVwcdiVgTQd0Rje8GbXATEAdvdxzYDKFtCKig02YEAdmxPSI-koSS1QRnZuaxRKvvytbRSwZkhrExY228CYI3AbeHmAZ-augAkn-1loRcjbGBKiRZFHZf6PWo_sNK-rXcdMGSZL-OlnjmqL_8bRDk_Sa-X4d7X6JqELUPekefSVjxVZNr99IQNEpM9Ho26iBE6H-ji_breN_zTZyWmWOV4gZb5s9ijT4tAPy5cIEYmTuQw4Tg6pWl8s6oudGYz17NAlusf_71EzWO5LVZFelKDoY4RrWjUmzoghxbw9fidC5figsOiKZsPqtiKdGXfCBadj8L_yQw8pzxEZPcAFeLfC6A4mzgJYZ4QFmGWKj16yTn5kP6c3il2hT1dpGWYGUPdTiUv2iRjKnxtvOSKp30BKqyhgVfa_Qq3ekovUjyu8Voav8xNprc3-3SGDS3ibwItcujb-vmRZ0dNbsZ_7Dku3bxQvragm25U44mhWzG34TBHqtH35ZDQOMD6o5zwV1XeXraARMKj2PLjaP_HahrTp4PnisRmniiFf1TMtdM4i8yJo14EmW2wBXytMSQzSdpaTilx4Km9IhRE88eAUOvsOl4RwfrOxAldFpFudRJJ9WVyE_S85M5IDvwqiG0B36r4ICzJzK7714y2AAZil2hEbkrw7WUP0FnMmvNFZST1jd53DNDcCyAL_zkR9Goqzb1KYIU-eLgx0FHvo15t0AWnL5GiEIY6aaqMJrLZRTJqZqpOfcTP9Uay0cIG70OkJ9Iyor8CxBLGnIGOqKsPGGXh1v1yvTL2_qpNCf-5YjI00K75PEwx1hbc-5zhr_oNRGeXeXcYuLgmwf6nm98xzoiWvuWyACI1', `SearchKey` = 'wofCscK4wrDgMOgwqCpcKDwrHCuMKrw5vDn8KhwrHChMKhw4jCvMOUwr7CiMwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwqPChMKhwqrCvMOUwwrrCi8OKw5rCscKzwqXDrsK1wpCsswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscK4w4DCtMOgwqDq8KDwrHCuMKrw5rCuc'
# [05-Jul-2024 15:23:09] /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
# [05-Jul-2024 15:23: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
# [05-Jul-2024 15:23:13] /finance/root/bg/invoices/2282.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` = 2282
            LIMIT 1

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