[Mysql] View

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `master`@`%` 
    SQL SECURITY DEFINER
VIEW `vw_ep_schedule_summary_info` AS
    SELECT 
        `a`.`pipe_id` AS `pipe_id`,
        `a`.`summary_url` AS `summary_url`,
        `a`.`mall_id` AS `mall_id`,
        `b`.`billing_type` AS `billing_type`,
        `b`.`mall_name` AS `mall_name`
    FROM
        (`mcps_interface_dev`.`ps_pipe_if` `a`
        JOIN `mcps_interface_dev`.`ps_mall_if` `b` ON ((`b`.`mall_id` = `a`.`mall_id`)))
    WHERE
        ((`b`.`mall_status` = 1)
            AND (`a`.`status` = 'Y')
            AND (`a`.`schedule_summary_hour` & POW(2,
                IF((CAST(LEFT(CURTIME(), 2) AS UNSIGNED) = 0),
                    24,
                    LEFT(CURTIME(), 2))))
            AND (`a`.`schedule_summary_min` = CAST(SUBSTR(CURTIME(), 4, 2) AS UNSIGNED)))