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 (43380,43381,43382,43385,43386,43387,43390,43393,43394,43395,43396,43397,43402,43403,43404,11906) 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]