# [11-Jul-2024 17:52: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
# [11-Jul-2024 17:52:06] /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
# [11-Jul-2024 17:52:12] /finance/root/bg/ajax/invoices/form/clone/10418.html?pid=10418&_=1720709533411 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10418
            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
# [11-Jul-2024 17:52:17] /finance/root/bg/ajax/invoices/insert.html?_=1720709538271 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` = '2285', `Language` = 'bg', `PostDate` = '2024-07-11', `LastUpdate` = '2024-07-11 17:52:17', `Type` = '1', `ParentID` = 10418, `Data` = 'L4PVLDwH3w5QSsxCU58UVqdmP2oksR8qadJqZqpMD9jBfxnmHv3IGhAvVS_u13R8uvlLKXI-t-5drJyugPpMYco4WQx6hwuyAtLbn7Wy1sAneXThhK2PKtlRduyJR1K0ct0gsNxQ5bBSeOtLKcONifl6ICaUT4hVQou7MN7mfbVyCXlwWfakyLuOAa8tzW3Hdilq3bTgP36wSSI9qIVeV4bLeNlWIeHOb-AJA9NEIjZzpHINknYLO55ft6E7PNLjhap4zSVugFO74K0hzqjPjzd6aJQxwDD3Tzs0-ej-5uIfyvcUjhpIcmGGTz9hyWVPFGmZS4eFy4dE4Juoo5K56Of85JGSqbkTPxXhRwFd4SqDWqVNzYlPle7zukDOigWrrcaj3RNmCNb9yybKW7Pa-HjHjC3KG5KwD5cffZx9WwgTtqAo43IIvfh50LwNfDuhxwysTRH9VJKxI5tQ2T-pqEw46cfzmwphHFnEOyFR_GRwYQqPpiurejY0O6AxXmztdBRGWDafYedyTx7qUFC8WdDCG6GMancUckkJXl_IC1ab24UZCy07--KoTkAqOXivuPu7-H48kMo3F7b1ypNS4hBXMWrfDgM6j2q9WCAWW_ZBbJZ8j0caeOIHYYz5iqtsEKTFRted_Y55ziAAmymWw1kiDBnT8LcMxUSROSb0USPtwS2NmFuEZtAk1N_Fp6SP3tVfUcDsp4ERQs1O23gciRVu5mXKkmRl8szOgMr-EcFBXVUvyoxrmNpvfXImvJaw2cgD550QTHfmdsYjU7YRHnI6v10YX6CcTO7TTbh0KPfobpHJV6Ow00T561NO0RISQZuj9ADWIlM5zFzMkIcY3rVRhMcjvt2DHzIuAfg4rrcU7ktnHyr9BgREMJ-goPwyIJcA2SUXnd6bmdCerhqLGhquCcp3sAORsLqYU28gwDn9sy7btToSN4xy5N8X--l0PDoLZS4Prycm8tPjgBOnuXwVGbXF3r6GMiBLp30z62x4d_K4OGahuZI6vtqg9sJeDljNKbu6SGBAFxUcmwUdzqNDA2SR0r7XfRAYW_nCXOMgEqlIOeh8osY3juS8fqfZjSfMeS8YUfvqcVzVJq0nHpQxSPUWkUnFHe_HTAj8DydVhr7RLH7H07cDzIEZKUOqbFOjmLFJm_MZQVnYzVca9gWalbOcTJ_X7vt_blvQ6YGwLNYKTJsGYKQ5ts9sanHSHvKFaz5qmS8FNp1NuLOupsqYl1aZZITWzWMqICJCYbwmx9UfaZmmYXiZjWW1wAgF2l52u1P5mi2MqnZxDu-J7bEAzKAjy0e_SPJodp_8dV3gRqs-6OjQMa3_x6cM6c03LJ1dhCxfAfX9k4bgbloi8xDNYqgz_8tFE4HLe1jUTGafehwCuH7PSUlMs41fdM8LX1kMZoYfrpERKnvFGWgJCGKMhG0_e1L85XjNdka0-aCofz_3OjsUotzSw-Pj1l4d_w7_qY0AaWHOkeRjLf0BWQMW6P1XL6B8npXAoqVcex3VjYgmr8_M00OiFNgc4QqLwAUTVt9X_J07r3RTwi6CkhPBqtKayWFoMfbs5NWVGowbyaCCTUwJTNl0Pc7rO8pZOaBmt190BlTbVeU22fD_PZSaNyuwdIpyLj-iIW8I5UPpA70KzTXv68oIIndabpmQ6GAtI5uCEgfWRcdFcqjLeDln20H-EWL4FHObL5M4U7ARPLDUbTWep_oRK6XXd6_qtUNbOSwstHCqvTZGQhqd8g', `SearchKey` = 'wofCpMOiwrDg8OgwqCrMKDwqTDi8Ksw4Dn8KhwrLChMKuw4TCvcOIwwofCscK8wrDgsK6wqCqcKDwqTDwofCpMOIwrDg8OgwqCocKDwqTCwrDCisKpw6LCsMK0w4LCpMKtwrDCtsKKwrDgsKgwwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDo'
# [11-Jul-2024 17:52:17] /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
# [11-Jul-2024 17:52:19] /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
# [11-Jul-2024 17:52:21] /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
# [11-Jul-2024 17:53: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
# [11-Jul-2024 17:54:10] /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
# [11-Jul-2024 17:54:15] /finance/root/bg/ajax/invoices/form/clone/10409.html?pid=10409&_=1720709656115 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 10409
            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
