LINE120 SQL:SELECT COUNT(id) AS all_count FROM `coupon` WHERE shop_id = AND start_date <= CURDATE() AND end_date >= CURDATE() ORDER BY sort_no ASC, id DESC