dataset - Quarry

SQL

/*
SELECT username, status
FROM (
  SELECT user.user_name AS "username", "1" AS "status" 
  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 comment.comment_text NOT LIKE "%جوا%"
  UNION 
  SELECT user.user_name AS "username", "0" AS "status" 
  FROM user
  WHERE user.user_id NOT IN (SELECT ipb_user FROM ipblocks)
) AS `list`
ORDER BY RAND()
LIMIT 20000;
*/

  SELECT user.user_name AS "username", "1" AS "status" 
  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 comment.comment_text NOT LIKE "%جوا%"
  limit 10000;
#  UNION 
 SELECT user.user_name AS "username", "0" AS "status" 
 FROM user
 WHERE user.user_id NOT IN (SELECT ipb_user FROM ipblocks)
 limit 1000;
SQL

Checking query status...
