Brownall News Archive

SELECT [page].*, [category].[categoryName] FROM ([page] LEFT JOIN [categoryPageLink] ON [page].[page_key] = [categoryPageLink].[page_fkey]) LEFT JOIN [category] ON [categoryPageLink].[category_fkey] = [category].[category_key] WHERE (([page].[active] = True) AND ([page].[inQuickFind]=True) AND ([category].[category_fkey] = 0) AND ([page].[navTitle]<>''))ORDER BY [category].[sortOrder], [category].[category_key], [page].[sortOrder], [page].[navTitle]