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

Restaurants 97007



Copyright 2008. Binary Bits, LLC.