# [02-Oct-2024 10:31:42] /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
# [02-Oct-2024 10:31:57] /finance/root/bg/invoices.html?from=&to=&keyword=vizitka 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOcwqTCrsOEwr7DpsKsw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Oct-2024 10:32:06] /finance/root/bg/invoices/2307.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` = 2307
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Oct-2024 10:32:38] /finance/root/bg/ajax/invoices/form/clone/2307.html?pid=2307&_=1727854357779 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2307
            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
# [02-Oct-2024 10:33:02] /finance/root/bg/ajax/invoices/insert.html?_=1727854381701 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 14 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` = '2350', `Language` = 'bg', `PostDate` = '2024-10-02', `LastUpdate` = '2024-10-02 10:33:02', `Type` = '1', `ParentID` = 0, `Data` = 'JIFLDdUBdS7FhBLD4hYUox3Xh2ospHCnIv7qkn1W6JuY0VF3KcyjPWLZS3XE3NI-3UlfOvP-98_R-LX4rND5LiTto32wvFIpONrH3jZCGM2fhkXQ7oXU_l3aSuPFimo1L3jyXLaJImDJYOLlv00XPmviL0iQN3p4sMma78EUTMihb0e9s9HOJHMJAY0PBmZemA8RSlcx51x-9EHwjp9dW9Cn2QeeYRELzRlPBLyWiYaAFble4WgfTPQYQThfrnZS8fYZwJVpv42eOSMdwtE6omOBOmC8dVO0TC8WgiRaETM_DAPsVJC6RETNUp9nJPxmlo8pmAw-pNRYMlXz6m_Gwzdqmssx9FC9gTWl-a4VV9y3-vFACs2rK2Qi5NyySnlOwLdLxomS-lHMExM2_nuST7l_V83lKhkp9N3SDaeOX049k8Qr2wsZ7Q7GufvdYtuUP0pkMKTJoygWYZ-9i_YfQgfU_nDTacmep2HtI-Tz-wxP4vqmqNqjg1YoaUoPhTg6mCAsbJkfv-RMdFWai4LQr5zqcWt3u5EzdHSH26EaVhsV2eJa4vYjn4ud52tTnXd-L8J0k2CfRj9jJgxE90bBNGAA6CdErg5aRG732njDxOPSDmLULfSxhkLakvTqhBXj-yoFarX2A0QWZ5aE-CFBMZ9MJZghrlxHs232kRv9KfDrmJ7jec0DZeuGlmm8Fx5nPZYCYGMdi_Jnv_ilqKj2mpi5qXOtEPhSBcpqscJiGveD6JZGHgIhwNk410Vu-6uMM73haW_sxiUFtBzR7-K1jmD0ovBp1sVEtqcKsTeFkAV9mkdjt6XT2USozsCRK5gcQoWdgsVevrhDV94xwVFWhvyXG-w2duveuJw0jrt_uJM6iM8fiKqjRApSrtXSu-Q4vpLyxT0Cmo8PiOkBZ0883mrOusIG4JX62GWkp-Oq28S9RV5upmFIy9qNB61_Y7l8PbZMUHiimlEzHhWHg4nqVTXNK1_Jv-fSc4nQfbgp8ibi2N31JN_MZciaViszLOyalWl8BmCV9CbSiXwGP3qV0kejC-PP21uoW9xyPTMp5oASYEjM3JReR35VXY2eMFAd', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwrvDhcOcwqTCrsOEwr7DpsKswwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh'
# [02-Oct-2024 10:33:02] /finance/root/bg/invoices.html?from=&to=&keyword=vizitka 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOcwqTCrsOEwr7DpsKsw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Oct-2024 10:33:04] /finance/root/bg/ajax/invoices/form/clone/2350.html?pid=2350&_=1727854384347 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2350
            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
