¿Ä¸ê  Áʪ«¨®¤º®e  µ²±b  
  ¿Ä¸ê » ¤ä²¼¶K²{¥Ø¿ý » ³Ì·s°Ó«~ ¿Ä¸ê  |  Áʪ«¨®¤º®e  |  µ²±b   
¿Ä¸ê¤ÀÃþ
¤ä²¼¶K²{ (9)
¤ä²¼­É´Ú (8)
¶K²{ (6)
¶gÂà (3)
¿Ä¸ê (3)
²¼¶K (6)
³ÌÀu¶K²{ §ó¦h
¶K²{¬O§é¦X¦¨²{¦bªº»ù­È
¶K²{¬O§é¦X¦¨²{¦bªº»ù­È
NT$2
§Ö³t´M§ä¿Ä¸ê°T®§
 
¿é¤JÃöÁä¦r´M§ä¿Ä¸ê
¶i¶¥´M§ä¿Ä¸ê
ªA°È¥x
°h´«³f¨Æ¶µ
Áô¨pÅv«OÅ@Án©ú
·|­ûÅv¯q¤Î¶·ª¾
Ápµ¸§Ú­Ì
³Ì·s°Ó«~ ³Ì·s°Ó«~
¶gÂà ¶gÂà
¤W¬[¤é´Á¡G 2010¦~September01¤éWednesday
»s³y¼t°Ó¡G

»ù®æ¡G NT$3 NT$1
©ñ¨ìÁʪ«¨®
¶K²{ ¶K²{
¤W¬[¤é´Á¡G 2010¦~September01¤éWednesday
»s³y¼t°Ó¡G

»ù®æ¡G NT$2 NT$1
©ñ¨ìÁʪ«¨®
¤ä²¼­É´Ú ¤ä²¼­É´Ú
¤W¬[¤é´Á¡G 2010¦~September01¤éWednesday
»s³y¼t°Ó¡G

»ù®æ¡G NT$3 NT$1
©ñ¨ìÁʪ«¨®
¤ä²¼¶K²{ªº·N¸q ¤ä²¼¶K²{ªº·N¸q
¤W¬[¤é´Á¡G 2010¦~September01¤éWednesday
»s³y¼t°Ó¡G

»ù®æ¡G NT$3
©ñ¨ìÁʪ«¨®
¤ä²¼¶K²{ ¤ä²¼¶K²{
¤W¬[¤é´Á¡G 2010¦~September01¤éWednesday
»s³y¼t°Ó¡G

»ù®æ¡G NT$2 NT$1
©ñ¨ìÁʪ«¨®
Åã¥Ü 31 ¨ì ²Ä35 (¦@35­Ó·s°Ó«~) Á`­¶¼Æ: [<< «e¤@­¶]   1  2  3  4 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'money91_66.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]

Áʪ«¨® §ó¦h
1 x ¶K²{¬O§é¦X¦¨²{¦bªº»ù­È
NT$2