# [16-Nov-2023 14:51:26] /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
# [16-Nov-2023 14:51:28] /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
# [16-Nov-2023 14:51:33] /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
# [16-Nov-2023 14:51:41] /finance/root/bg/ajax/invoices/form.html?_=1700139101337 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
# [16-Nov-2023 14:53:20] /finance/root/bg/ajax/invoices/insert.html?_=1700139200002 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 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` = '2130', `Language` = 'bg', `PostDate` = '2023-11-16 14:53:20', `LastUpdate` = '2023-11-16 14:53:20', `Type` = '1', `ParentID` = 0, `Data` = 'A7iLe10l_wES4w97FEQMeLakhpaVJCkmK2mT9yI0AbrluUVmo3IqZC3s6uILKlYBV_Ci2Hy2rYGM97TIlJyletgyUXTGH05p450bQOPQcjKcFSIob1qr8C3xcevJURnIReWYYPYC_2vmKxIvPQqry3tdpvqy1AILvLubqxMYsF954FmFRI-vvZCtpW_IbXXUOAxGdULnJB_5SysnRULhcpjr7nMc4zbDrFTBQZZ1ercJf_6EeSNQunIxR6bSsos-kU-_tV4kCs_0ObTLY_xfKiAVIciCk4_dALcPkxAIIoEsVzDsLSGxwJ8twLFfeF5x-b090-xIgLTR5sFOKkR_tQEyjvkhs_ayA-1ZKFRuc_Uhz4xPujuaPwRT_Lf8nvXzA-oNb6w0QxPKdMe6b_GT-51HBXtjewU16kfBrDHVtpLLFS9xm7qu78Vkz8uMSf1xFUrMxzR2SE6Hs51EU55UDMrOELJFbOZlyPlKqIdbqpg94lLd6M0Rt_dhxJ2uk8AJ5UzZtfQrU4tDUGu92u8JQQg9t6YcVieIYQ5hB5qcrsikKJlfBsYxCbWurn7EUzCtf0HQH8pFWwFImOvNJX8wQa2ibUm2HtCC_yUVOoy4Z9nyqpOeqR51pZ5c0xUxwC5FKYIhl_2EmigdcMQN5L6WwVrO0qJI9qHMigdiLR6wpeeACcjt2VadEDLXYxYOFqp0p-aIpGaN8XvEr9De3314_1Ew2ysACwa1zR73K4HlRG5X71uPYzhF1owgjp_qy4JIT9Xhh3QcHluyNjGHhPXEwteCnkmIqvjJROalidXzt_MkQ6pPJu5TyYtDcnWOKIAN6iVH2KbELUX0bM91ez5f486yjgj0HO5Faxo3Y1z9fgF6NEkgdvNzkqQXW7EGxTKBNhZKF9AHBQsWpaNEc7krGR0mzxcAnuPoXKqrRVpho6p81QAhNXDgioUkukuTXyqsXUSzUKPHO_ZwOilezfER1E_qjjJHbT0Kt0Ng1oubUZJmZH6CHYxe3OPVzhkaBjQhM1WOc8OHgNZaRmMjNK1YyA', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMO'
# [16-Nov-2023 14:53:20] /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
# [16-Nov-2023 14:53:22] /finance/root/bg/invoices/2130.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` = 2130
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-Nov-2023 14:53:31] /finance/root/bg/ajax/invoices/form/2130.html?_=1700139211879 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2130
            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
