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 (40645,40648,40649,40650,40671,40727,40728,40729,40731,40743,52166,52167,52168,52169,52170,52171,52172,52173,52174,52175,52176,52177,52178,52179,52180,52181,52182,52183,52184,52185,52186,52187,52188,52189,52190,52191,52192,52193,52194,52195,52196,52197,52198,52199,52200,52201,52202,52203,52204,52205,52206,52207,52208,52209,52210,52211,52212,52213,52214,52215,52216,52217,52218,52219,52220,52221,52222,52223,52224,52225,52226,52227,52228,52229,52230,52231,52232,62310,63105,63138,63167,63195,63222,63250,63273,63279,63284,63288,63292,63296,63300,63304,63308,63312,63316,63319,63326,63328,63330,63332,63334,63337,63339,63342,63346,63348,63350,63352,63354,63356,63358,63360,63362,63365,63367,63369,63371,63373,63375,63377,63379,63381,63384,63386,63388,63390,63392,63394,63396,63398,63401,63404,63408,63412,63416,63420,63424,63428,63432,63436,66284,66731,66732,66733,66734,66735,66736,66737,66738,66739,66740,66774,66775,66776,66777,66778,66779,66780,66781,66782,64196) 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]