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 )  INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )  INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.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,31160,38225,31429,38106,37867,37842,37840,37838,37834,36903,36863,37661,34264,36700,31684,36799,31047,35586,37006,27394,36875,36834,36811,36736,36634,32447,36204,36053,36034,35967,35902,35448,28622,35647,35639,30766,35438,35379,34948,29875,26248,21873,34308,32363,33858,32822,33492,33327,33002,32992,32436,31298,32355,32345,32333,32169,29517,31881,31423,31416,31391,31381,21163,31348,27881,31063,30897,30756,30672,30611,23936,30411,30401,14440,28974,29911,29893,29855,29709,19472,29684,29672,29080,29638,29116,29585,29570,29409,29505,28287,24404,29201,25582,27522,26539,26461,26535,29211,29093,28954,26297,28982,27270,24008,27893,27625,27679,26752,20078,24295,27379,14316,25420,24793,24781,21204,26971,26604,24838,25026,21206,22818,26285,18332,25600,25291,25610,25302,24659,24701,25455,25279,25170,20770,24713,20819,20630,16868,23266,21818,22792,24795,23021,15968,14529,20230,21188,24208,23851,23921,20279,23497,23849,21759,20417,20168,21363,19509,22501,21845,23535,23763,14304,22132,22780,23463,23324,23112,14771,22879,22800,17475,22388,21555,20937,22390,17775,22357,22355,22174,21029,21634,21209,20543,21757,21698,21499,21348,21322,20378,20552,20490,20364,20366,19929,19966,19904,14966,19732,19722,19714,14751,19440,19319,19110,17721,14229,18698,18688,18669,18428,18144,17131,17658,17629,17534,17496,14494,17257,17101,17094,17070,16801,16650,16648,16497,16457,15965,15932,14947,14958,14960,14985,14892,14919,14925,14931,14936,14943,14810,14858,14862,14863,14873,14874,14875,14762,14761,14758,14743,14768,14775,14781,14796,14803,14734,14731,14706,14705,14696,14692,14685,14676,14674,14672,14659,14633,14631,14605,14599,14597,14586,14572,14543,14541,14539,14538,14537,14530,14501,14498,14492,14487,14474,14472,14452,14441,14426,14415,14414,14389,14381,14370,14320,14306,14230,14226,14218,14189,14120,14167,14163,14159,14155,14156,14153,14146,14144,14138,14139) AND ( 
  ( wp_postmeta.meta_key = '_length' AND CAST(wp_postmeta.meta_value AS DECIMAL) <= '1045' ) 
  AND 
  ( mt1.meta_key = '_width' AND CAST(mt1.meta_value AS DECIMAL) <= '740' ) 
  AND 
  mt2.meta_key = '_length' 
  AND 
  mt3.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(mt2.meta_value AS DECIMAL) DESC, CAST(mt3.meta_value AS DECIMAL) DESC, wp_posts.menu_order DESC, wp_posts.post_date DESC, wp_posts.ID DESC
					 LIMIT 0, 20;