
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` = 'bg' AND
	    		`URLLabel` = 'cmr'
         AND `Visible` = 1 LIMIT 1

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

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 `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

INSERT INTO `cmr` SET `Progress` = 2, `LastUpdate` = '2025-11-24 10:46:22', `Language` = 'bg', `PostDate` = '2025-11-24', `Data` = '{"Name":"Мая Георгиева","EMail":"transport@slbg.bg","Number":"","Sender":"Нашата фирма ЕООД\\nул. Славянска 55, 2230 Костинброд, България","Receiver":"Вашата фирма ООД\\nул. Славянска 3, 2230 Костинброд, България","Date":"24.11.25","City":"Костинброд","Country":"България","UnloadingPoint":"ул. Славянска 3, 2230 Костинброд, България","DeliveryCountry":"България"}'

set names utf8

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

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

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

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            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
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 3, `LastUpdate` = '2025-11-24 10:47:47', `Language` = 'bg', `Data` = '{"Name":"Мая Георгиева","EMail":"transport@slbg.bg","Number":"","Sender":"Нашата фирма ЕООД\\nул. Славянска 55, 2230 Костинброд, България","Receiver":"Вашата фирма ООД\\nул. Славянска 3, 2230 Костинброд, България","Date":"24.11.25","City":"Костинброд","Country":"България","UnloadingPoint":"ул. Славянска 3, 2230 Костинброд, България","DeliveryCountry":"България","Symbols":"","NumberOfPackages":"2\\/два","PackagingMethod":"палета","TypeOfGoods":"резервни части","TotalWeight":"180кг","Volume":"няма"}' WHERE `ID` = '11' AND `Language` = 'bg'

set names utf8

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

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

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

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            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
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-24 10:49:18', `Language` = 'bg', `Data` = '{"Name":"Мая Георгиева","EMail":"transport@slbg.bg","Number":"","Sender":"Нашата фирма ЕООД\\nул. Славянска 55, 2230 Костинброд, България","Receiver":"Вашата фирма ООД\\nул. Славянска 3, 2230 Костинброд, България","Date":"24.11.25","City":"Костинброд","Country":"България","UnloadingPoint":"ул. Славянска 3, 2230 Костинброд, България","DeliveryCountry":"България","Symbols":"","NumberOfPackages":"2\\/два","PackagingMethod":"палета","TypeOfGoods":"резервни части","TotalWeight":"180кг","Volume":"няма","Notes":"Забележки няма","Documents":"Малко раздърпани палета","SpecialAgreements":"има грешка в заглавието","AdditionalNotes":"","CashOnDelivery":""}' WHERE `ID` = '11' AND `Language` = 'bg'

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 11 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

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

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

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
                *
	        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` = '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
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cmr'
         AND `Visible` = 1 LIMIT 1

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

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 * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

INSERT INTO `cmr` SET `Progress` = 2, `LastUpdate` = '2025-11-24 16:17:36', `Language` = 'bg', `PostDate` = '2025-11-24', `Data` = '{"Name":"Мая","EMail":"transport@slbg.bg","Number":"","Sender":"Красивите ООД\\nул. Славянска 55, 2230 Костинброд, България","Receiver":"Покрасивите ЕООД\\nул. Славянска 5, 2230 Костинброд, България","Date":"24.11.25","City":"Костинброд","Country":"България","UnloadingPoint":"ул. Славянска 5, 2230 Костинброд, България","DeliveryCountry":"България"}'

set names utf8

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

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

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

SELECT
                *
            FROM
                `cmr`
            WHERE
                `ID` = 12 AND
                `Language` = 'bg'
            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
                *
            FROM
                `cmr`
            WHERE
                `ID` = 12 AND
                `Language` = 'bg'
            LIMIT 1
