How to find the woocommerce orders in db

1. find db name in by filezilla in website directory wp-config.php filק
   1.  
2. enter cpannel/phpmyadin
3. point on the db
4. enter SQL tab
5. enter to following code and press "go"

   select * from wp_posts
   where post_type = 'shop_order'
   order by post_modified desc;​

    
6.  now you see the list of orders by date

sources: 

- wordpress.stackexchange - SQL Query for getting all posts in their latest revised state 

- stackoverflow- where is a woocommerce order placed in wordpress database