·íçE/¨T¨®­É´Ú¤£­­¨®ºØ°ê²£¨®¡B¶i¤f¨®¡B¤½¥q¨®¡B³f¨®¡B¹CÄý¨®¡A´[«¬¨®¡C·Ç³Æ¨®¥D¨­¥÷µý¥¿¥»¡A¦æ·Ó¥¿¥»¡A§Y¥i§Ö³t¿ì²z¡C¤À´Á¨®¥i­É§K¯d¨®¡A¨®·Ó¶]¡B¿ú¤SÂà¡A¯u¤è«K¡C±M·~¦Xªk¥ß®×¨T¨®­É´Ú,±Mªù¿ì²z·íçE¿Ä¸ê­É¶UªA°È¥]§t¨T¨®­É´Ú¡B­É´Ú¡B¸Ñ¨M­É¿ú¶gÂàµLªùªº§xÂZ¡C¤£­­¨®ºØ¡B¤£­­¨®ÄÖ¡A¦³µL¤À´Á§¡¥i¶U¡AÅý±zªº·R¨®´À±z«ÌªF¶gÂà¡Aµo´§¨ä»ù­È©Ê¡C¤j¤pª÷ÃB¤£­­¡A¤è«K±z¤jÃB¶gÂà¡C¥t¥i­°®§¥NÀv«H¥Î¶U´Ú©Î­°®§§UÁÙ¥LçE¾lÃB¡A´À±z»´ÃP¬Ù§Q¤§¾l¡A©|´À±z¼W¥[¶gÂàª÷¡A¥H³Æ©Ò»Ý¡C¦U¦æ¦U·~¬Ò¥i¥Ó¶U¡A§K¾á«O¡B§K«OÃÒ¤H¡CÅý±z¤£¥Î¦A¥|³B¥hÄw³Ð·~°òª÷¡A¤ä²¼¶K²{¤]¤£¥Î¦A«ô°U§O¤H¬Ý¤HÁy¦â¡CÀH®É¬°±z¹w¯d¤@µ§¹w³Æª÷¡AÅý±z¦³³ÆµL±wºûÅ@«H¥Î¡C¥Ó½Ð¤@¦¸¡A§Y¥iÀH®ÉÆF¬¡½Õ«×¸êª÷¡A²×¨­ÀH®É¶U¡Cµ²¦X¶Ç²Î»P²{¥N¤Æ¸gÀç²z©À¡AÀH¨ìÀH¿ì¡A¤âÄò²«K¡A»´ÃP«×¹LÃøÃö¡A¤¤¤p¥ø·~¡B¤u°Ó¿Ä¸ê¡A®§§C«O±K¡A°¨¤W¨ú´Ú¡C Àç·~¶µ¥Ø¥]¬A¨T¨®¡B¾÷¨®¡B¦W¿ö¡Bª÷¹¢¡B¯]Ä_¡B¤j­ô¤j¡B¹q¾¹¥Î«~¡B¤j©v³fª«¡B©Ð¦a¤Î¥ô¦ó¦³»ù­Èª«·íçE¬y·í«~µ¥¡C ¬F©²¥ß®×¡A¦Xªk¸gÀç¡AÀç§Q¨Æ·~µn°OÃҤΥx¥_¥«·íçE°Ó·~¦P·~¤u·|·|­ûÃҮѦp¤U¡C·íçE¨T¨®.¾÷¾¹.¤u¼t¿Ä¸ê¡C ¥N¿ì¥»¤H²¼.¤½¥q²¼.«È²¼¶K²{¡C ª÷¹¢.¦W¿ö.Æp¥Û¡C¥ø·~.¤jÃB¶gÂà¡C¥L·íçE­É´Ú.Âà­É¥»·íçE­°®§¡C

·íçE­É´Ú¤¤¤ß  ¨T¨®­É´Ú  ·íçE­É´Ú¤¤¤ß  
  ¨T¨®­É´Ú » ·íçE°Ó«~ » °Ó«~µû½× ·íçE­É´Ú¤¤¤ß  |  ¨T¨®­É´Ú  |  ·íçE­É´Ú¤¤¤ß   
·íçE¤ÀÃþ
·íçE (37)
¨T¨®­É´Ú (16)
­É¶U (2)
­É´Ú (8)
·íçE¿Ä¸ê¤½¥q
¨T¨®­É´Ú«P¾P §ó¦h
¨T¨®­É´Ú§K¯d¨®
¨T¨®­É´Ú§K¯d¨®
NT$2
§Ö³t´M§ä¨T¨®­É´Ú
 
¿é¤JÃöÁä¦r´M§ä°Ó«~
¶i¶¥´M§ä°Ó«~
ªA°È¥x
Àu½è·íçE/¨T¨®­É´Ú
­É´Ú
¨T¨®­É´Ú
Ápµ¸·íçE/¨T¨®­É´Ú
·íçE/¨T¨®­É´Ú ·íçE/¨T¨®­É´Ú
·íçE ¤ý¤K peter ©Òµû½×¼g¹D¡G µû½×¤é´Á: 2007¦~March24¤éSaturday
·íçE ±M·~·íçE¨T¨®­É´Ú,,±M·~³B²z·íçE­É´Ú,¨T¨®­É´Ú,µ¥°]¸gª÷¿Ä°ÝÃD,º-
ܸ۪ºÅwªï±z¿ËÁ{¥»¤½¥q©Î¨Ó¹q¬¢¸ß¡C·íçE¨T¨..

µûµ¥: 5 Áû¬P¡I [5 Áû¬P¡I]
Åã¥Ü 1 ¨ì ²Ä1 (¦@1­Óµû½×) Á`­¶¼Æ:  1 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'andseoc_a01.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

¬y·í«~ §ó¦h
ªÅªº...