How can i Extract order details for every FIRST customer order?

[REN9]

Hi, I'm tying to extract from my Prestashop 1.6 the following info for every first customer  order:

ID customer
sex
age
order date
total amount spent
product category
Newsletter subscription yes or not
using VAT yes or not
Using coupon yes or not
payment method
device or OS (it is the device the customer was connected from)

Is here anyone who can help me? 

Thank you very much!
 

[musicmaster]

There is no field for this. If you look at the Prestashop code you see something like:

IF((SELECT so.id_order FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = c.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as newcust

in the fields list that is retrieved. Of course that may be different for different for different PS versions.