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

Restaurants Lafayette



Copyright 2008. Binary Bits, LLC.