Don't take our words on it, see what our lovers have to say! (Array)
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 pd.products_name, r.reviews_id, rd.reviews_text, r.products_id, r.approve' at line 1
select count(r.reviews_id) as total select pd.products_name, r.reviews_id, rd.reviews_text, r.products_id, r.approved, r.date_added, r.new_customers_name, r.customers_name, r.reviews_date, p.products_image, r.reviews_rating, r.reviews_image, p.address_key FROM reviews r join reviews_description rd on r.reviews_id = rd.reviews_id left join products p on p.products_id = r.products_id left join products_description pd on pd.products_id = p.products_id and pd.language_id = 1 where r.approved = '1'