SELECT * FROM businesses
WHERE (
(
0=1
OR category_Lodging = 'Y' OR category_Dining = 'Y' OR category_Shopping = 'Y' OR category_Food = 'Y' OR category_Attraction = 'Y'
OR description LIKE '%#Keyword#%'
)
AND (
town LIKE '%Pownal%'
OR town LIKE '%Bennington%'
OR town LIKE '%Stamford%'
OR town LIKE '%Readsboro%'
OR town LIKE '%Woodford%'
OR town LIKE '%Searsburg%'
OR town LIKE '%Shaftsbury%'
OR town LIKE '%Glastenbury%'
OR town LIKE '%Arlington%'
OR town LIKE '%Sunderland%'
OR town LIKE '%Sandgate%'
OR town LIKE '%Manchester%'
OR town LIKE '%Windhall%'
OR town LIKE '%Rupert%'
OR town LIKE '%Dorset%'
OR town LIKE '%Peru%'
OR town LIKE '%Landgrove%'
OR town LIKE '%Bondville%'
)
AND (
town LIKE '%Whitingham%'
OR town LIKE '%Jacksonville%'
OR town LIKE '%Halifax%'
OR town LIKE '%Guilford%'
OR town LIKE '%Vernon%'
OR town LIKE '%Brattleboro%'
OR town LIKE '%Marlboro%'
OR town LIKE '%Wilmington%'
OR town LIKE '%Dummerston%'
OR town LIKE '%Somerset%'
OR town LIKE '%Dover%'
OR town LIKE '%Newfane%'
OR town LIKE '%Putney%'
OR town LIKE '%Stratton%'
OR town LIKE '%Wardsboro%'
OR town LIKE '%Townsend%'
OR town LIKE '%Westminster%'
OR town LIKE '%Athens%'
OR town LIKE '%Jamaica%'
OR town LIKE '%Peru%'
OR town LIKE '%Bellows Falls%'
OR town LIKE '%Rockingham%'
OR town LIKE '%Grafton%'
OR town LIKE '%Windham%'
OR town LIKE '%Londonderry%'
)
AND town LIKE '%#view_region#%'
)
ORDER BY name
Zero Businesses matched your chosen criteria. Try searching for more categories,
or possibly more Regions.
Finding
#category_list#
establishments in
All Counties.
#view_region#.
#out_name#
#category_list#