Skip to content

Instantly share code, notes, and snippets.

@rynaldos

rynaldos/Sql query

Created September 1, 2021 19:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rynaldos/6ca7c2319140c819e43eb246b60024a2 to your computer and use it in GitHub Desktop.
Save rynaldos/6ca7c2319140c819e43eb246b60024a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Sql query
SELECT product.ID as product_id, product.post_title as product_name, replace(product.post_content, '"', "'") as product_content, product_sku.meta_value as product_sku, product_price.meta_value as product_price, product_weight.meta_value as product_weight FROM wp_posts as product LEFT JOIN wp_postmeta as product_sku ON product.ID = product_sku.post_ID LEFT JOIN wp_postmeta as product_price ON product.ID = product_price.post_ID LEFT JOIN wp_postmeta as product_weight ON product.ID = product_weight.post_ID WHERE (product.post_type = 'product' OR product.post_type = 'product_variation') AND product_sku.meta_key = '_sku' AND product_price.meta_key = '_price' AND product_weight.meta_key = '_weight'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment