Get customers who have not been connected since registration using SQL Query (PS 1.7.x) [SOLVED]

[ZiedDams]

Hi ,
i want to get the list of customers who have not been connected since registration using SQL Query ,

or the list of customers who have not been connected since $X (date).

Edited November 20, 2023 by ZiedDams (see edit history)

[dnk.hack]

SELECT *
FROM ps_customer
WHERE date_add > '2022-02-02';

[musicmaster]

The ps_connection table has a field id_guest and the ps_guest table has a field id_customer.

That would be the logical road. But I never tested it...

[ZiedDams]

23 hours ago, musicmaster said:

The ps_connection table has a field id_guest and the ps_guest table has a field id_customer.

That would be the logical road. But I never tested it...

Ty Sir that exactly what im missing