# [18-Apr-2024 11:41:59] /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
# [18-Apr-2024 11:42:02] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [18-Apr-2024 11:42:18] /finance/root/bg/ajax/clients/form.html?_=1713429738187 167.99.142.201
# [18-Apr-2024 11:43:35] /finance/root/bg/ajax/clients/insert.html?_=1713429814835 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` = '62', `Language` = 'bg', `LastUpdate` = '2024-04-18 11:43:35', `Data` = '0oXR5EhDyXHov7G_PtO4awwXxNAwwE46_0mtHHdLWHNbx6IauP3c-sctG2DQuuBbWoz-1LCDKz2qKkoHJiHuc-M3TWpYgfYBmCoPOjX1eAvQpwWx6S-_iTTGrKoVDvuVQ9LAMxheeKOI-z84OTR8aV9maP6ZyBQQmpLYO4I4H0pCAeLNQ-anq5RBPQkUFcrul91nI3we7eCbFc540f_hSmhY_5iSnthGcz2533qlqfVS96zUHVWNZJ4oe0vT0db59_E8600cjIaQsDAc7qYn6aAI7v0NI7xj6QH2fja2EzoBZ51onuRxvz2SU9k6b6o8aWi3HLL_T7GsHs7gD93tsXGJNUb9bx6ZwROR6mAtWmI', `SearchKey` = 'wrnCisKpwqPCp8OEwwofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwofCpMOEwrDgsK6wqCrMKDwqTDlsKsw4zDn8KhwrrChMKuwwofCpMOiwrDgsK6wrPCtcKDwqTCo8Krw5jDwqTDgsKxw6bCnMOAwrXCqMKiwpzDk8', `Top` = 0, `Visible` = 1, `PostDate` = '2024-04-18 11:43:35'
# [18-Apr-2024 11:43:35] /finance/root/bg/clients.html 167.99.142.201

set names utf8

SELECT * FROM `clients` ORDER BY `PostDate` ASC
# [18-Apr-2024 11:43: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
# [18-Apr-2024 11:43:43] /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
# [18-Apr-2024 11:43:45] /finance/root/bg/ajax/invoices/form.html?_=1713429824737 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
# [18-Apr-2024 11:43:49] /finance/root/bg/ajax/clients/select/type_0.html?keyword=ooy&_=1713429829346 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `clients`
            WHERE
         `Type` = 0 AND 
                    `SearchKey` LIKE '%wrnCisKpw%'
                ORDER BY
                    CASE
                        WHEN `SearchKey` LIKE 'rnCisKpw%' THEN 0
                        ELSE 1
                    END
                LIMIT 20
# [18-Apr-2024 11:44:45] /finance/root/bg/ajax/invoices/insert.html?_=1713429885116 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 62 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` = '10401', `Language` = 'bg', `PostDate` = '2024-04-18 11:44:45', `LastUpdate` = '2024-04-18 11:44:45', `Type` = '0', `ParentID` = 0, `Data` = '_Gy9MZ_XtF2agh_9V7kWXR4Su12bUQ3lWV1KXnNnjVvXXC5sZVbUBse7JQRnQWd1YTtOciVNdk2-oNlJ-jydfJhRwJ8uc4oMWhr5LTS5IZNwaX-qiCmTSN3pjIMzBx7rDqr9b27hFFNSmcBglt7T-P_3UcUnXs3pWOosOjrwuqqceojRdI776-zga5RqvWb18nsX4cFmTQdgvPKrbjSTrxKfJtdUdS5CV5HKNSpZmK9Xf20ziDaYLO1fpENQ1Dbk9t0LZu5D5U0sxIkKOP0P3bWgMZu6Q0X5yVi2K7BwXZOVL0WaqeHmdlctCY6wJxB4HMp_SkIW39MlKQGSFC9dxh1EpZQiAFK8b8wehASFYm-TN2tL662kkoOj9hH8c6aIFbwLGkEvmhVkgwX0oytXQ__Vt3lFs4vdeoTIqBNsf5B8ZMAVC-6M066Yf8P02nPJsVpZUVdJkXKpn9lZkyJbaE-mjG0rKs_qmradGFVSTvd5eGioAo6HmELlAx1Grj_TaX0sG3vyu-LohxrjuL0Qiq-EXVuXw4NuiPdz7P_DiWBML9MooiZj3es8yvLE80Zf8_s5v1kWWmwngLwiwKxsOwu0aTYxWHARmJGQNZ90tpIthQIJOo1pwjksxIiZzLLvwpYIzbrhtlpoMA7Pf4unDeTpwoJhgbFOeUIV2aaaWHDbtYDGJtaC4xn-lrVv99_sVDCnbdnbcof0U9EObHmehn8GJDGTkKrEPfCmMNGqveN4YBwA4BYWexsgmdH96XQ4486azQqJqAnEqLEfSdL-YM_U0Qn0eXdSrGskm3IA6JSrC_FMj3YGgi82ExfH-azvxSFuqbWztM8nXoIRSsjTDK_ERRnwFkXPVmDtzy2j15jtehX8n5QMfURmcH0SX-BjuL8BPy8sfZu5BJGEnjZpF9CTZdwjRc3gIF9M1dzxbdrNNesx1crVNm4MApqoUCEEjPRQq_hFYtYcwyXoNxa2MghMuhaBAl4JeI3UmCoor8OIC3X8gaeevVwNoro_dSXI', `SearchKey` = 'wofCscOEw4DCtMK6wqCpcKDwrHDwofCscK4w4DCtsOgwqDk8KDwqTCo8Ksw4zCucKhwwofCpMKnwrDg8OgwqCwrnCisKpwqPCp8OEwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMOWwrDgMwofCscK0wrDgMK6wqCp8KDwrHCsMKrw5jCucKd'
# [18-Apr-2024 11:44: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
# [18-Apr-2024 11:44:48] /finance/root/bg/invoices/10401.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` = 10401
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Apr-2024 14:55:13] /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
# [18-Apr-2024 14:55:27] /finance/root/bg/invoices/2208.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` = 2208
            LIMIT 1

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