# [27-Mar-2025 09:17:05] /processspace/www/psNr2S0bbg/pages/www.letmekoo.lt/artists/vilma-sileikiene 167.99.142.201

set names utf8

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
# [27-Mar-2025 09:31:00] /processspace/www/psNr2S0bbg/pages/www.kimdottyhachmann.de 167.99.142.201

set names utf8

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
# [27-Mar-2025 13:39:59] /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
# [27-Mar-2025 14:53:11] /processspace/www/ 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
# [27-Mar-2025 14:53:11] /processspace/www/bg/ajax/cookies.html?_=1743079990203 167.99.142.201

set names utf8

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 ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 14:53:13] /processspace/www/bg/приятелски-клуб.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'приятелски-клуб' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'приятелски-клуб'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 14:53:13] /processspace/www/bg/ajax/cookies.html?_=1743079992151 167.99.142.201

set names utf8

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 ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 14:53:19] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 14:53:20] /processspace/www/bg/ajax/club/form/individual.html?_=1743079998529 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorIAgree') 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 14:54:13] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 14:54:13] /processspace/www/bg/ajax/club/form/individual.html?_=1743080052134 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorIAgree') 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 14:54:55] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1743080213066 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '3fBjxWPD9nJ2RNL0Fz16488O80PxTonLG6l4jxp7llL25qybQYI0569iLcTQA3xl'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOSw5XDlsK0w4bDl8KIw4fDkg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [27-Mar-2025 14:55:03] /processspace/www/psNr2S0b/bg/ajax/users/login.html?_=1743080220903 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '3fBjxWPD9nJ2RNL0Fz16488O80PxTonLG6l4jxp7llL25qybQYI0569iLcTQA3xl'
            LIMIT 1
# [27-Mar-2025 14:55:03] /processspace/www/psNr2S0b/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF((`MenuLabel` = '' OR `MenuLabel` IS NULL), IF((`SubMenuLabel` = '' OR `SubMenuLabel` IS NULL), `FooterLabel`, `SubMenuLabel`), `MenuLabel`) AS `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'club' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
# [27-Mar-2025 14:55:09] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [27-Mar-2025 14:55:14] /processspace/www/psNr2S0b/bg/ajax/payments/40.html?_=1743080231416 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 3623542469 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` = 40
            ORDER BY
                `payment_info`.`PostDate` ASC
# [27-Mar-2025 14:55:47] /processspace/www/psNr2S0b/bg/ajax/payments/38.html?_=1743080264252 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 3623542469 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` = 38
            ORDER BY
                `payment_info`.`PostDate` ASC
# [27-Mar-2025 14:55:55] /processspace/www/psNr2S0b/bg/ajax/payments/fibank/check/38.html?_=1743080273065 167.99.142.201

set names utf8

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

SELECT `TransactionID` FROM `payments` WHERE `ID` = 38 AND `Provider` = 'fibank' AND `Status` = 0

UPDATE `payments` SET `LastUpdate` = NOW(), `Status` = '10' WHERE `ID` = 38

SELECT * FROM `payment_info` LIMIT 1

SHOW COLUMNS FROM `payment_info`

INSERT INTO `payment_info` SET `PaymentID` = '38', `PostDate` = NOW(), `Result` = '{"RESULT":"TIMEOUT"}'
# [27-Mar-2025 14:55:56] /processspace/www/psNr2S0b/bg/payments/list.html 167.99.142.201

set names utf8

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

SELECT
                `payments`.`ID`,
                `payments`.`TransactionID`,
                `payments`.`PostDate`,
                `payments`.`LastUpdate`,
                `payments`.`Amount`,
                `payments`.`Status`,
                `club`.`Membership`,
                `club`.`Data`
            FROM
                `payments`
                INNER JOIN `club` ON
                    `payments`.`ModuleID` = `club`.`ID` AND
                    `payments`.`Module` = 'club'
            ORDER BY  `PostDate` DESC
