SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.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_posts.ID IN (1,14194,14295,14312,14342,14375,14436,14503,14504,14507,14509,14592,14632,14765,14790,14804,14820,16760,16813,16849,17549,17557,17709,17724,17801,18257,18441,18574,20572,20889,20899,21903,21917,22262,22293,22299,22377,22382,22384,22436,22828,23402,23448,23546,23793,24052,24243,24256,24267,24278,24293,24496,24510,24562,24760,24981,25079,25412,25428,25497,25889,26142,26152,26250,26264,26398,26407,26467,26470,26474,26647,26808,26911,27073,27099,27102,27104,27108,27118,27295,27308,27867,27904,27975,27987,27998,28010,28106,28136,28769,28896,29435,29467,29538,29785,29817,29825,29839,30228,30472,30526,30631,30834,30920,31074,31190,31361,31371,31523,31894,32068,32079,32517,32767,32783,33165,33892,34044,34242,34298,34340,35345,35369,35525,35533,35788,35932,35936,36014,36082,36162,36930,37473,37632,37785,38021,38324,38492,38719,38847) AND ( 
  wp_postmeta.meta_key = '_length' 
  AND 
  mt1.meta_key = '_width'
) 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 CAST(wp_postmeta.meta_value AS DECIMAL) DESC, CAST(mt1.meta_value AS DECIMAL) DESC, wp_posts.menu_order DESC, wp_posts.post_date DESC, wp_posts.ID DESC
					 LIMIT 0, 20;