SELECT * FROM video AS v, favourite as f WHERE f.UID=324 AND f.VID=v.VID ORDER BY v.addtime DESC LIMIT 0, 4