Low Stock

gistfile1.txt

SELECT p.post_title as 'Name', pm.meta_value as 'SKU', pm2.meta_value as 'Stock'
FROM wp_posts p
	INNER JOIN wp_postmeta pm
		ON p.ID = pm.post_id
	INNER JOIN wp_postmeta pm2
		ON p.ID = pm2.post_id
	AND pm.meta_key = '_sku'
	AND ((pm2.meta_key = '_stock' AND CAST(pm2.meta_value AS SIGNED) BETWEEN '1' AND '4' ))