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