| SQLSTATE |
HY000 |
| DATASOURCE |
mysqlcf_circuitmapcom |
| VENDORERRORCODE |
3 |
| SQL |
SELECT
rc.contact_id as rec_id,
rc.contact_id, rc.first,
rc.first as first_name,
rc.last,
rc.last as last_name,
rc.phone_cell as phone,
rc.email, rs.REEL_STATUS_name,
replace(replace(replace(replace(replace(rc.phone_cell,' ',''),'(',''),')',''),'-',''),'.','') as phone_number,
rc.complexion_id,
rc.ethnic_value1,
rc.eye_id,
rc.hair_length_id,
rc.hair_id,
rc.national_id,
rc.ethnic_value1,
rc.ethnic_value1 as ethnic_value,
rc.first as first_name,
rc.status_actorsaccess,
rc.first,
rc.full_name,
rc.imdb_image,
rc.imdb_title,
rc.last as last_name,
rc.last,
rc.range_id,
rc.sfa_dir,
rc.sfa_gen_yn,
rc.sx,
rc.weight_id,
ag.range_name,
cx.complexion_name,
e1.ethnic_name,
ey.eye_name,
hl.hair_length_name,
ht.hair_name,
na.national_name,
sex.term_id as sx_id,
sex.sx_name,
replace(replace(replace(replace(replace(rc.phone_cell,' ',''),'(',''),')',''),'-',''),'.',''),
UPPER(concat_ws(' ',
rc.first,
rc.last,
rc.sx,
rc.weight_id,
ag.range_name,
cx.complexion_name,
e1.ethnic_name,
ey.eye_name,
hl.hair_length_name,
ht.hair_name,
na.national_name,
rc.email
)) as s_body,
web.*,
h.HEIGHT_NAME AS HEIGHT,
w.WEIGHT_NAME AS WEIGHT,
na.NATIONAL_NAME as NATIONALITY,
E2.ETHNIC_NAME AS ETHNIC_NAME2,
E3.ETHNIC_NAME AS ETHNIC_NAME3,
cx.COMPLEXION_NAME as COMPLEXION,
cx.term_id as t_complexion_id,
ht.term_id as t_hair_id,
ht.HAIR_NAME as HAIR_TYPE,
hl.HAIR_LENGTH_NAME as HAIR_LENGTH,
hl.term_id as t_hair_length_id,
ey.EYE_NAME as EYE_COLOR,
ey.term_id as t_eye_id,
rc.SX as GENDER,
E1.ETHNIC_NAME AS ETHNIC_NAME1,
rc.email,
rc.testimonial,
rc.contact_update,
rc.contact_creation,
rc.url_lacasting,
rs.reel_status_name,
rc.website1,
rc.website2,
rc.imdb_id,
rc.url_actorsaccess,
rc.web_contact_yn,
rc.headshot_yn,
rc.bio,
rc.client_run,
web.web_local_dir
FROM REEL_CONTACTS rc
INNER JOIN REEL_STATUS rs ON rc.reel_status_id = rs.reel_status_id
INNER JOIN REEL_HEIGHTS h ON h.HEIGHT_ID = rc.HEIGHT_ID
INNER JOIN REEL_WEIGHTS w ON w.WEIGHT_ID = rc.WEIGHT_ID
INNER JOIN REEL_EYES ey ON ey.EYE_ID = rc.EYE_ID
INNER JOIN REEL_HAIR_LENGTHS hl ON hl.HAIR_LENGTH_ID = rc.HAIR_LENGTH_ID
INNER JOIN REEL_HAIR ht on ht.HAIR_ID = rc.HAIR_ID
INNER JOIN REEL_NATIONALITIES na on na.NATIONAL_ID = rc.NATIONAL_ID
INNER JOIN REEL_COMPLEXIONS cx on cx.COMPLEXION_ID = rc.COMPLEXION_ID
INNER JOIN REEL_AGE_RANGES AG ON AG.RANGE_ID = RC.RANGE_ID
LEFT JOIN REEL_ETHNICITIES E1 ON E1.ETHNIC_VALUE = RC.ETHNIC_VALUE1
LEFT JOIN REEL_ETHNICITIES E2 ON E2.ETHNIC_VALUE = RC.ETHNIC_VALUE2
LEFT JOIN REEL_ETHNICITIES E3 ON E3.ETHNIC_VALUE = RC.ETHNIC_VALUE3
inner join reel_sex sex on sex.sx = rc.sx
LEFT JOIN sfa_websites web on web.contact_id = rc.contact_id
WHERE rc.contact_active <> 0
and rc.nocall = 0
and rc.headshot_yn = 'Y'
and rc.contact_id in (select contact_id from reel_scenes where scene_status in ('Public','Pending'))
Group by rc.contact_id
order by rc.last
|
|