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,14783,14864,14946,14948,15991,17869,18341,18388,19015,19026,20978,21410,21419,21428,21437,21447,21481,21489,21620,22089,22137,22192,22200,22265,22289,22401,22498,22549,22767,23015,23019,23121,23404,23406,23408,23480,23561,23563,23565,23756,23790,23824,23826,23828,23831,23938,23940,23942,23990,24182,24184,24382,24402,24447,24616,24622,24628,24634,24671,24752,24848,24858,24880,25008,25043,25051,25059,25067,25077,25094,25106,25117,25130,25137,25182,25194,25389,25623,25855,25857,25859,25861,26170,26205,26276,26494,26496,26498,26502,26512,26523,26564,26572,26607,26619,26896,26898,26900,26930,26961,27020,27050,27227,27229,27250,27260,27366,27424,27433,27807,27953,28163,28733,28744,28755,29177,29247,29257,29267,29280,29295,29307,29336,29352,29393,29411,29419,29427,29446,29448,29669,29955,29965,30151,30275,30329,30373,30384,30394,30453,30506,30516,30549,30603,30934,31004,31014,31026,31136,31173,31323,31525,31527,31529,31531,31533,31618,31626,31636,31670,31676,32006,32299,32548,32559,32569,32632,32634,33543,33551,33561,33571,33581,33591,33798,33927,33937,33944,34074,34084,34365,34367,34637,34649,34660,34810,34873,34921,34982,34984,34992,34994,34996,35140,35148,35158,35166,35174,35231,35253,35262,35270,35278,35286,35296,35305,35313,35321,35329,35337,35658,35671,35754,35821,35835,35847,35950,35965,36012,36127,36137,36539,36550,36552,36562,36570,36580,36755,36764,36772,36778,36960,37259,37269,37283,37297,37314,37327,37384,37397,37410,37421,37434,37642,37650,37958,37966,38155,38245,38254,38262,38270,38314,38322,38435,38446,38582,38595,38597,38600,38606,38608,38610,38701,38879,38906,38912,38938) 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;