Εξαγωγή πεδίων από brands, manufacturers – WooComerce WordPress SQL script

SELECT * FROM `wp_wcm_sds_brands` brd,`wp_postmeta` pro,`wp_terms` trm  WHERE brd.meta_value=pro.post_id

and brd.term_taxonomy_id=trm.term_id