# [11-Jul-2024 17:54:21] /finance/root/bg/ajax/invoices/insert.html?_=1720709661926 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `clients`
            WHERE
                `ID` = 66 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` = '2286', `Language` = 'bg', `PostDate` = '2024-07-11', `LastUpdate` = '2024-07-11 17:54:21', `Type` = '1', `ParentID` = 10409, `Data` = '37rxWmUIxHnt3kxwmel1QpZaCvGM3W6tJ_BhSww88ndS5korqJX2f1GN2sqct2X_OyJ-u0oQFr0z4kKrqPp2sShuIvIsU-R1-v2EEiqHqOUyMNfHHp5_FuN3VfMvtYy0ei3YpyhkInPbkPy11uPuPuuhzvUo3QN3DhET151ohuNh_RqvALMgSz4D248R5qWfvRmAwsTrJwz43Cw0GgMx4SRe7BElhaVImby7p1y8dxy2Je9MK37jRSjlZQGZ_V8E4xO-TeuJd7lY6bU1z36A8VtYNvBgHJ9QWo7QcTUPAUIn-sQf-ZQw7MmTRL8WjgfzS5NXspUdkbpElZ5LVD6i_NKezdk9-63xpx0H1dN6RUldTHIfmTa_E54uj375rwGef9KUON-PzliHk_CkBxmPg_UrBUimb6LQf8kaTpPojfttKgtx21kcrr9To0ZjTWpXy2_6APQcKBiFsYAiSE75QqJB9Ac-EiAs5f-n6fU0YOQt5-qYaXBe5KnESksMtzxYvUNek_c_nMPiuzmMtIF8xETGuNFsG68nKYW1OZeMWyezaJwFc2bpO65g4aV7eaW0SZchY124ezNUaIdTl7t8b0PmM83WQQBysZTTQTzN49fqziq8Wvj_3zSxNwd4C8qwz6_Qg5FW-wQVBXbPfc17FfCqtEn8KYvhZ-xnis7cnG_r6xssnDRTJ8-gfq2ewEXy94NLu0Vxfow3FbGL9rTzqRaeNBr9UVPChYslcOZ8IzVrYh-vMH4p-azsM2WpYGkvL5PHlDU7eguTbVfovHDuuPiJZGknVN1pnwKWbyBCMv8oN0VIJot-i_ijcYjWisAWF_ruWDfpE-sXn7gXb8Gvs4q4qiX9v0Bh7KzpGSm644dqmcS7G3spb4XcRKaiBawlGHwnjNPDPUooZedfRHxY7-MH9rLENsu6tjVuPUs2vAZJ95dobrKmOADUdcZbGWxE9jnbLGc9xcZ2lXCSdcK4B8FcQoo1q_3_vneWX2TPgaY3ibOob135m7-XY6ZO5R0iLES48vooDNGaxry1bdGLw1F3WZgdtvPe9NE8E6Kp6qXUpp2CGwqO9wKvyihkwvDe_tfX6F5aiSWFwDP-N3-W0OXbNXxPGz7MUyIQabXI2HTICBr5q7dHYq9TAz9c7-oGLNewdMX_sAEjSNtJpN6AxXZrJNakXYp33-iSlSzJe5a5rPrniIUtO0fhXMSAPK42Jb78BSkBNWf05v9AcfxsLKa5e9d4gVxTH80ZuqlyRfcXMmQZis18J7gDgd3N9Ck2Q0KyCsbsZ2P99bqdtejgKTtHmCd28ZVgz89f3ZJ6PDrPXTVmbrkFSZ1MJpyQqfC3BJ7AYenqOXH10b7W8HnTOLINiQebBdFlqstjX234Z-gzzsWi2ydEmU1urgOruFgRnOHkcvjGZqhzilJ5XTAJTTgwvUHY0TO6re7HtAeBoeEvcjZ7J4Q6rjFrg6rgS73hOYTTC-24ZszY9_xJI-r0CBpCFfLhC1PW2LAQBN0R9k9arVtpBUqXHNSHjzu0TVoD1po5sOP9-IP2W3lHhMXaenpDAOg9LlC7Y5aGUx_F9yVRcHv5Z5I7FzX0yKLWX9tcSVmcGZLl0BxoOhov74kp0ZmPIbhKJI4nNNSWY8OjBrVvajASKNt4bGL8aEBG7KaHNFRZL7SlfBUWaoPXQAmtCc880MkoKpxFn9sVBXsYfQ2oaKfLmoe_lioK1-PzPbibuMXXgFwH79wJZDC4ZbRW4of1OAR1zUh6_47eqHsmtN9Gc7DyMNwykEy59NKCfwu2wGwBVAr8ro_FH3m_Q05TNzgA1sGhAFv0ElIwsf4_C84', `SearchKey` = 'wofCpMK0wrDg8OQwrPCt8KDwqTDlsKrw5vDn8Kdw47ChMKhwwofCscOEwrDgsK6wqCq8KDwqTDpsKsw4zCwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8Klwp7CrsODwqXDq8K0wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwq'
# [11-Jul-2024 17:54:21] /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
# [11-Jul-2024 17:54: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
# [11-Jul-2024 17:55:00] /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
# [11-Jul-2024 17:55:01] /finance/root/bg/invoices/1000000065.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` = 1000000065
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jul-2024 17:55:12] /finance/root/bg/ajax/invoices/form/1000000065.html?_=1720709713491 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1000000065
            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
