1054 - Unknown column 'rd.languages_id' in 'on clause'
select count(*) as total from
reviews r,
reviews_description rd,
products p,
products_description pd,
categories c,
products_to_categories p2c
LEFT JOIN
languages l
ON
l.languages_id = rd.languages_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 = '6'
and
p.products_id = p2c.products_id
and
p2c.categories_id = c.categories_id
and
r.approved=1
and bdsm=1
order
by r.reviews_id DESC
