Beretta Womens Silver Pigeon PoloSale
James Purdey Womens Polo ShirtSale
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 ( ( SELECT COUNT(1) FROM sl_term_relationships WHERE term_taxonomy_id IN (1624) AND object_id = sl_posts.ID ) = 1 AND sl_term_relationships.term_taxonomy_id IN (254,309,310,315,318,319,321,1383,2027,2295,2637,2638,2639,2656,2667,2680,2686) ) 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
The Sporting Lodge offers a wide selection of women’s country clothing from brands such as Barbour, Dubarry and Le Chameau, which combine classic and modern styles. For ladies who like to explore, we offer some highly technical women’s outdoor clothing from the likes of Fjallraven and Musto. Our women’s walking clothing and women’s hiking clothing collections are designed to enhance your performance capabilities whilst remaining extremely comfortable. For our fierce female shooter we stock a great range of women’s shooting clothing from the likes of Beretta and James Purdey. We are always expanding our women’s country wear collection to best serve our loyal ladies so make sure you check back here regularly.