³â ¿ù
ÀÏ ¿ù È­ ¼ö ¸ñ ±Ý Åä
25 26 27 28 29 30 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
 
 
 
 
SELECT g.* FROM sy__good g WHERE g.fk_ctgy1_no=2 and g.flag_show=1 and flag_modify=0 and ( ( flag_sell=2 and TO_DAYS(sell_date1)<=TO_DAYS('2022-10-1') and TO_DAYS('2022-10-1')<=TO_DAYS(sell_date2) ) or ( flag_sell=1 and TO_DAYS(sell_end)<=TO_DAYS('2022-10-31') and TO_DAYS('2022-10-01')<=TO_DAYS(sell_end) and sell_week='' ) ) ORDER BY g.sell_date1 ASC, g.sell_end DESC, g.price ASC LIMIT -20,20
 
 
 
 




°Ë»öµÈ »óÇ°ÀÌ ¾ø½À´Ï´Ù.