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,26214,29762,31181,37814,25874,36973,36981,36688,36680,36673,14896,35770,18451,34762,34672,34627,25850,33988,32046,33969,33961,33740,33734,33728,33538,33532,25395,33362,31171,32238,32191,32149,31849,26209,25410,22313,31179,31153,31037,30543,30537,30320,26457,29844,29841,29773,18076,26212,29154,21161,29492,29455,22462,22867,19508,29179,14895,21820,17454,28701,27754,27231,27356,27134,26862,15088,19623,20678,25400,26490,26216,26194,25880,22039,24987,14682,21201,25010,26492,23795,15044,19990,14468,19910,23974,22871,23758,22458,22875,23548,22468,22797,23152,23143,23125,22873,20325,22591,14438,22466,20916,20189,22170,22167,21843,17962,21199,21196,21109,18945,20181,20117,19994,14955,19654,17432,14897,18193,18185,18176,14423,14786,14930,17430,14479,16109,14779,14695,14647,14635,14606,14577,14575,14564,14558,14528,14512,14451,14424,14352,14331,14267,14212,14173,14088,14082) 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;