# [05-May-2025 14:09:18] /rapsody/root/rpV4nz0Sa0q/bg/events.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881527 AND
                                CRC32(`UserKey`) = 33772506 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'events' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'events' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
        
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
         LIMIT 0, 10

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

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

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

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
        
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
        ) AS CountTable

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'articles' AND `Language` = 'bg' 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`
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> ''
             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`
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language`
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE()
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         ORDER BY `PostDate` ASC
# [05-May-2025 14:09:18] /rapsody/root/bg/ajax/basket/qty.html?_=1746443358914 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847'
            LIMIT 1
# [05-May-2025 14:09:30] /rapsody/root/bg/ajax/orders/form/25.html?_=1746443370034 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 25 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 25

SELECT `ID` FROM `orders` WHERE `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847' AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEMail','LPhone','LAgreeText','ErrorIAgreeCheck','LAgreeData','ErrorNumber') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 25 AND `TypeID` = 0

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

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