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 (719)
) 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, 38080,38086,38045,38030,38104,64224,64209,64220,64235,64241,64245,64229,64255,64251,38129,38124), sl_posts.post_date DESC LIMIT 0, 24
