¤¤¥j,¤G¤âÀ\¶¼³]³Æ³»Åý¶R½æ

¤¤¥j,¤G¤âÀ\¶¼³]³Æ³»Åý¶R½æ

´£¨Ñ³»Åý¤¤¥j,¤G¤âÀ\¶¼³]³Æ,À\¶¼¾¹¨ã,§N­á³]³Æ,À\¨ã¡C¦UºØ¤G¤â¤Î¤¤¥jÀ\¶¼³]³Æ¶R½æ,¦UÃþ¥Í°]¾¹¨ã¥X²M¦¬ÁÊ,¶}©±¶R¤¤¥jÀ\¶¼³]³Æ³Ì¦Eºâ,§A·Q­nªºÀ\¶¼³]³Æ³q³q³£¦³¡C³»ÅýÀ\¶¼³]³Æ¡B¦­À\©±¡B¤p¦YÅu¡B©±­±¡BÀ\¨®¡B¼p©Ð³]³Æ¡B¤£ù׿û¼p¨ã¡B§NÂÃÂd³]³Æ¡B¤£ºÞ¬O­n¶R½æ©Î¬O¦¬ÁʧK¶O¥­¥xÅý§A¥Î¡C
¤G¤âÀ\¶¼³]³Æ
À\¶¼³]³Æ¶R½æ
¨T¨®­É´Ú
§Úªº±b¸¹  Áʪ«¨®¤º®e  µ²±b  
  ­º­¶ » °Ó«~¥Ø¿ý » ¤G¤â³Ã­Ñ §Úªº±b¸¹  |  Áʪ«¨®¤º®e  |  µ²±b   
°Ó«~¤ÀÃþ
À\¶¼³]³Æ (4)
³»Åý (5)
¤G¤â³Ã­Ñ (2)
¤¤¥j®a¨ã (1)
»s³y¼t°Ó
·s¤W¬[À\¶¼³]³Æ §ó¦h
³»ÅýÀ\¶¼³]³Æ
³»ÅýÀ\¶¼³]³Æ
NT$3
§Ö³t´M§äÀ\¶¼³]³Æ
 
¿é¤JÃöÁä¦r´M§äÀ\¶¼³]³Æ
¶i¶¥´M§ä°Ó«~
ªA°È¥x
°h´«³f¨Æ¶µ
Áô¨pÅv«OÅ@Án©ú
·|­ûÅv¯q¤Î¶·ª¾
Ápµ¸§Ú­Ì
°Ó«~¦Cªí °Ó«~¦Cªí
 «~¦W+   »ù®æ   °¨¤W¶R 
 ¤G¤â³Ã­Ñ   NT$2  °¨¤W¶R 
 ¤G¤â³Ã­Ñ¶R½æ   NT$3  °¨¤W¶R 
Åã¥Ü 1 ¨ì 2 (¦@2­Ó°Ó«~) Á`­¶¼Æ:  1 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'wesogo1_11.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, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '23' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Áʪ«¨® §ó¦h
ªÅªº...