Deerfield Vineyards

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND amenity_type_id = 1 ) AS 'tastingroom', EXISTS (SELECT * FROM ameni' at line 2]
SELECT w.description, w.WineryName, EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 1 ) AS 'tastingroom', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 7 ) AS 'cellar_tours', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 6 ) AS 'vineyard', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 4 ) AS 'motor_coach', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 11 ) AS 'kids', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 5 ) AS 'handicap_access', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 13 ) AS 'food', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 3 ) AS 'weddings', EXISTS (SELECT * FROM amenities WHERE winery_id = AND amenity_type_id = 2 ) AS 'banquet_facility', (SELECT notes FROM amenities WHERE winery_id = AND amenity_type_id = 9 ) AS 'summer_hrs', (SELECT notes FROM amenities WHERE winery_id = AND amenity_type_id = 10 ) AS 'winter_hrs', (SELECT link FROM links WHERE winery_id = AND link_type_id = 2 ) AS 'website', (SELECT link FROM links WHERE winery_id = AND link_type_id = 1 ) AS 'generalemail', (SELECT PhoneNumber FROM phones WHERE winery_id = AND phone_type_id = 1 ) AS 'phone', (SELECT PhoneNumber FROM phones WHERE winery_id = AND phone_type_id = 2 ) AS 'fax', (SELECT Street FROM addresses WHERE winery_id = AND address_type_id = 1 ) AS 'locationstreet', (SELECT City FROM addresses WHERE winery_id = AND address_type_id = 1 ) AS 'locationcity', (SELECT Zip FROM addresses WHERE winery_id = AND address_type_id = 1 ) AS 'locationpostal', (SELECT Abbreviation FROM states WHERE id = (SELECT state_id FROM addresses WHERE winery_id = AND address_type_id = 1) ) AS 'locationstate', (SELECT GROUP_CONCAT( v.varietal ) FROM varietals v INNER JOIN varietals_wineries wv ON v.id = wv.varietal_id WHERE wv.winery_id = ) as 'varietalsbottled' FROM wineries w WHERE w.id =

MO_4949




Contact Information
Address: ,
Phone:
Fax:
Website:
Email:
Hours - Summer:

Hours - Winter:

Varietals:
Cell Phone Tour:
Mobile Web Tour:

Amenities
Tasting Room:
Cellar Tours:
Vineyard:
Motor Coach Tours:
Kid Friendly:
Handicap Accessible:
Restaurant/Food:
Weddings:
Banquet Facilities:


Get it on Google Play