|
|
-
SELECT pd.products_id,
pd.products_name,
rd.reviews_id,
rd.reviews_text,
r.date_added,
r.customers_name
FROM reviews_description as rd
LEFT JOIN reviews as r
ON rd.reviews_id = r.reviews_id
LEFT JOIN products_description as pd
ON pd.products_id = r.products_id AND rd.languages_id = pd.language_id
LEFT JOIN products as p
ON p.products_id = pd.products_id
WHERE rd.languages_id = 5
AND p.manufacturers_id = language
ORDER BY r.date_added DESC
LIMIT 0,5
[TEP STOP]
| |