We have an error
SELECT c.*,r.id,(r.total_value/r.total_votes) AS rating FROM site_ratings AS r LEFT JOIN site_content AS c ON c.id=r.id WHERE r.domain = 'smokingkills.us' AND c.type!='Wiki' AND c.title LIKE '%Smoking Commercial%' OR c.content LIKE '%Smoking Commercial%' ORDER BY (r.total_value/r.total_votes) DESC LIMIT 0,10
Table 'domainsp_mwm.site_content' doesn't exist