cockpitinferno Posted July 10, 2015 Share Posted July 10, 2015 Hi, i would like to extract orders and their connections sources. i found something about that here: https://www.prestashop.com/forums/topic/86731-solved-where-is-the-order-source-table-in-the-db/ but it's a bit old and doesnt work on my ddb anyone coul help me ton find a way to do that please. i'm in 1.6.0.11 thanks a lot Link to comment Share on other sites More sharing options...
nuriatorr73 Posted July 10, 2015 Share Posted July 10, 2015 (edited) Sorry, I have no idea Edited September 27, 2016 by nuriatorr73 (see edit history) Link to comment Share on other sites More sharing options...
cockpitinferno Posted July 15, 2015 Author Share Posted July 15, 2015 nobody else? i want to find an sql request Link to comment Share on other sites More sharing options...
cockpitinferno Posted July 16, 2015 Author Share Posted July 16, 2015 bon j'ai trouvé une 1ere piste en extrayant les connections des clients avec cette requête: SELECT `http_referer` FROM `ps_connections` WHERE id_guest IN (SELECT id_guest FROM ps_guest WHERE id_customer != 0) remplacer ps par votre préfixe de bdd mais j'aimerais pouvoir vraiment les avoir avec les commandes. un peu d'aide serait bienvenue. merci d'avance Link to comment Share on other sites More sharing options...
Recommended Posts