Hoggs Professional
Hoggs of Fife is a long established supplier of protective clothing and working footwear for the country professional, and has always provided value for money products, fit for purpose in the country.
SELECT product_id, code, stylename, category1_id, image_main, is_newproduct, price_pound, saleprice_pound, new_color, is_on_offer, prod_url, other_colours_html, is_new_improved
FROM tbl_product
WHERE isavailable='y'
AND brand_id=30 ORDER BY stylename
