# [29-Oct-2024 10:54: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
# [29-Oct-2024 10:55:00] /finance/root/bg/invoices/2333.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` = 2333
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Oct-2024 10:55:08] /finance/root/bg/invoices/2332.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` = 2332
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Oct-2024 13:25:45] /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
# [29-Oct-2024 13:25:59] /finance/root/bg/ajax/invoices/form/clone/2358.html?pid=2358&_=1730201159898 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2358
            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
# [29-Oct-2024 13:27:47] /finance/root/bg/ajax/invoices/insert.html?_=1730201267838 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 11 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` = '2359', `Language` = 'bg', `PostDate` = '2024-10-29', `LastUpdate` = '2024-10-29 13:27:47', `Type` = '1', `ParentID` = 0, `Data` = 'kzbA0gtW-YSGWW6jVmk67kasmDNQ81DMFX1nxS5u-RrXwRQwz85WANFdT9FPw-NiHEeix0H8Ky0XI-qxrbgNmds-b_KxdrOaVAnkqEXON8A2Ck0tZTatDaSQp5b7OeAw-BqpJwdY7J7N9REEkrL8ajvCEq5vnvyRvItgtDbr5dgSni-kCmx3jexraUGqrJ7I9FlCuOvS_EVjNoyqXVWktKE_Pm8VHnSORM0LesMleM4viTSDo2nudMq7Wu_w_NR9x3U3Sr7f-aapAOoCsQTeVCtqipu8BasdUej-OVVpVh9sIU2KnQqgybwyGO0clhjvc9nWK72_-cGlC8Xq0WBPzzcfzMtaYqsFfReijgT1AWrXXphOR9tvfK5sTTI4odV3tBuX4plMtuddy4gVbZNd7XIYFvONGywxNSZsCz19rWtTGGtWq30zLUVI-BXL15WHkgDnfD4cJMd46Sa1JM_nkQ6jP-YHBGTfBlFc-0NyjusATmZIhBl0h5AKO5VHqC1OA8MBgGrQTP4agOXKrGf_OOv0FXGSpHZ8BPy_4nlNUCew0xtM3f2biXWQut-qCwlnLHEspg8m1NuSVms3cBtVIEGBmTVGft7ZANNVXZ8JSBpSqTwRRpztAkJmld-qnzMbTcytcw9mEnh_Jarq_lruiHAzO9AyTidiPAbr1i6h1oua_4zippl-1FYNEyYMUQOda4Fuk3Z_stbEueGwV4gz3AXXuAlDHS2r90GNZXmaPBTF4so1oIGtyTtYQck0nptKaIOrSYH8lnRcyclG9ChfEFkW00AtoXVyf6sUFnxZlwSo43ODfb_BXoFM2A6ZqIdXfxmK7fTu4k6PoIWAIZP8MTgqdajet6BgtSN6AconHQpITXJVYhtxcHqXa5zSqAidlfI8WkgRYnMNYja4WZsHW5pSBLHGPHzAAcj3WLo3gXyb94jR8ScVK3HGN9WRvPZNI_P4KeXB8PpSXpwfAO1xuksGSpUuNJGZmjB4tfIJBqF43wPJ6igugDDcjdsKNdvUk5bLZ1M8dIwV3AjkhlfDEYWOHsgI0vtWYvrPv_0kU1kPCVlOKWS9VE4e2TLzYoSc0HnjUKQ9EQEMuCII9ZWI4sLnFkgQeu43m9yOaWw1A6EVA9wIy4wzXPXOOKK_T-FEoxkEq5LlB2Y3BGd05yKQocdVr37rFUaoqvaPQDxwT33QAKqpXJEP63JRvAX1eoNsZ5yHswckPxzPOXLbRzUycXCUGuqbSOU-mxtJ-b2XGKoE8PWGnWpwYJTFlWZckIqnpQ-oAH--RuafQqlfRnyHPRj2RIzjnouD5K-Eas7hLVH81tZ7Wy9-TzahI91P8SHkg6cVB3DAv7gZtM6R14cvUHHP3fotMxpR9ykeWjha8M1U2huXXxme5NHKa2xZqwoTKkv1QQZpYmKgNFWxiSg2QhvUo8t9sVmuaB9Q2JssV_nbCpH7gzngi-bMnbDhCCUkcp7LiQzTjMy17wtyUr-BScve5c08EmAgS9eQ18NUyuaQgR2q91PO0JulKvZ9c5ivL9xC9o4uPPTVQ5lWMJxczRByN7AMgf6HXIlDvFMPGQo', `SearchKey` = 'wofCscOEwrDg8OgwqCrcKDwqTDgMKrw5jCucKhwrbChMKhwrzCvcOLwwofCpMOPw4DCtMK6wqCocKDwqTCvMKsw4zCucKdw6bChMKhw4zCvMOVw5TCiMwofCpMK0wrDg8OQwqDq8KDwqTDosKrw5rCucKhwrLChMKhwrzCvcOJwqnCiMKEwp3DgMwofCscOSwrDgcOQwqCrcKDwrHCuMKsw47Dn8KhwwofCpMOWwrDgMwofCpMOIwrDgMOgwrPC'
# [29-Oct-2024 13:27:48] /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
# [29-Oct-2024 13:27: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
# [29-Oct-2024 13:27:52] /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
# [29-Oct-2024 13:27:54] /finance/root/bg/invoices/2359.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` = 2359
            LIMIT 1

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