work in progeress<br>select id from customer where invoice_type = 'Fix Rate' and super_id='554' and id='4968'<pre><br>select SUM(pallets) as `storagetotal` , MONTH(entrydate) AS M , YEAR(entrydate) as Y,  storage_id ,entrydate as entry_date FROM storagesinvoices WHERE seller_id='4968' and  ( MONTH(entrydate)='8' ) and YEAR(entrydate)='2025' GROUP by M,Y,storage_id