307
308
309
310
311
312
313
|
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
|
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
ORDER BY parent, node
)
select *
from Hierarchy
-- where level>1
order by path;
</pre></nowiki>
<h1>Wiki Listings</h1>
Page names:
<nowiki><pre>
SELECT
substr(tagname,6) AS name
FROM tag JOIN tagxref USING('tagid')
WHERE tagname GLOB 'wiki-*'
AND tagxref.value+0 IS NOT NULL
UNION SELECT 'Sandbox' AS name
ORDER BY name COLLATE NOCASE;
</pre></nowiki>
More info:
<nowiki><pre>
SELECT
substr(tag.tagname, 6) AS wname,
lower(substr(tag.tagname, 6)) AS sortname,
tagxref.value+0 AS wrid,
max(tagxref.mtime) AS wmtime,
count(*) AS wcnt
FROM
tag,
tagxref
WHERE
tag.tagname GLOB 'wiki-*'
AND tagxref.tagid=tag.tagid
AND wrid IS NOT NULL -- only wiki- tags which are wiki pages
GROUP BY 1
ORDER BY 2;
</pre></nowiki>
|