select * from m_deal_round_detail where deal_round_id = 922 and CAST(deal_round_end as time) >= '10:08:10' and CAST(deal_round_start as time)<='10:08:10' order by deal_round_end asc
SELECT * FROM m_deal_round_detail rd
INNER JOIN (SELECT * FROM m_deal_round WHERE deal_round_date >= '2024-11-12' ORDER BY deal_round_date asc LIMIT 2) r ON r.deal_round_id = rd.deal_round_id
ORDER BY r.deal_round_date asc, rd.deal_round_start asc