(SELECT *, COUNT(*),1 As SEQ FROM temp_restaurants WHERE city_name='400' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),2 As SEQ FROM temp_restaurants WHERE state_name='400' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),3 As SEQ FROM temp_restaurants WHERE zip='400' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),4 As SEQ FROM temp_restaurants WHERE neighborhood='400' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),5 As SEQ FROM temp_restaurants WHERE address='400' GROUP BY restaurant_id order by SEQ)
Restaurants in 400 | FriendsEAT.com - Page 1
