no such column: W1.pid:

SELECT " " || pages.page, group_concat(" " || T1.value,'
')
                FROM (
                    SELECT DISTINCT pages.pid 
                    FROM pages  LEFT JOIN data AS T1 ON T1.pid = pages.pid AND T1.key = 'snipplet'
                    WHERE 1 = 1 AND T1.value = 'terminal'
                ) AS W1 
                 LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'lastupdate'
                LEFT JOIN pages ON W1.pid=pages.pid
                GROUP BY W1.pid
                ORDER BY T1.value DESC

Small code snipplets

These snipplets are not meant as HowTo or Tutorial or FAQ. Mostly they are only a line of code and a short comment.

See it more like an initial idea to give you a start.

List of snipplets

reset filter

Filtered by snipplet=terminal

Show all (remove filter/sort)

Snipplet	↑ Last updated
Nothing found