SELECT
ID,
MESSAGE,
MESSAGE_LID,
SAVE_STATISTIC,
URL_REDIRECT,
TEST
FROM
b_stop_list
WHERE
ACTIVE='Y'
and TEST='N'
and (SITE_ID = 'ru' or SITE_ID is null or len(SITE_ID)<=0)
and (DATE_START<=getdate() or DATE_START is null)
and (DATE_END>=getdate() or DATE_END is null)
and ((((MASK_1 & 89)=IP_1 and
(MASK_2 & 184)=IP_2 and
(MASK_3 & 83)=IP_3 and
(MASK_4 & 172)=IP_4)
or (IP_1 is null and IP_2 is null and IP_3 is null and IP_4 is null))
and (upper('Mozilla/2.0 (compatible; ARCHIVE.ORG.UA crawler)') like '%'+upper(USER_AGENT)+'%'
or len(USER_AGENT)<=0 or USER_AGENT is null)
and (48=0 or USER_AGENT_IS_NULL<>'Y')
and (upper('') like '%'+upper(URL_FROM)+'%'
or len(URL_FROM)<=0 or URL_FROM is null)
and (upper('http://www.ok2invest.com/ru/about/') like '%'+upper(URL_TO)+'%'
or len(URL_TO)<=0 or URL_TO is null)
)