Talent

SELECT * FROM publisherTalents INNER JOIN talentClips ON publisherTalents.avatarClipId = talentClips.talentClipId WHERE publisherTalentDisplayname != 'x' AND talentClipTalentId IN (SELECT talentClipTalentId FROM talentClips INNER JOIN publisherTalents ON talentClips.talentClipTalentId = publisherTalents.publisherTalentId WHERE talentClipTypeId = '1' AND publisherTalentSuspended != 1 AND active = 1 AND archive != 1) ORDER BY publisherTalentDisplayOrder ASC