Need a Query for Abandoned cart

[Roshan Bhavsar]

Hello Team,
I'm newbie in Prestashop and using a prestashop 1.7.
I need a query which will gives only Abandoned Cart details.

I'm trying to get the query for Abandoned cart, So printed the query available in the AdminCartsController.php.

I've tried a bunch of different options but nothing seems to work.
Every help will be appreciated.

Thanks
 

[ps8modules]

Hi.

Abandoned cart SQL sample:

SELECT t1.*, t3.*
FROM ps_cart t1
LEFT JOIN ps_orders t2 ON (t2.id_cart = t1.id_cart)
LEFT JOIN ps_cart_product t3 ON (t3.id_cart = t1.id_cart)
WHERE t2.id_cart IS NULL