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 ') and r.date_added > '2014-12-31' and r.reviews_rating > 2 and rd.languages_id=1' at line 2
in:
[select count(r.reviews_id) as total from reviews_description AS rd LEFT JOIN reviews AS r ON(rd.reviews_id = r.reviews_id) WHERE r.products_id in (34913,36172,36177,36199,48729,48733,48743,69401,48563) and (r.country_id in() and r.date_added > '2014-12-31' and r.reviews_rating > 2 and rd.languages_id=1 or rd.languages_id=2) AND r.status = 1 AND r.check_status=1 and r.reviews_rating = 1]