SELECT v.*, u.username, u.photo, u.gender, u.fname
               FROM video AS v, signup AS u WHERE v.VID = 1103 AND v.UID = u.UID LIMIT 1