nodeQueryForRelations

SELECT

	nodes.id,
	nodes.version,
	nodes.user_id,
	users.name AS user_name,
	nodes.tstamp,
	nodes.changeset_id,
	hstore_to_array(nodes.tags) AS tags,
	Y(nodes.geom) AS lat,
	X(nodes.geom) AS lon

FROM
	nodes,
	users,
	(SELECT
		relation_members.member_id AS id
	FROM
		relations,
		relation_members
	WHERE
		relations.id = relation_members.relation_id
	AND
		relation_members.member_type = 'N'
	AND 	(relations.tags @> hstore('amenity', 'pub'))

	UNION

	SELECT
		way_nodes.node_id AS id

	FROM
		relations,
		relation_members,
		way_nodes

	WHERE

		relations.id = relation_members.relation_id

	AND 	relation_members.member_type = 'W'
	AND 	relation_members.member_id = way_nodes.way_id
	AND 	(relations.tags @> hstore('amenity', 'pub'))

	) AS nodeIds

WHERE nodes.id = nodeIds.id AND users.id = nodes.user_id;