select distinct c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '242' and cd.language_id = '1' and c.categories_id = cd.categories_id order by sort_order, cd.categories_name
Stirrers and Hotplates:
Stirrers and hotplates come with varying features. |
|