Category |
select c.categories_id, cd.categories_name, c.parent_id, c.category_wheel_chair_status from categories c, categories_description cd where c.parent_id = '0' and c.category_featured_status = '0' and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status = '1' and c.category_wheel_chair_status = '1' order by sort_order, cd.categories_name |
Mobility Aids
There are currently no products to list in this category. |