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 (17931,36143,36157,36179,36180,36181,36182,36183,36189,36240,36258,36281,36305,36306,36313,36350,36358,36359,36361,36363,36395,36397,36421,36422,36439,36455,36668,36669,36670,36674,36676,36678,36680,36689,36691,36848,36849,39577,39578,39921,48558) 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]