SQL
x
/*
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.