select
c.categories_id,
cd.categories_name,
c.parent_id from
categories c,
categories_description cd
where c.categories_status = '1' AND
c.parent_id = '0'
and c.categories_id = cd.categories_id
and cd.language_id='1'
and c.products_group_access like '%G%'
order by sort_order, cd.categories_name
Advance Search
