select cat from directory where is_archived=0 and site_url != '' and (city='grifton' OR city='grifton') and (state='NC' OR state='North Carolina') and com_name='Greg\'s Pizza'
select id,site_url,local_address,com_name,city,state,zip from directory where is_archived=0 and site_url != '' and (city='grifton' OR city='grifton') and (state='NC' OR state='North Carolina') and cat='867' and sub_cat='868' and (sub_sub IS NULL OR sub_sub=0 ) and com_name='Greg\'s Pizza' order by com_name asc