# [05-Jun-2026 08:30:29] /shtastliveca/www/ 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Content`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'reviews' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         AND
                `Visible` = 1
            
            ORDER BY
                `PostDate` ASC
         LIMIT 0, 4

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:31] /shtastliveca/www/bg/vouchers.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'vouchers'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vouchers' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:31] /shtastliveca/www/bg/ajax/vouchers/formsum.html?_=1780637432060 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LVoucherSum','LAmount','LEnter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:33] /shtastliveca/www/bg/vouchers/form/25.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'form' AND
                P1.`Visible` = 1

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

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

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:33] /shtastliveca/www/bg/ajax/vouchers/form/25.html?_=1780637433563 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFullName','LPhone','LEMail','LSendVoucher','InfoRecipient','InfoRecipientEmail','LRecipientMessage','ErrorRecipientMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ISO`,
                `Name`,
                `NativeName`,
                `PhoneCode`
            FROM
                `countries`
            WHERE
                `PhoneCode` > 0
            ORDER BY
                CASE WHEN `ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceRecipient','LCountry','LInvoiceAddress') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `countries`.`ISO` AS `Code`,
                COALESCE(`labels`.`Value`, NULLIF(`countries`.`NativeName`, ''), `countries`.`Name`) AS `Name`
            FROM
                `countries`
                LEFT JOIN `labels` ON
                    `countries`.`Name` = `labels`.`Label` AND
                    `labels`.`Language` = 'bg'
            WHERE
                `countries`.`ISO` <> ''
            ORDER BY
                CASE WHEN `countries`.`ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:40] /shtastliveca/www/bg/ajax/vouchers/insert.html?_=1780637440613 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT * FROM `vouchers` LIMIT 1

SHOW COLUMNS FROM `vouchers`

INSERT INTO `vouchers` SET `Language` = 'bg', `PostDate` = '2026-06-05 08:30:40', `LastUpdate` = '2026-06-05 08:30:40', `Data` = 'ZTr4DUqW3xu-GP54RXERUS7H1x35-Ng44BBN1X6ib7dykffPrG4x-trO2nju9FZrXrYcLcy5ZUjGRkGQxtsItW43E9DdbjWYTqQp4WdTs4_H8NnAeuZri6RKl3OvafveBWwxcW5tjMSnetnKk4I7mdhDoj0_WObp4fuDnBucNXe85EU7yxXuHlZ8b6f9wUt-_cqWta0Eh0nwJSU03AXHuhBiFq3ggDR_ssH4h4r2k11XQILgpgyzRpDnQd57Wxrp9qCpLlCi_JGWNAdpiUSYmw', `Keywords` = '0L3QuNC60L7Qu9Cw0Lk0LjQstCw0L3QvtCyMzU5ODc5MzEwNzMxdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t', `SendKey` = 'X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM'

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 08:30:40] /shtastliveca/www/bg/vouchers/confirm/X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'confirm' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM' AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAmount','LFullName','LPhone','LEMail','LRecipient','LRecipientMessage','LEditVoucherData','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Merchant`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'vintagerest', 'vouchers', 8124863, 25)

INSERT INTO `borica_info`
            (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
            (104569, NOW(), '0', '{
    "AMOUNT": "25.00",
    "CURRENCY": "EUR",
    "DESC": "vouchers 8124863 2026-06-05 08:30:40",
    "TERMINAL": "V5200005",
    "MERCH_NAME": "Щастливеца",
    "MERCH_URL": "shtastliveca.com",
    "MERCHANT": "5610001773",
    "TRTYPE": "1",
    "ORDER": "104569",
    "AD.CUST_BOR_ORDER_ID": "104569#20260605083040",
    "COUNTRY": "BG",
    "TIMESTAMP": "20260605053040",
    "MERCH_GMT": "+03",
    "NONCE": "ECBE9463322DED7CF500E54371FB124D",
    "BACKREF": "https:\\/\\/www.shtastliveca.com\\/bg\\/borica\\/response.html",
    "ADDENDUM": "AD,TD",
    "M_INFO": "{\\"threeDSRequestorChallengeInd\\":\\"04\\",\\"cardholderName\\":\\"Nikolay Ivanov\\",\\"email\\":\\"test.maxgraphic@gmail.com\\",\\"mobilePhone\\":{\\"cc\\":\\"359\\",\\"subscriber\\":\\"879310731\\"}}",
    "P_SIGN": "CAF6BE79994160AFDA43719112018E3267CFEDCFC15283D48C66BF5F82F19438AEFF3F4D9016E67B9EF87D833FEB79372C6BAE7AEDF499AF3DC7877A6621B2C888743B65AE39AE31AF03A127FC4DE2F49D25FB3BDAE84E73FF340C18C185354AD5DDDE0957206D01D1E5C289E45DF90F8463507BC5C01862F6B4F236FD73D35C19B0B04EAF96AB780FA9598F648A277AB7AA0F5CF23BEBEBDFD7C3BC9C84859AE25ED969B2DADDAE85C9E88EC78152BF197C91DA50043259CBA48D4FE57AB265CFD81D0FB59524115ACF70BF8DC8D768B94D8CD06D45F7DEF0B16DA977DCBB200BE88239BBE22A0E12D968AA3DC19075C768897235B6A4F4040C1A196DFEF3A6"
}')

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:41] /shtastliveca/www/bg/borica/test/104569.html 108.61.209.243

set names utf8

SELECT
                `borica_info`.`Info`
            FROM
                `borica`
                INNER JOIN `borica_info` ON
                    `borica_info`.`BoricaID` = `borica`.`ID` AND
                    `borica_info`.`Type` = 0
            WHERE
                `borica`.`ID` = 104569 AND
                `borica`.`ResponseCode` IS NULL
            ORDER BY
                `borica_info`.`PostDate` DESC
            LIMIT 1

SELECT 
                    `borica`.`ID`,
                    `borica`.`Language`
                FROM 
                    `borica`
                    INNER JOIN `borica_info` ON
                        `borica_info`.`BoricaID` = `borica`.`ID` AND
                        `borica_info`.`Type` = 0
                WHERE 
                    `borica_info`.`Info` LIKE '%"ORDER": "104569"%' AND
                    `borica`.`ResponseCode` IS NULL
                ORDER BY
                    `borica`.`ID` DESC
                LIMIT 1

