| "ʹ"
áÊ´§ÃÒ¡Ò÷Õè 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 ÃÒ¡Òà | |
| |