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

Number of products found: 6

I
I'd Rather Be Cycling Mug

from £11.00

I
I
I'd Rather Be Drinking Gin Mug

from £11.00

I
I
I'd Rather Be Drinking Wine Mug

from £11.00

I
I
I'd Rather Be In Donegal Mug

from £11.00

I
I
I'd Rather Be In The Mournes Mug

from £11.00

I
I
I'd Rather Be Playing Golf Mug

from £11.00

I

I'd rather be mugs from ShonaD