COMMunication
RESearch.NET

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

<code>
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')
</code>

<code>
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 '%뉴미디어%'
</code>