# [12-Mar-2025 10:47:19] /sterimar/www/ 108.61.209.243

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `Title`,
                `URL`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                `Images` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `groups`.`Image`,
                `meta`.`URLLabel`,
                `groups`.`Title`,
                `groups`.`Annotation`,
                `groups`.`Color`,
                `meta`.`Visible`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `groups`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

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

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

SELECT
                `Content`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'articles' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Color`,
                `articles`.`Label`,
                `meta`.`Visible`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC
         LIMIT 0, 4

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

SELECT * FROM `instagram` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` DESC

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

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:23] /sterimar/www/bg/produkti/hipertonichni.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `groups`.`ID`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'hipertonichni'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `products`.`Annotation`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
                INNER JOIN `product_groups` ON
                    `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_groups`.`GroupID` = 10002 AND
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:30] /sterimar/www/bg/produkti/sterimar-sprey-za-zapushen-nos-bebe-50ml.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `groups`.`ID`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'sterimar-sprey-za-zapushen-nos-bebe-50ml'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                *
	        FROM
	        	`products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
	    	WHERE
	    		`meta`.`URLLabel` = 'sterimar-sprey-za-zapushen-nos-bebe-50ml'
         AND `meta`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'sterimar-sprey-za-zapushen-nos-bebe-50ml' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPurpose','LPack','LBuyNow','LPurpose1','LPurpose2','LPurpose3','LPurpose4') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:35] /sterimar/www/bg/produkti/sprei-za-higiena-50ml.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `groups`.`ID`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'sprei-za-higiena-50ml'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                *
	        FROM
	        	`products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
	    	WHERE
	    		`meta`.`URLLabel` = 'sprei-za-higiena-50ml'
         AND `meta`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'sprei-za-higiena-50ml' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPurpose','LPack','LBuyNow','LPurpose1','LPurpose2','LPurpose3','LPurpose4') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:39] /sterimar/www/bg/istoriya.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'istoriya'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'istoriya'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'istoriya' AND
                P1.`Visible` = 1

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:39] /sterimar/www/bg/blog.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'blog'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'blog'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'articles' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'blog' AND
                P1.`Visible` = 1

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

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Color`,
                `articles`.`Label`,
                `meta`.`Visible`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:47:41] /sterimar/www/bg/vaprosi.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'vaprosi'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'faq' AND
	    		`meta`.`URLLabel` = 'vaprosi'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'faq' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vaprosi' AND
                P1.`Visible` = 1

SELECT DISTINCT
                `Label`
            FROM
                `faq`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Употреба на продукта' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Състав' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Технология' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Практична информация' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:49:08] /sterimar/www/bg/vaprosi.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'vaprosi'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'faq' AND
	    		`meta`.`URLLabel` = 'vaprosi'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'faq' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'vaprosi' AND
                P1.`Visible` = 1

SELECT DISTINCT
                `Label`
            FROM
                `faq`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Употреба на продукта' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Състав' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Технология' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `ID`,
                `Question`,
                `Answer`,
                `Visible`
            FROM
                `faq`
            WHERE
                `Label` = 'Практична информация' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:49:27] /sterimar/www/ 108.61.209.243

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `Title`,
                `URL`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                `Images` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `groups`.`Image`,
                `meta`.`URLLabel`,
                `groups`.`Title`,
                `groups`.`Annotation`,
                `groups`.`Color`,
                `meta`.`Visible`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `groups`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

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

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

SELECT
                `Content`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'articles' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Color`,
                `articles`.`Label`,
                `meta`.`Visible`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC
         LIMIT 0, 4

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

