slug1: cowie-ptfe-laboratory-equipment
slug2: brands
Slug: ptfe-shaft-stirring
site: 0
SELECT TOP 1 [c].*, ISNULL([t].[controls], '') AS [controls], [t].[class] FROM [tblContent] AS [c] LEFT JOIN [tblTemplates] AS [t] ON [c].[PageTemplate] = [t].[id] WHERE [c].[Slug] = 'ptfe-shaft-stirring' AND [c].PageTemplate != 19 AND [c].[Parent] = ISNULL((SELECT TOP 1 [ID] FROM [tblContent] WHERE [Slug] = 'cowie-ptfe-laboratory-equipment' AND ([Parent] = '5' OR [Parent] = (SELECT TOP 1 [ID] FROM [tblContent] WHERE [Slug] = 'brands' AND [Parent] = '0'))), '-1') order by (case when [c].[site] = '0' then 0 else 1 end) PTFE Shaft Stirring | GPE Scientific

PTFE Shaft Stirring

GPE Scientific supply PTFE Reactor Lids and Fittings - Rotors, Stirrers, Shafts from Cowie

Browse below

Order By
Page 1 of 1
1
filter products

Contact Us

Quote Basket
Your quote basket is currently empty. View Quote Basket