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 (41727,41728,41729,41730,41731,41733,41735,41736,41737,41749,41750,41751,41752,41755,41757,41758,41759,41771,41772,41773,41774,41777,41778,41780,41781,41782,41783,41784,41785,41788,41789,41790,41791,41792,41793,41794,41795,41796,41797,41798,41799,41800,41801,41802,41803,41804,41805,41806,41807,41808,41809,41810,41942,42264,42265,42266,42267,42268,42508,42509,42510,42511,42512,42513,42514,42636,42637,42639,42640,42641,42646,42971,42974,42975,42983,42984,42986,42987,42988,42989,42990,42995,42996,43037,43038,43039,43040,43041,43101,44158,44159,44162,44163,50108,50109,50110,50111,50112,68635,68636,68663,69239,12018) 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]