
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
	        	`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
	        	`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
	        	`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-15 08:46:01', `Language` = 'bg', `PostDate` = '2025-11-15', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","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` = 8 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` = 8 AND
                `Language` = 'bg'
            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
                *
            FROM
                `cmr`
            WHERE
                `ID` = 8 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` = 8 AND
                `Language` = 'bg'
            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
                *
            FROM
                `cmr`
            WHERE
                `ID` = 8 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` = 8 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 3, `LastUpdate` = '2025-11-15 08:46:18', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем"}' WHERE `ID` = '8' 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` = 8 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` = 8 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 08:46:43', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача","Documents":"Документи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 08:50:50', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 08:53:59', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:23:23', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:40:40', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' 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` = 8 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` = 8 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:43:00', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:43:50', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:46:57', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' 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` = 8 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` = 8 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:47:22', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:49:54', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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

set names utf8

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

SELECT * FROM `cmr` LIMIT 1

SHOW COLUMNS FROM `cmr`

UPDATE `cmr` SET `Progress` = 4, `LastUpdate` = '2025-11-15 09:51:35', `Language` = 'bg', `Data` = '{"Name":"TEST TEST1","EMail":"davarski@gmail.com","Number":"25623456","Sender":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","Receiver":"tewtew EOOD\\nSDsdfsd\\nasdflgksjdfg 987","City":"Населено място на товарене на стоката","Country":"Държава на товарене на стоката","Date":"Дата на товарене на стоката","Time":"Час на пристигане на рампа","DepartureTime":"Час на потегляне от рампа","UnloadingPoint":"Разтоварен пункт","DeliveryCountry":"Държава на доставка на стоката","Symbols":"Знаци и номера","NumberOfPackages":"Брой пакети\\/колети","PackagingMethod":"Начин на опаковане","TypeOfGoods":"Вид стока","TotalWeight":"Общо тегло","Volume":"Обем","Notes":"Забележки от превозвача\\nЗабележки от превозвача","Documents":"Документи дадени на превозвача\\nДокументи дадени на превозвача","SpecialAgreements":"Специални договориности","AdditionalNotes":"Допълнителни уточнения","CashOnDelivery":"€10 000"}' WHERE `ID` = '8' AND `Language` = 'bg'

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