select cat from directory where is_archived=0 and site_url != '' and (city='rolesville' OR city='rolesville') and (state='NC' OR state='North Carolina') and com_name='Rosalini\'s Pizza and Subs'
select id,site_url,local_address,com_name,city,state,zip from directory where is_archived=0 and site_url != '' and (city='rolesville' OR city='rolesville') and (state='NC' OR state='North Carolina') and cat='181' and sub_cat='183' and (sub_sub IS NULL OR sub_sub=0 ) and com_name='Rosalini\'s Pizza and Subs' order by com_name asc