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

Number of products found: 3

Campbell College Rugby Club Mug
Campbell College Rugby Club Mug

from £11.00

Campbell College Rugby Club Mug
Inst Rugby Mug
Inst Rugby Mug

from £11.00

Inst Rugby Mug
Methodist College Rugby Club  Mug
Methodist College Rugby Club Mug

from £11.00

Methodist College Rugby Club  Mug

Rugby Club Mugs from ShonaD