Андрей

SELECT * FROM `products` where not exists (select product_id from `archive` where user_id = :user_id);

SELECT * FROM `products`
left join `archive` a on user_id = :user_id and p.id=a.product_id
where a.id is null

select DATE_FORMAT(FROM_UNIXTIME(`datetime`), '%Y-%m-%d') as _dt, count(*), status
from `data`
group by _dt, status