Long Beach, California Zip Codes: 90711,90712,90731,90740,90755,90801,90802,90803,90804,90805,90806,90807,90808,90809,90810,90813,90814,90815,90822,90831,90832,90833,90834,90835,90840,90842,90844,90845,90846,90847,90848,90853,90888,90895,90899
select cat from directory where is_archived=0 and site_url != '' and (city='long beach' OR city='long_beach') and (state='CA' OR state='California')
select cat from directory where is_archived=0 and site_url != '' and (city='long beach' OR city='long_beach') and (state='CA' OR state='California')
union
select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('long_beach', city) OR city='all' ) and (state='CA' OR state='California' OR state='all')