SELECT I.id, 5 AS sort_col 
FROM inzeraty I 
LEFT JOIN keywords_2_inzeraty K2I ON I.id=K2I.id_inzeratu 
LEFT JOIN keywords K ON K2I.id_keyword=K.id_keyword 
LEFT JOIN uzivatele U ON U.id=I.id_uzivatele 
LEFT JOIN uzivatele U2 ON U2.id=U.id_centraly 
WHERE I.`zobrazovat`='1' AND ((U.id_centraly = 0 AND U.active=1) OR U2.active=1) AND
(`K`.`id_keyword` IN ('91', '92', '90', '781', '780', '779', '778', '95', '96', '776', '94', '93',
'777', '447', '448', '449', '452', '453', '450', '451', '782', '564', '562', '563', '567', '565',
'568', '569', '566', '570', '571')) AND (`I`.`regiony` LIKE '%PAR%') 
ORDER BY U.typ_search, datum DESC, I.id DESC
Nabídka práce | Dobrá práce.cz