[Building Sakai] Lesson Builder cleanup

[Sobieralski, Damian Michael]

We're looking to cleanup db records for a specified site for our site import  Lesson Builder hiccup.  However, we are running into a bit of a problem.

At first, we thought we could use this to clean up the groups.

delete from LESSON_BUILDER_GROUPS where ITEMID in (select SAKAIID from LESSON_BUILDER_ITEMS where PAGEID in (select PAGEID from LESSON_BUILDER_PAGES where SITEID = 'My_Cool_SiteId'));

But the problem is during previous unsuccessful site imports the SAKAI_ID in the LB items record might still have "/dummy" in it.  And the itemId in the groups table doesn't appear to have any "dummy" s.  So how we can relate the item table to the group table in LB to purge the orphaned records?