gistfile1.txt

SELECT relation_id, ways.linestring FROM relations, relation_members, ways 

WHERE
	relation_members.member_id = ways.id

AND 
	relation_members.member_type = 'W'

AND
	relations.tags @> hstore('admin_level','8') AND relations.tags @> hstore('boundary','administrative')

AND
	relation_members.relation_id = relations.id
	
AND
	ST_intersects(ways.linestring, (SELECT ST_envelope(geom) FROM countries_europe WHERE countries_europe.relation_id = 174737))