SELECT SQL_CALC_FOUND_ROWS sl_posts.ID FROM sl_posts LEFT JOIN sl_term_relationships ON (sl_posts.ID = sl_term_relationships.object_id) INNER JOIN sl_postmeta ON ( sl_posts.ID = sl_postmeta.post_id ) INNER JOIN sl_postmeta AS mt1 ON ( sl_posts.ID = mt1.post_id ) WHERE 1=1 AND (
sl_term_relationships.term_taxonomy_id IN (298)
) AND (
( sl_postmeta.meta_key = '_visibility' AND sl_postmeta.meta_value IN ('visible','catalog') )
AND
( mt1.meta_key = '_stock_status' AND mt1.meta_value = 'instock' )
) AND sl_posts.post_type = 'product' AND (sl_posts.post_status = 'publish' OR sl_posts.post_status = 'acf-disabled') GROUP BY sl_posts.ID ORDER BY FIELD(sl_posts.ID, 45115,14804,14799,14796,14727,14540,14512,53449,60214,60260,53465,53454,53459,40124,40099,27833,27830,27802,21035), sl_posts.post_date DESC LIMIT 0, 24