# [02-Oct-2024 10:33:13] /finance/root/bg/ajax/invoices/insert.html?_=1727854393021 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 14 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` = '2351', `Language` = 'bg', `PostDate` = '2024-10-02', `LastUpdate` = '2024-10-02 10:33:13', `Type` = '1', `ParentID` = 0, `Data` = 'Qem7i9gDeUtW2bzawIprfC3DVRH0LMkrFROjkMB5BLvNvGf3JkdZvlZR2lstpMhK2Bnw1DB9FpX3c2Rq_mVZQLCLLNTj18z9c3bQy9FoUOOB6733-AWuV8a3rgIavZstUGV8yztRV0rCofwwh-I2pVgjZI2bA2rHW4FdI0Pq2MscjSeQCKnzoYUrN4fYDotJ5vJGXIP9k2mLWXjMItl8hkL8EHj5Brp_S_vzXlYn8t6lIROVW0c9Nu118puewLxhX-PUxLLHeFa2hU-13-8wlvnnoRrnRlXipViQeaUTScNdG22VAxiO2u4mLe9hvDmGQBR8epHzc7_DQ9GFN7lf0NcEActEHj38SjHSoO4Kgot0dKQ7jq9velYUxFcGf4koqstyWhgxPEQaHVAYRvCi702LOEv2k2Q8UJ6U3MOFJhJzyLsjp0lcJy0prd7rtMR6zB5NdxbAvRCv0RZBnVehg2VpMAS6B9-dssdAxoKANYIz-naGJIcitS85dzMdPviMm0PJxEQcMyCyJE9quMFZ8d5sEc59Y3U3ImqwG-XHQ5xHhu21-A3JHoxK-4Rzf9P0sv7q_0-SyY_PVWAkeXBreUudXFvxDRI7lKtK--sVk6Iv_gCCmq8BjeyhDhHG6zCBt6ymUWDHilAAAdPQgH66gFho5pfGLQeEH832hf4eNm76QvpwpCfYzTphgL8cP49NkwSh-T70NvcmP8hkf76GsBWlyxlvsVk97S2VB_e0jaJkBMaX1ewUGkJbeCu--0UdUHWN1fVVk7dSCUpesF-iLF7QNoVn0E1GG3VQz0iLF-23LkvPihQRdzffm_CbLLk3dFywhnd20GDHtU8Hv33EUQhcGkIqh2JujT1lNhfd20hU7jNgh6bCR9iUdDD6mnRYoMt3XTXbIwOexGYQB-iJrNkpycrXYtRhMMWg_83y8OcF7HByeMzw3qTl0QXw6g5M9GuWbVPP4Wv4rJWeLM3nEtLw6ypFYD51vywSLoRsoxWZhB_a9XEqI-5X4CMmixOuoaPbG93sDDU7KKNnDYcjmThcOpHISvWuOPzPmkmcTAI', `SearchKey` = 'wofCpMKjw4DCt8wofCpMOqwrDgcOQwqCpMKDwqTDlsKsw4DwofCpMOIwrDgMOgwrPCtcKDwqTCo8Krw5vCpMKdwwofCpMKnwrDg8OgwqCwrvDhcOcwqTCrsOEwr7DpsKswwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfCh'
# [02-Oct-2024 10:33:13] /finance/root/bg/invoices.html?from=&to=&keyword=vizitka 167.99.142.201

set names utf8

SELECT * FROM `invoices` AS `Inv` WHERE `Inv`.`Type` > 0 AND `Inv`.`SearchKey` LIKE '%wrvDhcOcwqTCrsOEwr7DpsKsw%' ORDER BY `Inv`.`PostDate` DESC, `Inv`.`ID` DESC
# [02-Oct-2024 10:33:18] /finance/root/bg/invoices/2350.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` = 2350
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Oct-2024 10:55: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
# [02-Oct-2024 10:55:57] /finance/root/bg/ajax/invoices/form/2347.html?_=1727855757159 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2347
            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