SELECT * FROM `instagram` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` DESC

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

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:49:33] /sterimar/www/bg/produkti.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'produkti' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:50:20] /sterimar/www/bg/produkti.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'produkti' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:50:27] /sterimar/www/bg/produkti/sprei-za-higiena-50ml.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `groups`.`ID`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`URLLabel` = 'sprei-za-higiena-50ml'
         AND
                `meta`.`Visible` = 1
             LIMIT 1

SELECT
                *
	        FROM
	        	`products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
	    	WHERE
	    		`meta`.`URLLabel` = 'sprei-za-higiena-50ml'
         AND `meta`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'sprei-za-higiena-50ml' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPurpose','LPack','LBuyNow','LPurpose1','LPurpose2','LPurpose3','LPurpose4') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:50:34] /sterimar/www/bg/produkti.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'produkti' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:50:43] /sterimar/www/bg/produkti.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'produkti' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 10:50:44] /sterimar/www/bg/produkti.html 108.61.209.243

set names utf8

SELECT
                `meta`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
	    		`meta`.`URLLabel` = 'produkti'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'products' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'produkti' AND
                P1.`Visible` = 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `products`.`Images`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title`,
                `meta`.`Visible`
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','InstagramURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 15:54:51] /sterimar/www/ 108.61.209.243

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `Title`,
                `URL`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                `Images` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `meta` AS P1
                INNER JOIN `meta` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P1.`Module` = P2.`Module` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Module` = 'pages' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'products' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `groups`.`Image`,
                `meta`.`URLLabel`,
                `groups`.`Title`,
                `groups`.`Annotation`,
                `groups`.`Color`,
                `meta`.`Visible`
            FROM
                `groups`
                INNER JOIN `meta` ON
                    `groups`.`ID` = `meta`.`ID` AND
                    `groups`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'groups'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `groups`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

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

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

SELECT
                `Content`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'articles' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Color`,
                `articles`.`Label`,
                `meta`.`Visible`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC
         LIMIT 0, 4

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

SELECT * FROM `instagram` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` DESC

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

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `gama`.`UploadID`,
                `gama`.`MenuLabel`,
                `gama`.`Icon`,
                `gama`.`Color`,
                GROUP_CONCAT(`products`.`ID`) AS `ProductIDs`
            FROM
                `gama`
                INNER JOIN `product_gama` ON `gama`.`ID` = `product_gama`.`GamaID`
                INNER JOIN `products` ON `products`.`ID` = `product_gama`.`ProductID`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
            WHERE
                `gama`.`Language` = 'bg' AND
                `products`.`Language` = 'bg'
         AND
                `gama`.`Visible` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `gama`.`ID`
            ORDER BY
                `gama`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10001','10000')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10005','10004')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `products`.`Title` AS `MenuLabel` -- TODO: add MenuLabel in table
            FROM
                `products`
                INNER JOIN `meta` ON
                    `products`.`ID` = `meta`.`ID` AND
                    `products`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'products'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'products'
            WHERE
                `meta`.`Language` = 'bg' AND
                `products`.`ID` IN('10002','10003')
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `products`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOurCommitments','Address','LContacts','LFollowUs','FacebookURL','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 15:54:54] /sterimar/www/bg/ajax/users/form/login.html?_=1741787694095 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [12-Mar-2025 15:54:58] /sterimar/www/sMv8dk1cXir/bg/ajax/users/login.html?_=1741787697710 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTIYjFhNTYxNzFmZThiOWY0YjI0NWU5MzU5Mzg0NTk5NTc%'
            LIMIT 1
# [12-Mar-2025 15:54:58] /sterimar/www/sMv8dk1cXir/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `pages`.`Action`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         ORDER BY `meta`.`PostDate` ASC
# [12-Mar-2025 15:55:01] /sterimar/www/sMv8dk1cXir/bg/ajax/pages/form/contacts/102.html?_=1741787700496 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876878 AND
                                CRC32(`UserKey`) = 3249993104 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `Parent`.`Module` AS `ParentModule`,
                `meta`.*,
                `pages`.*
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 102 AND
                `meta`.`Module` = 'contacts' AND
                `meta`.`Language` = 'bg'
            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `pages`.`MenuLabel` AS `Label`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'contacts' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''

SELECT `Module`, `Action`, `Label` FROM `blocks`
