Links

This Links Section provides links to other related organisations and websites. If we've not listed a link that you feel should be included please contact us.

query

RESULTSET

query
	CAT_CATID	CAT_CATNAME	CAT_SORTORDER
1	430	Business Improvement	1
2	454	Government Departments	2
3	455	Materials Information	3
4	456	Representative Bodies	4
5	457	Research and Consultancy	5

CACHED

false

EXECUTIONTIME

SQL

SELECT article_id AS cat_catid, XPath_String(article_xml, '/article_xml/page_heading') AS cat_catname, article_sortorder AS cat_sortorder FROM t_live_articles WHERE article_section_id = ? AND XPath_bool(article_xml, '/article_xml/agglink') ORDER BY article_sortorder

SQLPARAMETERS

array
1	90

Business Improvement
Government Departments
Materials Information
Representative Bodies
Research and Consultancy

Print friendly version