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

Number of products found: 3

Windsor Tennis Club Mug (Gentleman)
Windsor Tennis Club Mug (Gentleman)

from £13.00

Windsor Tennis Club Mug (Gentleman)
Windsor Tennis Club Mug (Lady)
Windsor Tennis Club Mug (Lady)

from £13.00

Windsor Tennis Club Mug (Lady)
Windsor Tennis Club Mug with logo
Windsor Tennis Club Mug with logo

from £13.00

Windsor Tennis Club Mug with logo

Tennis Club Mugs from ShonaD