# [11-Jul-2024 17:55:33] /finance/root/bg/ajax/invoices/update/1000000065.html?_=1720709733886 167.99.142.201

set names utf8

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

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

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

INSERT INTO `history`
                (`ID`, `PostDate`, `TableName`, `PrimaryKey`, `Data`) VALUES
                (NULL, NOW(), 'invoices', '1000000065bg', 'GKzT0QINgBxe3JrXLkN33cTz2iUg7nEJDbLm4CCvcrS6IXx2qtlmFF3S1lFuZna68kFgqKoYeOkA3k112eXbjIRy6Aa5hrxPDAnDXpOUdaa0fI3bmrPfHq3-ZegfJBDRtrefNoxNTdSDnlCwHZM8W2FExZUK2M-ajgs2t-S9gOpmMt8WajxEv9LTMNxVAcXMlgx09vqyvjERSKhSP8-JPD-_7_LE3JQzuOu5DYPyqrVL_nv_jdgdB7yCPGStpZvFB0Uhok9_prTlfr7Mi6mJWqwaNHh9WIOtgMD8QN7BDtiNSmyldiP-wRhxTebcxjEl3wVRMwaC0BuwClsRO_oENOhLtZ2cvWjQEj0rysLKIh2lFGAXkKUkD0w6z58wKgOp6ZhctqE_WP4B8-pYms7OVhEDfFEst_TVTlxnccY4OPuQ6YnYmn9gsF2yMzj7spwzl6jhgfZ5nPZZpXUolnts49ybFefXyMzwSUsrn3B86SmE-z-Tz82tinlGOonRWIZiIijaMCEtXDxHorhDQ27923o7wzByzqSVIBtLZ4FW5EE8j8YKSmdeL0TV9GlJacDYYnOOEcP7z4nTUOaPZUkoi74rJoiu1XmB25dl8FnbjUdesu-yy5kK4NKr1k0_dTqlqz7aN3m68aBOVnxwkQGk8BBOktNZB4NJ0uN8qcgJzTrXsHr8md7HH4j39fGhq-2bm1Pk3aFfkxwKY64txVFbKNTWPkNY0v9JptXEU4SsHcrzt36i73pRs7jj3Vi_YQxa7OYWNM78NBLT2RdK0dQr5inMJYlfJjPeN4wNWPI7YAgigbbTMsRhapqSWaaLcDNxvbEr2hTvXXjo1xto-BukWl8dFHTfoRyOMW_Rdvnss33s6-rmxBWnRI4dnhafxm8gME3Cu51LkloQ-hYizlg3l0rYNSBqSOlN6Zqx1RQ0ccCcNCD9ZkMlS449j8zUq3Cbt5J9z8t4hKrfaoAyL_hU_0Mlh_nNuKpbl7W_yCCLgbiBt7mAAqoAROsBSjhL_MskLn7Qs_VqfWspE0VQW5_ZL-Yo1A0x9pW-_rS9VLEIrJWnzoHqyITmzeADAh5IEQxXW4QfMvd23KniACDroLwS3YgT6WTHUJk9rHv5MLg_3icFUyqTHnE_FLO80-r8ARxMZChDSqfud0VsYJnuh0H-LkxSFtTsT_Xnc-us5oNSAbZwEtXBlihwo5L9C1zLW27qwqeX-F9lYqE7p74t9JEsjvDwakQFQqawJpOcXhOwvqjysnpUpFdLO-y39byEU4aXy3rhnIpKj49dThT2d8aqLudHZS9rPqbUBDMm5kT_Gt7HpylUG7InYwrCjZOz1GFKE7ipqFwhRR3MQehWcDr3NHZk6sm4UycQTUeTTizjQu8Kl14rlAqqHMIzwNiRgZETsciU3CXc02JjgTrm1npTsZdbU0R4S3tHsg0ACzL9bFKMPeDudnjDpJQ-w7YCa9umms8Z5aQQPsuMl0WHCkb8QZcB8E07X_N9D4ivpQJ6wHsV3sU7VjZjSuqHRs7Xxb05PAvP7pSRc61P1eXyFEnu-DZaf2IsAxXPnZGNjEe3F8RDzOUbaD-gqTok8mTdi23KZRp9mkLEk-HT5rCg3ZphiP7fj3OjdrfLXDhz4uZq8qQOtdtKf3V97jtpBNkZGxOJem_xhQXjLfIyaW8ELDZkJcr92rhAjp1m-ZxkdZeF3YlVMSscs1_VHsQfWRO3xxp8594ZTmas9vRmsiOpYZW91XysPd0qschFr5sLbOz2Pt4iPfw5G5HoVKcUF3xJDrlC61qtkXi1BikGQp1r_Dbk_T-dUUvCLGBNgvPuB8QD2XcgQG2wiwbCg-h1nMXBkQWAJtb7SRzRiJwNUownKvCUumi_JarxGCxr8mCkBYMhuiSHBeZUb60r2xWwxiQFhtA8mODbmXxj9kkQSHpXA6GRtoFj0PcKNHrBvVcRSKfd1ZC5Pz-peOwOg3S5tDpsR7rdxRtgLbERJuUm5detBSED0GIJ0ORGU-Wo3TrLMK71LmDWxa4fLyIjy2QdQUTg5u8w7tGzuMqKvaBptj_g_N_-aiNkxbsUSySijD2dHWtUd4Nrm6shOy8fjst_ddIOXKeFd-311skmDOYt8cDCZe7h_PM98Rruck8OfiHOyhOcv5GlIZyZkuZtV8IoMa3kBag094bHqQInXbGf4pwh7b49uclAE8LwSrQ6XuIwr31WavF3NFKqeju8m9cTXio3NVAev-j59eGfKF017vKzoAwlWbjryk_E5lKnvoVtxTIj5GJub-tkJJREmYc0vF7AQk_otLmO_jFD-cPUTayOGi39TS20UzRT3LhGu93lXNmljn55tLT9CNzuJJSjracy6keOS9q9uDmWYZ5fifNLl-NzS6xtL2n90sbxegntrx5xnKapQCHQaucYgWWeRyjwTybdNJ6JYajQwxjYVDmREcybcP_SIP1s_z32_8g1BxAuqCHrCGdXtLA8OSizMzn7C2g9clSW_jNoCLEGK1CJ5QuxgqsCSrWF9ULzT5t2D-VMnjHxvbtH3QPyHsW9cd_ubXTPHjjybuNFGD6bCX_QXC2GpNfVYdBBblcsw8Arfv5wDzTxchz1ffuw42jlhpxVdbn6Qz25X0dR0nK3Of5yszKQng7OTyuRIoNb3Gt5ZIqHvv8oEVahrasT_bxxuQ5htS8uen6R_nhyvSSvMA8Fpmuv9zdrZOP-Kf8dirZ8b8vMAEhy9Yj5p9nUAxzz6r-iwiyKTRLcGU4bgxT7svzzTmYvrRyqk-G5OFXwV_h0FVhMiH2lUu4vBeqCAlTIsvE9SaySlKBpEkyPEMFu324sPJUTvUDO969X_ImA4StClsfkGhmoM7LJRRMoq43U4k_-GjDhA5UQuFMP88dfpuWcGk5kWlTpQHr7Trwm2qig5DrO0txE4-AiZPO_Jqyb3gwflMRJV4v9EYNnVcmUCGonmHE9xh9v2TkodJ2JYbkykydlzKg-nXuZtHrAeOh3Dio3uqDn_IfeWUczBbbpNrn38RULMvNQBnC5Qju3I4vrlrFdNC4')

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

