Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1. SELECT
  2. user_id,
  3. user_name,
  4. user_editcount,
  5. datediff(now(),user_registration) AS age
  6. FROM user
  7. LEFT JOIN ipblocks ON user_id=ipb_user
  8. WHERE
  9. user_email_authenticated IS NOT NULL
  10. AND ipb_reason IS NULL
  11. AND (user_registration > 20110223000000 )
  12. INTO OUTFILE 'userList1.csv'
  13. FIELDS TERMINATED BY ','
  14. ENCLOSED BY '"'
  15. LINES TERMINATED BY '\n';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement