create table tmp as select * from ( select user_id ,max(case when meta_key like '%PCO#_%' ESCAPE '#' or meta_key like '%#_PCO%' ESCAPE '#' then meta_value end) as PCO ,max(case when meta_key like '%first#_name%' ESCAPE '#' then meta_value end) as first_name ,max(case when meta_key like '%last#_name%' ESCAPE '#' then meta_value end) as last_name ,max(case when meta_key like '%user#_phone%' ESCAPE '#' then meta_value end) as user_phone ,lX9c1_users.user_email ,max(case when meta_key like '%Ladder%' then meta_value end) as Ladder from lX9c1_usermeta INNER JOIN lX9c1_users ON lX9c1_usermeta.user_id = lX9c1_users.ID ) t order by user_id
