SELECT u.id FROM users u
WHERE NOT EXISTS (SELECT 1 FROM mlinks l 
WHERE l.user_id = u.id AND
l.created >  (NOW() - interval 200 day)
) 

SELECT u.id FROM users u
WHERE NOT EXISTS (SELECT 1 FROM xx_income_log inc 
WHERE inc.icusr = u.id AND
inc.ictime >  (NOW() - interval 200 day)

) 


SELECT u.id FROM users u
WHERE NOT EXISTS (SELECT 1 FROM xx_userips ip 
WHERE ip.user_id = u.id AND
ip.time >  (NOW() - interval 200 day)

) 

[SQL]SELECT u.id
FROM users u
LEFT JOIN mlinks l 
ON l.user_id = u.id 
AND l.created > (NOW() - interval 200 day)) 
LEFT JOIN xx_income_log inc ON inc.icusr = u.id AND inc.ictime > (NOW() - interval 200 day)) 
LEFT JOIN xx_userips ip ON ip.user_id = u.id AND ip.time > (NOW() - interval 200 day)) 
WHERE
l.user_id IS NULL
inc.icusr IS NULL
ip.user_id IS NULL

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
LEFT JOIN xx_income_log inc ON inc.icusr = u.id AND inc.ictime > (NOW() - in' at line 5

SELECT u.id
FROM users u
LEFT JOIN mlinks l ON l.user_id = u.id AND l.created > (NOW() - interval 200 day) 
LEFT JOIN xx_income_log inc ON inc.icusr = u.id AND inc.ictime > (NOW() - interval 200 day) 
LEFT JOIN xx_userips ip ON ip.user_id = u.id AND ip.time > (NOW() - interval 200 day) 
WHERE
 l.user_id IS NULL AND
 inc.icusr IS NULL AND
 ip.user_id IS NULL