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 = 5 ) AS 'facebook_link', (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 =