|
Unable to get the person list select distinct person.person_id, person.person_uuid, person.`first_name`, person.`last_name`, person.`middle_name`, person.`full_name`, person.`date_of_birth`, person.`ssn`, person.`sex`, person.`aka`, person.`type`, person.`sort_order`, person.`bio`, person.`short_bio`, person.`credits`, person.talents, person.`rate_show`, person.`rate_week`, person.`door_deal`, person.`ticket_price`, person.`stage_intro`, person.rating, person.`type`, person.`anniversary`, person.`sort_order`, person.`verified`, category.category_uuid, category.name category from person inner join person_category lcs on person.person_uuid = lcs.person_uuid inner join category on lcs.category_uuid = category.category_uuid inner join person_role prole on person.person_uuid = prole.person_uuid inner join role on (prole.role_uuid = role.role_uuid and role.`role_uuid`!='0148c888e6b1e48') where 1 and person.person_uuid NOT IN (SELECT DISTINCT person_uuid FROM person_role WHERE role_uuid = '014a85b5eb27385') and (person.last_name like '�%') and (category.name = 'Performer') and person.deleted != 'Y' ORDER BY person.last_name, person.first_name Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' |
|---|
