notes:sql
This is an old revision of the document!
SELECT
DISTINCT(u1.ID),
u1.user_email,
u1.display_name,
m1.meta_value AS fristname,
m2.meta_value AS lastname,
m3.meta_value AS description
from net_users u1
JOIN net_usermeta m1 ON (m1.user_id=u1.ID AND m1.meta_key='first_name')
JOIN net_usermeta m2 ON (m2.user_id=u1.ID AND m2.meta_key='last_name')
JOIN net_usermeta m3 ON (m3.user_id=u1.ID AND m3.meta_key='description')
notes/sql.1427211073.txt.gz · Last modified: 2015/03/25 00:31 by hkimscil