You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `rec_cams` rc JOIN ( SELECT `camid`, MAX(`id`) ' at line 11

SELECT rcf.*, rc.`nazwa`, rc.`miasto_pogoda`, rc.`kategoria`, wrcs.meta_description, wrcs.meta_title, wrcs.meta_keywords, wrcs.seo_nazwa, wrcs.seo_opis, FROM `rec_cams` rc JOIN ( SELECT `camid`, MAX(`id`) as max_id FROM `rec_cams_files` GROUP BY `camid` ) rcf_max ON rcf_max.`camid` = rc.`id` JOIN `rec_cams_files` rcf ON rcf.`id` = rcf_max.`max_id` LEFT JOIN wnews_rec_cams_seo wrcs ON wrcs.id=rc.id WHERE 1 AND rc.`miasto_pogoda` = 'Wdzydze Kiszewskie' AND rc.`kategoria` = '3' AND rc.`showshop` = 1 and rc.enabled=1 GROUP BY rcf.`camid` ORDER BY rcf.`id` DESC