• Модуль: calendar
  • Путь к файлу: ~/bitrix/modules/calendar/lib/update/updatedgoogleeventcleaner.php
  • Класс: BitrixCalendarUpdateUpdatedGoogleEventCleaner
  • Вызов: UpdatedGoogleEventCleaner::getDuplicatedLinkInfo
private function getDuplicatedLinkInfo()
{
	global $DB;

	return $DB->Query("
		SELECT
            MIN(ID) as FIRST_LINK_ID, 
            MAX(ID) as LAST_LINK_ID,
            VENDOR_EVENT_ID,
            COUNT(1) as CNT
		FROM b_calendar_event_connection
		WHERE VENDOR_EVENT_ID <> '' AND ENTITY_TAG <> ''
		GROUP BY VENDOR_EVENT_ID, CONNECTION_ID
		HAVING CNT = 2
		LIMIT " . self::PORTION . ";
	");
}