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