# [02-Oct-2024 10:56:06] /finance/root/bg/ajax/invoices/update/2347.html?_=1727855765889 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '2347bg', 'nqaSLh2ePyB-57znL_tAmbtX5yhq1ZPnRsR5MBegLSCxymCb2pgE78B3FBkweK4UfaSduZisu0xNN5eFzPeZyJVmjKndImr40QD7yGcsx8sBXxJu1IE6ocABfLc8w1MFJiHZDsWp5Q6AAo5E6_e_jh7N7sP9vQC70EYOjnLUJm9VnPjkr29wZbFVxwhUXxBxWVuVW_xRgesrdFP1ndP33zXRFNb2hPHVhwx_6OUxyPoadfOC19Hedh6mCc_1pVKNiOUyCoHDj_SQZiO8gsOdv7kNYtpJlYSVz5jS0ePYZWcKZfB92opjrXygWUGOhRpYhB9ycOOj899zJ4ZWdnGR8kltR7HTNz_qBMbBoKWTxIVJctbs9HVwiOLNRT-C_8G7PbKyobNEcULCEXcuOQcyKQ0XXaTK-7CeJ8psui6TIZr6TZRLA-tcRNykuND57ypCVkMt1jNXuKCe8a2rxswQrjpjJzWIBnROJvVevF30v9xCjtQuCdpkEqxDSXg5kNUG9hcCRcGPx6bn3ZQHx1Haycjlbz7iyG9bf0joMYPYseS8ZcwVDhszimz4ZZuNf67EctEzNzHP6jtzPWCf-k6mFRrFTIaCe1138SIkJtCJQguK_sgJ3omGtf8cXVZtHU_lvfNix535GSFjQtDxnVMwem6mWs06FbmIDAjXewLi0VNeB5OLwFmrxbD83QyRZgJkLUq5ro0zivRGF0G011eG9vpaor-d1rgHj9lIq6sb6h_XblXcQijoVm8-Kd689YhekiRTho9GiBSr5HH3lA4GZQMO0WY8sw8JE6_Mtrzr-4emII46osiL2rfENCesvSL5EejwUynyyGkCz2s7655gaqmTQFgIz7QpJ4H22VmvDxFK2pBj-P_k-FWYpzdDsPKhMqPL02t_Q41JFaRr9dGXgzGLc7dDLnsXRlIR1OiieRPiAECgzO3LJugVp5ay58AiBxA9_hgm0xEZwKlLEpIWNrOK5NtTkLeX_o4DhDmuPdBffOIxupx0lxNtsHH0HU-cukxqp0KjwUHUKtnFKTM0brXdKVvT-qBHYC4ieJ-Oh84dVCEEyP-JCPvBTvSQH_xnKbnrIfV0Jvd9Zb9oLgF77ONfU0BuFgDgBNURpn2wVQePmJ6N-jQMRKrIqlebImMD9wToJFc6VM6MGjuiUHlRZt48WvBAOXQVEKLYfM0JTmGGZPt4dnCwrqztIyTSJWGRxgpxLCDy-5ekTcpoa9WugMMdZkILe34UYrx1u1Cdujn4YHzZ5X7qzAK_QBmnvOy52VjzEz6deB0RJj8E5OVgN7lLJ8hvwza5FfBwcZLqxfpNiwisImcxJTqvrNoGoOFZsulFYSiIOdlRxjLHyHFdelHNUYmOhppTkVodXaZlSbSXL_sqR5xyN6tiAC5Rc5hfSWAy0qa7ltdbiWZelYvBv6Ii8jcv7h6fMvvDejy36aH1jeVPpwvPZ-5jsgH1zRpoCAtMj3YKrOcHhAkczuwZ2BRRChgUxsdmgFoD9sW0xfXcpU7zd2jsv-zpBMK7mVTNJfMA2ztbWA1iEaOXvQ5U1-IMujVtVEDOrP87l_gmBOX1g6BwF2HvfgGMMHRWwLngL7u_pUJY0LZNuPvlatMKVf-Qd26yl2NAx4URIgr88mUsDtfYJZ5og2j3b4Wdu4POTJ9C8U0QvoJcLAF4vIvJTnzbz-h4Z8S7hEF8qAdVQoU2dMQTooA50El_dETnB-9556sNrBZkgrpjlbP0X2095xra9QLwDgbe8fhI-fKVdImuu8dPuWZYWdKkSPGm3w61M8kTjaagJVnko6M4bobgPbfk2ENQ8DoGRqiPj0U3byGL5bEzLPsNcrFOk22T7p0Y9hJBQPO9MVZDzQhk_7Gbc28JnJAjCdzpVxKG3hkQt1J3V9mTwaecnjCvuM3YZ-dizl2JGTutah7gXBr80SkvsgMKpkHdr4p-n9SXCEnykVfGeLplmmm6ppAGeqabPMPDapAKCgynAkbzaGH-NYnWFsQd5R_S5jecjVH3o_B51mq9hj1U92SCOkNuPSbWa3Is')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '2347', `Language` = 'bg', `PostDate` = '2024-10-01', `LastUpdate` = '2024-10-02 10:56:06', `Type` = '99', `ParentID` = 0, `Data` = 'IEPHqOqRSyJxDt0qcAjT5zFd_8D0Ku7hdoXHzXk7GHDk7RTPoVoRw-BPNwIXNVJqM-B3HmugpIz9V5v22TB686EI6CgSueULeaR7Ur2_hLSX0kOWYLvism43XVtEOxSQdsvKj6FMNj80IlGwFUc5QGNVcaKniXxuGWTC9kvR95c3-x7b2vfN6WdCYLC1Ba4okMb643oXgYZabNPnTIVFH8G8RcKPlElilLvblsIKhqQIUGHDwDUFmU74AYmyWh85_oBhSDtAiHV54pWVplVsOgXDP8-rcdmnaaSnJWNVSAvVlALwCDTzBnMBsL5afiYyf2tPRL7ZuUGzpDnd95fuVxRjaFxorvcZO0RYMQ6wt95tbiEf73k_8TYNcjMuDcjctTRuHzxVgzDQjZdlBOJgmlNq7Zf-91kVbE-SM1yKMAN0JuWDNw7RMeywMD_sm6yxTttNGhvvFSC3PogB8WlrbLtEHvsFyX2ntjaS4Hl2G4ezNkvWlMBTptlojNx1R2f_OMqCpTu-Z-GDQO89QcqnXzbLgR9earmnnxSfBqKcaP1mixLk3XNxfq5s19O7ZwWvzDlCfUti_FcChhlkBRWo0tWoXhUYkB4yvvK2So__Y_sx2NiZpocviTAwHBNOsqe7sNYtJy2SqHXs0AWJWE6MfJM7wbBPjOIbGsC-7oba_vaIhk3kFdtPhO-BlvBYQXdTWxWwpaH0YTMlYMqW7D6VaUPpLgnPOFpbWQn73Q-ZkfcEgHlvulqQkrdv-eYo4WDJGRn0DfFYsMPvFPQFVsBvj6Oj2WCpaJYlRK3EeUL6S15UXE2kKxlYrOr84ucHZ9o_NdXTV_kKii9-rg4lX2_XeY6oBsRhe7daw2KLb8mZcdKaE9Jv42VoopV1VPnu2RwQIEC55hM3TStvgvGhJrgXFmvBz8O4AkbNvaet7vlKRHkDYVX0UrLdYYk26O4M0cBsPlw6JNw6Nrye6ooyP8jZmG4YWkFXvrqY0Wt1_n0IH0yyg5qsEXuKhiCAr4g6uuBkgyTS6q5S0vsOnWYdsGLmDf6NGY6VeupdmY3h1Z67wIq0VIe94h4bP4ymLIf-SvyM', `SearchKey` = 'wofCscK4wrDg8K6wqDq8KDwrHCsMKsw4zDn8KhwwofCpMKnwrDg8OgwqCwrrCisKhw5bCsMOawr7DwofCscOIwrDg8OgwrPCtsKDwrHCuMKrw5rCucKdwqjChMKhwwofCpMOEwrDg8OgwqCrMKDwqTDhMKrw5rDj8KdwwrrCi8KwwofCscK4wrDgcOQwrPCtcKDwrHCuMKrw5rCucKhwrTChMKhwrzCvMOWw6TCiMOKwp3DjcwofCscK8wrDgcO' WHERE `ID` = '2347'
# [02-Oct-2024 10:56:06] /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
# [02-Oct-2024 13:41:24] /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
# [02-Oct-2024 13:41:35] /finance/root/bg/ajax/invoices/delete/2351.html?_=1727865695803 167.99.142.201

