rating.sql

SELECT * FROM v_enrolment_mon

UNION

SELECT * FROM v_enrolment_destination_admission eda
WHERE eda.enrolment_id NOT IN (
	SELECT 
		mon.enrolment_id 
	FROM v_enrolment_mon mon
	)

UNION

SELECT * FROM v_enrolment_off_competition_entry eoce
WHERE eoce.enrolment_id NOT IN (

	SELECT mon.enrolment_id  FROM v_enrolment_mon mon
	UNION
	SELECT eda.enrolment_id FROM v_enrolment_destination_admission eda
	WHERE eda.enrolment_id NOT IN (
		SELECT 
			mon.enrolment_id 
		FROM v_enrolment_mon mon
	)
	
)

UNION

SELECT * FROM v_enrolment_default_entry default_entry
WHERE default_entry.enrolment_id NOT IN (
	SELECT mon.enrolment_id FROM v_enrolment_mon mon

	UNION

	SELECT eda.enrolment_id FROM v_enrolment_destination_admission eda
	WHERE eda.enrolment_id NOT IN (
		SELECT 
			mon.enrolment_id 
		FROM v_enrolment_mon mon
		)

	UNION

	SELECT eoce.enrolment_id FROM v_enrolment_off_competition_entry eoce
	WHERE eoce.enrolment_id NOT IN (

		SELECT mon.enrolment_id  FROM v_enrolment_mon mon
		UNION
		SELECT eda.enrolment_id FROM v_enrolment_destination_admission eda
		WHERE eda.enrolment_id NOT IN (
			SELECT 
				mon.enrolment_id 
			FROM v_enrolment_mon mon
		)
		
	)
)
ORDER BY priority DESC,kb