Restaurants in 89104 | FriendsEAT.com

(SELECT *, COUNT(*),1 As SEQ FROM business_restaurant WHERE city_name='89104' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),2 As SEQ FROM business_restaurant WHERE state_name='89104' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),6 As SEQ FROM business_restaurant WHERE city_name='89104' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),7 As SEQ FROM business_restaurant WHERE state_name='89104' GROUP BY restaurant_id order by SEQ) UNION (SELECT *, COUNT(*),10 As SEQ FROM business_restaurant WHERE address='89104' GROUP BY restaurant_id order by SEQ) order by rand() limit 0,2 Restaurants in 89104 | FriendsEAT.com - Page 1