set names utf8

DELETE FROM `invoices` WHERE `ID` = '2351'
# [02-Oct-2024 13:41:35] /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
# [02-Oct-2024 16:34:04] /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
# [02-Oct-2024 16:34:14] /finance/root/bg/ajax/invoices/form/clone/2329.html?pid=2329&_=1727876054059 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 2329
            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
# [02-Oct-2024 16:34:34] /finance/root/bg/ajax/invoices/insert.html?_=1727876074534 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 68 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` = '2351', `Language` = 'bg', `PostDate` = '2024-10-02', `LastUpdate` = '2024-10-02 16:34:34', `Type` = '1', `ParentID` = 0, `Data` = 'aMi8bYpwmhvytURVdY9D6YpgrHeJh37uY5i2QiygrtBlasLBebxhKxLkRnV-Abj_idvB8fkA_sltJ7XNdlAlDsegzS5nNaWfEPynqV5ZBa7mQDM7DHwtc1Uldk1tvIxzlQTYJHXKQYSAlMOJAue9AH3i0BklurgDDaRTO32-Pu2ci9tg3kG5Xq-Kp70In50M8xL9segkvu8f1PkQztK7dbhFesnW3XnXD7DRrOIf7O5SWqysGDh-arz4HoyxRhKdVK9l3GW-GxxvncWBOCF2let5UQldRGd6FfQs6gxx6sKDp3q2T_4ohdxpEZRyOGp5lEeoYjue6zRyXRzo0OuwaAePINDf5eQbnvqg_2Qq74wU7FORfShwWtSgEP5Nh9MNYQ_m0ULj6P_DZ59fEDdCiZKo6Lys9dt3c0B3IvrvvIh-iQKhe7v85n4WFm3DPYT5gAZg20Ez5_50kq9NbGx3P1m0pS9jcQ81dwRuvMABIC9HlyzTw3YEnA7s7ueowuErXhtcSYlxjmOg95SQBXK_TjE1q7k7F8VYuGlYZFj5ckdieArX3Fc6aYAkyiUW9lY1aXYAHDpUZFwu90JxWQsqk89rWVf1LharqPWumc7m3B_OuW1Jj5u0nu2wquM57U7cH0W7VmFtx6eaIe6Eh0VP-Ed2r6MPSi7Fti41lektCsHvyfJ-JRHK-dYLTl160SM26WuRcHzu_NK-efyC0Mo4LrQLVvh0-r-IZ0PgKl7IQskWEPY77CeXiioXSE59rk_rfZVniqW1nFA8r2lKwGLYcxnjM6RYm0nCJCWG0gLFYb7Rr51rZ4YQyTPJr4Lor43k7GVrEYlVfV8F-fmCKBWbx5IpcmrVvBK2aOJYcMhMxtq7wFbLkURnW6s8bTIVzKJY0f8ihiA-DkpmffpB8C0e4eeRA03KVgGFEIVm_LBbyUtmxjKJn1FLxVia7iw1xgfFrvg2ytDJuweovszo3MfsWH6Obu6oW1bRZnWNDnMyblo', `SearchKey` = 'wofCscK8w4DCtMK6wqCqMKDwqTDnsKrw5vDn8KdwwofCpMOAw4DCtMwofCpMOIwrDg8OgwqCocKDwqTCwrvCoMK6w57CpsKewqXDwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwqfChMKhwqrCvMOXwwofCpMK4w4DCt8OgwqCpMKDwqTDjsKrw5nDj8KhwwofCpMOWwrDgMwrHDhcK2w5jCp8ODwrbDqsK1worDwofCpMOWwrDgMwofCpM'
# [02-Oct-2024 16:34:34] /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
# [02-Oct-2024 16:34:38] /finance/root/bg/invoices/2351.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` = 2351
            LIMIT 1

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