SQL Woocommerce Products (original)

SELECT
     /** Post ID **/
     p.id,
     /** Product Code **/
     mt.meta_value AS sku,
     /** Product Stock **/
     m.meta_value AS stock,
     /** Item Title **/
     p.post_title AS title,
     /** Item Description **/
     p.post_content AS description,
     /** Item Price **/
     pt.meta_value AS price,
     /** Item Weight **/
     wt.meta_value AS weight
FROM
     wp_posts p
INNER JOIN wp_postmeta m ON (
     p.id = m.post_id
)
INNER JOIN wp_postmeta mt ON (
     p.id = mt.post_id
)
INNER JOIN wp_postmeta pt ON (
     p.id = pt.post_id
)
INNER JOIN wp_postmeta wt ON (
     p.id = wt.post_id
)
WHERE
 p.post_type = 'product'
AND
 m.meta_key = '_stock'
AND
 mt.meta_key = '_sku'
AND
 pt.meta_key = '_price'
AND
 wt.meta_key = '_weight'