| |
select distinct m.movieID, m.Description, n.name AS production_name, r.name AS producer_name,ra.rating AS rating,m.releasedate AS year,m.duration AS duration, m.title AS title, ra.total AS rating_total, m.insertdate AS insert_date from wc_movie m
LEFT JOIN wc_movie_production n USING (productionID)
LEFT JOIN wc_movie_producer r USING (producerID)
LEFT JOIN wc_movie_rating ra USING (movieID)
LEFT JOIN wc_movie_vs_category vc USING (movieID) WHERE disabled=0 AND deleted=0 AND EXISTS (SELECT s.movieID FROM wc_movie_site_enabled s WHERE (s.site_ID = 31) AND s.movieID = m.movieID) order by ifnull((SELECT rankingID FROM wc_movie_ranking WHERE movieID = m.movieID and now() between fromdate and tilldate ), 10000 ) , m.insertdate DESC, m.movieID DESC limit 0, 8 DBSError::!! Error executing the dbs query (errorcode: 1004). Please mail this errorcode to support@sneakcams.com to solve this problem
| |
