| | PLACES | | SEARCH BY CATEGORY | |
| | SEARCH BY NAME | |
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z | NAME | CITY | SELECT e.mem_id, e.estab_name, e.estab_city, e.isbold
FROM establishments e
WHERE LEFT(e.estab_name, 1) = 'I'
AND e.city_id IN (SELECT city_id FROM city_region WHERE region_id = 1)
ORDER BY e.estab_name asc | Irish Pub | Greensboro |
|
|
|
