Help:Sandbox/protected

This page is for sysops to experiment with W3TPL code and anything else that requires edit protection.

<let name=topic val="ValueOptions" /> <let name=max val=10 />

 <let name=idx />
 <let name=including val=1 />

 <let name=topic self with="_"> </let>

 <let name=sqlWhere>(cl_to='</let>
 <let name=sqlList>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=sqlList append copy=topic />
 <let name=sqlList append>') ORDER BY page_title DESC LIMIT </let>
 <let name=sqlList append copy=max />

SQL 1: <get name=sqlList />

 <let name=noLoad val=1 />

 <for sql=$sqlList hide>
   <let name=pg_nspace_code>{{ns:</let>
   <let name=pg_nspace_code append val=@row.page_namespace />
   <let name=pg_nspace_code append>}}</let>
   <let name=pg_nspace copy=pg_nspace_code parse />
   <let name=pg_title val="@row.page_title" />
   <let name=pg_name copy=pg_nspace />
   <let name=pg_name append>:</let>
   <let name=pg_name append copy=pg_title />
   <let name=idx inc />
   <let name=data[Title] null />
   <load page=$pg_name />
   <if flag=data[Title]>
     <call GetBlogEntryBrief />
     <let name=e.rtn append copy=e.out />
   </if>
   <let name=data />
 </for>

SQL 2: <get name=sqlList />