Someone
public text v1 · immutableSELECT p.posts_id, p.posts_title, COUNT( ph.photos_id )
FROM posts AS p, photos AS ph
WHERE (
ph.photos_post_id = p.posts_id
)
GROUP BY ph.photos_post_id
ORDER BY p.posts_id DESC
LIMIT 0 , 5SELECT p.posts_id, p.posts_title, COUNT( ph.photos_id )
FROM posts AS p, photos AS ph
WHERE (
ph.photos_post_id = p.posts_id
)
GROUP BY ph.photos_post_id
ORDER BY p.posts_id DESC
LIMIT 0 , 5