|
|
select G.GOODS_CODE , G.TITLE , G.CATE_CODE, G.PIC_NAME1 , G.LOW_PRICE , C.C_NAME , C3.CODE_NAME as TOUR_PERIOD_NUM_NAME from (TB_GOODS as G left outer join TB_CATEGORY as C on G.CATE_CODE = C.CATE_CODE) left outer join TB_CODE as C3 on G.TOUR_PERIOD_NUM = C3.CODE_ID and C3.CODE_GROUP = 1 where G.OPTION1 = '1' and C.CATE_CODE in('05','06','07','08') ORDER BY G.CATE_CODE asc, G.TITLE asc
¿ï¸ªµµ 2ÀÏ Äè¼Ó (25³â2¿ù28ÀÏ~7¿ù10ÀÏ)
310,000~
1¹Ú2ÀÏ
¿ï¸ªµµ 3ÀÏ Äè¼Ó (25³â2¿ù28ÀÏ~7¿ù10ÀÏ)
360,000~
2¹Ú3ÀÏ
¿ï¸ªµµ 3ÀÏ µ¶µµ¹«·áÀ̺¥Æ®(24³â9¿ù1ÀÏ~11¿ù30ÀÏ)
345,000~
2¹Ú3ÀÏ
¿ï¸ªµµ 3ÀÏ ¿¬ÈÞ (24³â9¿ù13ÀÏ~10¿ù6ÀÏ)
415,000~
2¹Ú3ÀÏ
2025³â È«µµ&Èæ»êµµ 2ÀÏ
330,000~
1¹Ú2ÀÏ
2025³â Çѱ¹´ëÇ¥ ºñ°æ ! °Å¹®µµ/¹éµµ 1¹Ú2ÀÏ
290,000~
1¹Ú2ÀÏ
½½·Î½ÃƼ û»êµµ/¿Ïµµ 2ÀÏ
265,000 ~
1¹Ú2ÀÏ
|
|