UPDATE `invoices` SET `ID` = '1000000065', `Language` = 'bg', `PostDate` = '2024-07-03', `LastUpdate` = '2024-07-11 17:55:33', `Type` = '1', `ParentID` = 10409, `Data` = 'K7Y8pHnMqNun_ZyeIy2PSr3tCbY2q16jCes5XLZL4NMMOzmRqKwxmmcZAaH12UvwvhTju1iCu_IUaoilqQsl2LjCLrjJE--SIRNFJ_UarM6ZPCmhimfjOGyu7j0gvyK2PmvkiBzmxK1oOXFHrYHSonsMKXpcUC-EmuAhZeV7a-oudtdynwwn7AAT2Olr60I_UIgJ60ZomV6tkqCMPTM7-M5u7zS0Z3v2cBrFmFa-18acc0_yiT_y1DbhdFHFrwGF5StBLpxlF56wx0Lpigts-XOhPqvq22gsR3eeMOpmHeL4SqWc4EAfJD1DnVVpVF0nUhWkSm6RBgKVoGCjCoBuhuhqzrNzB58WnBL0u3t_lCjCV-T5FgdryjS9xxICGqlWUwh3dAuQPBbc-8m24V3fTgPG6U_B82DFCit3r718Uyvn1QENc52dDK6TmpsBJQk_beCZOt2ojqiOeAfAFJPslxp7kc5bI6Nsv105i0G3cCENxGcbYJRx38qSccmPD9usWr-qe7oxmyC-wsFACbCbx2IxRbD6EGCS9B4gSXYvC_fDTzveKIfNCivWeCrKm7nd_Fjn6ml7j8Apfwd9rF4astjP20LLtyNrNgFm1FgxxbC1sgRdiGQY3-smylh7_Ziw_oqXG-qHW5nQjWrS58ZJfMD9VDVtfAfucmK0nSheNidHy4cZnYMgwsDae-QWzvdScxeUvGfjZkkJoptpb1Oq-EN368UyeOZYCMclHjZt2PzPecLSUFOBvajO8cuJgGbZnJFWrkdpj8jjSOLX1piG7hq1I9ZXleIIFIH4EIo25C0jxfWyZdbEWrZaFSMzNdnUWVtlbtmrlaFcgILGAEW_0PBrgZeM3kDBblvtWk2tSX8POdDqpyjVRCPthzCoEvIGCNt7etF_2j2tjn_nRSjbKgtkbgcRfMlPyGHMdyyvbzt7dw__fIJ81mp-YqMVGKvtkw1QG3CFm_S8XpQAHtj8y_fD--l1jpNu4GDA5ka2OT7sQkpAf83xez7z_CVieYwp3ROnHqbZOkYMGY5Dn1zAR4ZOGg6CiFw_9PZl0r8k6qsI-3zb9hpDQAGJfLM6tGeRhdaj8kqxX_WPQ2WNYdh_8LIOV-F1KktHVqSRIbg0VJggdDZNLr8gH0rtpi35e-3XLJtv-HNewzQWBQxmNiz9n2K_jsglFboq-NlGsT8z00XFWFYPr2Ul3sPNfpWuKd97E4Fr0eLVN42kNspKLPSYtoQo2WHqQmcJ1rfTpsYpzmghGlAJvXkDApHAukCbK6KrHGVmuEuoX_4Q8o6daiwaJNtVOSaM5cr2wj165zdZXQc95OlbeKHWe0piYd8_6WxWFa0ggXwngdMq-Ii8uSq1kIfHjPQ0f7G3hNnZpFn88A3LaFZ03ftSo8pIIPDJb5S-jl_JPJsrA6_Nk9GtM39Nni2iQq9ErAenxFgdpKg87Lfel9Kd5LjuI6g_lKZk2kKIs5DHsPfFgSmu5uWyBbbwReIOqKVjlD289CFkVT0DOhe92mCFaEpKkyP88V1r7he67n3HOXBETuRs6X5L7Ocov-HwniddobCJ4H-5A3Mexnfz-N26mnvdMO4yTp5T13i7V2DyRvXYjQpL0GaInMKgewqaqbhht0a8TA_CO8clfc8ubJcVxxi1WENzSSQ0CJK-AMkNKzIE5KCAGH2YcZ9p2gK7mf7vClp1_qWspw_S8w73ebPsjuNJBWMx-ABwnREP94yl2cMmyRKzJK7kT3Vzqr1qYYmsrU-A-ffMm_0Samx1Wzo-7d4zafCoTC0jKUSFKz-BXZk0Ci2M78QNJrTw-R7b5Ms0rj3VOeH7UQufMlA', `SearchKey` = 'wofCpMK0wrDg8OQwrPCt8KDwqTDlsKrw5vDn8Kdw47ChMKhwwofCscOEwrDgsK6wqCq8KDwqTDpsKsw4zCwofCpMOIwrDg8OgwqCocKDwqTCwrDCr8Klwp7CrsODwqXDq8K0wwofCscOAwrDg8KlwrPCtcKDwqTCsMKrw5jDn8KdwqbChMKhwqrCvMOXw5TCiMKHwp3DgMwofCpMKjwrDgMwofCscK0wrDgcOQwqCqsKDwqTDosKrw5jCucKdwq' WHERE `ID` = '1000000065'
# [11-Jul-2024 17:55: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
# [11-Jul-2024 17:55:39] /finance/root/bg/invoices/1000000065.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` = 1000000065
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jul-2024 17:56: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
# [11-Jul-2024 17:56:40] /finance/root/bg/invoices/2285.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` = 2285
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jul-2024 17:57:34] /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
