我要求一个查询,选择最新的100篇文章,然后返回该结果的30篇文章的最高评级排序。我的例子出了点问题。FROM SELECT articleid,articletitle,articleicon,timesviewed WHERE articlestatus = 1 AND (articletype = 1 || articletype = 6) )
ORDER BY (totalvotepoints/totalvotes)
我有3个表(provider、provider_has_product、product):
(原文:)SELECT DISTINCT `provider_has_product2行的Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQLsyntax to use near 'SELECT * FROMproductWHERE NOT EXIST