Edit History

16 hours ago, D. Tengler said:

This way you can find it by customer number, by order number or by customer email.

Otherwise, there is also the option to edit PaymentModule.php or Order.php and save the IP address in the ps_orders table (add column).
But that's something else.

SELECT a.id_order, a.id_customer, b.id_guest, c.ip_address, c.date_add, d.email 
FROM ps_orders a
LEFT JOIN ps_guest b ON (a.id_customer = b.id_customer)
LEFT JOIN ps_connections c ON (b.id_guest = c.id_guest)
LEFT JOIN ps_customer d ON (a.id_customer = d.id_customer)
WHERE d.email = '[email protected]' OR a.id_customer = 3 OR a.id_order = 3
ORDER BY c.ip_address

appreciate that - thanks - worked perfectly

note for anyone else that reads this: I had to keep the ' ' around the email address part as my sql syntax was different(?)