Strumenti Utente

Strumenti Sito


Barra laterale

Navigazione

Benvenuti
Chi siamo
Documenti
Foto
Progetti
Il blog dei dilettanti.
CondiviBiblio
Mediateca
crea libro elettronico
Video
Partecipazione
Centro studi
Sondaggi
Siamo qui
Il calendario
Forum
Sulla privacy


Visite
Posta


0
online

Albero delle cartelle




inizio:mediateca:start
HY000 11 database disk image is malformed:
SELECT pages.page || '|' || pages.title, group_concat(" " || T1.value,'
'), group_concat(" " || T2.value,'
')
                FROM (
                    SELECT DISTINCT pages.pid AS 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 = 'autore'
                    WHERE 1 = 1 AND T1.value = 'mediateca' AND T2.value != ''
                ) AS W1
                 LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'titolo opera' LEFT JOIN data AS T2 ON T2.pid = W1.pid AND T2.key = 'autore'
                LEFT JOIN pages ON W1.pid=pages.pid
                GROUP BY W1.pid
                ORDER BY T2.value ASC LIMIT 11
HY000 11 database disk image is malformed:
SELECT group_concat(" " || T1.value,'
'), group_concat(" " || T2.value,'
'), group_concat(" " || T3.value,'
'), group_concat(" " || T4.value,'
'), group_concat(" " || T5.value,'
'), group_concat(" " || T6.value,'
'), group_concat(" " || T7.value,'
'), group_concat(" " || T8.value,'
'), group_concat(" " || T9.value,'
'), group_concat(" " || T10.value,'
'), group_concat(" " || T11.value,'
'), group_concat(" " || T12.value,'
'), group_concat(" " || T13.value,'
'), group_concat(" " || T14.value,'
'), group_concat(" " || T15.value,'
'), group_concat(" " || T16.value,'
')
                FROM (
                    SELECT DISTINCT pages.pid AS 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 = 'autore'
                    WHERE 1 = 1 AND T1.value = 'mediateca' AND T2.value != ''
                ) AS W1
                 LEFT JOIN data AS T1 ON T1.pid = W1.pid AND T1.key = 'genere' LEFT JOIN data AS T2 ON T2.pid = W1.pid AND T2.key = 'specifica genere' LEFT JOIN data AS T3 ON T3.pid = W1.pid AND T3.key = 'data pubblicazione' LEFT JOIN data AS T4 ON T4.pid = W1.pid AND T4.key = 'editore' LEFT JOIN data AS T5 ON T5.pid = W1.pid AND T5.key = 'edizione numero' LEFT JOIN data AS T6 ON T6.pid = W1.pid AND T6.key = 'isbn' LEFT JOIN data AS T7 ON T7.pid = W1.pid AND T7.key = 'dewey' LEFT JOIN data AS T8 ON T8.pid = W1.pid AND T8.key = 'immagine' LEFT JOIN data AS T9 ON T9.pid = W1.pid AND T9.key = 'url' LEFT JOIN data AS T10 ON T10.pid = W1.pid AND T10.key = 'scaffale' LEFT JOIN data AS T11 ON T11.pid = W1.pid AND T11.key = 'dove' LEFT JOIN data AS T12 ON T12.pid = W1.pid AND T12.key = 'commenti vari' LEFT JOIN data AS T13 ON T13.pid = W1.pid AND T13.key = 'in prestito' LEFT JOIN data AS T14 ON T14.pid = W1.pid AND T14.key = 'a chi' LEFT JOIN data AS T15 ON T15.pid = W1.pid AND T15.key = 'data prestito' LEFT JOIN data AS T16 ON T16.pid = W1.pid AND T16.key = 'data restituzione' LEFT JOIN data AS T17 ON T17.pid = W1.pid AND T17.key = 'autore'
                LEFT JOIN pages ON W1.pid=pages.pid
                GROUP BY W1.pid
                ORDER BY T17.value ASC LIMIT 11
HY000 11 database disk image is malformed:
SELECT data.value AS value, COUNT(data.pid) AS cnt
                  FROM data   LEFT JOIN data AS T1 ON T1.pid = data.pid AND T1.key = 'type' 
                 WHERE data.key = 'autore'
                   AND T1.value = 'mediateca'
              GROUP BY data.value ORDER BY cnt DESC
HY000 11 database disk image is malformed:
SELECT data.value AS value, COUNT(data.pid) AS cnt
                  FROM data   LEFT JOIN data AS T1 ON T1.pid = data.pid AND T1.key = 'type' 
                 WHERE data.key = 'titolo opera'
                   AND T1.value = 'mediateca'
              GROUP BY data.value ORDER BY cnt DESC
HY000 11 database disk image is malformed:
SELECT data.value AS value, COUNT(data.pid) AS cnt
                  FROM data   LEFT JOIN data AS T1 ON T1.pid = data.pid AND T1.key = 'type' 
                 WHERE data.key = 'genere'
                   AND T1.value = 'mediateca'
              GROUP BY data.value ORDER BY cnt DESC
HY000 11 database disk image is malformed:
SELECT data.value AS value, COUNT(data.pid) AS cnt
                  FROM data   LEFT JOIN data AS T1 ON T1.pid = data.pid AND T1.key = 'type' 
                 WHERE data.key = 'commenti vari'
                   AND T1.value = 'mediateca'
              GROUP BY data.value ORDER BY cnt DESC

Mediateca-elenco

Ricerca1) - I risultati estratti dalla base di dati2)

schedaTitolo opera Autore
Nothing found

Ricerche per nuvole

Ricerca per autori

    Ricerca per titolo

      Ricerca per genere

        Ricerca per commenti

          1)
          Ogni campo delle sottostanti schede è ordinabile alfabeticamente cliccando sul titolo relativo. Sotto ogni titolo c'è un campo di ricerca nel quale basta digitare qualche carattere per ottenere un filtro. Inoltre, sotto l'elenco si possono ottenere dati filtrati per titolo dell'opera, autore, commenti vari. Cliccando sul collegamento “Mediateca-scheda” si ottiene la singola scheda ricercata.
          2)
          sono stati fissati nel numero di 10 per pagina ma si può modificare questo dato a piacere anche se non è buona cosa avere delle pagine chilometriche.
          Potresti lasciare un commento se ti fossi autenticato.
          inizio/mediateca/start.txt · Ultima modifica: 14/04/2018 18:01 da cesiano