common.php에서 실행되는 쿼리문

select count(0) as cnt from 
    happy_auto_jump 
where 
    aj_hour <= '".date("H")."' and aj_min <= '".date("i")."' 
    and not EXISTS (
        SELECT 
            * 
        FROM 
            `happy_auto_jump_history` 
        WHERE 
            happy_auto_jump_history.aj_seq = happy_auto_jump.seq 
            and aj_hour <= '".date("H")."' and aj_min <= '".date("i")."'
            and DATE_FORMAT(reg_date, '%Y-%m-%d') = CURDATE()
    )
    AND EXISTS (
        SELECT
            *
        FROM
            happy_info
        WHERE
            (select mb_2 from g5_member where mb_id = happy_info.mb_id) > now()
           AND happy_info.mb_id = happy_auto_jump.mb_id and happy_info.hi_autojump = 1
    )