SELECT 
d.language_id,
p.products_id,
c.categories_id,
c.categories_image,
parent_id,
sort_order,
d.categories_name 
from <@PREFIX>products_to_categories p join <@PREFIX>categories c on 
(p.categories_id = c.categories_id) 
join <@PREFIX>categories_description d on (p.categories_id = d.categories_id)
where d.language_id = %s