# [12-Sep-2025 09:45:44] /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
# [12-Sep-2025 09:45:46] /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
# [12-Sep-2025 09:45:49] /finance/root/bg/ajax/invoices/form/clone/10462.html?pid=10462&_=1757659549816 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10462
            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
# [12-Sep-2025 09:45:54] /finance/root/bg/ajax/invoices/insert.html?_=1757659554100 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 48 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` = '2549', `Language` = 'bg', `PostDate` = '2025-09-12', `LastUpdate` = '2025-09-12 09:45:54', `Type` = '1', `ParentID` = 10462, `Data` = '4mhROn0xLV_cqIJmEOXF2h6WFo1eUAfK4ad8IPimz1ebzALLXDh0OWxVfT0XogC4LSZhYgUNua1njiKRRUzdmGkGg80cRLaetc5F13pd0C14yiGJgOkRnStCe50FNwMYxDC1bk0gjm7sWwQg7sBSHzuQCBoDHcZ0Iv12bbdSYUIseUCKxZ_fxwjY3UdUVaM2yvTMiQ5jFo4Ou-KmwlADfQKUlGGMdvscuLAUMHstjc33MDZ4x0BeMzFyMuzbKEoWVKQsmiB3cWTvPro1lfAPACJWMHawsCO4Gd8MK7AyYHG8n97BScCG1AKacGGLIttzkR207WQJAezgd6GtX4sEPNv0xl3KmVR4hY8DvUVFwzgVEbX_OY1y5JrkjNvQmI5xWHioMg63fzPkmyZGxCI7Kjcvm9uZ4PTBCsKGvissXNN9kcocBOmhLV8z4v0HtUN5i1sm_4vHETtzJWkWoK7q_FWcYwZ1YkpCBOR9aI1m2wMXF0Em0MGDrcrFDM_Nr7cUdsWmJ8TgYRZDraWuPBXQP6E3XYxtIjltqiPHvzO_K1hpXh3JE_VMfZPzHAooTM13eghn9R8vvsAC3M3Z_HgTmzwxHKgqQfibL-EVL4PMXj5bw_WEvQZRgs46KbYObmWw42z3yYJprs1Ew8gJzyNKxRUjicIufufJhOejcGhbCUUrZO6t_WDTHKQpdhD9dPq4Iqr_INCqBkLL2bZykkqU6OTdoVg9HIHtEyjjYgdmhyhGoVTDEWez7NmZW1-xlZMNp4XywUpGWf-PdjP-CxcPjjGWtg00pTyF8GYMlJKv9A0xQPQgp8EJM8t_b95kZ6WM7ou2EITWARBV6F9-uvJvVOO6DPFPW4GDwkjaGuK7uLGj74X1bl63jcZNJlAMHzJi6Q5DiMMM_KCouHB8SP8DYNLA7N_QTNJvepnTf5YHWzw9WV-WjxGl5avf3Qp-V_bytxg61b-UO2nUIphJB-xvnyXAn9NvqTARyStvqn3IuR-dmKAwNaSoz_Yzqn8GFaAM_Zn-57p9PDySYn9Y7wbIu7d0cqr88KeRbjKG9c1dSkODQaIwMxWrmVqcqvd8XXku2y4FwzgEgRF8-iikWx_q0EA2aOgF-7KJ6cCX5An5oaGntXfKLJLCs_sVaM4BaSIy', `SearchKey` = 'wofCpMOAw4DCtMKlwrPCuMKDwqTCwofCpMOIwrDg8OQwqCwofCpMOAwrDg8OgwrPCwofCpMOiwrDgcOQwrPCt8KDwrHDnsKsw4zCucKdwqPChMKhwoXCvMOUwwofCpMOIwrDg8OgwqCocKDwqTCwrHCisKpw6TCp8KzwrLDqcKtwpDkMwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw'
# [12-Sep-2025 09:45:54] /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
# [12-Sep-2025 09:46:00] /finance/root/bg/ajax/invoices/form/clone/10457.html?pid=10457&_=1757659560320 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10457
            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
# [12-Sep-2025 09:46:05] /finance/root/bg/ajax/invoices/insert.html?_=1757659565490 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 81 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` = '2550', `Language` = 'bg', `PostDate` = '2025-09-12', `LastUpdate` = '2025-09-12 09:46:05', `Type` = '1', `ParentID` = 10457, `Data` = 'wNAgoUYm1lSjYxvo3LQx1boXtXyNMwvBgXZsdmrOM6Pxi6I2xgnq67-dIh9FAltmu0gohWFxX0mGL_DgSJtHeimk29zfBFDHkePsWWhq8nDCr06pEysC8Ve2rR5rhLu7hJy8IXu5WFhaTV7_lJ8yiig6eAZ7QPcqabYbrSRIrH6F2hq6tdPwwI77ceDlzQpFXAtvtKxUfL4TyJwYlJe3xQXiHyzRLjoCZNLtMRUq4Uw_dsjFgxzx2b1KbQIGiGSEXfTPRmF2rimaKpeYLTGVki0c0xpcEKeWrhbPjZ1aDy7doj83r4t68wVvRkTTyrb_8jvOBQrVyoqs9r8_SQC4aR_gSAz7HNSjR1KhKJ3ityf7sfOmS_yOF9y1a7vF9spCA8L3WC-rqjw7y122i1326hKgKnmHJAT6YTJT33yFBaYKtjSJyYte6Cq5BQ3T2W6bZV6T4Ff0SyWBVaUXw9l4bk2lmhZV1kVh2h1p_eretQzuHUwIq-M7tgRXML-qRmCc_PZp0tNSp8n4uM2k7qdRHU1OhYgIjPOaA1ReAmAJB0n5QjhNxZVD3NlSxxK_USlAKE0BKiWl0oMO_EQ4NYrprDxzCAH6gWcU_45pKATGfGIIfqHTSl_cGbd1hXp4NX_vjytb6zVwgM22u2J3hv9eYVxaz8uwW64ds5CVXVKcyudOpKpXAZvSUVJzNBZzshhGLP15X9QO6xxlDRTIlAmCk0W4OgRIGUT08PACL_rjowJtVMmSkPosusvHM62M7iwB78yNBGBZi7qNVAUmVRoKxR2cvkt4gmiggqEb59xYlev1Lem3mzXwX68_M8t6m9fuX97liuGxVccz3EWWZ3wV8-NqOV7m7YKutg2gAw4MBYWjOIRUDjv96I-9gXBEozGWgYtX9-ydyv-GR-bIA5--qmb_O04WOgUDJ2CTcuV3waZZeLQnr6fYMnJO1mv3LNf7p_wYEJSFuScCp-akbLExDNuNc0Ws3l3jf03wzh6HkUlHGIXMzDOkR6OwEWTNrcWw', `SearchKey` = 'wofCpMOPwrDgcOQwrPCt8KDwqTDnsKrw5vDwofCpMK0wrDg8OQwqDrsKDwqTDhMKrw5rCpMKdwpzChMKhwwofCpMK4wrDgMwofCpMOIwrDg8OgwqCocKDwqTCwrrCn8OGwp7CrsKewqXDnMK1w4XDkMOGw4fCssKTwwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8K'
# [12-Sep-2025 09:46:05] /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
# [12-Sep-2025 09:46:16] /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
# [12-Sep-2025 09:46:20] /finance/root/bg/invoices/2549.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` = 2549
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Sep-2025 09:46:35] /finance/root/bg/invoices/2550.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` = 2550
            LIMIT 1

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