SELECT 

    a.*, 

    (SELECT COUNT(0) FROM happy_coupon WHERE a.seq = happy_coupon.hi_seq) AS coupon 

FROM 

    happy_info AS a 

LEFT JOIN 

    g5_member AS b 

ON 

    (a.mb_id = b.mb_id) 

WHERE 

    a.hi_use = 1 

    AND '2025-03-26' BETWEEN b.mb_1 AND b.mb_2 

    AND a.hi_title_on_off = 1 

ORDER BY 

    a.hi_order ASC 

LIMIT 10