ERROR:  select c.categories_id, count(p.products_id) as product_count
				from categories c
				left join categories_description cd on cd.categories_id=c.categories_id
				left join products_to_categories p2c on p2c.categories_id=c.categories_id
				left join products p on p.products_id=p2c.products_id  left join products_to_flags p2f on p2f.products_id = p.products_id
	                                left join flags f on p2f.flag_id=f.flag_id where (c.categories_id in ( ))
				and cd.language_id='1'
				and p.products_status=1 and f.name='flags_made_in_usa'  group by c.categories_id
				order by c.sort_order, cd.categories_name<br/><br/>