Restaurants in 37917 | FriendsEAT.com

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