Men's Shooting Vests & Waistcoats

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 (256) ) 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 sl_posts.menu_order ASC, sl_posts.post_title ASC LIMIT 0, 24