SELECT a.id as sid, a.price, a.roomclass,a.salestart,a.saleend,a.image,a.downdate,a.ShowTimer,a.sort, b.name, b.description,
c.id as hno, d.roomname,e.*,rl.classname
FROM (suite a, room c)
LEFT JOIN suite_i18n b ON (a.id = b.id AND b.lang = 'tw')
LEFT JOIN room_i18n d ON( c.id = d.id AND d.lang = 'tw')
LEFT JOIN suiteprice e ON a.id = e.id
LEFT JOIN rclass rc ON (a.hno = rc.hno AND a.roomclass = rc.id)
LEFT JOIN rclass_i18n rl ON (rc.id = rl.rclassno AND rl.lang = 'tw')
WHERE a.hno ='101' AND a.rno = c.id and a.activedate <='2026-11-15' and a.downdate >='2026-11-15' and b.name<>' ' and a.del_fg='N'
and a.ShowTimer = '0' and a.SpecialSuite='0394' order by a.sort ASC
訂房系統
