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'
0 results