Get your best sales day total for an Easy Digital Downloads WordPress store

edd_best_sales_day.sql

SELECT Date(post_date) as Date, 
       Round(Sum(pm.meta_value - pm1.meta_value)) as Total
FROM   wp_posts p 
       INNER JOIN wp_postmeta pm 
               ON p.id = pm.post_id 
                  AND pm.meta_key = '_edd_payment_total' 
       INNER JOIN wp_postmeta pm1 
               ON p.id = pm1.post_id 
                  AND pm1.meta_key = '_edd_payment_tax' 
WHERE  post_type = 'edd_payment' 
       AND post_status = 'publish' 
GROUP  BY Date(post_date) 
ORDER  BY 2 DESC 
LIMIT  1