Array ( [0] => WP_Term Object ( [term_id] => 11558 [name] => Basic [slug] => basic [term_group] => 0 [term_taxonomy_id] => 11558 [taxonomy] => product_cat [description] => [parent] => 11523 [count] => 259 [filter] => raw ) [1] => WP_Term Object ( [term_id] => 11522 [name] => Damenmode [slug] => damenmode [term_group] => 0 [term_taxonomy_id] => 11522 [taxonomy] => product_cat [description] => [parent] => 363 [count] => 1119 [filter] => raw ) [2] => WP_Term Object ( [term_id] => 11523 [name] => Pullover langarm [slug] => pullover-langarm [term_group] => 0 [term_taxonomy_id] => 11523 [taxonomy] => product_cat [description] => [parent] => 11522 [count] => 460 [filter] => raw ) [3] => WP_Term Object ( [term_id] => 363 [name] => Stricksets [slug] => stricksets [term_group] => 0 [term_taxonomy_id] => 363 [taxonomy] => product_cat [description] => [parent] => 0 [count] => 2427 [filter] => raw ) ) SELECT b.id, SUM(obl.product_qty) AS total_qty_sold FROM Ha3DZU38O_posts b LEFT JOIN Ha3DZU38O_wc_order_product_lookup obl ON obl.product_id = b.ID WHERE b.post_type = 'product' AND b.ID IN(SELECT object_id FROM Ha3DZU38O_term_relationships WHERE term_taxonomy_id = 11558) GROUP BY b.ID ORDER BY total_qty_sold DESC LIMIT 8