Errore sul database di WordPress: [Unknown column 'wp_posts.ID' in 'on clause']
SELECT DISTINCT wp_postmeta.meta_value FROM wp_posts, wp_postmeta, wp_woocommerce_order_items, wp_woocommerce_order_itemmeta LEFT JOIN wp_icl_translations icl_t ON icl_t.element_id = wp_posts.ID WHERE wp_posts.post_type = 'shop_order' AND wp_posts.post_status IN ( 'wc-completed', 'wc-processing', 'wc-on-hold' ) AND wp_posts.ID = wp_woocommerce_order_items.order_id AND wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_customer_user' AND wp_postmeta.meta_value > '0' AND wp_woocommerce_order_items.order_item_id = wp_woocommerce_order_itemmeta.order_item_id AND wp_woocommerce_order_items.order_item_type = 'course' AND wp_woocommerce_order_itemmeta.meta_value LIKE '3848' AND icl_t.language_code='it' ORDER BY wp_postmeta.meta_value DESC