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
|
|
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 DESCSELECT 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 DESCSELECT 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 DESCSELECT 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 DESCSELECT 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 = 'specifica genere'
AND T1.value = 'mediateca'
GROUP BY data.value ORDER BY cnt DESCSELECT 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 = 'editore'
AND T1.value = 'mediateca'
GROUP BY data.value ORDER BY cnt DESC
