What about something like this? ![]()
-- [params]
-- int :cat_id = 4
-- int :limit = 10
SELECT id, username
FROM users u
WHERE u.id NOT IN
(SELECT user_id FROM categories WHERE id=:cat_id)
LIMIT :limit
What about something like this? ![]()
-- [params]
-- int :cat_id = 4
-- int :limit = 10
SELECT id, username
FROM users u
WHERE u.id NOT IN
(SELECT user_id FROM categories WHERE id=:cat_id)
LIMIT :limit