# [12-Sep-2024 15:42:45] /hanson/www/ 108.61.209.243

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `URL`
            FROM
                `slides`
            WHERE
                `Language` = 'en' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [12-Sep-2024 15:42:47] /hanson/www/en/contacts.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [12-Sep-2024 15:42:48] /hanson/www/en/ajax/contacts/form.html?_=1726144967839 108.61.209.243

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [12-Sep-2024 15:42:59] /hanson/www/en/ajax/contacts/send.html?_=1726144978885 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRequest','LName','LPhone','LEMail','LSubject','LMessage','LSend','ErrorIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P1
                    INNER JOIN `pages` P2 ON
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Module` = P2.`Module` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P1.`Language` = 'en' AND
                    P1.`ParentID` = 1 AND
                    P1.`Module` = 'contacts' AND
                    P2.`Action` = 'success'
             AND P1.`Visible` = 1 AND P2.`Visible` = 1 LIMIT 1
# [12-Sep-2024 15:42:59] /hanson/www/en/contacts/success.html 108.61.209.243

set names utf8

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [12-Sep-2024 15:47:40] /hanson/www/en/contacts.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [12-Sep-2024 15:47:41] /hanson/www/en/ajax/contacts/form.html?_=1726145260799 108.61.209.243

set names utf8

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

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

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

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