lukecav

SELECT
	wp_posts.post_title AS Product,
	wp_postmeta1.meta_value AS SKU,
	wp_postmeta2.meta_value AS Price,
	wp_postmeta3.meta_value AS Sales Price,
        wp_postmeta4.meta_value AS Stock,
        wp_postmeta5.meta_value AS Weight,
	GROUP_CONCAT( wp_terms.name ORDER BY wp_terms.name SEPARATOR ', ' ) AS ProductCategories
FROM wp_posts
LEFT JOIN wp_postmeta wp_postmeta1