| "¹"
áÊ´§ÃÒ¡Ò÷Õè 1 - 28 ¨Ò¡ 28 ÃÒ¡Òà | |
ÇÕ«Õ´Õ VCD : THE TREE OF LIFE : ·ÃÕ ÍÍ¿ äÅ¿ì (Ẻ«Í§) (˹ѧ½ÃÑè§)138365 35ß VCD : DOCTOR STRANGE : ´Ã.ÊàµÃ¹¨ì ÎÕâÃè¾ÅѧàÇ·Âì (Ẻ«Í§)135988 35ß VCD : SPONGEBOB SQUAREPANTS SEASON 6 : ʾѹ¨ìºêͺ Êá¤ÇÃìá¾¹·ì «Õ«Ñè¹ 6 Vol.05135666 59ß VCD : SPONGEBOB SQUAREPANTS SEASON 6 : ʾѹ¨ìºêͺ Êá¤ÇÃìá¾¹·ì «Õ«Ñè¹ 6 Vol.03135664 59ß VCD : CASPER S SCARE SHOOL : á¤Êà»ÍÃì ¼Õ¹éÍÂà¾×è͹ÃÑ¡ Box set Vol.1-26 ¨º.(˹ѧ¡ÒÃìµÙ¹à´ç¡)130164 499ß VCD : The Godfather : à´ÍÐ ¡çÍ´¿Òà¸ÍÃì124018 69ß Vcd : The Cat In The Hat à´ÍРᤷ àËÁÕÂÇáʺãÊèËÁÇ¡«èÒÊì (˹ѧ½ÃÑè§)123948 59ß Vcd : The Wild thornberrys movie ¨ÔëÇáʺµÐÅØ»èÒ (˹ѧ½ÃÑè§)123901 59ß Vcd : Target »Á»ÃÔÈ¹Ò à¤Ã×Í¢èÒÂÁóР(˹ѧ½ÃÑè§)123893 59ß Vcd : The Hunt For Red October : ÅèÒµØÅÒá´§ (˹ѧ½ÃÑè§)123888 59ß Vcd : Godzilla ¡ç͵«ÔÅÅèÒ ÍÊÙþѹ¸Øì¹ÔÇà¤ÅÕÂÃìÅéÒ§âÅ¡ (˹ѧ½ÃÑè§)123844 59ß Vcd : ÍØŵÃéÒäÇâÍàÅçµ ÁѨ¨ØÃÒªÁËÒ»ÃÐÅÑ Ultraviolet(˹ѧ½ÃÑè§)123842 59ß Vcd : â´¹ÍÂèÒ§¹Õé ¾Õè¢Í»Åé¹ Fun With Dick And Jane(˹ѧ½ÃÑè§)123841 59ß Vcd : So Close 3 ¾ÂѤ¦ìÊÒÇ ÁËÒ»ÃÐÅÑ (˹ѧ¨Õ¹)123840 59ß Vcd : The One à´ÍÐÇѹ...à´ÕèÂÇÁËÒ»ÃÐÅÑÂ(˹ѧ¨Õ¹)123825 59ß Vcd : Charlie s Angels ¹Ò§¿éÒªÒÃìÅÕ(˹ѧ½ÃÑè§)123821 59ß VCD : DOCTOR STRANGE ´Ã.ÊàµÃ¹¨ì ÎÕâÃè¾ÅѧàÇ·Âì123566 59ß Edutainment Vcd : ÍѨ©ÃÔÂÐÊÙèÅÙ¡¹éÍ à¢Õ¹¡.ä¡è123515 39ß VCD : The Brave One : à´ÍÐ àºÃ¿ Çѹ ËÑÇã¨à¸Íµéͧ¡ÅéÒ (˹ѧ½ÃÑè§)122306 149ß VCD : Body#19 : Í´ÕéȾ 19(˹ѧä·Â)122300 99ß VCD : ¼ÕàÅÕé§ÅÙ¡¥¹ : Ghost Mother (˹ѧä·Â)122295 99ß VCD : Twins Mission : ¤Ùè¾ÒÂØ ¿Ñ´·ÐÅØ¿éÒ (˹ѧ¨Õ¹)122294 99ß Education Vcd : A B C ¹Ñº 1-10121159 39ß Education Vcd : ¡.ä¡è áÅÐ ¹Ñº 1-10121157 39ß VCD : à´ÍÐ àŵàµÍÃì à¢Õ¹à»ç¹Ê觵Ò (˹ѧä·Â)121083 39ß VCD : Rocky Balboa : Ãçͤ¡Õé ÃÒªÒ¡Ó»Ñé¹...·ØºÊѧàÇÕ¹ (˹ѧ½ÃÑè§)121057 139ß Education Vcd : Pang Pond àÃÕ¹ÃÙé ÀÒÉÒÍѧ¡ÄÉ a-z120851 69ß Edutainment Vcd : 300 ¤Ó¶ÒÁ ˹ÙËҤӵͺ 2118976 39ß select t1.productid,t1.ean,t1.typeid,t1.productname, t1.title_e, t1.sellprice,
t1.displayprice, t1.hotprice,t1.sprodcode from product as t1 left outer join characters as t2 on t2.charactersid=t1.charactersid left outer join description as t3 on t3.ean=t1.ean join supplier as t4 on t4.supplierid=t1.supplierid left outer join brand as t5 on t5.brandid=t1.brandid left outer join studio as t6 on t6.studioid=t1.studioid
left outer join category as t7 on t7.categoryid=t1.categoryid1
left outer join category as t8 on t8.categoryid=t1.categoryid2
left outer join category as t9 on t9.categoryid=t1.categoryid3
where (
t1.productname LIKE '%%¹%%'
or t1.productid like '%%¹%%'
or t1.title_e LIKE '%%¹%%'
or t1.keywords LIKE '%%¹%%'
or t1.productid LIKE '%%¹%%'
or t1.ean LIKE '%%¹%%'
or t1.tags like '%%¹%%'
or t2.charactersname like '%%¹%%'
or t2.charactersnamee like '%%¹%%'
or t2.tags like '%%¹%%'
or t3.description like '%%¹%%'
or t4.suppliername like '%%¹%%'
or t5.brandname like '%%¹%%'
or t5.brandnamee like '%%¹%%'
or t6.studioname like '%%¹%%'
or t6.studionamee like '%%¹%%'
or t7.categoryname like '%%¹%%'
or t7.categorynamee like '%%¹%%'
or t8.categoryname like '%%¹%%'
or t8.categorynamee like '%%¹%%'
or t9.categoryname like '%%¹%%'
or t9.categorynamee like '%%¹%%'
)
and t1.approved=1 and typeid!=40 and typeid=54 order by t1.productid desc "¹"
áÊ´§ÃÒ¡Ò÷Õè 1 - 28 ¨Ò¡ 28 ÃÒ¡Òà | |
| |