select cat from directory where is_archived=0 and site_url != '' and (city='lavallette' OR city='lavallette') and (state='NJ' OR state='New Jersey') and com_name='Lenny\'s Pizza & Italian Grill'
select id,site_url,local_address,com_name,city,state,zip from directory where is_archived=0 and site_url != '' and (city='lavallette' OR city='lavallette') and (state='NJ' OR state='New Jersey') and cat='181' and sub_cat='183' and (sub_sub IS NULL OR sub_sub=0 ) and com_name='Lenny\'s Pizza & Italian Grill' order by com_name asc