0 items, 0.00
Manufacturers
select count(distinct p.products_id) as total FROM categories c left join products_to_categories p2c on (c.categories_id=p2c.categories_id), categories_description cd WHERE c.parent_id = '0' and c.categories_status=1 and c.categories_id = cd.categories_id and cd.language_id='1' and ( c.products_group_access LIKE '%,G,%' OR c.products_group_access LIKE 'G,%' OR c.products_group_access LIKE '%,G' OR c.products_group_access = 'G' )
[TEP STOP]