slug1: chemglass-laboratory-equipment
slug2: chemistry
Slug: flasks
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] = 'flasks' AND [c].PageTemplate != 19 AND [c].[Parent] = ISNULL((SELECT TOP 1 [ID] FROM [tblContent] WHERE [Slug] = 'chemglass-laboratory-equipment' AND ([Parent] = '5' OR [Parent] = (SELECT TOP 1 [ID] FROM [tblContent] WHERE [Slug] = 'chemistry' AND [Parent] = '0'))), '-1') order by (case when [c].[site] = '0' then 0 else 1 end) Flasks | GPE Scientific

Flasks

Order By
Page 7 of 9
123456789
filter products

Contact Us

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