SELECT s.news_id AS p_id, s.data AS p_data, s.thumbnail AS p_thumbnail, s.category_id AS p_category, s.gallery_id AS p_gallery, s.red AS p_red, s.aktivnost AS p_akt, p.ime AS p_ime, p.opis AS p_opis, c.red AS p_cred, cp.title AS p_cat, i.ifile AS p_ifile FROM news s INNER JOIN news_prevod p ON s.news_id = p.news_id AND p.ezik_id=1 LEFT JOIN category c ON s.category_id = c.category_id LEFT JOIN category_prevod cp ON s.category_id = cp.category_id AND cp.ezik_id=1 LEFT JOIN img i ON i.img_id IN (SELECT img_id FROM gallery_img WHERE gallery_id = s.gallery_id AND red=1) WHERE c.category_id != 3 AND s.news_id = 16/ ORDER BY p_cred, p_category, s.red