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
Neuheiten
