find the wine in contra costa.
Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity Entity
m.03ggl6p m.03bt1_6 m.03j_ss6 m.03mr64v m.03j_t0v m.0447yj1 m.03k0f9h m.03gglp8 m.03bt21q m.03ggllb m.03k0ffg m.03k0hsg m.03n6y5f
2006 Cline "Ancient Vines" Contra Costa County Zinfandel 2004 Atelier Contra Costa Zinfandel 2004 Trinitas "Old Vine" Contra Costa County Zinfandel 2005 Viano "Sand Rock Hill" Contra Costa County Zinfandel 2003 Trinitas "Bigalow Vineyard" Contra Costa County Zinfandel 2003 CA'NA Contra Costa County Estate Cabernet Sauvignon 2005 Rosenblum "Carla's Vineyards" San Francisco Bay Zinfandel 2006 Cline "Heritage" Contra Costa County Zinfandel 2002 Atelier Contra Costa Zinfandel 2005 Cline "Bridgehead" Contra Costa County Zinfandel 2006 Rosenblum "Appellation Series" Contra Costa County Zinfandel 2005 Rosenblum "Planchon Vineyard' San Francisco Bay Zinfandel 2003 Viano Contra Costa County Zinfandel Port
class entity
wine.wine m.0kq1l
wine.wine wine.wine_sub_region
Wine contra costa
none none
wine.wine.wine_sub_region
Wine Sub-region
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.0kq1l } 
?x0 :wine.wine.wine_sub_region ?x1 . 
FILTER ( ?x0 != ?x1  )
}
}
(AND wine.wine (JOIN wine.wine.wine_sub_region m.0kq1l))