# Time: 141026  2:11:44
# User@Host: mediaryazan[mediaryazan] @  [127.0.0.1]
# Query_time: 3.548305  Lock_time: 0.000138 Rows_sent: 84  Rows_examined: 16369
SET timestamp=1414275104;
/* #0 /var/www/mediaryazan/html/bitrix/modules/main/classes/mysql/database.php(161): CDatabaseMysql->getBacktrace(...)
#1 /var/www/mediaryazan/html/bitrix/modules/iblock/classes/mysql/iblockelement.php(735): CDatabaseMysql->Query(...)
#2 /var/www/mediaryazan/html/bitrix/components/usw/news.calendar/component.php(132): CIBlockElement->GetList(...)
#3 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/component.php(467): include(...)
#4 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/component.php(510): CBitrixComponent->__includeComponent(...)
#5 /var/www/mediaryazan/html/bitrix/modules/main/classes/general/main.php(2223): CBitrixComponent->includeComponent(...)
#6 /var/www/mediaryazan/html/bitrix_personal/templates/biz_main/header.php(397): CAllMain->IncludeComponent(...)
#7 /var/www/mediaryazan/html/bitrix/modules/main/include/prolog_after.php(86): include_once(...)
#8 /var/www/mediaryazan/html/bitrix/modules/main/include/prolog.php(12): require(...)
#9 /var/www/mediaryazan/html/bitrix/header.php(1): require_once(...)
#10 /var/www/mediaryazan/html/biz/news_detail.php(2): require(...)
#11 /var/www/mediaryazan/html/bitrix/modules/main/include/urlrewrite.php(155): include_once(...)
#12 /var/www/mediaryazan/html/bitrix/urlrewrite.php(2): include_once(...)
 */ 
SELECT DISTINCT IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM 
                        FROM 
                        b_iblock B
                        INNER JOIN b_lang L ON B.LID=L.LID
                        INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
                         INNER JOIN (
                                        SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID
                                        FROM b_iblock_section_element BSE

                                        INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID
                                        INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID
                                                AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN
                                                AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN)

                                        WHERE ((BS.ID IN (890)))
                                        ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID



                        WHERE 1=1 
                        AND (

                                ((((BE.ACTIVE='Y'))))
                                AND ((((BE.ACTIVE_FROM >= '2014-10-01 00:00:00'))))
                                AND ((((BE.ACTIVE_FROM < '2014-11-01 00:00:00'))))
                                AND ((((BE.IBLOCK_ID = '2'))))
                        )
                        AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))

                 LIMIT 10000;