select * from rsvt_room as r inner join rsvt_han_room as dr on r.uid=dr.r_id and r.p_id=dr.p_id where r.p_id='olley' and '' <= (r.fixednum+r.addnum) and if(r.prd_type=2,'20240514' < r.r_start or '20240514' > r.r_end,r.prd_type!=2) order by r.r_order asc, r.uid asc
0 :
error file : /search/search_pension.html