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

Number of products found: 4

Large Belfast Greetings Card
Large Belfast Greetings Card

from £3.50

Large Belfast Greetings Card
Large Fermanagh Greetings Card
Large Fermanagh Greetings Card

from £3.50

Large Fermanagh Greetings Card
Large Holywood Greetings Card
Large Holywood Greetings Card

from £3.50

Large Holywood Greetings Card
Small Belfast Greetings Card
Small Belfast Greetings Card

from £2.00

Small Belfast Greetings Card

Locally Themed Card from ShonaD