SELECT DISTINCT id, COUNT(id)
FROM payment
WHERE
created_at BETWEEN DATE_SUB(CURDATE(), INTERVAL 10 DAY)
AND
CURDATE() AND id NOT IN
(SELECT DISTINCT id FROM payment WHERE created_at < DATE_SUB(CURDATE(), INTERVAL 10 DAY) )
GROUP BY ID
- ?a ("array") - набор значений для IN (строка вида 'a','b','c')