Mine

        my $q = "select HIGH_PRIORITY
        IFNULL(IF(R.GRP = 0, S.RGRP_ID_T,R.GRP),0) AS GRP,R.PRICE,R.CODE_ID,
        IFNULL(S.OPER_ID,0) AS OPER_ID,
        R.RATE_ID,UNIX_TIMESTAMP(R.RATE_DATE) AS TSTAMP,
        IFNULL(S.ID,0) AS ID,R.capacity,R.ID AS RID,
        CONCAT(R.TZ_ID,',',IF(UNIX_TIMESTAMP(R.STOP_DATE)>0,UNIX_TIMESTAMP(R.STOP_DATE),2145906000)) AS TZ_ID,
        HOUR(NOW()) as hr,IFNULL(R.ncnt,0) AS ncnt,R.state,
        IFNULL(IF(R.DENY_GRP = 0,S.RGRP_DENY_ID_T,R.DENY_GRP),0),
        IFNULL(IF(R.GRP = 0, S.RGRP_ID_T,R.GRP),0) AS DGRP,R.CODE_ID,IFNULL(S.hunt_mode,0) as hunt_mode
        from SITE S
        LEFT JOIN RATES R FORCE INDEX (rate_fnd) ON R.RATE_ID=S.rate_t
        WHERE
        R.CODE_ID IN ($did_str)
        AND R.STOP_DATE > SUBDATE(NOW(),INTERVAL 1 DAY)
        AND R.RATE_DATE <= ADDDATE(NOW(),INTERVAL 1 DAY)
        AND S.rate_t>0
        AND R.state != 2
        ";