编程错误在 / 按"id"排序是模棱两可的 第 1 行：...logapp_article.userid=blogapp_useradd.uname ORDER BY id DESC

Question

异常值：
ORDER BY"id"不明确第1行：。。。logapp_article.userid=blogapp_useradd.uname ORDER BY id DESC

视图中的错误位置.py

def索引(请求):

ad1 = ads.objects.raw("select * from blogapp_ads order by id desc limit 1")
ad2 = ads.objects.raw("select * from blogapp_ads order by id desc limit 1 offset 1")
ad34 = ads.objects.raw("select * from blogapp_ads order by id desc limit 2 offset 2")
ob1 = news.objects.raw("select * from blogapp_news order by id desc limit 5")
obb = article.objects.raw(
"select * from blogapp_article inner join blogapp_useradd on blogapp_article.userid=blogapp_useradd.uname ORDER BY id DESC LIMIT 14")
obj = article.objects.raw(
"select * from blogapp_article inner join blogapp_useradd on blogapp_article.userid=blogapp_useradd.uname ORDER BY id DESC LIMIT 5")
ob = article.objects.raw(
"select * from blogapp_article inner join blogapp_useradd on blogapp_article.userid=blogapp_useradd.uname ORDER BY id DESC")
return render(request, 'Guest/Index.html', context={'data9':obb, 'data3': ob1,'data1': ob, 'data2':obj, 'time': now,'data4':ad1,'data5':ad2,'data6':ad34})

Answer 1

在没有表的可见性的情况下，我假设"id"作为一个属性存在于您要连接的两个表中。尝试将您的加入声明更改为：

ob = article.objects.raw(
"select * from blogapp_article as a inner join blogapp_useradd as b on a.userid=b.uname ORDER BY a.id DESC")