Hello,
I've got following query:

Code:
SELECT y.c_node_id, y.c_code_id, y.c_rule_id
FROM 
	CODE c2
	JOIN (
		SELECT c.c_id AS c_code_id, c.c_code, r.c_id AS c_rule_id, r.c_node_id, 1 AS 'priority'
		FROM
			CODE c
			JOIN HRY h ON h.c_dimension_id = c.c_dimension_id
			JOIN NODE n ON h.c_id = n.c_hierarchy 
			JOIN RULE r ON n.c_id = r.c_node_id
		WHERE
...