# [04-Jul-2024 12:42:19] /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
# [04-Jul-2024 12:42:21] /finance/root/bg/invoices/2281.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` = 2281
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-Jul-2024 14:24:41] /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
# [04-Jul-2024 14:24:42] /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
# [04-Jul-2024 14:24:45] /finance/root/bg/ajax/invoices/form.html?_=1720092286924 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
# [04-Jul-2024 14:24:50] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Jul-2024 14:24:52] /finance/root/bg/ajax/clients/form.html?_=1720092293442 167.99.142.201
# [04-Jul-2024 14:25:58] /finance/root/bg/ajax/clients/insert.html?_=1720092359948 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` = '67', `Language` = 'bg', `LastUpdate` = '2024-07-04 14:25:58', `Data` = 'SUi-ip7mMgqHFssKnfm2bWlpztsSN1ziY3OIwbQbYqnOr-_ROETt6rHv3D2hMpobYDzYWhqFb-mYottknP1__nQGnim_PdkKPT5Pf2Ta3xxAajKEGhb0IBrJjBkX8f6jTnPcAoO3C27uptJf__ZMTnFkbU_yTFCkxNNCPiC-O5VUf2khNgWGOuqnEd_jAH73ZO9ifMrUn9LK-CoM2NpiEyKhcLLDqKo77he_NSGy9n8el4t6sFahia3Hh5jWv-92MeiQFfhdG86dhTaRmGXadBK8KqXf7hj3QPlYnBnmnj1rn_D17hfTi0j-BiLNcrKwiUopDvNc4Ir3Tl5wen4lQg', `SearchKey` = 'wrrCi8OKw5rCscKzwqXDrsK1wpCsswofCscK4wrDgMOgwqCpcKDwrHCuMKrw5vDn8KhwrHChMKhw4jCvMOUwr7CiMwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwqPChMKhwqrCvMOUwwofCscK4wrDgMOgwqCpcKDwrHCuMKrw5vDn8KhwrHChMKhw4jCvMOUwr7CiMwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwqPChMKhwqrCvMOUwwqTCnMKxw6XCmsKwwq3Dq8KgwpzCrcORwrLC', `Top` = 0, `Visible` = 1, `PostDate` = '2024-07-04 14:25:58'
# [04-Jul-2024 14:25:58] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [04-Jul-2024 14:26:05] /finance/root/bg/ajax/clients/form/67.html?_=1720092366236 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 67
            LIMIT 1
# [04-Jul-2024 14:26:17] /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
# [04-Jul-2024 14:26:18] /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
# [04-Jul-2024 14:26:21] /finance/root/bg/ajax/invoices/form.html?_=1720092382179 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
# [04-Jul-2024 14:26:24] /finance/root/bg/ajax/clients/select/type_0.html?keyword=svetoslav&_=1720092385136 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrrCi8OKw5rCscKzwqXDrsK1wpCss%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rrCi8OKw5rCscKzwqXDrsK1wpCss%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [04-Jul-2024 14:26:49] /finance/root/bg/ajax/invoices/insert.html?_=1720092410403 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` = '10419', `Language` = 'bg', `PostDate` = '2024-07-04', `LastUpdate` = '2024-07-04 14:26:49', `Type` = '0', `ParentID` = 0, `Data` = '9ZVdWraBDklNOcre8G7l8og7a1PyQE7HijBO-fb8hqi3_WOdZGwY8ZlmFBEdhqkGfJ4amlptxu6L-UrCp7T-Oq7Tvma3B4AwZIrNRNJ8IL9b1IhBKRWzEuTWE6YfK-x-LwXOSGlYOsgr9QyLBlKBWp9IulUK0ingtPCjF1SRLkKsiOmTE_13zErsfByYvcFCV6fdIAtxotjAGWFjoQIsg6NIJH5zwijqPUFfu6oLE3cQxDTroY0Xs89TMG2TwCGxx-8a4fbGOFsCqd7HQtipc3PdqJI33sQ4TTYTeZK2tmKojvxs_jvtxcPrKsZ0IjNcUx3Fo_a78_kG6l6IVfVaX7-eklOK4djGstMYbTel8cDRttCMyXSPN-EzoZFyZC-TlD5hkWmp6kJ13ugvezETvsDwJGNjcx1BnEyAPY96E9-Sqt8oHLkJqAwtGYR-ricdbDL3R8aOL4_ozVzsMsCH6AUgqA4fOEs4bYdXElyi087Tp6bZLuaRwtwN5Q2Bpdg86O4HgGhPSJje9DJE5j7Ec2zONCmXto6agWTxR67khiELSUhouvHpA4UUT1Ubsf4DK2qWiju7vMTDjak8tLnGAHyZ2gHb1cg2pxo9glbMoD6VBEUjzXWBOwg57By5x74hv3jfApe-az9uzfcVWjut-hxJBlyM8TMBEUDdTCKGJmVmLLphOZyyrM_Z7gl9vRSy0aABTcebyZzmRWcuTgu_EYQq-IUWrnrOVh_72M24_vw1vfYJPLnLl2wxjlB-7qMrifentrt9t43YKvDVxX2wkMp5NIG5WKgTw5QibXNu3rlL8Bwo2qZSeqleZ1-f5B20lN9Gqf5KfGFOiEbqF8lA3VtRlD3tDNjehoVDh7b6Wync4zJjc0xdQqDnVPoeugGAFJd4vXERPCnU1qTtcTKrsnDKG2jv6oaMq55HqiLofmKobsnaUSc1pY_7j-yo0MW3', `SearchKey` = 'wofCscK4wrDgMOgwqCpcKDwrHCuMKrw5vDn8KhwrHChMKhw4jCvMOUwr7CiMwofCpMOAwrDgcOQwqCocKDwrHCsMKrw5jCpMKdwqPChMKhwqrCvMOUwwrrCi8OKw5rCscKzwqXDrsK1wpCsswofCpMOawrDgcKlwrPCtcKDwqTCsMKrw5jDj8KdwpzChMKuwp7CvMOWw6TCiMwofCpMKjwrDgMwofCscK4w4DCtMOgwqDq8KDwrHCuMKrw5rCuc'
# [04-Jul-2024 14:26:49] /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
# [04-Jul-2024 14:26:51] /finance/root/bg/invoices/10419.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` = 10419
            LIMIT 1

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