SELECT ID ,UUID ,Name ,CategoryID ,Tagline ,Abstract ,Overview ,Features ,Specifications ,Datasheet ,Photo ,PhotoMed ,PhotoThumb ,NetsuiteLink ,DisplayFlag ,DisplayOrder ,CreateDateTime ,UpdateDateTime FROM Products WHERE ID = #url.id# SELECT C.ID FROM Content C, ProductContent PC WHERE PC.ProductID = #url.id# AND C.ID = PC.ContentID AND C.NavigationID IN (6,7) AND C.DeleteDateTime IS NULL AND C.PublishDateTime IS NOT NULL SELECT C.ID FROM Content C, ProductContent PC WHERE PC.ProductID = #url.id# AND C.ID = PC.ContentID AND C.NavigationID IN (9,10,11,12,13,14,15,16) AND C.DeleteDateTime IS NULL AND C.PublishDateTime IS NOT NULL