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#

Name:

Gender:

Language:

Available Demo Types:

Home Studio:

Categories:

Voice Traits:

Age Range:

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#)