Ordini

SELECT umc.meta_value Cognome, umn.meta_value Nome, p.post_date Data, p.post_status Stato, o.order_item_name Ordine FROM `wpn7_posts` p, wpn7_woocommerce_order_items o, wpn7_postmeta pm, wpn7_users u, wpn7_usermeta umc, wpn7_usermeta umn WHERE p.post_type = 'shop_order' AND p.id = o.order_id AND p.id = pm.post_id AND pm.meta_key = '_customer_user' AND pm.meta_value = u.id AND u.id = umc.user_id AND u.id = umn.user_id AND umn.meta_key = 'first_name' AND umc.meta_key = 'last_name'
NomeCognomeDataOrdine
Ryan oliverLas eras2018-06-10 19:42:32Canottiera gara Uomo - S
Ryan oliverLas eras2018-06-10 19:42:32Pantaloncini gara uomo - M
PAOLOCOSTANTINI2018-06-11 10:26:51Polo Joma uomo con Logo - M
SIMONAMAIO2018-06-13 15:12:46Pantaloncini gara donna - M
LorenzoMinisci2018-06-13 23:08:45Canottiera gara donna - S
LorenzoMinisci2018-06-13 23:08:45Pantaloncini gara uomo - M
LorenzoMinisci2018-06-13 23:08:45Polo Joma uomo con Logo - M
LorenzoMinisci2018-06-13 23:08:45Polo Joma donna con Logo - S
LorenzoMinisci2018-06-13 23:08:45Felpa Joma con logo - Bianco, M
ANDREABUCRA2018-06-14 12:45:18Polo Joma uomo con Logo - S
ANDREABUCRA2018-06-14 12:45:18Cappello Joma con logo
ANDREABUCRA2018-06-14 12:45:18Maglia gara maniche lunghe uomo - S
giuseppePetrone2018-06-16 20:38:04Maglia gara maniche corte uomo - M
giuseppePetrone2018-06-16 20:38:04Maglia gara maniche lunghe uomo - M
giuseppePetrone2018-06-16 20:38:04Pantaloncini ciclista gara uomo
FedericoPodrini2018-06-17 19:02:58Canottiera gara Uomo - S
FedericoPodrini2018-06-17 19:02:58Giacca tuta Joma donna con Logo - S
FedericoPodrini2018-06-17 19:02:58Pantaloni tuta donna Joma - S
FedericoPodrini2018-06-17 19:02:58Canottiera gara Uomo - M
AdolfoMarino2018-06-20 15:47:23Polo Joma uomo con Logo - M
MauroRaponi2018-06-21 21:21:41Polo Joma uomo con Logo - M
LorenzoMinisci2018-06-24 14:37:02Canottiera gara Uomo - M
IvanIannone2018-07-04 22:12:21Canottiera gara Uomo - S
IvanIannone2018-07-04 22:12:21Polo Joma uomo con Logo - M