|   "ʹ"
áÊ´§ÃÒ¡Ò÷Õè 1 - 37 ¨Ò¡ 37 ÃÒ¡Òà | |
´ÕÇÕ´Õ DVD BOXSET V1+2 AVENGERS (àÊÕ§ä·ÂÍÂèÒ§à´ÕÂÇ)(«Õ´Õ˹ѧ½ÃÑè§)(´ÕÇÕ´ÕÅ´ÃÒ¤Ò¾ÔàÈÉ)149698 99ß  DVD : Pirates of the Caribbean 5 : ʧ¤ÃÒÁá¤é¹â¨ÃÊÅÑ´äÃéªÕ¾ (àÊÕ§ä·ÂÍÂèÒ§à´ÕÂÇ)(˹ѧ½ÃÑè§)149521 139ß  DVD : Frankenweenie : á¿Ã§à¡é¹ÇÕ¹Õè ¤×¹ªÕ¾à¾×è͹«ÕéÊÕè¢Ò («Õ´Õ¡ÒÃìµÙ¹à´ç¡)(àÊÕ§ä·ÂÍÂèÒ§à´ÕÂÇ)149177 59ß  DVD : MOBILE SUIT GUNDAM THUNDERBOLT : âÁºÔÅÊÙ· ¡Ñ¹´ÑéÁ ¸Ñ¹à´ÍÃìâºÅ·ì ´Õà«ÁàºÍÃì ʡҠ(01)149101 430ß  DVD : CHI S SWEET HOME : ºéÒ¹¹ÕéµéͧÁÕàËÁÕÂÇ vol.01-08 Packset148158 792ß  DVD : AMAGAMI SS: ÍÒÁÒ¡ÒÁÔ ÍØºÑµÔÃÑ¡Çѹ¤ÃÔʵìÁÒÊ (Packset 1-6)148076 1,400ß  DVD : Gundam build fighters Try : ¡Ñ¹´ÑéÁºÔÅ´ìä¿·ìàµÍÃìÊ ä·Ã Vol.01-09 Packset146832 3,600ß  DVD : MAGIC KAITO ¨ÍÁâ¨Ã¤Ô´ ºØÃØÉÃѵµÔ¡ÒÅ 1412 Vol.02146661 279ß  DVD : Aura : ÈÖ¡ÊØ´·éÒ¢ͧÍÊÙÃÁѧ¡Ãà¢ÕéèÂÇáʧ à´ÍÐÁÙ¿ÇÕè ¾ÃéÍÁ¹ÔÂÒÂ145596 385ß  DVD : Yuru Yuri : ÂÙÃØ ÂÙÃÔ Vol.06145517 279ß  DVD : KOKORO CONNECT : àª×èÍÁËÑÇ㨠ÊÅѺÃèÒ§ÍÅàǧ Vol.01145022 279ß  BD : Mobile Suit Z Gundam : âÁºÔÅÊÙ· «ÕµéÒ ¡Ñ¹´ÑéÁ Vol.01144749 825ß  DVD : TO - LOVE - RU VOL.03144345 329ß  DVD : True Tears ¹éÓµÒáË觤ÇÒÁÃÑ¡ ã¹àÃ×èͧÃÒǸÃÃÁ´Ò vol.05144214 279ß  DVD : TO - LOVE - RU VOL.01 (¾ÃéÍÁCollector Box)144148 369ß  DVD : True Tears ¹éÓµÒáË觤ÇÒÁÃÑ¡ ã¹àÃ×èͧÃÒǸÃÃÁ´Ò vol.04144015 279ß  DVD : Medaka Box : àÁ´Ò¡Ð ºêÍ¡ Vol.05143982 279ß  DVD : True Tears ¹éÓµÒáË觤ÇÒÁÃÑ¡ ã¹àÃ×èͧÃÒǸÃÃÁ´Ò vol.02143734 279ß  DVD : Puchimas ! : »Ø¨ÔÁÒÊ! Vol.03143733 279ß  DVD : Kono Danshi Uchujin to Tatakaemasu : ˹ØèÁà·¾»Ð·ÐàÍàÅÕè¹143731 219ß  DVD : Medaka Box : àÁ´Ò¡Ð ºêÍ¡ Vol.04143618 279ß  DVD : Puchimas ! : »Ø¨ÔÁÒÊ! Vol.02143576 279ß  DVD : Medaka Box : àÁ´Ò¡Ð ºêÍ¡ Vol.03143426 279ß  DVD : Medaka Box : àÁ´Ò¡Ð ºêÍ¡ Vol.02143412 279ß  DVD : Puchimas ! : »Ø¨ÔÁÒÊ! Vol.01 (Collection Box)143382 359ß  DVD : CLANNAD After Story ÀÒ¤ 2 Vol.7143224 279ß  DVD : CLANNAD After Story ÀÒ¤ 2 Vol.5142860 279ß  DVD : CLANNAD After Story ÀÒ¤ 2 Vol.2142278 279ß  DVD : Keroro 5 : à¤âÃâÃÐ ¢ºÇ¹¡ÒÃÍêº Íêº »èǹâÅ¡ ÀÒ¤ 5 Vol.62134865 159ß  DVD : Onepiece season 6 : Çѹ¾Õª season 6 Vol.40(´ÕÇÕ´ÕÅ´ÃÒ¤Ò¾ÔàÈÉ)132410 99ß  DVD : The Prince of Tennis : à´ÍÐ »ÃÔé¹ÍͿ෹¹ÔÊ »Õ 4 Vol.04129138 190ß  DVD : Assault On Precinct ʹ.13 ÃÇÁËÑÇÊÙé (everyday low price)(˹ѧ½ÃÑè§)126228 59ß  DVD : (˹ѧà¡ÒËÅÕ) Jiang Hu ¡ÍËÇÙè à©×͹¤Á⤵Ãà¨éÒ¾èÍ (everyday low price)126227 59ß  DVD : A Sound of Thunder 2054 à¨ÒÐä´â¹àÊÒÃìâÅ¡ÅéÒ¹»Õ (everyday low price)(˹ѧ½ÃÑè§)126216 59ß  DVD : Brothers Grimm µÐÅØÂ¾ÔÀ¾ÁËÑȨÃÃÂì (everyday low price)(˹ѧ½ÃÑè§)126197 59ß  DVD : Conan ÂÍ´¹Ñ¡Ê׺¨ÔëÇ⤹ѹ à´ÍЫÕÃÕèÊì »Õ6 Vol.05125571 95ß  DVD Conan : ÂÍ´¹Ñ¡Ê׺¨ÔëÇ⤹ѹ à´ÍЫÕÃÕèÊì »Õ4 Vol.05(´ÕÇÕ´ÕÅ´ÃÒ¤Ò¾ÔàÈÉ )123831 95ß  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=52 order by t1.productid desc "ʹ"
áÊ´§ÃÒ¡Ò÷Õè 1 - 37 ¨Ò¡ 37 ÃÒ¡Òà | |
| |