# [03-Jun-2026 15:32:45] /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
# [03-Jun-2026 15:32:48] /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
# [03-Jun-2026 15:32:49] /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
