Query |
SET NAMES UTF8 SELECT u.universityID, u.longName as name, up.name as uniPic FROM users_apll ua INNER JOIN university_specialty AS us ON (ua.university_specialtyID = us.university_specialtyID) LEFT JOIN university AS u ON (u.universityID = us.universityID) LEFT JOIN pic AS up ON (up.ID = u.pix) WHERE userID = '' GROUP BY u.universityID ORDER BY u.longName ASC SELECT u.* FROM university as u WHERE u.hide=0 ORDER BY u.longName SELECT url FROM university WHERE universityID = '30' SELECT url FROM university WHERE universityID = '30' SELECT url FROM university WHERE universityID = '34' SELECT url FROM university WHERE universityID = '34' SELECT url FROM university WHERE universityID = '40' SELECT url FROM university WHERE universityID = '40' SELECT url FROM university WHERE universityID = '29' SELECT url FROM university WHERE universityID = '29' SELECT url FROM university WHERE universityID = '10' SELECT url FROM university WHERE universityID = '10' SELECT url FROM university WHERE universityID = '11' SELECT url FROM university WHERE universityID = '11' SELECT url FROM university WHERE universityID = '1' SELECT url FROM university WHERE universityID = '1' SELECT url FROM university WHERE universityID = '39' SELECT url FROM university WHERE universityID = '39' SELECT url FROM university WHERE universityID = '37' SELECT url FROM university WHERE universityID = '37' SELECT url FROM university WHERE universityID = '50' SELECT url FROM university WHERE universityID = '50' SELECT url FROM university WHERE universityID = '47' SELECT url FROM university WHERE universityID = '47' SELECT url FROM university WHERE universityID = '51' SELECT url FROM university WHERE universityID = '51' SELECT url FROM university WHERE universityID = '15' SELECT url FROM university WHERE universityID = '15' SELECT url FROM university WHERE universityID = '48' SELECT url FROM university WHERE universityID = '48' SELECT url FROM university WHERE universityID = '2' SELECT url FROM university WHERE universityID = '2' SELECT url FROM university WHERE universityID = '49' SELECT url FROM university WHERE universityID = '49' SELECT url FROM university WHERE universityID = '25' SELECT url FROM university WHERE universityID = '25' SELECT url FROM university WHERE universityID = '16' SELECT url FROM university WHERE universityID = '16' SELECT url FROM university WHERE universityID = '21' SELECT url FROM university WHERE universityID = '21' SELECT url FROM university WHERE universityID = '19' SELECT url FROM university WHERE universityID = '19' SELECT url FROM university WHERE universityID = '36' SELECT url FROM university WHERE universityID = '36' SELECT url FROM university WHERE universityID = '18' SELECT url FROM university WHERE universityID = '18' SELECT url FROM university WHERE universityID = '38' SELECT url FROM university WHERE universityID = '38' SELECT url FROM university WHERE universityID = '33' SELECT url FROM university WHERE universityID = '33' SELECT url FROM university WHERE universityID = '32' SELECT url FROM university WHERE universityID = '32' SELECT url FROM university WHERE universityID = '20' SELECT url FROM university WHERE universityID = '20' SELECT url FROM university WHERE universityID = '35' SELECT url FROM university WHERE universityID = '35' SELECT url FROM university WHERE universityID = '12' SELECT url FROM university WHERE universityID = '12' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '6' SELECT url FROM university WHERE universityID = '6' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '27' SELECT url FROM university WHERE universityID = '27' SELECT url FROM university WHERE universityID = '28' SELECT url FROM university WHERE universityID = '28' SELECT url FROM university WHERE universityID = '31' SELECT url FROM university WHERE universityID = '31' SELECT url FROM university WHERE universityID = '17' SELECT url FROM university WHERE universityID = '17' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '22' SELECT url FROM university WHERE universityID = '22' SELECT url FROM university WHERE universityID = '45' SELECT url FROM university WHERE universityID = '45' SELECT url FROM university WHERE universityID = '23' SELECT url FROM university WHERE universityID = '23' SELECT url FROM university WHERE universityID = '26' SELECT url FROM university WHERE universityID = '26' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '9' SELECT url FROM university WHERE universityID = '9'
|