mysql对不同项计数,mysql只对连接查询中的不同值计数

WOW! That's a weird title, but I'm happy you're looking, cause I couldn't find another way to say it.

I have a table of people and a table of links to photos and videos.

I join the people to the media, and of course a person can have more than one piece of media.

I am attempting to grab the first 30 people and all of their media in one query, but when I say LIMIT 0,30. Of course I'll only get the first 30 media files, which could be 10 people.

Before I make the query, I don't know how many media files each person is going to have. Is there a way I can say LIMIT DISTINCT(uid 0,30)????

or something like that?

解决方案

Can you use subqueries in your version of MySQL?

select *

from media m

inner join

( select uid

from users_tbl

limit 0,30) map

on map.uid = m.uid

inner join users_tbl u

on u.uid = m.uid