Random three-table list from favourites

[Ouduk3]

Hello.

I have this SQL playlist to pick three random VPX tables:

 

select * from games WHERE EMUID=1 order by random() limit 3

 

I would like to limit it to pick only from my VPX favourites (not Global favourites) instead of the whole VPX collection. Can anyone please help?

 

Thanks

[Rappelbox]

SELECT g.*
FROM games g
JOIN playlistdetails p ON g.gameid = p.gameid
WHERE emuid=1 AND p.isFav = 1
ORDER BY RANDOM()
LIMIT 3;