Lily & Me
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=110 ORDER BY stylename
