SELECT t.loginid FROM talent t INNER JOIN customlogins l ON t.loginid = l.loginid LEFT JOIN talent_category c ON t.loginid = c.loginid LEFT JOIN talent_ethnicity e ON t.loginid = e.loginid LEFT JOIN talent_affiliation g ON t.loginid = g.loginid LEFT JOIN talent_workhistory w ON t.loginid = w.loginid LEFT JOIN talent_skills s ON t.loginid = s.loginid WHERE l.siteid = 45 AND t.loginid IN( SELECT DISTINCT loginid FROM talent_voiceover tv WHERE inHome = 1 WHERE inHome = 0 WHERE inHome IN (0,1) AND clipType = '#form.voicecategory#' ) AND t.published = 1 AND (CONCAT(t.firstname,' ',t.lastname) like '%#form.byName#%') AND voiceCategories LIKE '%#category#%' AND voiceTraits LIKE '%#form.traits#%' OR voiceTraits LIKE '%#trait#%' AND t.gender = '#form.gender#' AND (IFNULL(t.age_min,0) BETWEEN #val(agemin)# AND #val(agemax)# OR IFNULL(t.age_max,100) BETWEEN #val(agemin)# AND #val(agemax)# OR (IFNULL(t.age_min,year(now())-year(t.DOB)) <= #val(agemin)# AND IFNULL(t.age_max,year(now())-year(t.DOB)) >= #val(agemax)#) ) AND s.skill = '#form.lang#' AND (t.DOB <= '#dateFormat(dateAdd("yyyy",-18,now()),"YYYY-MM-DD")# 00:00:00' OR t.DOB IS NULL OR t.DOB = '') GROUP BY t.loginid ORDER BY #variables.orderBy# << style="font-weight: bold; text-decoration: none;">#pageCount# >> SELECT * FROM talent_categoryoptions WHERE siteid = 45 ORDER BY category SELECT * FROM talent_ethnicityoptions WHERE siteid = 45 ORDER BY ethnicity SELECT * FROM talent_affiliationoptions WHERE siteid = 45 ORDER BY affiliation SELECT * FROM talent_creditoptions WHERE siteid = 45 ORDER BY credittype
#url.msg#

Search Voice Over Database as an Administrator you see published and unpublished profiles

#request.getConfig.searchPageText#
Note: To search for persons under the age of 18 you need administrator approval. To contact the administrator you may email a request to: #listFirst(request.getConfig.publishRequestEmail)#
Available Talent
#results.howmany# Results Found
#pagination#
 Per Page
 (sorted by #form.sort# #lcase(startingDirection)#, viewing page #currentPage#)
#talentObj.displayProfile(getData.loginid,"search",form.voicecategory)#
#talentObj.displayProfileThumbsTest(getData.loginid,"search",form.voicecategory)#
Your search may be too refined.
No results were found.

Your search criteria was:
  • By Name: #form.byName#
  • Category: #form.category#
  • Gender: #form.gender#
  • Age Range: #replace(form.age,";"," - ")# years
  • Height: #replace(form.height,";"," - ")# inches
  • Eye Color: #form.eye#
  • Hair Color: #form.hair#
  • Ethnic Look: #form.ethnic#
  • Guilds/Unions: #form.guild#
  • Prompter: #form.prompter#
  • Sexual Orientation: #form.so#
Note: To search for persons under the age of 18 you need administrator approval. To contact the administrator you may email a request to: #listFirst(request.getConfig.publishRequestEmail)#
Select your search criteria above to begin
#results.howmany# Results Found  #pagination#  
 (sorted by #form.sort# #lcase(startingDirection)#, viewing page #currentPage#)