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