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 'select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products' at line 1
select count(select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from reviews r, reviews_description rd, products p, products_description pd, categories c, products_to_categories p2c where p.products_status = \'1\' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = \'1\' and rd.languages_id = \'1\' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and r.approved=1 order by r.reviews_id DESC) as total
