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 (
  	comment.comment_text not LIKE "%دمية%"
    or 
    comment.comment_text not LIKE "%جوارب%"
    or 
    comment.comment_text not LIKE "%لحم%"
  ) 
  limit 100;
SQL

Checking query status...
