Skip to content

Tag: woocommerce

MySQL – summing up products from several orders

I want to sum up the number of items purchased from several orders. I have this query, however it shows me each order on a separate row. I want have it all added up in one row. This is woocommerce database. Example output: and this is how it should be: Answer You want the aggregation string over all those items,

Support needed for a query

I need help to finish a SQL Query for a Woocommerce product list. I need this for a wpdatatable sql input. I searched for a example code and have adapted a found code: SELECT p.ID, p.post_title, …