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 100;
*/



SELECT user.user_name AS "name",comment_text, "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 "%لحم%"
  ) 
  limit 100;
SQL

Checking query status...
