-

select cd.categories_id, c.parent_id, cd.categories_name, cd.categories_description, cd.categories_seo_addon, cd.categories_meta_title, cd.categories_meta_keywords, cd.categories_meta_description from categories c LEFT JOIN categories_description cd using(categories_id) WHERE categories_id ='100150' AND cd.language_id = '4'

[TEP STOP]