Skip to content

Instantly share code, notes, and snippets.

@rbrahul

rbrahul/Fetch-only-amazon-products.sql

Created April 7, 2019 09:36
Show Gist options
  • Save rbrahul/5d409b46c85550b8f70d3bf7de8cf4ca to your computer and use it in GitHub Desktop.
Save rbrahul/5d409b46c85550b8f70d3bf7de8cf4ca to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Fetch-only-amazon-products.sql
select wp.ID, wpm.meta_value from wp_posts wp INNER JOIN `wp_postmeta` wpm ON wp.ID = wpm.`post_id`
WHERE wp.`post_type` = 'product' AND wpm.`meta_key`='_amzASIN'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment