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