INSERT INTO `borica_info`
                    (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
                    (104569, NOW(), '1', '{
    "ACTION": "0",
    "RC": "00",
    "STATUSMSG": "Test",
    "TERMINAL": "V5200005",
    "TRTYPE": "1",
    "AMOUNT": "0.00",
    "CURRENCY": "EUR",
    "ORDER": "104569",
    "LANG": "bg",
    "TRAN_DATE": "20260605083041",
    "APPROVAL": "TEST"
}')

UPDATE `borica` SET `LastUpdate` = NOW(), `ResponseCode` = '00' WHERE `ID` = 104569 LIMIT 1
# [05-Jun-2026 08:30:42] /shtastliveca/www/bg/borica/status/104569.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'borica' AND
	    		`meta`.`URLLabel` = 'status'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'borica' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'status' AND
                P1.`Visible` = 1

SELECT
                *
            FROM
                `borica`
            WHERE
                `ID` = 104569
            LIMIT 1

SELECT
                `SendKey`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`ID` = 8124863 AND
                `Language` = 'bg'
            LIMIT 1
# [05-Jun-2026 08:30:42] /shtastliveca/www/bg/vouchers/send/X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'send'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'send' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:30:42] /shtastliveca/www/bg/ajax/vouchers/send/X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM.html?_=1780637442641 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'X5Jsvv6w7ZBGPkfkyur0HjTWPYgDwoWsD0m2dDICnFaLKTOVA6abr55jswV0a6SM' AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers` SET `SendKey` = NULL WHERE `ID` = 8124863 AND `Language` = 'bg' LIMIT 1

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

SELECT
                `ID`
            FROM
                `countries`
            WHERE
                `ISO` = 'BG' AND
                `EU` = 1
            LIMIT 1

SELECT
                MAX(`ID`)
            FROM
                `invoices`
            WHERE
                `Language` = 'bg' AND
                `Supplier` = 'vintagerest'
            LIMIT 1

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = 9000000810, `Language` = 'bg', `Supplier` = 'vintagerest', `PostDate` = '2026-06-05', `LastUpdate` = '2026-06-05 08:30:42', `ParentID` = 0, `Type` = 1, `Data` = 'DbSeCHKaoZNbwTg4pZDCvx37aUybzr7LkE7KGAb4F7NvJkvQpXExN9GhLz2NUJcfPebbASFGbTuuhRD7uUl2ZRGSaXrSA6q5OY3OMje6ppg4fOFgPxq_aCh4uGi8ofaJAq9gItV5UL_hQ6aCgFQSbgGh5GfnKFfLt2xe0JM44aLWF7hPvzWljRPoZ4O_HFSGCcx2rCi-r6JFL0UVWAp8dZPnNjiRmPvIB0fg043UUCU7P-rO7YolTlVfcAMQT1yR5vy7iH03umq49j-WNtcpZr4j7E-EIqBFQqzUD0j5TjfBmIFvRu0P25HOad36HQr7FvnV-zwublmBb_S7UNKtzg-VqqpL4mJFIsn1-veo1aEs8LshTczjIfptWAOFDlDQXOIpF8cY2nnkeY9feJ0FRTDqNs1yDMHhNCWqvWjc-O-AZrGR4pUu0JqEzkk-mqrcwUcyXPB_P4l7e3mupNSRInN59kh2oJIkJyuqavFD1Dy4k174b96gaFjuDlPGzZaWQhJ4IVcaBjIF4T_8C8ugp5CSA264XcsKn6C_3mz-iFsnVRXm5DpCRKAWy71f5ofrFsfb-Ti2azcm4Y-idZdEd3FWCEh1GZKr1CI7htWOGn4IKlbE-XzTUiEw9ePp19WdD78wav-N-hk_DP20YD-enFacNXGRt4KAg7cBdzqgOo1AUb0D2H-6qRqLZ0BSfYuJPodzFfcovuNCsMVHBRrtvKz5XD91GSgluQVEmWUrDNgSNlfm4jqFi9WY3YSCmt81pqE6s2nqDW2TB69O2CTqSg', `Keywords` = '0LHRitC70LPQsNGA0LjRjw0L3QuNC60L7Qu9Cw0Lk0LjQstCw0L3QvtCydGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Client` = '0LHRitC70LPQsNGA0LjRjw0L3QuNC60L7Qu9Cw0Lk0LjQstCw0L3QvtCydGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Payment` = 1, `Currency` = 'EUR', `VAT` = 20, `Total` = 20.83

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 9000000810 AND
                `Type` = 1
            AND `Language` = 'bg' AND `Supplier` = 'vintagerest' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LCompanyVatNumber','LCompanyNumber','LCompanyPerson','LRecipient','LInvoiceDescription','LInvoiceQuantity','LInvoicePrice','LInvoiceSum','LInvoiceSubTotal','LInvoiceVAT','LInvoiceSlovom','LInvoiceTotal','LInvoicePaymentMethod','LInvoiceReceived','LInvoiceComposed') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'invoices' AND
                `Action` = 'accounting' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

UPDATE `vouchers`
            SET `InvoiceID` = 9000000810
            WHERE
                `ID` = 8124863 AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers`
            SET `Data` = 'hWvGg6yjYSLnKkTHwAuJBb4Fzv5NDGRKCUINGdqK3asPHsUDoiVTP3VxHx-8k2wng4oo6ZeDSUGqjRY2JK-LaAoEyAcIseDjZVnlCMy8a8OyuDcNznbwf5-YRC8aQoVJ3MXWuaYmev6zuUPrmdWAbKl0ryNRiEW_SXUgdYclc8prtF8tzCCfyiH6lzRRt_0Tknfnr-Bmaj9ogj5jnNmsWx4MyjGtmcoC_5tv6Ih1LS2BXgL3hD_tTzag0O9mizlmKXPPTsh3IxDiZcXzX7FuO0RBgtDVC1xzO01zvXwL3vrBKlbI0efVjbkVFJ-yiPGH_d-UtPRcfVRIqKfk1a70i3pBDkxt5jEO4Y_lWkwjl6CEeK1FAjymTehItu1KbTGi'
            WHERE
                `ID` = 8124863 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'restaurants' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'vouchers' AND
                `Action` = 'buy' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 08:30:48] /shtastliveca/www/bg/vouchers/success.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'success' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:50:49] /shtastliveca/www/bg/vouchers.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'vouchers'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vouchers' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:50:49] /shtastliveca/www/bg/ajax/vouchers/formsum.html?_=1780638649882 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LVoucherSum','LAmount','LEnter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:50:50] /shtastliveca/www/bg/vouchers/form/25.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'form' AND
                P1.`Visible` = 1

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

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

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:50:51] /shtastliveca/www/bg/ajax/vouchers/form/25.html?_=1780638651198 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFullName','LPhone','LEMail','LSendVoucher','InfoRecipient','InfoRecipientEmail','LRecipientMessage','ErrorRecipientMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ISO`,
                `Name`,
                `NativeName`,
                `PhoneCode`
            FROM
                `countries`
            WHERE
                `PhoneCode` > 0
            ORDER BY
                CASE WHEN `ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceRecipient','LCountry','LInvoiceAddress') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `countries`.`ISO` AS `Code`,
                COALESCE(`labels`.`Value`, NULLIF(`countries`.`NativeName`, ''), `countries`.`Name`) AS `Name`
            FROM
                `countries`
                LEFT JOIN `labels` ON
                    `countries`.`Name` = `labels`.`Label` AND
                    `labels`.`Language` = 'bg'
            WHERE
                `countries`.`ISO` <> ''
            ORDER BY
                CASE WHEN `countries`.`ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:53:29] /shtastliveca/www/bg/ajax/vouchers/insert.html?_=1780638809888 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT * FROM `vouchers` LIMIT 1

SHOW COLUMNS FROM `vouchers`

INSERT INTO `vouchers` SET `Language` = 'bg', `PostDate` = '2026-06-05 08:53:29', `LastUpdate` = '2026-06-05 08:53:29', `Data` = 'QLm0gHsXLAgxqbTulTgL-_W4TFgXITCJ_y-YhhiEZtBhfGUxSMOi7n5QcF_ujDfJGXHqgKvElzGMeW50NcPB5PtE2V-0YK72kB0RILER_RdIiZUqs5QyUM_OycrfQq9p9v4qTtZRnYjtE-Rw_cQjr7g268BpPbYOMadxfB7w2V6ITiCkQEDS_bvb5WeptRnMb7eu7qTD_UaYmzXlICf223vUmtxPa4Ge2SpQmQhqOtQIkxbJSuTgwrj2ZMotlj7I', `Keywords` = 'dGVzdAdGVzdAMzU5ODg1MDY4MzQ1dGVzdAbWF4Z3JhcGhpYwZ21haWwY29t', `SendKey` = 'MQ6MKXK3olhBIxcrZveq6uBo5EV1RYwHtvOukmTvD247B8urIMNQE70trlgbYkS0'

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 08:53:30] /shtastliveca/www/bg/vouchers/confirm/MQ6MKXK3olhBIxcrZveq6uBo5EV1RYwHtvOukmTvD247B8urIMNQE70trlgbYkS0.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'confirm' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'MQ6MKXK3olhBIxcrZveq6uBo5EV1RYwHtvOukmTvD247B8urIMNQE70trlgbYkS0' AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAmount','LFullName','LPhone','LEMail','LRecipient','LRecipientMessage','LEditVoucherData','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Merchant`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'vintagerest', 'vouchers', 8124864, 25)

