EventQueueManager::getEventListDb

static function getEventListDb()
{
	global $DB;
	$sqlQuery = "SELECT "
		. " e.SECTION_ID,"
		. " ec.ID as EVENT_CONNECTION_ID,"
		. " ec.EVENT_ID,"
		. " ec.ENTITY_TAG,"
		. " ec.VENDOR_VERSION_ID,"
		. " ec.CONNECTION_ID,"
		. " ec.VENDOR_EVENT_ID,"
		. " ec.VERSION,"
		. " ec.SYNC_STATUS,"
		. " ec.RETRY_COUNT,"
		. " con.*"
		. " FROM b_calendar_event e"
		. " INNER JOIN b_calendar_event_connection ec ON ec.EVENT_ID = e.ID "
		. " INNER JOIN b_calendar_section s ON s.ID = e.SECTION_ID "
		. " INNER JOIN b_dav_connections con ON con.ID = ec.CONNECTION_ID "
		. " INNER JOIN b_calendar_section_connection sc ON sc.SECTION_ID = e.SECTION_ID "
		. " WHERE "
		. " ec.SYNC_STATUS <> '" . Dictionary::SYNC_STATUS['success'] . "'"
		. " and ec.SYNC_STATUS <> '" . Dictionary::SYNC_STATUS['failed'] . "'"
		. " and s.ACTIVE = 'Y' and sc.ACTIVE = 'Y' and sc.CONNECTION_ID = con.ID"
		. " and con.NEXT_SYNC_TRY <= NOW()"
		. " ORDER BY ec.RETRY_COUNT ASC"
		. " LIMIT " . self::CHECK_ENTRY_LIMIT;

	return $DB->Query($sqlQuery);
}