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 = 'type' LEFT JOIN data AS T2 ON T2.pid = pages.pid AND T2.key = 'snipplet'
                    WHERE 1 = 1 AND T1.value = 'snipplet' AND T2.value = 'files'
                ) 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 ASC

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=files

Show all (remove filter/sort)

Snipplet	↓ Last updated
Nothing found