Build a specific wordpress/woocommerce query

Job ID: 31406390

Budget: €8 – €30 EUR

As easy as that. No formatting implied.

I need a list (with name and link to the attribute's link) for something like that

"Show me all pa_xxxxx term names, just for products stored under category (and children) number XXX."
Related categories: PHP WordPress MySQL HTML WooCommerce