# [27-Mar-2025 14:55:59] /processspace/www/psNr2S0b/bg/ajax/payments/38.html?_=1743080276465 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 3623542469 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` = 38
            ORDER BY
                `payment_info`.`PostDate` ASC
# [27-Mar-2025 14:56:11] /processspace/www/psNr2S0b/bg/ajax/payments/39.html?_=1743080288408 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 3623542469 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` = 39
            ORDER BY
                `payment_info`.`PostDate` ASC
# [27-Mar-2025 14:56:19] /processspace/www/psNr2S0b/bg/ajax/payments/38.html?_=1743080297148 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 3623542469 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` = 38
            ORDER BY
                `payment_info`.`PostDate` ASC
# [27-Mar-2025 14:57:16] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 14:57:16] /processspace/www/bg/ajax/club/form/individual.html?_=1743080235045 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorIAgree') 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 15:02:03] /processspace/www/en/club/individual.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'club' AND
	    		`URLLabel` = 'individual'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:02:03] /processspace/www/en/ajax/club/form/individual.html?_=1743080522428 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 15:02:08] /processspace/www/en/friends-club.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'friends-club' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'friends-club'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:02:11] /processspace/www/ 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
# [27-Mar-2025 15:02:14] /processspace/www/bg/friends-club.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'friends-club' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 15:02:16] /processspace/www/en/index.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'en' 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` = 'en' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:02:18] /processspace/www/en/friends-club.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'friends-club' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'friends-club'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:02:23] /processspace/www/bg/club/individual.html 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [27-Mar-2025 15:02:23] /processspace/www/bg/ajax/club/form/individual.html?_=1743080541898 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorIAgree') 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 15:02:28] /processspace/www/en/index.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'en' 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` = 'en' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:02:30] /processspace/www/en/friends-club.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'friends-club' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'friends-club'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:03:35] /processspace/www/en/friends-club.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'friends-club' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'friends-club'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:03:37] /processspace/www/en/club/individual.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'club' AND
	    		`URLLabel` = 'individual'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'en'
             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` = 'en' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'en' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [27-Mar-2025 15:03:37] /processspace/www/en/ajax/club/form/individual.html?_=1743080616444 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LInvText','LInvRecipient','LInvEIK','LInvVAT','LInvCity','LInvAddress','LInvMOL','LInvEMailInfo','LSend') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [27-Mar-2025 15:10:30] /processspace/www/en/ajax/club/submit/individual.html?_=1743081028696 167.99.142.201

set names utf8

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

SELECT * FROM `club` LIMIT 1

SHOW COLUMNS FROM `club`

INSERT INTO `club` SET `Language` = 'en', `PostDate` = '2025-03-27', `LastUpdate` = '2025-03-27 15:10:30', `Membership` = 'individual', `Data` = 'ci9PhVg23CHz7FGKXRtZqQcNl4lNcRVnbhsEY4hBfKgiCHeB16fwL1luXtCWkE4TJvIJqCQhEAYWieFbs6yDYoksL52afwEgD2XBnRLf2mbLjCONpPuZmXfQoyknL8Xm1div-UAO0gaiC3qAoBUOp7IY2hWXrR9oD7UEBRwaG0U2HW_QFaY8zpBr6sPRfOW2i3TZOcgwuEOZo3EyEOgXAjInEflP2q9q9lL88NhD70zlwxnXNuDHeTe7o47yX3MwoGBieA09Xtb4CJm4eAvI3e3-6948QQw3c4_8dc18f34cMFol7emHSt2cMhFyT2FLmdRYfLkVw0MsaG08iWGJRpBFyS4i-aug8iAcMlNwse0'

SELECT * FROM `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `TransactionID` = 'sb5xYwzZgJhJvNNrxUrF1Qhwukc=', `Description` = '48 individual davarski@gmail.com', `PostDate` = '2025-03-27 15:10:32', `LastUpdate` = '2025-03-27 15:10:32', `Module` = 'club', `ModuleID` = 48, `Amount` = 0.1, `Currency` = 'BGN', `Provider` = 'fibank'
# [27-Mar-2025 16:16:12] /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
