Module: advertising
Class: CAdvContract
File: /home/a/artoffice/public_html/bitrix/modules/advertising/classes/mysql/advertising.php
Function: GetList
Line: 234
MySQL Query Error: SELECT if (( (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) 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.ACTIVE='Y') ), 'green', 'red') LAMP, C.ID, C.ACTIVE, C.NAME, C.DESCRIPTION, C.ADMIN_COMMENTS, C.WEIGHT, C.SORT, C.MAX_SHOW_COUNT, C.SHOW_COUNT, C.EMAIL_COUNT, C.CREATED_BY, C.MODIFIED_BY, C.MAX_CLICK_COUNT, C.CLICK_COUNT, C.DEFAULT_STATUS_SID, C.MAX_VISITOR_COUNT, C.VISITOR_COUNT, C.KEYWORDS, if(C.SHOW_COUNT<=0,0,round((C.CLICK_COUNT*100)/C.SHOW_COUNT,2)) CTR, DATE_FORMAT(C.DATE_SHOW_FROM, '%d.%m.%Y %H:%i:%s') DATE_SHOW_FROM, DATE_FORMAT(C.DATE_SHOW_TO, '%d.%m.%Y %H:%i:%s') DATE_SHOW_TO, DATE_FORMAT(C.DATE_CREATE, '%d.%m.%Y %H:%i:%s') DATE_CREATE, DATE_FORMAT(C.DATE_MODIFY, '%d.%m.%Y %H:%i:%s') DATE_MODIFY, count(distinct B.ID) BANNER_COUNT FROM b_adv_contract C LEFT JOIN b_adv_banner B ON (B.CONTRACT_ID=C.ID) WHERE (1=1 AND ( if (( (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) 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.ACTIVE='Y') ), 'green', 'red') = 'red' ) AND ( C.EMAIL_COUNT<='0' ) ) GROUP BY C.ID HAVING (1=1) ORDER BY ifnull(C.SORT,0) desc [Table 'artoffice_bitrix.b_adv_banner' doesn't exist]

DB query error.
Please try later.