Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- user_id,
- user_name,
- user_editcount,
- datediff(now(),user_registration) AS age
- FROM user
- LEFT JOIN ipblocks ON user_id=ipb_user
- WHERE
- user_email_authenticated IS NOT NULL
- AND ipb_reason IS NULL
- AND (user_registration > 20110223000000 )
- INTO OUTFILE 'userList1.csv'
- FIELDS TERMINATED BY ','
- ENCLOSED BY '"'
- LINES TERMINATED BY '\n';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement