Plagido’s Winery

WordPress database error: [Subquery returns more than 1 row]
SELECT w.description, w.WineryName, EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 1 ) AS 'tastingroom', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 7 ) AS 'cellar_tours', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 6 ) AS 'vineyard', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 4 ) AS 'motor_coach', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 11 ) AS 'kids', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 5 ) AS 'handicap_access', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 13 ) AS 'food', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 3 ) AS 'weddings', EXISTS (SELECT * FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 2 ) AS 'banquet_facility', (SELECT notes FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 9 ) AS 'summer_hrs', (SELECT notes FROM amenities WHERE winery_id = 2999 AND amenity_type_id = 10 ) AS 'winter_hrs', (SELECT link FROM links WHERE winery_id = 2999 AND link_type_id = 2 ) AS 'website', (SELECT link FROM links WHERE winery_id = 2999 AND link_type_id = 5 ) AS 'facebook_link', (SELECT link FROM links WHERE winery_id = 2999 AND link_type_id = 1 ) AS 'generalemail', (SELECT PhoneNumber FROM phones WHERE winery_id = 2999 AND phone_type_id = 1 ) AS 'phone', (SELECT PhoneNumber FROM phones WHERE winery_id = 2999 AND phone_type_id = 2 ) AS 'fax', (SELECT Street FROM addresses WHERE winery_id = 2999 AND address_type_id = 1 ) AS 'locationstreet', (SELECT City FROM addresses WHERE winery_id = 2999 AND address_type_id = 1 ) AS 'locationcity', (SELECT Zip FROM addresses WHERE winery_id = 2999 AND address_type_id = 1 ) AS 'locationpostal', (SELECT Abbreviation FROM states WHERE id = (SELECT state_id FROM addresses WHERE winery_id = 2999 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 = 2999) as 'varietalsbottled' FROM wineries w WHERE w.id = 2999

plagido's




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

Hours - Winter:

Varietals:

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


Get it on Google Play