我正在尝试显示表中的项目,并根据点赞数量对它们进行排序。likes在另一张表中,这让我感到困惑。
images
id url
1 blablabla.jpg
2 hejhej.png
3 picture.jpg第二个是likes,看起来像这样:
likes
id image
1 2
2 2
3 1
4 3
5 2现在我想要的图像是排序的最喜欢。我应该在查询中写什么使它看起来像这样呢?:
hejhej.png - 3 likes
blablabla.jpg - 1 like
picture.jpg - 1 like如果你能帮我解决我的问题,我将不胜感激。
发布于 2013-01-21 03:42:39
SELECT url, COUNT(likes.id) as likes
FROM images, likes
WHERE likes.image = images.id
GROUP BY images.id
ORDER BY likes DESC要仅获取过去24小时的记录,请将以下内容添加到查询中:
WHERE likes.date > DATE_SUB(CURDATE(), INTERVAL 1 DAY)发布于 2013-01-21 03:44:01
SELECT
url,
COUNT(likes.id) Likes
FROM
images,
likes
WHERE
likes.image = images.id
GROUP BY
images.url
ORDER BY
Likes DESC您可以选择FROM这两个表,按点赞的数量按descending顺序对图片url和ordered进行排序。
https://stackoverflow.com/questions/14428477
复制相似问题