Посты по тегу "sql":

php / SQL в Битриксе

    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 LENGTH( SITE_ID ) <=0
    )
    AND (
    DATE_START <= NOW( )
    OR DATE_START IS NULL
    )
    AND (
    DATE_END >= NOW( )
    OR DATE_END IS NULL
    )
    AND (
    (
    (
    (
    MASK_1 &127
    ) = IP_1
    AND (
    MASK_2 &0
    ) = IP_2
    AND (
    MASK_3 &0
    ) = IP_3
    AND (
    MASK_4 &1
    ) = 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/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ru) Opera 9.51'
     ) LIKE CONCAT
    ( '%', UPPER( USER_AGENT ) , '%' )
    OR LENGTH( USER_AGENT ) <=0
    OR USER_AGENT IS NULL
    )
    AND ( 65 =0
    OR USER_AGENT_IS_NULL <> 'Y' )
    AND (
    UPPER( 'http://bitrix.ru/search/index.php?show_page_exec_time=Y&
    show_include_exec_time=Y&
    show_sql_stat=Y&bitrix_include_areas=Y&q=%EF%EE%E8%F1%EA&where=' ) LIKE CONCAT
    ( '%', UPPER( URL_FROM ) , '%' )
    OR LENGTH( URL_FROM ) <=0
    )
    AND (
    UPPER( 'http://bitrix.ru/search/index.php?show_page_exec_time=Y&
    show_include_exec_time=Y&show_sql_stat=Y&bitrix_include_areas=Y&q=%EF%EE%E8%F1%EA&where=&PAGEN_1=2' ) LIKE CONCAT
    ( '%', UPPER( URL_TO ) , '%' )
    OR LENGTH( URL_TO ) <=0
    OR URL_TO IS NULL
    )
    )