hey everyone trying to randomize a member and also randomize a image associated with this member. (not always same image) or album also if possible
SELECT DISTINCT(u.id) FROM members m
INNER JOIN album a ON a.mid = m.id
LEFT JOIN albums_images ai ON ai.album_id = a.id
ORDER BY RAND()
is there a way instead of a subquery? there could be multiple albums / multiple images with in the albums.
Thanks for your time
