notes:sql
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')
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') where m3.meta_value LIKE '%뉴미디어%'
notes/sql.txt · Last modified: 2015/03/25 14:00 by hkimscil