Get all Products from WooCommerce Database

I had to export all the products from the WordPress Database for a eCommerce project recently which used WooCommerce – An awesome product I must add! All I needed was some of the key information (Excluding review data etc. ) Just a very quick snippet for those who may come across the same issue :)!

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'