## Villages across Countries

select ?href
       ?name
       ?geo
       ?latitude
       ?longitude
       ?o as ?textSearchPattern
from <http://linkedgeodata.org>
where { 
			{ 
				{ select * 
				  where {
					 		?href 
							<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://linkedgeodata.org/ontology/Village> ;
							<http://www.w3.org/2003/01/geo/wgs84_pos#geometry> ?geo ;
							geo:lat ?latitude;
							geo:long ?longitude;
							rdfs:label ?name;
							?p ?o .

							?o 
							bif:contains "'Nigeria'" .
							# filter(bif:st_intersects(bif:st_geomfromtext("LINESTRING(1 2, 3 6, 9 4)"), ?geo)) 
						 } 
			 	  limit 50 
				 } 
			}
union
			{ 
				{ select * 
				  where {
					 		?href 
							<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://linkedgeodata.org/ontology/Village> ;
							<http://www.w3.org/2003/01/geo/wgs84_pos#geometry> ?geo ;
							geo:lat ?latitude;
							geo:long ?longitude;
							rdfs:label ?name;
							?p ?o .

							?o 
							bif:contains "'Ghana'" .
							# filter(bif:st_intersects(bif:st_geomfromtext("LINESTRING(1 2, 3 6, 9 4)"), ?geo)) 
						 } 
			 	  limit 50 
				 } 
			}

union
			{ 
				{ select * 
				  where {
					 		?href 
							<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://linkedgeodata.org/ontology/Village> ;
							<http://www.w3.org/2003/01/geo/wgs84_pos#geometry> ?geo ;
							geo:lat ?latitude;
							geo:long ?longitude;
							rdfs:label ?name;
							?p ?o .

							?o 
							bif:contains "'Benin'" .
							# filter(bif:st_intersects(bif:st_geomfromtext("LINESTRING(1 2, 3 6, 9 4)"), ?geo)) 
						 } 
			 	  limit 50 
				 } 
			}
union
			{ 
				{ select * 
				  where {
					 		?href 
							<http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://linkedgeodata.org/ontology/Village> ;
							<http://www.w3.org/2003/01/geo/wgs84_pos#geometry> ?geo ;
							geo:lat ?latitude;
							geo:long ?longitude;
							rdfs:label ?name;
							?p ?o .

							?o 
							bif:contains "'Togo'" .
							# filter(bif:st_intersects(bif:st_geomfromtext("LINESTRING(1 2, 3 6, 9 4)"), ?geo)) 
						 } 
			 	  limit 50 
				 } 
			}
}