¹øÈ£ |
Á¦¸ñ |
µî·ÏÀÚ |
ºÐ´ã±Ý¾× |
¼öÀÍ±Ý¾× |
ÆÇ¸Å±Ý¾× |
ÆǸÅÀÏ |
SELECT TB.SUBJECT,TB.PRICE,TB.REGDATE,K.PDS_CATE,K.UID,K.UNAME FROM MP_TEMPBUY AS TB,MP_KNOWLEDGE AS K,MP_ORDER AS OD WHERE TB.FLAG = 'K' AND left(TB.REGDATE,7) = '2024-01' AND K.KNO = TB.P_NO AND TB.O_NO = OD.ORDER_NO AND OD.R_RESULT NOT IN ('C','R') ORDER BY TB.NO DESC
3 |
¾ÓÄ«º¼Æ® µµ¸é ÀÚ·á |
¹Ú¹èÁ¤ [moonnight06] |
250 ¿ø |
250 ¿ø |
500 ¿ø |
2024-01-10 |
2 |
º¼³ª»ç ¼±Á¤°è»ê½ÃÆ® |
À¯º´±Ô [yoo709] |
500 ¿ø |
500 ¿ø |
1000 ¿ø |
2024-01-10 |
1 |
À¯¾Ð°ü·Ã °è»ê ÇÁ·Î±×·¥ |
³²¸í±â [smeng] |
1,000 ¿ø |
1,000 ¿ø |
2000 ¿ø |
2024-01-01 |
|