|
FILE: /storage/www/matchfishing/matchfishing.ru/htdocs/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 671
MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,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 ACTIVE_FROM,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.NAME as NAME,BE.CODE as CODE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.WF_STATUS_ID as WF_STATUS_ID,BE.WF_PARENT_ELEMENT_ID as WF_PARENT_ELEMENT_ID,BE.CREATED_BY as CREATED_BY, FPS0.PROPERTY_4 as PROPERTY_AUTHOR_VALUE, FPS0.DESCRIPTION_4 as PROPERTY_AUTHOR_DESCRIPTION, concat(BE.ID , ':' , 4) as PROPERTY_AUTHOR_VALUE_ID,BE.SHOW_COUNTER as SHOW_COUNTER,L.DIR as LANG_DIR,BE.SORT as SORT,BE.XML_ID as EXTERNAL_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID 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 b_iblock_element_prop_s2 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = 32 AND FPS0.PROPERTY_32 = FPEN0.ID INNER JOIN ( SELECT DISTINCT B.ID FROM b_iblock B INNER JOIN b_iblock_group IBG ON IBG.IBLOCK_ID = B.ID WHERE (( IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') )) AND ((((B.IBLOCK_TYPE_ID LIKE 'info')))) AND ((((B.ID = '2')))) ) BB ON BB.ID = BE.IBLOCK_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 (2))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((B.IBLOCK_TYPE_ID LIKE 'info')))) AND ((((BE.IBLOCK_ID = '2')))) AND ((((BE.ACTIVE='Y')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((FPEN0.VALUE LIKE 'Y')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.ACTIVE_FROM desc ,BE.SORT asc ,BE.ID desc [Disk full (/usr/db/tmp/#sql4c9_45e77d1_2); waiting for someone to free some space...]
Module: advertising
Class: CAdvBanner
File: /storage/www/matchfishing/matchfishing.ru/htdocs/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 931
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'mf') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'mf') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '23') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '23') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Disk full (/usr/db/tmp/#sql4c9_45e77d1_3); waiting for someone to free some space...]
LINE: 671
MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,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 ACTIVE_FROM,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.NAME as NAME,BE.CODE as CODE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.WF_STATUS_ID as WF_STATUS_ID,BE.WF_PARENT_ELEMENT_ID as WF_PARENT_ELEMENT_ID,BE.CREATED_BY as CREATED_BY, FPS0.PROPERTY_4 as PROPERTY_AUTHOR_VALUE, FPS0.DESCRIPTION_4 as PROPERTY_AUTHOR_DESCRIPTION, concat(BE.ID , ':' , 4) as PROPERTY_AUTHOR_VALUE_ID,BE.SHOW_COUNTER as SHOW_COUNTER,L.DIR as LANG_DIR,BE.SORT as SORT,BE.XML_ID as EXTERNAL_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID 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 b_iblock_element_prop_s2 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = 32 AND FPS0.PROPERTY_32 = FPEN0.ID INNER JOIN ( SELECT DISTINCT B.ID FROM b_iblock B INNER JOIN b_iblock_group IBG ON IBG.IBLOCK_ID = B.ID WHERE (( IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') )) AND ((((B.IBLOCK_TYPE_ID LIKE 'info')))) AND ((((B.ID = '2')))) ) BB ON BB.ID = BE.IBLOCK_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 (2))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((B.IBLOCK_TYPE_ID LIKE 'info')))) AND ((((BE.IBLOCK_ID = '2')))) AND ((((BE.ACTIVE='Y')))) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((FPEN0.VALUE LIKE 'Y')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.ACTIVE_FROM desc ,BE.SORT asc ,BE.ID desc [Disk full (/usr/db/tmp/#sql4c9_45e77d1_2); waiting for someone to free some space...]
|
Module: advertising
Class: CAdvBanner
File: /storage/www/matchfishing/matchfishing.ru/htdocs/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetPageWeights_RS
Line: 931
MySQL Query Error: SELECT DISTINCT B.TYPE_SID, B.ID BANNER_ID, B.WEIGHT BANNER_WEIGHT, B.SHOWS_FOR_VISITOR, B.FIX_CLICK, B.FIX_SHOW, B.KEYWORDS BANNER_KEYWORDS, DATE_FORMAT(B.DATE_SHOW_FIRST, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FIRST, DATE_FORMAT(B.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(B.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, B.FLYUNIFORM FLYUNIFORM, B.MAX_SHOW_COUNT MAX_SHOW_COUNT, B.SHOW_COUNT SHOW_COUNT, C.ID CONTRACT_ID, C.WEIGHT CONTRACT_WEIGHT, C.KEYWORDS CONTRACT_KEYWORDS FROM b_adv_type T INNER JOIN b_adv_banner B ON ( B.ACTIVE='Y' and B.TYPE_SID = T.SID and B.STATUS_SID = 'PUBLISHED' and (B.FOR_NEW_GUEST is null or B.FOR_NEW_GUEST='Y') and (ifnull(B.MAX_SHOW_COUNT,0)>ifnull(B.SHOW_COUNT,0) or ifnull(B.MAX_SHOW_COUNT,0)=0) and (ifnull(B.MAX_CLICK_COUNT,0)>ifnull(B.CLICK_COUNT,0) or ifnull(B.MAX_CLICK_COUNT,0)=0) and (ifnull(B.MAX_VISITOR_COUNT,0)>ifnull(B.VISITOR_COUNT,0) or ifnull(B.MAX_VISITOR_COUNT,0)=0) and (B.DATE_SHOW_FROM<=now() or B.DATE_SHOW_FROM is null or length(B.DATE_SHOW_FROM)<=0) and (B.DATE_SHOW_TO>=now() or B.DATE_SHOW_TO is null or length(B.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_banner_2_site BS ON ( BS.BANNER_ID = B.ID and BS.SITE_ID = 'mf') INNER JOIN b_adv_contract C ON ( C.ID = B.CONTRACT_ID and C.ACTIVE='Y' and (ifnull(C.MAX_SHOW_COUNT,0)>ifnull(C.SHOW_COUNT,0) or ifnull(C.MAX_SHOW_COUNT,0)=0) and (ifnull(C.MAX_CLICK_COUNT,0)>ifnull(C.CLICK_COUNT,0) or ifnull(C.MAX_CLICK_COUNT,0)=0) and (ifnull(C.MAX_VISITOR_COUNT,0)>ifnull(C.VISITOR_COUNT,0) or ifnull(C.MAX_VISITOR_COUNT,0)=0) and (C.DATE_SHOW_FROM<=now() or C.DATE_SHOW_FROM is null or length(C.DATE_SHOW_FROM)<=0) and (C.DATE_SHOW_TO>=now() or C.DATE_SHOW_TO is null or length(C.DATE_SHOW_TO)<=0)) INNER JOIN b_adv_contract_2_site CS ON ( CS.CONTRACT_ID = B.CONTRACT_ID and CS.SITE_ID = 'mf') INNER JOIN b_adv_contract_2_type CT ON ( CT.CONTRACT_ID = C.ID and (CT.TYPE_SID = 'ALL' or CT.TYPE_SID = T.SID)) INNER JOIN b_adv_banner_2_weekday BW ON ( BW.BANNER_ID = B.ID and BW.C_WEEKDAY='FRIDAY' and BW.C_HOUR = '23') INNER JOIN b_adv_contract_2_weekday CW ON ( CW.CONTRACT_ID = C.ID and CW.C_WEEKDAY='FRIDAY' and CW.C_HOUR = '23') LEFT JOIN b_adv_banner_2_group UG1 ON ( (UG1.BANNER_ID = B.ID and UG1.GROUP_ID in (2) and UG1.GROUP_ID<>2) ) LEFT JOIN b_adv_banner_2_page BP1 ON ( BP1.BANNER_ID = B.ID and BP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_banner_2_page BP2 ON ( BP2.BANNER_ID = B.ID and BP2.SHOW_ON_PAGE='N' and '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(BP2.PAGE, '%')) LEFT JOIN b_adv_contract_2_page CP1 ON ( CP1.CONTRACT_ID = C.ID and CP1.SHOW_ON_PAGE='Y') LEFT JOIN b_adv_contract_2_page CP2 ON ( CP2.CONTRACT_ID = C.ID and CP2.SHOW_ON_PAGE='N' and '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(CP2.PAGE, '%')) LEFT JOIN b_adv_banner_2_stat_adv BA ON BA.BANNER_ID = B.ID LEFT JOIN b_adv_banner_2_country BC ON BC.BANNER_ID = B.ID AND ( ( (B.STAT_TYPE is null OR length(B.STAT_TYPE)=0 OR B.STAT_TYPE='COUNTRY') AND BC.COUNTRY_ID='' ) OR ( B.STAT_TYPE='REGION' AND BC.COUNTRY_ID='' AND BC.REGION='' ) OR ( B.STAT_TYPE='CITY' AND BC.CITY_ID='0' ) ) WHERE T.ACTIVE = 'Y' and ( B.STAT_COUNT is null or B.STAT_COUNT = 0 or BC.BANNER_ID is not null ) and BP2.ID is null and CP2.ID is null and (BP1.ID is null or '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(BP1.PAGE, '%')) and (CP1.ID is null or '/galery/index.php?PAGE_NAME=detail&USER_ALIAS=Seal&SECTION_ID=851&ELEMENT_ID=1176622' like concat(CP1.PAGE, '%')) and (BA.STAT_ADV_ID is null or BA.STAT_ADV_ID='0') and (BC.COUNTRY_ID is null or BC.COUNTRY_ID='') and ( (B.SHOW_USER_GROUP = 'Y' and UG1.GROUP_ID is not null) or (B.SHOW_USER_GROUP <> 'Y' and UG1.GROUP_ID is null) ) ORDER BY B.TYPE_SID desc, C.ID desc [Disk full (/usr/db/tmp/#sql4c9_45e77d1_3); waiting for someone to free some space...]
|