Need mysql query for inactive customers

[Ritesh_5]

Hi,

i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database.

id_customer, firstname, lastname, email, last order date.

or is there any way i can export in active customers list (those customers who didn't placed any order for last 3 months.)

thanks,

Ritesh

[AndrisP]

select * from some_table where `last order date` < date_sub(now(), interval 3 month)

[Ritesh_5]

Hi,

   thanks for the reply, but i have no technical knowledge about programming & database, can you create sql query for me compatible to prestashop 1.4.8.2 table structure.

   thank you in advance.

   regards,
   Ritesh