| "ʹ"
áÊ´§ÃÒ¡Ò÷Õè 1 - 21 ¨Ò¡ 21 ÃÒ¡Òà | |
ÇÕ«Õ´Õ VCD : NARUTO : ¹ÒÃÙâµÐ µÓ¹Ò¹ÇÒÂØÊÅҵѹ 4 ÀÒ¤¨ÍÁ¾Ô¦ÒµÍÁµÐ Vol.05134219 59ß VCD : CASPER S SCARE SHOOL : á¤Êà»ÍÃì ¼Õ¹éÍÂà¾×è͹ÃÑ¡ Box set Vol.1-26 ¨º.(˹ѧ¡ÒÃìµÙ¹à´ç¡)130164 499ß VCD : NARUTO : ¹ÒÃÙâµÐ ¹Ô¹¨Ò¨ÍÁ¤Ò¶Ò Boxset ªØ´ 10 vol.100-110127939 159ß VCD : NARUTO : ¹ÒÃÙâµÐ ¹Ô¹¨Ò¨ÍÁ¤Ò¶Ò Boxset ªØ´ 3 vol.23-33127932 159ß VCD : NARUTO : ¹ÒÃÙâµÐ ¹Ô¹¨Ò¨ÍÁ¤Ò¶Ò Boxset ªØ´ 2 vol.12-22127931 159ß VCD : Ä·¸ÔìËÁÑ´´ÒÇà˹×Í ÀÒ¤ µÓ¹Ò¹ÃÒâÍ º·áË觡ÒÃËéÓËÑè¹·Õèáʹ´Øà´×Í´ 127139 79ß VCD : Conan ÂÍ´¹Ñ¡Ê׺¨ÔëÇ⤹ѹ à´ÍЫÕÃÕèÊì »Õ7 Vol.20126636 89ß VCD : Battle B-Daman : ËØè¹àËÅç¡ÊÒ¿éÒºÕ´ÒáÁ¹ vol.04(ÇիմիͧŴÃÒ¤Ò¾ÔàÈÉ)126379 19ß VCD : Stuart Little 2 : à¨éÒ˹Ùáʹ«¹ 2124031 59ß 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 : The Brave One : à´ÍÐ àºÃ¿ Çѹ ËÑÇã¨à¸Íµéͧ¡ÅéÒ (˹ѧ½ÃÑè§)122306 149ß VCD : ¼ÕàÅÕé§ÅÙ¡¥¹ : Ghost Mother (˹ѧä·Â)122295 99ß Education Vcd : A B C ¹Ñº 1-10121159 39ß Education Vcd : ¡.ä¡è áÅÐ ¹Ñº 1-10121157 39ß VCD : Noodle Boxer : áʺʹԷ ÈÔÉÂìÊèÒÂ˹éÒ(˹ѧä·Â)120896 99ß 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 - 21 ¨Ò¡ 21 ÃÒ¡Òà | |
| |