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 (42039,42040,42093,42094,42095,42096,42098,42099,42101,42102,42103,42104,43407,43408,43409,43410,43411,43437,43439,43440,43441,43442,43443,43444,43446,43448,43449,43450,43452,43453,43454,43457,43463,43464,43465,43466,43516,50021,50024,50025,50026,50027,50031,50032,50033,50035,50036,50037,50038,50042,50043,50044,50046,50049,50050,50051,50052,62557,62559,68831,68832,68833,68834,68855,68857,68862,68865,68871,68873,68874,68876,68878,68879,68880,68882,68883,68885,68893,68895,68906,12331) 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]