# [18-Jun-2024 07:27:56] /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
# [18-Jun-2024 07:28:01] /hanson/www/en/terms-and-conditions.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'terms' AND
	    		`URLLabel` = 'terms-and-conditions'
         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
# [18-Jun-2024 07:28:29] /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
