Database Error in /includes/classes/split_page_results.php at line 37
Called via /reviews.php at line 58: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 'JOINproducts p ON p.products_id = r.products_id
I' at line 6
select count(*) as total FROM (SELECT r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, p.products_id,
pd.products_name, p.products_image, r.customers_name
FROM reviews r
INNER JOIN reviews_description rd ON rd.reviews_id = r.reviews_id
AND rd.languages_id = '1'
INNER JOINproducts p ON p.products_id = r.products_id
INNER JOIN products_description pd ON pd.products_id = p.products_id
AND pd.language_id = '1'
WHERE r.is_enabled = 1
AND p.products_status = '1'
ORDER BY r.reviews_id DESC) k
[TEP STOP]
|
