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 s.specialtyID, sl.shortName, sl.longName, sl.url FROM specialty as s INNER JOIN university_specialty AS us ON (s.specialtyID = us.specialtyID) INNER JOIN specialty_lang AS sl ON (s.specialtyID = sl.specialtyID AND sl.langID =1) WHERE s.hide = 0 AND us.hide=0  GROUP BY specialtyID  ORDER BY sl.shortName 
SELECT universityID, longName_bg as shortName,url_bg as url FROM university WHERE hide = 0  ORDER BY shortName  
SELECT s.specialtyID, sl.shortName, sl.longName, sl.url FROM specialty as s INNER JOIN specialty_lang AS sl ON (s.specialtyID = sl.specialtyID AND sl.langID =1) WHERE s.hide = 0  ORDER BY s.hits DESC LIMIT 0,4
SELECT universityID, longName_bg as shortName, url_bg as url, pix FROM university WHERE hide = 0  ORDER BY hits DESC  LIMIT 0, 4
SELECT * FROM pic WHERE ID='0'    
SELECT * FROM pic WHERE ID='0'    
SELECT * FROM pic WHERE ID='0'    
SELECT * FROM pic WHERE ID='0'    
SELECT url_bg as url FROM university WHERE universityID = '192'    
SELECT url_bg as url FROM university WHERE universityID = '176'    
SELECT url_bg as url FROM university WHERE universityID = '183'    
SELECT url_bg as url FROM university WHERE universityID = '37'    
SELECT url_bg as url FROM university WHERE universityID = '33'    

unicons_de

search

default

Array
(
)
1

Array
(
)
1

Array
(
)
1

1