INSERT INTO `borica_info`
            (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
            (104570, NOW(), '0', '{
    "AMOUNT": "25.00",
    "CURRENCY": "EUR",
    "DESC": "vouchers 8124864 2026-06-05 08:53:30",
    "TERMINAL": "V5200005",
    "MERCH_NAME": "Щастливеца",
    "MERCH_URL": "shtastliveca.com",
    "MERCHANT": "5610001773",
    "TRTYPE": "1",
    "ORDER": "104570",
    "AD.CUST_BOR_ORDER_ID": "104570#20260605085330",
    "COUNTRY": "BG",
    "TIMESTAMP": "20260605055330",
    "MERCH_GMT": "+03",
    "NONCE": "6EA747743800A65F662276C4FC340C50",
    "BACKREF": "https:\\/\\/www.shtastliveca.com\\/bg\\/borica\\/response.html",
    "ADDENDUM": "AD,TD",
    "M_INFO": "{\\"threeDSRequestorChallengeInd\\":\\"04\\",\\"cardholderName\\":\\"TEST TEST\\",\\"email\\":\\"test.maxgraphic@gmail.com\\",\\"mobilePhone\\":{\\"cc\\":\\"359\\",\\"subscriber\\":\\"885068345\\"}}",
    "P_SIGN": "D055B56C524250324EB85091492809DBAC38D4051403BEC0CA79CD05E5815E6C3F16525F887AFE8A71A79539D52939072E10AA4C81DC31BA95F861B51DE64A391CE21843561486009D63B2A023F103FF63FC2A092DBC692103C0729F2EA47147AECE3E8F9EB0FF16E262EC04967E2124307FB48D7BD04509BCBEB506BDBF1B4FD5D9839DE68E10C0635B9D6FF20A8DB82EBDC2A9061F04931974A4056E8F673309CEFA3599B141F260C5F1EED43D471454B625718306F57A094C3D15C7304EC3B75900C52D93C86157161F50DBF874F5CEAF9567A133EA294EDD672EF4DF0AB6EB2247E17FF940679D668D79294D9781F6789B689E67A5B16976CD151CFADDC2"
}')

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:53:32] /shtastliveca/www/bg/borica/test/104570.html 108.61.209.243

set names utf8

SELECT
                `borica_info`.`Info`
            FROM
                `borica`
                INNER JOIN `borica_info` ON
                    `borica_info`.`BoricaID` = `borica`.`ID` AND
                    `borica_info`.`Type` = 0
            WHERE
                `borica`.`ID` = 104570 AND
                `borica`.`ResponseCode` IS NULL
            ORDER BY
                `borica_info`.`PostDate` DESC
            LIMIT 1

SELECT 
                    `borica`.`ID`,
                    `borica`.`Language`
                FROM 
                    `borica`
                    INNER JOIN `borica_info` ON
                        `borica_info`.`BoricaID` = `borica`.`ID` AND
                        `borica_info`.`Type` = 0
                WHERE 
                    `borica_info`.`Info` LIKE '%"ORDER": "104570"%' AND
                    `borica`.`ResponseCode` IS NULL
                ORDER BY
                    `borica`.`ID` DESC
                LIMIT 1

