Section Sql = SELECT * FROM `sections` WHERE `id` = '91'
Product Sql = SELECT products.* FROM `products` INNER JOIN `sections` ON products.section = sections.id WHERE products.section = '91' AND products.showonweb = 'Yes' AND sections.showonweb = 'Yes' ORDER BY `sort`, `name`

Number of products found: 3

Belfast City Hospital Blue Uniform Coaster
Belfast City Hospital Blue Uniform Coaster

from £7.00

Belfast City Hospital Blue Uniform Coaster
Belfast City Hospital Burgundy Uniform Coaster
Belfast City Hospital Burgundy Uniform Coaster

from £7.00

Belfast City Hospital Burgundy Uniform Coaster
Belfast City Hospital Pale Blue Uniform Coaster
Belfast City Hospital Pale Blue Uniform Coaster

from £7.00

Belfast City Hospital Pale Blue Uniform Coaster

Healthcare Coasters from ShonaD