1054 - Unknown column 'rd.languages_id' in 'on clause'
select count(*) as total from
establishment_reviews r,
establishment_reviews_description rd,
categories c,
categories_description cd
LEFT JOIN
languages l
ON
l.languages_id = rd.languages_id
where
c.categories_status = '1'
and
c.categories_id = r.categories_id
and
r.reviews_id = rd.reviews_id
and
c.categories_id = cd.categories_id
and
cd.language_id = '2'
and
r.approved=1
and bdsm=1
order
by r.reviews_id DESC