Uživatelské nástroje

Nástroje pro tento web


mise
HY000 11 database disk image is malformed:
SELECT pages.page || '|' || pages.title, group_concat(" " || T1.value,'
'), group_concat(" " || T2.value,'
'), group_concat(" " || T3.value,'
')
                FROM (
                    SELECT DISTINCT pages.pid AS pid
                    FROM pages 
                    WHERE 1 = 1 AND pages.class = 'mise'
                ) AS W1
                 LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'datum' LEFT JOIN data AS T2 ON T2.pid = W1.pid AND T2.key = 'lokace' LEFT JOIN data AS T3 ON T3.pid = W1.pid AND T3.key = 'agent' LEFT JOIN data AS T4 ON T4.pid = W1.pid AND T4.key = 'cislo'
                LEFT JOIN pages ON W1.pid=pages.pid
                GROUP BY W1.pid
                ORDER BY CAST(T4.value AS NUMERIC) ASC

Mise

mise.txt · Poslední úprava: 2019/01/28 16:07 autor: administrator