31 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 1 2 3 4
 
 
 
 
SELECT g.* FROM sy__good g WHERE g.flag_show=1 and flag_modify=0 and ( ( flag_sell=2 and TO_DAYS(sell_date1)<=TO_DAYS('2020-06-6') and TO_DAYS('2020-06-6')<=TO_DAYS(sell_date2) ) or ( flag_sell=1 and TO_DAYS(sell_end)<=TO_DAYS('2020-06-30') and TO_DAYS('2020-06-01')<=TO_DAYS(sell_end) and sell_week='넗' ) ) ORDER BY g.sell_date1 ASC, g.sell_end DESC, g.price ASC LIMIT -20,20
 
 
 
 




검색된 상품이 없습니다.