Required Mysql query to extract first order date for each customer

[riteshuae]

Hi,

 

      i have installed prestashop 1.4.8.2, i need mysql query to extract below column information from database.

 

id_customer, firstname, lastname, first order date

 

thanks,

 

Ritesh

[vekia]

select c.id_customer AS ID, c.firstname as Firstname, c.lastname as Lastname, o.date_add as 'order date'  from ps_orders o INNER JOIN ps_customer c ON o.id_customer = c.id_customer  group by id

should work :-)