dataset - Quarry

SQL

SELECT user.user_name AS "name", "0" AS "spam" 
 FROM user
 WHERE user.user_id NOT IN (SELECT ipb_user FROM ipblocks)
 ORDER BY RAND()
 limit 30000;


/*
SELECT user.user_name AS "name", "1" AS "spam" 
  FROM ipblocks
  INNER JOIN user ON ipblocks.ipb_user = user.user_id
  INNER JOIN comment ON ipblocks.ipb_reason_id = comment.comment_id
  WHERE comment.comment_text LIKE "%مستخدم%" 
  and not (
    comment.comment_text  LIKE "%جوارب%"
    or comment.comment_text  LIKE "%دمية%"
    or comment.comment_text  LIKE "%دمى%"
    or comment.comment_text  LIKE "%جورب%"
    or comment.comment_text  LIKE "%لحم%"
    or comment.comment_text  LIKE "%حساب آخر%"
    or comment.comment_text  LIKE "%تدقيق مستخدم%" 
  ) 
*/
SQL

Checking query status...
