During this course, the student is introduced to profiling p
WordPress database error: [Unknown column 'hvW61qhWg_posts.ID' in 'on clause']SELECT DISTINCT hvW61qhWg_postmeta.meta_value
FROM hvW61qhWg_posts, hvW61qhWg_postmeta, hvW61qhWg_woocommerce_order_items, hvW61qhWg_woocommerce_order_itemmeta
LEFT JOIN hvW61qhWg_icl_translations icl_t ON icl_t.element_id = hvW61qhWg_posts.ID
WHERE hvW61qhWg_posts.post_type = 'shop_order'
AND hvW61qhWg_posts.post_status IN ( 'wc-completed', 'wc-processing', 'wc-on-hold' )
AND hvW61qhWg_posts.ID = hvW61qhWg_woocommerce_order_items.order_id
AND hvW61qhWg_posts.ID = hvW61qhWg_postmeta.post_id
AND hvW61qhWg_postmeta.meta_key = '_customer_user'
AND hvW61qhWg_postmeta.meta_value > '0'
AND hvW61qhWg_woocommerce_order_items.order_item_id = hvW61qhWg_woocommerce_order_itemmeta.order_item_id
AND hvW61qhWg_woocommerce_order_items.order_item_type = 'course'
AND hvW61qhWg_woocommerce_order_itemmeta.meta_value LIKE '4630'
AND icl_t.language_code='en'
ORDER BY hvW61qhWg_postmeta.meta_value DESC