SELECT pr.product_image, pr.product_name, LEFT(pr.product_content,200) AS minimal_content, pr.product_content FROM products AS pr WHERE pr.product_name = 'POLISHED REAL BRASS FRAME OPTION'

POLISHED REAL BRASS FRAME OPTION

The ADVANTAGE, INNOVATION, MAXIMISER, OPTIMISER, SENSATION & SENSATION SLIM fires are available with this frame option.