INSERT INTO `borica_info`
                    (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
                    (104570, NOW(), '1', '{
    "ACTION": "0",
    "RC": "00",
    "STATUSMSG": "Test",
    "TERMINAL": "V5200005",
    "TRTYPE": "1",
    "AMOUNT": "0.00",
    "CURRENCY": "EUR",
    "ORDER": "104570",
    "LANG": "bg",
    "TRAN_DATE": "20260605085332",
    "APPROVAL": "TEST"
}')

UPDATE `borica` SET `LastUpdate` = NOW(), `ResponseCode` = '00' WHERE `ID` = 104570 LIMIT 1
# [05-Jun-2026 08:53:32] /shtastliveca/www/bg/borica/status/104570.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'borica' AND
	    		`meta`.`URLLabel` = 'status'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'borica' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'status' AND
                P1.`Visible` = 1

SELECT
                *
            FROM
                `borica`
            WHERE
                `ID` = 104570
            LIMIT 1

SELECT
                `Info`
            FROM
                `borica_info`
            WHERE
                `BoricaID` = 104570 AND
                `Type` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Error`
            FROM
                `borica_errors`
            WHERE
                `Language` = 'bg' AND
                `Code` = '00'
            LIMIT 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:57:56] /shtastliveca/www/bg/vouchers.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'vouchers'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vouchers' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:57:57] /shtastliveca/www/bg/ajax/vouchers/formsum.html?_=1780639077406 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LVoucherSum','LAmount','LEnter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:57:58] /shtastliveca/www/bg/vouchers/form/25.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'form' AND
                P1.`Visible` = 1

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

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

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:57:58] /shtastliveca/www/bg/ajax/vouchers/form/25.html?_=1780639078696 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFullName','LPhone','LEMail','LSendVoucher','InfoRecipient','InfoRecipientEmail','LRecipientMessage','ErrorRecipientMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ISO`,
                `Name`,
                `NativeName`,
                `PhoneCode`
            FROM
                `countries`
            WHERE
                `PhoneCode` > 0
            ORDER BY
                CASE WHEN `ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceRecipient','LCountry','LInvoiceAddress') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `countries`.`ISO` AS `Code`,
                COALESCE(`labels`.`Value`, NULLIF(`countries`.`NativeName`, ''), `countries`.`Name`) AS `Name`
            FROM
                `countries`
                LEFT JOIN `labels` ON
                    `countries`.`Name` = `labels`.`Label` AND
                    `labels`.`Language` = 'bg'
            WHERE
                `countries`.`ISO` <> ''
            ORDER BY
                CASE WHEN `countries`.`ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:58:13] /shtastliveca/www/bg/ajax/vouchers/insert.html?_=1780639093165 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT * FROM `vouchers` LIMIT 1

SHOW COLUMNS FROM `vouchers`

INSERT INTO `vouchers` SET `Language` = 'bg', `PostDate` = '2026-06-05 08:58:13', `LastUpdate` = '2026-06-05 08:58:13', `Data` = 'F7SOf7Gh0JQDDpvU51VMpwe6jlyC6e0z4tmJvC96fsypZTJgCe3oLt3RG7r9vOuUbv6ZMBMUDQcEIz840ogxiUJGUstBqLA7fYBP_16Wt8fmjZRkxIlIcVNW7Z4D1S_4_i9t316qfjB-dwrxK-KfDQ0K9X3Eq2Ima-cKTuoarEoDtAhl_7BZTX1LTFqaQzaocO_S-bpuTKIvUAvxcGGZ3yD7qQw9FHY6j4PB7z3nDaJDkCoqZ9JGtHrscW7KWE-fXOl9tOoXfzHG4Tt5NyKxzA', `Keywords` = '0YLQtdGB0YI0YLQtdGB0YIMzU5ODc1NjE1MDUxdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t', `SendKey` = 'LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM'

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 08:58:13] /shtastliveca/www/bg/vouchers/confirm/LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'confirm' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM' AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAmount','LFullName','LPhone','LEMail','LRecipient','LRecipientMessage','LEditVoucherData','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Merchant`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'vintagerest', 'vouchers', 8124865, 25)

INSERT INTO `borica_info`
            (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
            (104571, NOW(), '0', '{
    "AMOUNT": "25.00",
    "CURRENCY": "EUR",
    "DESC": "vouchers 8124865 2026-06-05 08:58:13",
    "TERMINAL": "V5200005",
    "MERCH_NAME": "Щастливеца",
    "MERCH_URL": "shtastliveca.com",
    "MERCHANT": "5610001773",
    "TRTYPE": "1",
    "ORDER": "104571",
    "AD.CUST_BOR_ORDER_ID": "104571#20260605085813",
    "COUNTRY": "BG",
    "TIMESTAMP": "20260605055813",
    "MERCH_GMT": "+03",
    "NONCE": "14DF54EB6AAEDEB8F7B732356A01DAE1",
    "BACKREF": "https:\\/\\/www.shtastliveca.com\\/bg\\/borica\\/response.html",
    "ADDENDUM": "AD,TD",
    "M_INFO": "{\\"threeDSRequestorChallengeInd\\":\\"04\\",\\"cardholderName\\":\\"test test\\",\\"email\\":\\"test.maxgraphic@gmail.com\\",\\"mobilePhone\\":{\\"cc\\":\\"359\\",\\"subscriber\\":\\"875615051\\"}}",
    "P_SIGN": "E289F3084FA299B7EC4DB3387E1D445F534E129A32F2515640ED79837E98B76845BEAE90CC8F72221F8585B64F7F418877192C282D7C4509CF8EFDF9D205CC61622E2A2D8960D091EF9A7669D147ED422A7FC5F8DAC2B4852921263CF47496CE89FA697219A060824ED5805F66507F6965D70F66ADD92576034BB3089EF250BF03029E41CB48D67C5A831EAD8BC625FA8EA0193BFD4B7333408A6950FC1A1D30E8831A59AAAA78648171BE8292F9D8B84EEB902CDF4CC3B398E2B312A95B4725096EFD016D4AE028BB5219381BCF28357771E524CB27224000CDF513739D43108DF820832CA2109E51094408C932644DDFD33ADDFE9252D32A2A9332F2F646B0"
}')

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:58:15] /shtastliveca/www/bg/borica/test/104571.html 108.61.209.243

