# [25-Mar-2025 06:48:29] /processspace/www/psNr2S0b/bg/ajax/payments/37.html?_=1742878109321 167.99.142.201

set names utf8

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

SELECT
                `payments`.`TransactionID`,
                `payments`.`PostDate` AS `PaymentDate`,
                `payments`.`Description`,
                `payments`.`Amount`,
                `payment_info`.`PostDate`,
                `payment_info`.`Result`
            FROM
                `payments`
                LEFT JOIN `payment_info` ON `payments`.`ID` = `payment_info`.`PaymentID`
            WHERE
                `payments`.`ID` = 37
            ORDER BY
                `payment_info`.`PostDate` ASC
# [25-Mar-2025 07:32:16] /processspace/www/bg 167.99.142.201

set names utf8

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

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `HeaderFirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ImageHome` > '' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `NoIndex` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 68
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

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

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

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
