CAllMeetingItem::DeleteAbandoned

static function DeleteAbandoned()
{
	global $DB;
	$dbRes = $DB->Query('SELECT I.ID FROM b_meeting_item I LEFT JOIN b_meeting_instance MI ON MI.ITEM_ID=I.ID GROUP BY I.ID HAVING COUNT(MI.ID)=0');

	$ids = '';
	while ($arRes = $dbRes->Fetch())
		$ids .= ($ids == '' ? '' : ',').$arRes['ID'];

	if ($ids != '')
	{
		$GLOBALS['DB']->Query('DELETE FROM b_meeting_item_files WHERE ITEM_ID IN ('.$ids.')');
		$GLOBALS['DB']->Query('DELETE FROM b_meeting_item_tasks WHERE ITEM_ID IN ('.$ids.')');
		$GLOBALS['DB']->Query('DELETE FROM b_meeting_item WHERE ID IN ('.$ids.')');
	}
}