select cat from directory where is_archived=0 and site_url != '' and (city='dallastown' OR city='dallastown') and (state='PA' OR state='Pennsylvania') and com_name='Roma\'s Pizza & Restaurant'
select id,site_url,local_address,com_name,city,state,zip from directory where is_archived=0 and site_url != '' and (city='dallastown' OR city='dallastown') and (state='PA' OR state='Pennsylvania') and cat='181' and sub_cat='183' and (sub_sub IS NULL OR sub_sub=0 ) and com_name='Roma\'s Pizza & Restaurant' order by com_name asc