|
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' | |