woocommerce attributes sql query

woocommerce_attributes_query.sql

SELECT
    t.term_id AS 'Attribute Value ID',
    tt.taxonomy AS 'Attribute Name',
    wat.attribute_label AS 'Attribute Label',
    t.name AS 'Attribute Value',
    COUNT(t.name) as 'num'
FROM
    wp_posts AS p
INNER JOIN wp_term_relationships AS tr
ON
    p.ID = tr.object_id
INNER JOIN wp_term_taxonomy AS tt
ON
    tr.term_taxonomy_id = tt.term_id AND tt.taxonomy LIKE 'pa_%'
INNER JOIN wp_terms AS t
ON
    tr.term_taxonomy_id = t.term_id
    INNER JOIN wp_woocommerce_attribute_taxonomies AS wat
ON
    TRIM('pa_' FROM tt.taxonomy) = wat.attribute_name
WHERE
    p.post_type = 'product' AND p.post_status = 'publish'
GROUP BY t.term_id, t.name, tt.taxonomy, wat.attribute_label;