SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
	LEFT JOIN wp_postmeta AS custom_status ON custom_status.post_id = wp_posts.ID AND custom_status.meta_key = 'status_toggle'
	LEFT JOIN wp_postmeta AS stock_status ON stock_status.post_id = wp_posts.ID AND stock_status.meta_key = '_stock_status'

					 WHERE 1=1  AND ( 
  wp_postmeta.meta_value LIKE '{0c99df8e4e7557b79ec76a6cb192b143bf670c88b1e43fd58c69f77f10729413}\"new\"{0c99df8e4e7557b79ec76a6cb192b143bf670c88b1e43fd58c69f77f10729413}'
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ( (
				stock_status.meta_value = 'instock'
			AND wp_posts.post_status = 'publish'
			AND	custom_status.meta_value NOT LIKE '%\"reserved\"%'
		) OR (
			custom_status.meta_value LIKE '%\"reserved\"%'
		) )
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.post_date DESC
					 LIMIT 0, 20;