which red wine is produced by the gary farrell vineyards and winery winery?
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.04j4hwj m.04j4h7_ m.04j4vz7 m.04j4wdh m.04j4h48 m.04j4hgv m.04j4j6f m.04j4j15 m.04j4hss m.04j4gyd
2005 Gary Farrell "Starr Ridge Vineyard" Russian River Valley Pinot Noir 2005 Gary Farrell "Hallberg Vineyard" Russian River Valley Pinot Noir 2006 Gary Farrell "Hallberg Vineyard" Russian River Valley Pinot Noir 2006 Gary Farrell "Russian River Selection" Russian River Valley Pinot Noir 2005 Gary Farrell "Hillside Blocks, Allen Vineyard" Russian River Valley Pinot Noir 2005 Gary Farrell "Rochioli-Allen Vineyards" Russian River Valley Pinot Noir 2006 Gary Farrell "Bien Nacido Vineyard" Santa Maria Valley Pinot Noir 2005 Gary Farrell "Dijon Clones, Starr Ridge Vineyard" Russian River Valley Pinot Noir 2005 Gary Farrell "Russian River Selection" Russian River Valley Pinot Noir 2005 Gary Farrell "Ramal Vineyard" Los Carneros Pinot Noir
class entity entity
wine.wine m.04j4h0y m.02wsb20
wine.wine wine.wine_producer wine.wine_color
Wine Gary Farrell Vineyards and Winery Red Wine
none none none
wine.wine_producer.wines wine.wine.color
Wines Color
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX : <http://rdf.freebase.com/ns/> 
SELECT (?x0 AS ?value) WHERE {
SELECT DISTINCT ?x0  WHERE { 
?x0 :type.object.type :wine.wine . 
VALUES ?x1 { :m.04j4h0y } 
VALUES ?x2 { :m.02wsb20 } 
?x1 :wine.wine_producer.wines ?x0 . 
?x0 :wine.wine.color ?x2 . 
FILTER ( ?x0 != ?x1 && ?x0 != ?x2 && ?x1 != ?x2  )
}
}
(AND wine.wine (AND (JOIN (R wine.wine_producer.wines) m.04j4h0y) (JOIN wine.wine.color m.02wsb20)))