Проверка на критерии за прием: ЕЗИКОВИ ПОЗНАНИЯ

SET NAMES UTF8
----------CHANGING DATABASE TO unicons_unichoice----------
SELECT langID,iso,name FROM langs WHERE `default` = 1    
----------CHANGING DATABASE TO unicons_de----------
----------CHANGING DATABASE TO unicons_unichoice----------
SELECT * FROM langs   ORDER BY `default` DESC  
----------CHANGING DATABASE TO unicons_de----------

			SELECT c.certificateID, c_l.longName as certName FROM certificate as c		
			LEFT JOIN certificate_lang as c_l ON (c.certificateID = c_l.certificateID AND c_l.langID = '1')
			LEFT JOIN certificate_type as c_t ON c_t.certificate_typeID = c.certificate_typeID
			WHERE c_t.certificate_typeID = '2'
		
			
			SELECT DISTINCT c_m.certificate_masterID, c_m_l.shortName as mastName FROM certificate_master as c_m
			LEFT JOIN certificate_master_lang as c_m_l ON (c_m.certificate_masterID = c_m_l.certificate_masterID AND c_m_l.langID = '1')
			LEFT JOIN certificate as c ON c.certificate_masterID = c_m.certificate_masterID
			LEFT JOIN certificate_level as l ON l.certificate_levelID = c.certificate_levelID
			LEFT JOIN certificate_type as c_t ON c_t.certificate_typeID = c.certificate_typeID
			WHERE (l.parent_certificate_levelID = 1 OR l.parent_certificate_levelID = 4 OR l.parent_certificate_levelID = 7)
			AND c_t.certificate_typeID = '1'
		

			SELECT c.certificateID, c_l.longName as certName FROM certificate as c		
			LEFT JOIN certificate_lang as c_l ON (c.certificateID = c_l.certificateID AND c_l.langID = '1')
			LEFT JOIN certificate_type as c_t ON c_t.certificate_typeID = c.certificate_typeID
			WHERE c_t.certificate_typeID = '3'
		
SELECT txt FROM txt WHERE txtID = '43' AND hide = 0    

unicons_de

ezikStart

ezikStart/ezikStart

Array
(
)
1

Array
(
)
1

Array
(
    [p1] => ezikStart
    [ezik_poz] => 2
)
1

1