# [09-Jul-2025 04:28:25] /rapsody/root/bg/ajax/basket/qty.html?_=1751932800010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
# [09-Jul-2025 05:58:10] /rapsody/root/bg/контакти.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'контакти' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'контакти' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'contacts' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'contacts' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 05:59:17] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
# [09-Jul-2025 05:59:18] /rapsody/root/bg/ajax/contacts/form.html?_=1752019200011 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSendRequest','LSend','LName','LPhone','LEMail','LMessage','LAgreeCheck','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1
# [09-Jul-2025 07:47:34] /rapsody/root/bg/блог/занзибар.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'блог' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'занзибар' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 28 AND
                `Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 2

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'articles' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 07:47:59] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
# [09-Jul-2025 10:00:36] /rapsody/root/bg/блог/будва-перфектната-парти-дестинация-за-лято-2023.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'блог' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'будва-перфектната-парти-дестинация-за-лято-2023' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 30 AND
                `Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 2

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'articles' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 10:00:38] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '6dcc40356766058eb720c0fa41b044d9212f6c97cd57daa5dfec6dbc1bb35f2a'
            LIMIT 1
# [09-Jul-2025 12:06:13] /rapsody/root/bg/общи-условия-за-ползване.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'общи-условия-за-ползване' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'общи-условия-за-ползване' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'общи-условия-за-ползване' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 12:06:39] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
# [09-Jul-2025 13:36:13] /rapsody/root/bg/livigno.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'livigno' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'livigno'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 71 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1542 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1508 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1508
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1508
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 71 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 71 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 13:36:22] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
# [09-Jul-2025 18:33:02] /rapsody/root/bg/блог/оперативна-програма-иновации-и-конкурентноспособност.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'блог' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'оперативна-програма-иновации-и-конкурентноспособност' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 8 AND
                `Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 2

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'articles' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 21:33:02] /rapsody/root/bg/shop/тениска-vespa-green.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'shop' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *,
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
	    		`URLLabel` = 'тениска-vespa-green'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `URLLabel`,
                `ColorImage`,
                `Gallery`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `RefID` = (SELECT `RefID` FROM `products` WHERE `ID` = 10 LIMIT 1) AND
                `Language` = 'bg' AND
                `ColorImage` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC,`LastUpdate` ASC

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

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

SELECT * FROM `faq` WHERE `OfferID` = 0 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Jul-2025 21:33:06] /rapsody/root/bg/ajax/basket/qty.html?_=1752019200010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '229929334aad00df61589a6a3a8fcf75e0af2c92cd6eefc1f6e08fd207e75f43'
            LIMIT 1
