slow.sql

SELECT DISTINCT COUNT(DISTINCT `products`.`id`) 
FROM `products` 
WHERE (moderation_status in ('QUEUED','QUEUED_AFTER_APPROVAL','QUEUED_AFTER_REJECT','PROMOTED') 
OR treasureProduct.products.id in (NULL))

/*=====================*/

SELECT  COUNT(DISTINCT u.id) AS Listers,COUNT(p.id)AS Listings
   FROM   accounts.users u
   LEFT JOIN
   treasureProduct.products p
   ON
   u.id=p.user_id
   WHERE
   u.status='verified'
   AND
   p.status='active'
   AND
   p.created_at < TIMESTAMP(SYSDATE());
   
/*=====================*/

SELECT p.source as source, COUNT(p.id)AS Listings     
FROM accounts.users u     
LEFT JOIN     treasureProduct.products p     
ON u.id=p.user_id     
WHERE u.status='verified'     
AND p.status='active'     
AND p.created_at BETWEEN TIMESTAMP(CURDATE()) 
AND TIMESTAMP(SYSDATE())     
GROUP BY 1\G