set names utf8

SELECT
                `borica_info`.`Info`
            FROM
                `borica`
                INNER JOIN `borica_info` ON
                    `borica_info`.`BoricaID` = `borica`.`ID` AND
                    `borica_info`.`Type` = 0
            WHERE
                `borica`.`ID` = 104571 AND
                `borica`.`ResponseCode` IS NULL
            ORDER BY
                `borica_info`.`PostDate` DESC
            LIMIT 1

SELECT 
                    `borica`.`ID`,
                    `borica`.`Language`
                FROM 
                    `borica`
                    INNER JOIN `borica_info` ON
                        `borica_info`.`BoricaID` = `borica`.`ID` AND
                        `borica_info`.`Type` = 0
                WHERE 
                    `borica_info`.`Info` LIKE '%"ORDER": "104571"%' AND
                    `borica`.`ResponseCode` IS NULL
                ORDER BY
                    `borica`.`ID` DESC
                LIMIT 1

INSERT INTO `borica_info`
                    (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
                    (104571, NOW(), '1', '{
    "ACTION": "0",
    "RC": "00",
    "STATUSMSG": "Test",
    "TERMINAL": "V5200005",
    "TRTYPE": "1",
    "AMOUNT": "0.00",
    "CURRENCY": "EUR",
    "ORDER": "104571",
    "LANG": "bg",
    "TRAN_DATE": "20260605085815",
    "APPROVAL": "TEST"
}')

UPDATE `borica` SET `LastUpdate` = NOW(), `ResponseCode` = '00' WHERE `ID` = 104571 LIMIT 1
# [05-Jun-2026 08:58:15] /shtastliveca/www/bg/borica/status/104571.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'borica' AND
	    		`meta`.`URLLabel` = 'status'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'borica' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'status' AND
                P1.`Visible` = 1

SELECT
                *
            FROM
                `borica`
            WHERE
                `ID` = 104571
            LIMIT 1

SELECT
                `Info`
            FROM
                `borica_info`
            WHERE
                `BoricaID` = 104571 AND
                `Type` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 1

SELECT
                `Data`,
                `Keywords`
            FROM
                `vouchers`
            WHERE
                `ID` = 8124865 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `SendKey`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`ID` = 8124865 AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers`
            SET
                `LastUpdate` = NOW(),
                `Status` = 2
            WHERE
                `ID` = 8124865 AND
                `Language` = 'bg'
            LIMIT 1
# [05-Jun-2026 08:58:15] /shtastliveca/www/bg/vouchers/send/LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'send'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'send' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 08:58:16] /shtastliveca/www/bg/ajax/vouchers/send/LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM.html?_=1780639096094 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'LVG2CSovmvcDZLms9raEhG1RcWc8qIOE65EhFJdgK09inHgvPqbUoXEHJ7sv4qCM' AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers` SET `SendKey` = NULL WHERE `ID` = 8124865 AND `Language` = 'bg' LIMIT 1

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

SELECT
                `ID`
            FROM
                `countries`
            WHERE
                `ISO` = 'BG' AND
                `EU` = 1
            LIMIT 1

SELECT
                MAX(`ID`)
            FROM
                `invoices`
            WHERE
                `Language` = 'bg' AND
                `Supplier` = 'vintagerest'
            LIMIT 1

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = 9000000811, `Language` = 'bg', `Supplier` = 'vintagerest', `PostDate` = '2026-06-05', `LastUpdate` = '2026-06-05 08:58:16', `ParentID` = 0, `Type` = 1, `Data` = 'k9ht3Ikr-UFoBQ2axdWrkaT3XnY9tdNci9Dw4mwlZl_KvIm9G_pVDAgicWaWVVLSelnusG3ji2yYNz0J6BRhaADMohrLDH5rX4trI-eVIaXSvXzzLR9ZPN5aE4hOxYYaFtCpX_gbHcn83nZ3YUICA_rnkZnjuNUJCuYtT01CokHqXnrh3jQ-a9tEm07X1ZERo9qp0i83pRmxrmy1yEHV_i7lYbLJNqs1nAvpHGeJou9rQaAsFDtvqBkHCzNfy1r3T1dLfbMx2V0t-R9Oddp2JZ0piXhLlSSQ0KEk8wsDLxOObEzR48WnGTW8o5FsKBW3_Vba-c49RopMVHCrPXcf1TBnkO1f7uRRYe6Cv_0VloD3aTLm9RDW82aaVrYXRjSfajtzuPsUf7A5n9GRxPSNLV2dkG4UrZ2gZ91TXEcnqMqM2_exBKLe9m2sH9fDqWrVzKGc510hWaNgLzqIn6KddwsYOl5dLJDuzeJzTZkNTC1P_xbfvXTe5eN1Qg9JpcIFk3SJeNNbBPnD6auNwo9w4MX-VPfkl7pSipGpnrPwhxqm6d826zpC-yvzw5r8hQvDnjASDBXhXm44aJVNPfA0ADA2m8XqF2kFO-F5hgR2h-pnW4XGZinIjyaY_mEmLIi71iNA7e2qV-3krMarP0ZTaLGuStI_zUUJYBFEgcNHaLkExQ10upV6VMErcD6mlWq5R6QZQwTJFxYiwDZeWMoU99m322XQDi0qJyX_FLYMtvsvZTpr0l5bagWsELP18bv5vIAgpUozaZWKv80r3k7q3w', `Keywords` = '0LHRitC70LPQsNGA0LjRjw0YLQtdGB0YI0YLQtdGB0YIdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Client` = '0LHRitC70LPQsNGA0LjRjw0YLQtdGB0YI0YLQtdGB0YIdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Payment` = 1, `Currency` = 'EUR', `VAT` = 20, `Total` = 20.83

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 9000000811 AND
                `Type` = 1
            AND `Language` = 'bg' AND `Supplier` = 'vintagerest' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LCompanyVatNumber','LCompanyNumber','LCompanyPerson','LRecipient','LInvoiceDescription','LInvoiceQuantity','LInvoicePrice','LInvoiceSum','LInvoiceSubTotal','LInvoiceVAT','LInvoiceSlovom','LInvoiceTotal','LInvoicePaymentMethod','LInvoiceReceived','LInvoiceComposed') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'invoices' AND
                `Action` = 'accounting' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

UPDATE `vouchers`
            SET `InvoiceID` = 9000000811
            WHERE
                `ID` = 8124865 AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers`
            SET `Data` = 'Uvy_wpl5m1pNvVv3DG1ZDzRvT2M9HX9wEH1BF4qhacEvtwv-DU9fmAKbH8GO22sRH5GMW0EgLbMxzFy0opCCJVHInbdHWNNtbAlFlyYzCZzw94-h6StVDHS6r7z7eRoOxFgCBT07m2E91Ks8kvzrqyEmcCA759igvhpn00HnObWsxAtgDOV0TUhklXWZN3V6aG45jXyB6JnZ-RhKB8pnDfn7qn2QTMPbe48F-Eym3oIvGvqbmACco2nHwo3HAyAi1rH2bAihag6tcKkaOGi_Kbob4Fb-d4_rgC0SmdIaplQzXQNaGNgAh4TkokxoYOOCZFmnGJi1SkfN5PTAlclKg4H37mKOc1UzxSpaRa4vv9A'
            WHERE
                `ID` = 8124865 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'restaurants' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'vouchers' AND
                `Action` = 'buy' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 08:58:22] /shtastliveca/www/bg/vouchers/success.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'success' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:18] /shtastliveca/www/bg/vouchers.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'vouchers'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vouchers' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:19] /shtastliveca/www/bg/ajax/vouchers/formsum.html?_=1780639339147 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LVoucherSum','LAmount','LEnter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:20] /shtastliveca/www/bg/vouchers/form/25.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'form' AND
                P1.`Visible` = 1

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

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

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:20] /shtastliveca/www/bg/ajax/vouchers/form/25.html?_=1780639340412 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFullName','LPhone','LEMail','LSendVoucher','InfoRecipient','InfoRecipientEmail','LRecipientMessage','ErrorRecipientMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ISO`,
                `Name`,
                `NativeName`,
                `PhoneCode`
            FROM
                `countries`
            WHERE
                `PhoneCode` > 0
            ORDER BY
                CASE WHEN `ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceRecipient','LCountry','LInvoiceAddress') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `countries`.`ISO` AS `Code`,
                COALESCE(`labels`.`Value`, NULLIF(`countries`.`NativeName`, ''), `countries`.`Name`) AS `Name`
            FROM
                `countries`
                LEFT JOIN `labels` ON
                    `countries`.`Name` = `labels`.`Label` AND
                    `labels`.`Language` = 'bg'
            WHERE
                `countries`.`ISO` <> ''
            ORDER BY
                CASE WHEN `countries`.`ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:35] /shtastliveca/www/bg/ajax/vouchers/insert.html?_=1780639354983 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorVoucherAmount','ErrorName','ErrorPhoneCode','ErrorEMail','ErrorIAgreePrivacy','ErrorIAgreeVoucher') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT * FROM `vouchers` LIMIT 1

SHOW COLUMNS FROM `vouchers`

INSERT INTO `vouchers` SET `Language` = 'bg', `PostDate` = '2026-06-05 09:02:35', `LastUpdate` = '2026-06-05 09:02:35', `Data` = 'AVrkOjpr6wcW2JQn3mh1ZvCk9HUXQUYI2QJ3jQTd9-bERhbQR2tb35slRpI_mPlC4cxKU0vNugcAF3Q_8YbQ1ClawbVVtjHyz9d657dei094bzmjAVsDZIZq6g5TfIDCdhm2E36UlFilFqUIcajkfKBEhkno6Q-u9O9XrXYX3lyMnoSgfVVOIXbhNBQZjuzPR3XtnFcCEeaPlN3058mdIhOxatDt6r7OloNtmsndeUx_xWTs2pP9T36kuMNCplEV', `Keywords` = 'dGVzdAdGVzdAMzU5ODg1MDY4MzQ1dGVzdAbWF4Z3JhcGhpYwZ21haWwY29t', `SendKey` = 'Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z'

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 09:02:35] /shtastliveca/www/bg/vouchers/confirm/Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'confirm'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'confirm' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z' AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAmount','LFullName','LPhone','LEMail','LRecipient','LRecipientMessage','LEditVoucherData','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'form'
         AND `meta`.`Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Merchant`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'vintagerest', 'vouchers', 8124866, 25)

INSERT INTO `borica_info`
            (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
            (104572, NOW(), '0', '{
    "AMOUNT": "25.00",
    "CURRENCY": "EUR",
    "DESC": "vouchers 8124866 2026-06-05 09:02:35",
    "TERMINAL": "V5200005",
    "MERCH_NAME": "Щастливеца",
    "MERCH_URL": "shtastliveca.com",
    "MERCHANT": "5610001773",
    "TRTYPE": "1",
    "ORDER": "104572",
    "AD.CUST_BOR_ORDER_ID": "104572#20260605090235",
    "COUNTRY": "BG",
    "TIMESTAMP": "20260605060235",
    "MERCH_GMT": "+03",
    "NONCE": "44BC0CCED9EB9C41AA80BDE08387EB5C",
    "BACKREF": "https:\\/\\/www.shtastliveca.com\\/bg\\/borica\\/response.html",
    "ADDENDUM": "AD,TD",
    "M_INFO": "{\\"threeDSRequestorChallengeInd\\":\\"04\\",\\"cardholderName\\":\\"TEST TEST\\",\\"email\\":\\"test.maxgraphic@gmail.com\\",\\"mobilePhone\\":{\\"cc\\":\\"359\\",\\"subscriber\\":\\"885068345\\"}}",
    "P_SIGN": "49AC46E59838949AA9E2BEC0D873E31069FE57E7E6A7EF81A5E1B0B2D64DAE048A4BC898B4521A48ABB3EFC190D004CF7BCBB3AF751E6F8C5A66C1CF5D19A296953653DB72C1FEEE12B7EE165E5A6110A512BB42B73BD6937C1BD8F6F915B5E8E6332CB0E18FA5DCB52BCDF66640D228EB1AAF63A5CBA011AC85A7A7FEABD2919B57101179E1FE9F10E394A8B4F315F5CEC966943A26E772680C156E5C61963089E853F2D4474FCB4D4FD622D5C1A6AEDD1580FEAA26EF121F0F97914E8A8DE403A822F894CCE95C077F5DBB534503A258C3CF9291A9D756427ECE6CFFC8823B3D15BFC8040F5FAFCB0EBAADD366C476CB480C778AE34927DE3B7FF0982A761F"
}')

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:38] /shtastliveca/www/bg/borica/test/104572.html 108.61.209.243

set names utf8

SELECT
                `borica_info`.`Info`
            FROM
                `borica`
                INNER JOIN `borica_info` ON
                    `borica_info`.`BoricaID` = `borica`.`ID` AND
                    `borica_info`.`Type` = 0
            WHERE
                `borica`.`ID` = 104572 AND
                `borica`.`ResponseCode` IS NULL
            ORDER BY
                `borica_info`.`PostDate` DESC
            LIMIT 1

SELECT 
                    `borica`.`ID`,
                    `borica`.`Language`
                FROM 
                    `borica`
                    INNER JOIN `borica_info` ON
                        `borica_info`.`BoricaID` = `borica`.`ID` AND
                        `borica_info`.`Type` = 0
                WHERE 
                    `borica_info`.`Info` LIKE '%"ORDER": "104572"%' AND
                    `borica`.`ResponseCode` IS NULL
                ORDER BY
                    `borica`.`ID` DESC
                LIMIT 1

INSERT INTO `borica_info`
                    (`BoricaID`, `PostDate`, `Type`, `Info`) VALUES
                    (104572, NOW(), '1', '{
    "ACTION": "0",
    "RC": "00",
    "STATUSMSG": "Test",
    "TERMINAL": "V5200005",
    "TRTYPE": "1",
    "AMOUNT": "0.00",
    "CURRENCY": "EUR",
    "ORDER": "104572",
    "LANG": "bg",
    "TRAN_DATE": "20260605090238",
    "APPROVAL": "TEST"
}')

UPDATE `borica` SET `LastUpdate` = NOW(), `ResponseCode` = '00' WHERE `ID` = 104572 LIMIT 1
# [05-Jun-2026 09:02:38] /shtastliveca/www/bg/borica/status/104572.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'borica' AND
	    		`meta`.`URLLabel` = 'status'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'borica' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'status' AND
                P1.`Visible` = 1

SELECT
                *
            FROM
                `borica`
            WHERE
                `ID` = 104572
            LIMIT 1

SELECT
                `Info`
            FROM
                `borica_info`
            WHERE
                `BoricaID` = 104572 AND
                `Type` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 1

SELECT
                `Data`,
                `Keywords`
            FROM
                `vouchers`
            WHERE
                `ID` = 8124866 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `SendKey`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`ID` = 8124866 AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers`
            SET
                `LastUpdate` = NOW(),
                `Status` = 2
            WHERE
                `ID` = 8124866 AND
                `Language` = 'bg'
            LIMIT 1
