SQL Woocommerce

SELECT wp_posts.post_title as ‘producto’,wp_posts.post_excerpt as ‘descripción corta’,wp_posts.post_content as ‘descripción’,w.meta_value as ‘peso’,h.meta_value as ‘altura’,l.meta_value as ‘longitud’,wi.meta_value as ‘ancho’,r.meta_value as ‘precio regular’,s.meta_value as ‘precio rebajado’,sk.meta_value as ‘sku’,wp_aioseo_posts.keywords as ‘palabras clave’ FROM wp_posts

LEFT JOIN

wp_postmeta w ON w.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta r ON r.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta s ON s.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta h ON h.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta l ON l.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta wi ON wi.post_id=wp_posts.ID

LEFT JOIN

wp_postmeta sk ON sk.post_id=wp_posts.ID

LEFT JOIN

wp_aioseo_posts ON wp_aioseo_posts.post_id=wp_posts.ID

WHERE 

wp_posts.post_type=’product’ AND

w.meta_key=’_weight’ AND

r.meta_key=’_regular_price’ AND

s.meta_key=’_sale_price’ AND

h.meta_key=’_height’ AND

l.meta_key=’_length’ AND

wi.meta_key=’_width’ AND

sk.meta_key=’_sku’;