analytics.md

Item titles that appear to have duplicate items

mysql> select value, count(*) from value where property_id=1 and resource_id in (select resource_id from value where property_id=62) group by value having count(*) > 1;
+------------------------------------------------------+----------+
| value                                                | count(*) |
+------------------------------------------------------+----------+
| 1821-09-18 Adelaide V2912 Register1 SLR13468-13675   |        2 |
| 1822-06-08 Esperança V2920 Register2 SLR14879-15025  |        2 |
| 1829-03-13 União V3017 FO315-32 f125-136             |        2 |
| British Commissary Judge                             |        3 |
+------------------------------------------------------+----------+

(note that items are limited to those which have a court property)

Query to list items created for Sierra Leone documents

select distinct value from value where property_id=1 and resource_id in (select resource_id from value where property_id=62) order by 1;

Documents with no thumbnails

mysql> select source from media where has_thumbnails = 0;
+---------------------------------------------------------------------------------------------------------+
| source                                                                                                  |
+---------------------------------------------------------------------------------------------------------+
| pdfs/1822 Esperança Feliz V2919/1822-07-04 Esperança Feliz V2919 FO315-31 f85-87.pdf                   |
| pdfs/1822 Esperança Feliz V2919/1822-07-04 Esperança Feliz V2919 FO84-15 f163v-164v.pdf                |
| pdfs/1822 Juliana V2924/1822-12-30 Juliana da Praça V2924 FO315-31 f131-133.pdf                        |
| pdfs/1825 União V2953/1825-11-04 União V2953 Register1 SLR20322-20570.pdf                              |
| pdfs/1825 União V2953/1825-11-04 União V2953 Register2 SLR20514-20570.pdf                              |
| pdfs/1826 Esperança V2956/1826-06-08 Esperança V2956 FO315-31 f283.pdf                                 |
| pdfs/1826 Esperança V2956/1826 Esperança V2956 Register1 SLR22287-22290.pdf                            |
| pdfs/1826 Esperança V2956/1826 Esperança V2956 Register2 SLR22287-22290.pdf                            |
| pdfs/1822 Esperança V2920/1822-06-08 Esperança V2920 Register2 SLR14879-15025.pdf                      |
| pdfs/1822 São Antônio de Lisboa V2935/1822-12-03 Santo Antônio de Lisboã V2935 SLR16313-16629.pdf     |
| pdfs/1829 União V3017/1829-03-13 União V3017 FO315-32 f125-136.pdf                                     |
+---------------------------------------------------------------------------------------------------------+