Query to return all orders and their statuses

[phirestarter]

Hi there,

 

I'm trying to run a query on the database, that will return all orders already made, and all the statuses they went trough. I'm trying to calculate an average time that takes for an order to change from one status to another.

 

Thanks in advance for any help,

phire

[Guest]

Here's one that pulls the info. You'll want the date the change was made, right? calculating the difference between the first and last mention of the order is up to you ;)

 

 

SELECT orders_id,orders_status_id,date_added FROM `orders_status_history` order by orders_id

 

Depending on your version of mysql, this should at least get you started.

What I mean is that the syntax might be slightly different for you but this works on mine.