|
Community
|
select
picture.picture_id,
member.member_id,
member.member_login,
picture.120x120_url,
picture.album_id
from
picture,
member,
album
where
picture.recs > 0
and
picture.private = 'N'
and
picture.member_id = member.member_id
and
picture.album_id = album.album_id
and
picture.upload_date > date_sub(curdate(), interval 300 day)
order by picture.recs desc, picture.counter desc limit 0,1
| | |