An Error Was Encountered
Error Number: 1064
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 'WHERE s.film_id='' AND published = 1 AND publish_stamp < 1227285035 ' at line 7
SELECT cached_path, s.*, (SELECT url FROM fms_flv_servers f WHERE f.cluster_id = s.cluster_id AND f.server_id NOT IN(s.error_servers) AND offline = 0 ORDER BY RAND() LIMIT 1) as server FROM fms_film_segments s LEFT JOIN fms_films f ON f.id=s.film_id LEFT JOIN fms_tv_channels c ON c.id= WHERE s.film_id='' AND published = 1 AND publish_stamp < 1227285035 AND status = 'live' GROUP BY s.id ORDER BY sortorder