Metacat

AND id.guid = cd.guid;

-- look at them

SELECT * 

FROM restore_documents;

--STOP HERE WHEN TESTING

 * (Avoids encountering this issue again)

 */

 */

SELECT count(id.guid)

FROM xml_revisions x,

	identifier id,

AND id.guid = sm.guid

AND sm.obsoleted_by IS NOT null

AND sm.archived = 'true';

/*Do the update on xml_revisions

 */

/** 

 * Check numbers in xml_documents

 */

SELECT count(id.guid)

FROM xml_documents x,

	identifier id,

AND id.guid = sm.guid

AND sm.obsoleted_by IS NOT null

AND sm.archived = 'true';

/*Do the update on xml_documents

 */