Differences

This shows you the differences between two versions of the page.

--- notes:sql [2015/03/25 00:31] – created hkimscil
+++ notes:sql [2015/03/25 14:00] (current) – hkimscil
@@ Line 1: / Line 1: @@
+<code>
 SELECT
 DISTINCT(u1.ID),
@@ Line 10: / Line 11: @@
 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>