SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 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 )
	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,37650,37642,25182,37434,37421,37410,37397,37384,37327,37314,37297,37283,37269,37259,36137,34873,36960,35321,36778,36772,36755,36764,36580,36570,36562,36552,36550,36539,23019,36127,35262,31531,36012,35965,35950,35313,35847,33944,35835,35821,35754,35671,35658,34365,32006,35337,35253,35278,35270,35231,35174,35166,35158,25043,35148,35140,34996,34994,34992,35296,34982,35305,35286,34921,34984,35329,34810,34660,34649,34637,32632,34084,32569,26205,34367,29307,34074,33937,33927,26494,26496,26498,33798,33591,33581,33571,33561,33551,33543,27020,30603,32634,32559,32548,29336,32299,26607,30394,31676,31670,26170,31636,31626,31618,31323,31533,31529,31527,31525,29295,26564,30516,31173,31136,31026,31014,31004,30934,30151,29257,29965,29247,30549,30506,30453,30384,30373,30329,30275,27953,25855,29955,29669,26572,29352,29427,27807,25051,29448,29446,29419,29411,29393,27424,28744,25077,28755,29280,29267,29177,28163,27250,25389,28733,26930,26900,27227,22265,26523,27260,26896,27229,25067,26961,27050,27433,21620,27366,26502,26276,23828,26512,26898,15991,22089,25859,25059,26619,17869,22767,25861,24858,25094,25117,25857,23408,14946,25623,23790,23480,25008,24382,25106,24182,24671,24848,25194,24880,24752,25137,25130,23406,22137,24622,24634,21489,24184,21428,23826,23824,24447,24628,24616,23756,23940,24402,23942,23990,23831,23938,23015,23565,23563,21410,23561,23404,23121,22192,22549,21437,22401,22498,14783,22289,22200,21419,21481,21447,20978,18388,19015,19026,18341,14948,14864) AND ( 
  wp_term_relationships.term_taxonomy_id IN (13,16,17,18,19,20,21,22,41,44,46,47,1657)
) AND ( 
  wp_postmeta.meta_key = '_length' 
  AND 
  ( 
    ( mt1.meta_key = '_length' AND CAST(mt1.meta_value AS DECIMAL) REGEXP '([[:digit:]]*[.])?[[:digit:]]+' ) 
    AND 
    ( mt2.meta_key = '_length' AND CAST(mt2.meta_value AS DECIMAL) != '0' )
  )
) 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 wp_postmeta.meta_value+0 ASC
					 LIMIT 0, 20;