
set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'bg' AND
                `ID` = 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
	        	`Title`,
	        	`MenuLabel`,
                `URLLabel`,
                `SubTitle`,
	        	`Annotation`,
                `Icon`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `AddOn` LIKE '%/reviews/%'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `FirstPage` = 0 AND `Visible` = 1

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

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'tr' AND
                `ID` = 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
	        	`Title`,
	        	`MenuLabel`,
                `URLLabel`,
                `SubTitle`,
	        	`Annotation`,
                `Icon`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'tr' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/reviews/%'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `FirstPage` = 0 AND `Visible` = 1

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'tr'
         AND `Visible` = 1 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'tr' AND
	    		`URLLabel` = 'cmr'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'tr' AND
                `ID` = 17

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'tr' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'en' AND
                `ID` = 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
	        	`Title`,
	        	`MenuLabel`,
                `URLLabel`,
                `SubTitle`,
	        	`Annotation`,
                `Icon`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/reviews/%'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `FirstPage` = 0 AND `Visible` = 1

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'en' AND
                `ID` = 17

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

INSERT INTO `cmr` SET `Progress` = 2, `LastUpdate` = '2025-11-19 12:27:10', `Language` = 'en', `PostDate` = '2025-11-19', `Data` = '{"Name":"Виктория","EMail":"victoria@gmail.VM","Number":"","Sender":"VM clothing \\nSofia ","Receiver":"AD clothing\\nPazardhik","Date":"20.11.2025","City":"Sofia","Country":"Bulgaria","UnloadingPoint":"Italy , Milano ","DeliveryCountry":"Italy"}'

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'en' AND
                `ID` = 17

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 3, `LastUpdate` = '2025-11-19 12:28:18', `Language` = 'en', `Data` = '{"Name":"Виктория","EMail":"victoria@gmail.VM","Number":"","Sender":"VM clothing \\nSofia ","Receiver":"AD clothing\\nPazardhik","Date":"20.11.2025","City":"Sofia","Country":"Bulgaria","UnloadingPoint":"Italy , Milano ","DeliveryCountry":"Italy","Symbols":"1","NumberOfPackages":"1200","PackagingMethod":"boxes","TypeOfGoods":"boxes","TotalWeight":"100","Volume":"10cbm"}' WHERE `ID` = '10' AND `Language` = 'en'

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'en' AND
                `ID` = 17

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-19 12:28:21', `Language` = 'en', `Data` = '{"Name":"Виктория","EMail":"victoria@gmail.VM","Number":"","Sender":"VM clothing \\nSofia ","Receiver":"AD clothing\\nPazardhik","Date":"20.11.2025","City":"Sofia","Country":"Bulgaria","UnloadingPoint":"Italy , Milano ","DeliveryCountry":"Italy","Symbols":"1","NumberOfPackages":"1200","PackagingMethod":"boxes","TypeOfGoods":"boxes","TotalWeight":"100","Volume":"10cbm","Notes":"","Documents":"","SpecialAgreements":"","AdditionalNotes":"","CashOnDelivery":""}' WHERE `ID` = '10' AND `Language` = 'en'

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

set names utf8

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

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'en' AND
                `ID` = 25

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `AddOn` LIKE '%/rules/%'
         AND `Visible` = 1 LIMIT 1
