select a.reviews_id, a.reviews_rating, a.products_id, a.products_image, a.products_name 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, reviews_description rd, products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) 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 = '4' and rd.languages_id = '4' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 group by r.reviews_id
union
select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added,
0 as products_id, '' as products_name, '' as products_image, r.customers_name
from reviews r, reviews_description rd
where r.products_id = 0 and r.reviews_id = rd.reviews_id and rd.languages_id = '4'
) a where a.products_id = '40' order by a.reviews_id desc limit 10
