Difference between revisions of "HypertWiki:Code/lib/data"
Jump to navigation
Jump to search
(added <hr> before The Rest) |
(rewrite of blogpost listing SQL) |
||
| Line 250: | Line 250: | ||
<let name=sqlWhere>(cl_to='</let> | <let name=sqlWhere>(cl_to='</let> | ||
<let name=sql>SELECT q1.* FROM qryW3_Titles_Catgs AS q1 LEFT JOIN qryW3_Titles_Catgs AS q2 ON q1.cl_from=q2.cl_from WHERE (q1.cl_to='Data/blog/post') AND (q2.cl_to='</let> | |||
<let name=sqlWhere append copy=topic /> | <let name=sqlWhere append copy=topic /> | ||
<let name=sqlWhere append>')</let> | <let name=sqlWhere append>') SORT page_title DESC LIMIT=</let> | ||
<let name=sqlWhere append copy=max /> | |||
<let name=noLoad val=1 /> | <let name=noLoad val=1 /> | ||
<for | <for sql=$sql hide> | ||
<let name=pg_nspace_code>{{ns:</let> | <let name=pg_nspace_code>{{ns:</let> | ||
<let name=pg_nspace_code append val=@row.page_namespace /> | <let name=pg_nspace_code append val=@row.page_namespace /> | ||