Difference between revisions of "Catalogus statistieken"
DustyJacobs (talk | contribs) |
DustyJacobs (talk | contribs) |
||
Line 57: | Line 57: | ||
| width=25px | || align=right | '''{{#cargo_query: | | width=25px | || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename))=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%museum%' | |where=Headline LIKE '%museum%' | ||
Line 67: | Line 67: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename))=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%rijksmuseum%' | |where=Headline LIKE '%rijksmuseum%' | ||
}}'''|| [[naamgeving Rijksmuseum|Rijksmuseum]] || waarvan || align=right | '''{{#cargo_query: | }}'''|| [[naamgeving Rijksmuseum|Rijksmuseum]] || waarvan || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het rijksmuseum%' | |where=Headline LIKE '%het rijksmuseum%' | ||
Line 79: | Line 79: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%rijks-museum%' | |where=Headline LIKE '%rijks-museum%' | ||
}}'''|| [[naamgeving Rijks-museum |Rijks-museum]]|| waarvan || align=right | '''{{#cargo_query: | }}'''|| [[naamgeving Rijks-museum |Rijks-museum]]|| waarvan || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het rijks-museum%' | |where=Headline LIKE '%het rijks-museum%' | ||
Line 91: | Line 91: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%rijks museum%' | |where=Headline LIKE '%rijks museum%' | ||
}}'''|| [[naamgeving Rijks museum |Rijks museum]] || waarvan || align=right | '''{{#cargo_query: | }}'''|| [[naamgeving Rijks museum |Rijks museum]] || waarvan || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het rijks museum%' | |where=Headline LIKE '%het rijks museum%' | ||
Line 103: | Line 103: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%ryksmuseum%' | |where=Headline LIKE '%ryksmuseum%' | ||
}}'''|| [[naamgeving Ryksmuseum |Ryksmuseum]] || waarvan || align=right| '''{{#cargo_query: | }}'''|| [[naamgeving Ryksmuseum |Ryksmuseum]] || waarvan || align=right| '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het ryksmuseum%' | |where=Headline LIKE '%het ryksmuseum%' | ||
Line 115: | Line 115: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%ryks-museum%' | |where=Headline LIKE '%ryks-museum%' | ||
}}'''|| [[naamgeving Ryks-museum |Ryks-museum]] || waarvan || align=right| '''{{#cargo_query: | }}'''|| [[naamgeving Ryks-museum |Ryks-museum]] || waarvan || align=right| '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het ryks-museum%' | |where=Headline LIKE '%het ryks-museum%' | ||
Line 127: | Line 127: | ||
|| || || align=right | '''{{#cargo_query: | || || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%ryks museum%' | |where=Headline LIKE '%ryks museum%' | ||
}}'''|| [[naamgeving Ryks museum |Ryks museum]] || waarvan || align=right| '''{{#cargo_query: | }}'''|| [[naamgeving Ryks museum |Ryks museum]] || waarvan || align=right| '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%het ryks museum%' | |where=Headline LIKE '%het ryks museum%' | ||
Line 139: | Line 139: | ||
| width=50px | || || align=right | '''{{#cargo_query: | | width=50px | || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%museum%' AND Headline NOT LIKE '%s museum%' AND Headline NOT LIKE '%smuseum%' AND Headline NOT LIKE '%-museum%' | |where=Headline LIKE '%museum%' AND Headline NOT LIKE '%s museum%' AND Headline NOT LIKE '%smuseum%' AND Headline NOT LIKE '%-museum%' | ||
Line 149: | Line 149: | ||
|| || align=right | '''{{#cargo_query: | || || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline NOT LIKE '%museum%' | |where=Headline NOT LIKE '%museum%' | ||
}}'''|| <u>met titel [[naamgeving anders dan museum | anders dan museum]]</u> || waarvan || align=right| '''{{#cargo_query: | }}'''|| <u>met titel [[naamgeving anders dan museum | anders dan museum]]</u> || waarvan || align=right| '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline LIKE '%amsterdam%' AND Headline NOT LIKE '%museum%' | |where=Headline LIKE '%amsterdam%' AND Headline NOT LIKE '%museum%' | ||
Line 166: | Line 166: | ||
| width=32px | || align=right | '''{{#cargo_query: | | width=32px | || align=right | '''{{#cargo_query: | ||
tables=Metadata | tables=Metadata | ||
− | |fields= COUNT(_pagename)=Aantal | + | |fields= COUNT(DISTINCT(_pagename)=Aantal |
|format=string | |format=string | ||
|where=Headline IS NULL | |where=Headline IS NULL |
Revision as of 19:50, 10 August 2020
Statistieken tabel
77 | Artikelen |
969 | Mediabestanden |
397 | Catalogusnummers in totaal |
391 | Catalogusnummers exclusief objecten (e.g. gebouw, tuin, deel gebouw etc.), |
144 verschillende foto's/afbeeldingen worden gebruikt, | 46 | foto's/afbeeldingen worden meervoudig gebruikt, | 98 | foto's/afbeeldingen worden op een enkele uitgave gebruikt. |
hierbij worden de volgende 10 foto's/afbeeldingen het meest gebruikt: |
351 | catalogusnummers met in titel museum: |
217 | Rijksmuseum | waarvan | A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Rijksmuseum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het rijksmuseum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | ||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Rijks-museum|| waarvan || align=right | Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%rijks-museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Rijks-museum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het rijks-museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |||||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Rijks museum || waarvan || align=right | Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%rijks museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Rijks museum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het rijks museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |||||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Ryksmuseum || waarvan || align=right| Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%ryksmuseum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Ryksmuseum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het ryksmuseum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |||||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Ryks-museum || waarvan || align=right| Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%ryks-museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Ryks-museum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het ryks-museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |||||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Ryks museum || waarvan || align=right| Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%ryks museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| Het Ryks museum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%het ryks museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |||||
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| alleen museum
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%museum%' AND Headline NOT LIKE '%s museum%' AND Headline NOT LIKE '%smuseum%' AND Headline NOT LIKE '%-museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) |
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| met titel anders dan museum || waarvan || align=right| Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline NOT LIKE '%museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| met Amsterdam in titel || en de volgende overige titels: || align=right| Een monument is de meest tastbare herinnering, Railrunner
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline LIKE '%amsterdam%' AND Headline NOT LIKE '%museum%' ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) | |
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
|| geen titel
Query: SELECT COUNT(DISTINCT(_pagename)=Aantal AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE Headline IS NULL ORDER BY COUNT(DISTINCT(_pagename)=Aantal LIMIT 2500 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `COUNT(DISTINCT( pagename)=Aantal` FROM `mwyy_cargo__Metadata` WHERE H...' at line 1 (localhost) |
met de volgende 10 meest voorkomende titel's:
|
272 | met de volgende geregistreerde tijdvakken in uren (NB. sommige catalogusnummers hebben meerdere geregistreerde tijdstippen, totaal registraties:276): |
14 | tussen 06u00-06u55 | 2 | tussen 14u00-14u55 | 3 | tussen 22u00-22u55 | |||
39 | tussen 07u00-07u55 | 0 | tussen 15u00-15u55 | 0 | tussen 23u00-23u55 | |||
104 | tussen 08u00-08u55 | 0 | tussen 16u00-16u55 | 0 | tussen 00u00-00u55 | |||
47 | tussen 09u00-09u55 | 1 | tussen 17u00-17u55 | 0 | tussen 01u00-01u55 | |||
22 | tussen 10u00-10u55 | 11 | tussen 18u00-18u55 | 0 | tussen 02u00-02u55 | |||
13 | tussen 11u00-11u55 | 0 | tussen 19u00-19u55 | 0 | tussen 03u03-03u55 | |||
2 | tussen 12u00-12u55 | 0 | tussen 20u00-20u55 | 0 | tussen 04u04-04u55 | |||
18 | tussen 13u00-13u55 | 0 | tussen 21u00-21u55 | 0 | tussen 05u05-05u55 |
6 | Catalogusnummers objecten (schilderij, beeldhouwwerk, meubilair, etc.) |
112 | Bestanden bronmateriaal (kranten, foto's etc.) |