# [16-Nov-2023 14:53:40] /finance/root/bg/ajax/invoices/update/2130.html?_=1700139220168 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 2 AND
                `Visible` = 1
            LIMIT 1

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 1 AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `invoices` WHERE 1  AND ID = '2130' AND Language = 'bg' LIMIT 1

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2130bg', 'FIOapSSfVRVdslY7ED2UKfkBeGKBKck3SSCmqz5sExvOHRtnw1YyHbnsK2dPQ3Dc0BWdqNkT8_6QkjSNiRtNgpJ68VaWfdSWlMrkeutNg1rm2Q2EMDVrd6yHn8WIkT98vob_394I2nIew2CCk8b48nShRG-JZS4Cy3tXumEfT0fvUVS9PEgdEh9FUGpFXcqM2C4XqPoZvYTWVQmvTEkSFTdZbIOcPQ7ayZEqrNeA5rcoi2NLpoe2sm2xD74TaFmkhKBcX4lfV6rGcQOwHiTAXnbCxbKd7rxo-veEq9b8ugFxr_xf1E4Aa1AT9mdLvQbdpb5QCquc389runTEltW7k1tvXtXodifiRn0TpZ6gkOxQOm6zTnzcAKnDWDEQgYAJZdD1WQXSN6kVs8pSEPOoAyQOGHiZ2bRpnuGGSW7R_ukdp5zvcjJxsaruY1l77FaXkJUcuoZgzdjQIV_9Qv3tfM7Fp4HfUHQqGmNwpJ3eMMukezTExXttdfg_YJc4J4yhbHmn5zcSvrQuYaKNgd6jJ2zpXcwLs0EwXolXEaeU1o-tlYQUfmLNruElrT-nfA1UMrOnql8sqJsd6rTiPANDf25iyZiac8oG04D9pbguiuUY4eDI86u4nwy8QcgI__QNfFcBEVRuJkF18TSqDffOzqSaphAC6w1zuqInj9yh33AYHyCfjNETKXTAtvcX-6uIweXgke3J_I4_yOomz6NxuvbvLJtNWxBB8pFlVmUxXBi8z0ugBHrAlmsv5pZDJMHPRYgR2ZDl7YiH93ec_AnPkYV8d9EhIl-ULwLJjn_0SBEkVI5D4EeTjUuvou_L4IKcejpasmi6gidWMMGAsjkWP7r6i15kIscXI3lernkVxxwuS8R1rnLRnmnf424VvVUSzCsFeZRiUz08um3uQY0PrMNOy_nERgwPpfZK6slsTYFq743T4IknqacGB9mYBaAPdh3OtK7xqy_-xf66RCWCjDhrBxSb7QNJvMhDnW40ScH2WGo443RotVKE5guTtjHwF_s42aXYqThUYZ0PetKaa8yWQadzXALOCPadUx9W-6GAopC3hddIPFgAk-SJonxFdN4yovneijCCUjJXjpMt1U2912CsqzVtTZi0PtdY9Cww20EcKNKQ6dODambEAy0-pOxM6FE_XiejBi6QxClzmSc-U2X2bA6-YXCTAywRHPRqfY9DV6FLkVwCbdCEmRAhmRVgDPbK4-9P4b_m3srVXhmcXqI6E3gACyFPU_54SK4u6phcWvi2ybunwo_3A3Sl49QIzFJWujy16Qnpjw04d9qpcwkYfENuyMf0xFYJ447DKzbXh5NbKVfv4R_DoldjDJ5SgMAsP4utrU-zaMirL8s9BdjHFE0fGS7qrm-oKKTHsR_xtQpVAZNsVR6xqVuee3jL628rNwdV-uR59ypli97EANJUdghKUWrcVJP0ROqArA3Eg3vcd19vsh_n89zPSB1SSzjjQ2e71vuKdhimjMXyGKnCtKRh9wDYbLs1u240lFvRaUh3iL8t99vNl94LKIvo7QBDKyDrY4N-ZtIF8RrpqKax9HSzzV7_KlaqWzXStF-7-51Dmtay97Q_pF3SSAN4_V8c6_6BADRtWZPRcZftvPbgD7H1Z0-tn76TQPPh3ekqYCeHBloJgaiBbxY5MUNPNr-pbZvMFEyXp8gSbPCtd7qP9DXg4PMzz-nFyqeWdGkJ4nkvs5o5aGBDYpbPlrNlLE9CWTHnOgIGrw_ZNaTxcGAArKaxTV0mAvP6cJJ33ytiwIXmTyxZkBTASDdceQ27CbAuAEfZEINSz_7QwgzED4TD6_jIJjMOY1jHat7N1yIvbqB90AkhRPwDVAogKZJNvsmVISAJFnwWuElh2mTY3c1Nbd58OZWg6lmlD03bRJKDxSa_RBbUDUex53RgYR0aCACv-67yihveMXrByArMjkv5hV66ff0sAsVni5yAoiUYS_rwOcYZsdtAOPcm3t_scFgCSns4qHnYt2DLiQ')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2130', `Language` = 'bg', `PostDate` = '2023-11-16 14:53:40', `LastUpdate` = '2023-11-16 14:53:40', `Type` = '1', `ParentID` = 0, `Data` = 'n9C4iMho_0N89Xwm7R9famvtfKWzR6BX7KR33PT5mVpE3PieFbtB8trUasjUrpoyUwp6QsYc8GEXxO_9rAGYAVXSCLu_m44eTwMN60tuxhpgyxWn6679RLXXQ_DxfxHN08CIsZS1gNBPxMEHiUhD3r8UCfF-T4zJGT6QHy5ZvUm5BjAEBYffrWuKnMhR_I1Af_iqmPYyw21XUMCk5uO-zb8SkBQ9DiksOMb-pXNzikBrgqfNhtfwwemDMYXGzZr0QLOaPzioqJkTuifNVxNNvq2o4dwxYCGuVFCXf9DNreg_xMH72P6m4EudJ7wzG1fpNlH0Z_P-YkDjddOOd6LPsh90ibga6zynNLOlFiIuzyvDtpFjCD5GdGoTSlZoCYlRFn6A03hbG4QLsCwAZDLhp_NJ0BM87c574XTPJedLXr3WmuyK0Q9UOGB7lQc162waXITIZbYgijushFUg9vmGCefHUHaZbDb5RTKOBok_XS82SMYC2TL3RRx9hmwM1NTzEcSZXaAEFPNICOK-AilSyUeFbBmxL64dTMGo9Chf2bzLzhQ4O7L5TtYhfApq4BxTLGadeaMGiVAnNFGqYDbm7e6vvid8cgb7MIOC-Rfz-WyYh6pYoGMmhvD3Pg8gWpJZM3AI9qH28p6zCPye3CSh7oKTXmsqsaEXs2EisRy7fnLkIq3FF8At4HKnKTY5qy3ZMgHe8Fdqvh4YesiBaN5Fbv8vttrn9dpxtK1Z6L1ZIZLQrLV5dUbzR6hwJkboq3PoKBl-Om5qmpj3wVHwpKchTtN3TZzfyLhTutoQjiiHlaYbz5w1DoH2eEBVpL0w6YAlRgNpl1MBsZEos2-yH-HnxIENZPuozejFHlY5MorwnRdlMxsv0zFaz8WOJ29-W-RL5MDOr5tzfZCSPGOr5ICaTVRZP7YY-CjWrfATHIKJFpnmHM5aa5HPitptXmqAetFOeUtwTWkXpxl0e0_NkrHZi_NJfL_z6n33ys6tpLhci3Mw6FfuFTJj6NKBbX9ptIQroAIWqKqxg59RMWD3mOM1xg', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCpMK0wrDgMOgwqDq8KDwqTCn8Ksw4zDj8KdwpzChMKhwp7CvMOXwwofCpMOPwrDgsKlwqDq8KDwrHDmsKrw5jCucKdwqjChMKhwwofCpMO' WHERE `ID` = '2130'
# [16-Nov-2023 14:53: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
# [16-Nov-2023 14:53:42] /finance/root/bg/invoices/2130.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` = 2130
            LIMIT 1

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