# [05-Jun-2026 09:02:38] /shtastliveca/www/bg/vouchers/send/Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'send'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'send' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:02:38] /shtastliveca/www/bg/ajax/vouchers/send/Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z.html?_=1780639358882 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                `Keywords`
	        FROM
	        	`vouchers`
	    	WHERE
	    		`SendKey` = 'Ku3pBy2lt9nzSbs517AOcMhS12JI1y8rx4Cd8RtGzOzu6P4xHATTF9Rkk8DqCS8Z' AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers` SET `SendKey` = NULL WHERE `ID` = 8124866 AND `Language` = 'bg' LIMIT 1

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

SELECT
                `ID`
            FROM
                `countries`
            WHERE
                `ISO` = 'BG' AND
                `EU` = 1
            LIMIT 1

SELECT
                MAX(`ID`)
            FROM
                `invoices`
            WHERE
                `Language` = 'bg' AND
                `Supplier` = 'vintagerest'
            LIMIT 1

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `ID` = 9000000812, `Language` = 'bg', `Supplier` = 'vintagerest', `PostDate` = '2026-06-05', `LastUpdate` = '2026-06-05 09:02:38', `ParentID` = 0, `Type` = 1, `Data` = 'MQ5quyYLK4z34FmpYgYA-ujnRggezCNvTH1b48J3Ww0w8pqNEHliqacR03ZEQu-S-O7Lx1nTF4bmEC6dTgB3P0XIp-ay8g73fXpEtV8cC2bREtuPvHYrccZesvmQZxRzf-a6yei4LJyr1mWKJPLAGbjc-O_-n_4Mo7oIp7oEGQc6TDftSBdyBnXG8RocbkTGFKvgXbNWLfwN_eLLCdbUOeKZpCFAx1lg0N1U825yUHXRgKPoy9fa1te-2HPUY6NwHf_T4ERUpm1aK0u_Q5dXqmpVG7CquaQ_qSjoiSgJ0pKDqQxv13flhb5WLQ4SoPHjSz2eOhXNWU8_Hm-gYe2SuBK0cEZRpMc7V4yCC0YYr1xPHWBsbiteAhiWk4C39lFSPGuCYuAE-VCekc5-Vxo7e1lLN11coo5JxlQN0scBojPzbEE7S4c4P-g9Jt4pDF-iCy9Bajv8M8MqXtXKOEaBFdKpTIbTtsDwJS43A9W1Y33GF64VuFVA8QdlWEJSwcoCk8YfQ3QBvv4X2Qr2MUzDo4fBbjpv06lVJdqADzKONSLQeDv-prl5q6vFYoQYhJzA5wJgkMfo9FJVN-ZKSTnS2oDqWJUDm0kleYLcvRdwS1uEscVGYJ6dkyKGfiVaq46DlN9DIwqIC1SXJT7M0YToUySd-pJZzZQJl0AjL-Kxtcb4sZuZipcEfzuYi74fFezcCgWSlMJrPZdpkDJ-ooZDDVex3ffNuxychXLo4NYfIJNFQ0fHI573xrHYTYkWKMV9', `Keywords` = '0LHRitC70LPQsNGA0LjRjwdGVzdAdGVzdAdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Client` = '0LHRitC70LPQsNGA0LjRjwdGVzdAdGVzdAdGVzdAbWF4Z3JhcGhpYwZ21haWwY29t0LLQsNGD0YfQtdGA0LfQsA0LrQvtC90YHRg9C80LDRhtC40Y80YDQtdGB0YLQvtGA0LDQvdGC0Lg0YnQsNGB0YLQu9C40LLQtdGG0LA', `Payment` = 1, `Currency` = 'EUR', `VAT` = 20, `Total` = 20.83

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 9000000812 AND
                `Type` = 1
            AND `Language` = 'bg' AND `Supplier` = 'vintagerest' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LCompanyVatNumber','LCompanyNumber','LCompanyPerson','LRecipient','LInvoiceDescription','LInvoiceQuantity','LInvoicePrice','LInvoiceSum','LInvoiceSubTotal','LInvoiceVAT','LInvoiceSlovom','LInvoiceTotal','LInvoicePaymentMethod','LInvoiceReceived','LInvoiceComposed') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'invoices' AND
                `Action` = 'accounting' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

