DROP TABLE IF EXISTS GroupParmTable
;
-- Census needed #1871 Canada - group Unmark list.sql

CREATE TEMP TABLE IF NOT EXISTS GroupParmTable
AS
SELECT LabelValue AS GroupID, LabelName COLLATE NOCASE FROM LabelTable --2011-11-27 LabelID corrected to LabelValue
WHERE LabelName LIKE '%Census needed%#1871%Canada%'
;

-- Unmark (list of manual unmarks, not advisable for a parameterised query)

DELETE FROM GroupTable
WHERE GroupID LIKE
(
SELECT GroupID FROM GroupParmTable
)
AND StartID IN (759,849,756,529,367) -- list of RINs to unmark, separated by commas
;

-- END OF SCRIPT