UPDATE `vouchers`
            SET `InvoiceID` = 9000000812
            WHERE
                `ID` = 8124866 AND
                `Language` = 'bg'
            LIMIT 1

UPDATE `vouchers`
            SET `Data` = 'oiOVLjG2tioGQVvqO8UIxfl-yGKowVwwHs27pv9pSVxBuAOfxIVI2Psiiatxi5LkxvGaS_9dwYpJHxKKMNfQMT0c6bVZsjTwKUyDx-eXE1PJCRC_KBAGI6c85XWVhGZ5hwbYJ9cWAZ2KtwQ-0K1Hq0-qOUmn5GndmbisxrUNGMc3GkH_ciaJplqVUExuRoHu_EBZX8EgOLRwHmFJdeAiq9LnSwCqYKztv8qqW6dS5ke0omLxySabkflmfBoAqJ9BzXUEp64Dsg2oUlAZHvyfSdFvtblw68_Xm8dfXAAYyUbHYu0tmGPeQQ75Tb9B3hFNdFZdXW-fUNUCjdcYXu_L3Q'
            WHERE
                `ID` = 8124866 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'voucher'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'restaurants' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'vouchers' AND
                `Action` = 'buy' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
                `pages`.`Action` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1
# [05-Jun-2026 09:02:44] /shtastliveca/www/bg/vouchers/success.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'vouchers' AND
	    		`meta`.`URLLabel` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'vouchers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'success' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:04:46] /shtastliveca/www/bg/reservations.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
	    		`meta`.`URLLabel` = 'reservations'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'reservations' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'reservations' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`ID`,
                `restaurants`.`Image`,
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`Address`,
                `restaurants`.`Phones`,
                `restaurants`.`EMails`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`,
                `meta`.`UploadID`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:04:48] /shtastliveca/www/bg/reservations/shtastlivetsa-sofiya-bul-vitosha.html 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`URLLabel` = 'shtastlivetsa-sofiya-bul-vitosha' AND
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'restaurants' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'shtastlivetsa-sofiya-bul-vitosha' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGuestsNumber','LDate','LTime','LContinue','Tomorrow') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:04:55] /shtastliveca/www/bg/reservations/shtastlivetsa-sofiya-bul-vitosha.html 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`URLLabel` = 'shtastlivetsa-sofiya-bul-vitosha' AND
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'restaurants' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'shtastlivetsa-sofiya-bul-vitosha' AND
                P1.`Visible` = 1

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

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

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

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

SELECT
                `ISO`,
                `Name`,
                `NativeName`,
                `PhoneCode`
            FROM
                `countries`
            WHERE
                `PhoneCode` > 0
            ORDER BY
                CASE WHEN `ISO` = 'BG' THEN 0 ELSE 1 END,
                `Name` ASC

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

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:05:07] /shtastliveca/www/bg/ajax/reservations/insert.html?_=1780639507805 108.61.209.243

set names utf8

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

SELECT
                    CONCAT(`Town`, ' - ', `LocationLabel`)
                FROM
                    `restaurants`
                WHERE
                    `ID` = 220000004 AND
                    `Language` = 'bg'
                LIMIT 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ID` = NULL, `PostDate` = '2026-06-05', `LastUpdate` = '2026-06-05 09:05:07', `Language` = 'bg', `RestaurantID` = '220000004', `ResDate` = '2026-06-06', `ResTime` = '11:00', `Guests` = '10', `Data` = '6v-ufjtTjBluh3deYp64gPI2X7FIU8_gdhp2n_jvISa1WJaFVFERe_jIPeglGhw7DMu5z38GGc40d4g1vgmgO94WoIQ9Skr0Gp2rwUqYtrMbHmytr6IZ-B-6UPamC9Iyt96xowX0hOGC8s4LvcsaN4t845veZxilV_9pE0JurwOb6cPjg-41RIZGofeuj-pegnYi7eqmVlj9_n-ZpE84oumLOWDum3T11Kus_lFzvwl-VQvSeDvOpGK5_-O67X0096seeTiqZyBwv2qzh9wPrpnkh3MUj-BWkJS6ScUGP5_0DzrZvwjv9yAuxvNmhEHisUtUOBSlyAPbqLkxFnR7zJ2ugNQ0fuH8h8TZuK0w-zo2apg_XDdiFRGS6b16gA9uAzYTVLgHsstGOeycqq5EdcZ1Ig0aHzi-1BYQNRlVdoryoCLki-LGlMCrDbWhHi4a', `Keywords` = 'dGVzdAdGVzdAdGVzdAbWF4Z3JhcGhpYwZ21haWwY29tMzU5ODg1MDY4MzQ1'

SELECT
                `Subject`,
                `Content`
            FROM
                `templates`
            WHERE
                `Module` = 'reservations' AND
                `Action` = 'send' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1
# [05-Jun-2026 09:05:11] /shtastliveca/www/bg/reservations/success.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
	    		`meta`.`URLLabel` = 'success'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'reservations' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'success' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurRestaurants') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jun-2026 09:52:19] /shtastliveca/www/bg/reservations/paid.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
	    		`meta`.`URLLabel` = 'paid'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'reservations' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'paid' AND
                P1.`Visible` = 1

SELECT
                `restaurants`.`UpTitle`,
                `restaurants`.`Town`,
                `restaurants`.`LocationLabel`,
                `meta`.`URLLabel`
            FROM
                `restaurants`
                INNER JOIN `meta` ON
                    `restaurants`.`ID` = `meta`.`ID` AND
                    `restaurants`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'restaurants'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            ORDER BY
                `meta`.`PostDate` ASC

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