cometadata/datacite-titles-descriptions-related-identifiers huggingface dataset:
DOI: 10.15468/dl.jsv7dg
title: Occurrence Download

description: A dataset containing 832351 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Singapore",
 "OccurrenceStatus is Present",
 "TaxonKey is Aves",
 "Year 2020-2025"
 ]
}

 The dataset includes 832351 records from 12 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035322-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.d3k2sr
title: Occurrence Download

description: A dataset containing 132 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Melinis repens",
 "Country is Costa Rica",
 "HasCoordinate is true"
 ]
}

 The dataset includes 132 records from 11 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035381-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.dhrzhr
title: Occurrence Download

description: A dataset containing 1074 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Aconitum volubile"
 ]
}

 The dataset includes 1074 records from 38 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035377-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.xyg83v
title: Occurrence Download

description: A dataset containing 3747 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Aconitum japonicum"
 ]
}

 The dataset includes 3747 records from 117 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035378-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.vngmct
title: Occurrence Download

description: A dataset containing 29524 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "TaxonKey is Commelina erecta"
 ]
}

 The dataset includes 29524 records from 491 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035380-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.jtjywn
title: Occurrence Download

description: A dataset containing 52 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Melinis repens",
 "Country is Cuba",
 "HasCoordinate is true"
 ]
}

 The dataset includes 52 records from 9 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035383-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.p4tmz8
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Oncorhynchus nerka",
 "Country is Argentina",
 "HasCoordinate is true"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035385-250811113504898/datasets/export for details.
DOI: 10.15468/dl.scqxgn
title: Occurrence Download

description: A dataset containing 51 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Melinis repens",
 "Country is Dominican Republic",
 "HasCoordinate is true"
 ]
}

 The dataset includes 51 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035384-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.c6frd9
title: Occurrence Download

description: A dataset containing 0 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Oncorhynchus nerka",
 "Country is Chile",
 "HasCoordinate is true"
 ]
}

 The dataset includes 0 records from 0 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035386-250811113504898/datasets/export for details.
DOI: 10.15468/dl.hg4kp7
title: Occurrence Download

description: A dataset containing 94919 species occurrences available in GBIF matching the query:
{
 "TaxonKey" : [
 "is Lamium galeobdolon montanum"
 ]
}

 The dataset includes 94919 records from 455 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035269-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.f6knfj
title: Occurrence Download

description: A dataset containing 12628 species occurrences available in GBIF matching the query:
{
 "and" : [
 "HasCoordinate is true",
 "TaxonKey is Commelina diffusa"
 ]
}

 The dataset includes 12628 records from 533 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0035382-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.3535/gve-dv9-fkm
title: Orthiopteris Copel.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/jzd-3dy-ffj
title: Plantae

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.15468/dl.gjcrgv
title: Occurrence Download

description: A dataset containing 119 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Bidens pilosa",
 "Country is Peru",
 "HasCoordinate is true"
 ]
}

 The dataset includes 119 records from 19 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0023688-250811113504898/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.3535/0s3-5pd-f3l
title: Parasmittina Osburn, 1952

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xl7-0d3-4ba
title: Spondylus Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/wqc-g5n-x55
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/100-p5z-mz6
title: Orthiopteris Copel.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/fvv-frr-fld
title: Astarte J. Sowerby, 1816

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/nhx-sjh-a3p
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/rvh-0fq-eyp
title: †Miogypsina Sacco, 1893

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/a8q-k9j-y6z
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xsx-0sl-95r
title: Thalamoporella Hincks, 1887

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/jjy-v4v-nqc
title: Stephanollona contracta (Waters, 1899)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/vxx-r04-5va
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/x42-j81-319
title: Biflustra tenuis (Desor, 1848)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/mgz-0b5-edn
title: Gen. indet. sp. indet.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xjl-q75-3j0
title: Orthiopteris Copel.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/msv-sbk-526
title: Plantae

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/q0c-zly-236
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/ccz-z8t-egb
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/g4b-1r8-raf
title: Cupuladria canariensis (Busk, 1859)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/b8r-t2l-lw4
title: Plantae

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/d8g-h51-cd2
title: Cerithium Bruguière, 1789

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/c7b-ztj-ake
title: Crinoidea Miller, 1821

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4s6-jn7-s78
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/7rg-pqe-87d
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/veh-h5x-cwj
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/yx0-zbp-57d
title: Gen. indet. sp. indet.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/4yy-ft0-yg5
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/vvr-er6-hjp
title: Cnidaria

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/1y0-ppx-kk7
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/nrm-cd6-881
title: Schizoporella Hincks, 1877

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/chd-e7x-3aj
title: Plantae

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/njx-lmv-bhh
title: Echinoidea Schumacher, 1817

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/63m-d4g-d18
title: Bryozoa

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/xqw-pj0-x2c
title: †Miogypsina Sacco, 1893

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/htk-rz3-j06
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/sz9-lqj-qdw
title: †Miogypsina Sacco, 1893

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/s07-x9l-wet
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/t6e-j1h-j0n
title: Juglans L.

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/y7s-304-5ty
title: Crisia Lamouroux, 1812

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/dd5-hp6-l28
title: Biflustra tenuis (Desor, 1848)

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.3535/zk2-1vy-dex
title: Mammalia Linnaeus, 1758

description: Digital Specimen for the physical specimen hosted at Naturalis Biodiversity Center.
DOI: 10.60507/fk2/p0ziyz/5u3xtc
title: Aryballos_2671_images.zip
DOI: 10.60507/fk2/p0ziyz/k4wplt
title: GÜNZEL_Aryballos_2671_readme.txt
DOI: 10.60507/fk2/p0ziyz/tailkm
title: Aryballos_2671_model.zip
DOI: 10.60507/fk2/p0ziyz
title: Corinthian Aryballos in the Academic Art Museum (Inv. 2671

description: Corinthian Aryballos in the Academic Art Museum (University of Bonn, Inv. 2671) showing two antithetical arranged leopards. Date: -595 to -570 BC.
description: AgisoftMetashape, 1.3
description: Blender, 4.0
description: Substance Designer, 12.3.1
DOI: 10.34740/kaggle/dsv/13757886
title: Peer-to-Peer Boliviano (BOB) Exchange Data
DOI: 10.15468/dl.fadmvm
title: Occurrence Download

description: A dataset containing 2153169 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Agaricomycetes",
 "Country is United States of America",
 "HasCoordinate is true"
 ]
}

 The dataset includes 2153169 records from 251 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037970-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.d4z26k
title: Occurrence Download

description: A dataset containing 294 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-185.73715 26.16548,-69.26285 26.16548,-69.26285 72.83452,-185.73715 72.83452,-185.73715 26.16548))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Sorex navigator",
 "Year 1970-2020"
 ]
}

 The dataset includes 294 records from 7 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037976-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.15468/dl.npakn4
title: Occurrence Download

description: A dataset containing 47703 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Continent is Europe",
 "Country is Germany",
 "DatasetKey is EOD – eBird Observation Dataset",
 "Geometry POLYGON((-212 -90,147 -90,147 90,-212 90,-212 -90))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "TaxonKey is Apus apus"
 ]
}

 The dataset includes 47703 records from 1 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037977-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.17481536
title: Confinement Effects on the RhCp* / Polyoxometalate System in Photochemical CO2 Reduction Reactions: Porous Organic Polymer vs. Metal–Organic Framework

description: This data publication is based on the metadata and datasets underlying the manuscript: "Confinement Effects on the RhCp* / Polyoxometalate System in Photochemical CO2 Reduction Reactions: Porous Organic Polymer vs. Metal–Organic Framework"

A readme file containing all descriptions can be found in the main folder.
description: The incorporation of polyoxometalates (POMs) into transition metal-based photosystems has emerged as an effective strategy to boost photocatalytic performances for CO2 and water reduction into renewable energy vectors, in the presence of sacrificial electron donors. Despite significant progress in designing {POM,porous host} composites containing isolated catalytically active metal complexes, the atomic-level understanding of their structure-function relationship remains limited. Here, we investigate the effect of encapsulated [PW12O40]3- POMs on the photocatalytic CO2 reduction (CRR) performance of a Rh-catalyst, namely the pentamethylcyclopentadienyl rhodium(III) (Cp*Rh), immobilized in X-ray amorphous porous organic polymers (POPs) and compare it with that of its crystalline counterpart, i.e. the Cp*Rh-functionalized Zr-based UiO-67 MOF. While the incorporated POM enhances overall activity in both systems, (POM,Rh)@POPs show a stronger shift in selectivity toward the hydrogen evolution reaction (HER). By combining the high sensitivity of Dynamic Nuclear Polarization enhanced NMR spectroscopy with atomistic computational modelling techniques, we elucidate the POMs’ location, speciation and host-guest interactions within the amorphous POP matrices. The results reveal that in presence of solvent, electrostatic anchoring of POMs to the POP’s backbone promotes the accumulation of HTEOA+ proton donors near Rh active sites, favoring HER. The latter contrasts with the confinement of the POM within the narrower pores of UiO-67, which limits such POM···HTEOA+ interactions, resulting in higher HCOOH:H2 ratios and thus a higher selectivity for formic acid.
DOI: 10.5281/zenodo.17481537
title: Confinement Effects on the RhCp* / Polyoxometalate System in Photochemical CO2 Reduction Reactions: Porous Organic Polymer vs. Metal–Organic Framework

description: This data publication is based on the metadata and datasets underlying the manuscript: "Confinement Effects on the RhCp* / Polyoxometalate System in Photochemical CO2 Reduction Reactions: Porous Organic Polymer vs. Metal–Organic Framework"

A readme file containing all descriptions can be found in the main folder.
description: The incorporation of polyoxometalates (POMs) into transition metal-based photosystems has emerged as an effective strategy to boost photocatalytic performances for CO2 and water reduction into renewable energy vectors, in the presence of sacrificial electron donors. Despite significant progress in designing {POM,porous host} composites containing isolated catalytically active metal complexes, the atomic-level understanding of their structure-function relationship remains limited. Here, we investigate the effect of encapsulated [PW12O40]3- POMs on the photocatalytic CO2 reduction (CRR) performance of a Rh-catalyst, namely the pentamethylcyclopentadienyl rhodium(III) (Cp*Rh), immobilized in X-ray amorphous porous organic polymers (POPs) and compare it with that of its crystalline counterpart, i.e. the Cp*Rh-functionalized Zr-based UiO-67 MOF. While the incorporated POM enhances overall activity in both systems, (POM,Rh)@POPs show a stronger shift in selectivity toward the hydrogen evolution reaction (HER). By combining the high sensitivity of Dynamic Nuclear Polarization enhanced NMR spectroscopy with atomistic computational modelling techniques, we elucidate the POMs’ location, speciation and host-guest interactions within the amorphous POP matrices. The results reveal that in presence of solvent, electrostatic anchoring of POMs to the POP’s backbone promotes the accumulation of HTEOA+ proton donors near Rh active sites, favoring HER. The latter contrasts with the confinement of the POM within the narrower pores of UiO-67, which limits such POM···HTEOA+ interactions, resulting in higher HCOOH:H2 ratios and thus a higher selectivity for formic acid.
DOI: 10.25919/9s3b-bb97
title: Parkes observations for project P1386 semester 2025OCTS_07

description: J0045-7319 is a B star/pulsar binary in the Small Magellanic Cloud (SMC) with an orbital period of 51 days. The system is highly eccentric, with a closest approach of only 6 B-star radii, and it offers an unusual probe into massive stars in the SMC. Although similar systems exhibit strong dispersion measure (DM) variation during periastron arising from the stellar wind, observations in 1996 on the Parkes 70 cm receiver found no evidence of a wind from the B star. We propose a new set of observations on the Ultra-Wide Low-frequency receiver (UWL) designed to measure the wind. A null result will decrease the known upper limit on the B-star wind's contribution to DM by a factor of 9.
DOI: 10.15468/dl.73x7h8
title: Occurrence Download

description: A dataset containing 103097 species occurrences available in GBIF matching the query:
{
 "and" : [
 "TaxonKey is Pezizales",
 "Country is United States of America",
 "HasCoordinate is true"
 ]
}

 The dataset includes 103097 records from 112 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037972-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.17612921
title: Dados de Transplantes de Órgãos (Correlação entre datasets GODT e HDRO)

description: A fonte de dados contida nesse repositório "df_transplants.csv" é um arquivo do tipo CSV que utiliza como separador de campos o caractere ';' (ponto e vírgula).

Ela contém a correlação da fonte  de dados do Global Observatory on Donation and Transplantation (GODT) e da fonte de dados do Human Development Report Office (HDRO).

Essa fonte foi criada no dia 16/11/2025.

Essa fonte possui duas colunas adicionais em relação à versão anterior (DOI https://doi.org/10.5281/zenodo.17612922).

As colunas são:



TOTAL tx (total de transplantes): TOTAL tx=TOTAL Kidney Tx + TOTAL Liver TX + Total Heart TX + TOTAL Lung Tx + Pancreas Tx + Small Bowel Tx ;e

pmp_TOTAL tx: Total de transplantes (pmp).
DOI: 10.5281/zenodo.17624833
title: Dados de Transplantes de Órgãos (Correlação entre datasets GODT e HDRO)

description: A fonte de dados contida nesse repositório "df_transplants.csv" é um arquivo do tipo CSV que utiliza como separador de campos o caractere ';' (ponto e vírgula).

Ela contém a correlação da fonte  de dados do Global Observatory on Donation and Transplantation (GODT) e da fonte de dados do Human Development Report Office (HDRO).

Essa fonte foi criada no dia 16/11/2025.

Essa fonte possui duas colunas adicionais em relação à versão anterior (DOI https://doi.org/10.5281/zenodo.17612922).

As colunas são:



TOTAL tx (total de transplantes): TOTAL tx=TOTAL Kidney Tx + TOTAL Liver TX + Total Heart TX + TOTAL Lung Tx + Pancreas Tx + Small Bowel Tx ;e

pmp_TOTAL tx: Total de transplantes (pmp).
DOI: 10.15468/dl.vx2v7m
title: Occurrence Download

description: A dataset containing 76 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Country is Morocco",
 "TaxonKey is Androctonus mauritanicus"
 ]
}

 The dataset includes 76 records from 8 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037978-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.34740/kaggle/dsv/13757935
title: Efficacy of Inactivated Vaccine
DOI: 10.15468/dl.2vzyxk
title: Occurrence Download

description: A dataset containing 208006 species occurrences available in GBIF matching the query:
{
 "and" : [
 "Geometry POLYGON((-4.02217 62.75404,-5.96238 58.75235,-3.84027 53.65929,0.04015 49.23318,8.77497 51.81176,11.98459 55.41761,11.37827 59.6012,3.72353 63.48162,-4.02217 62.75404))",
 "HasCoordinate is true",
 "HasGeospatialIssue is false",
 "OccurrenceStatus is Present",
 "TaxonKey is Phocoena phocoena",
 "Year 2015-2025"
 ]
}

 The dataset includes 208006 records from 76 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0037974-251025141854904/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.
DOI: 10.5281/zenodo.17624871
title: Amethyst queries

description: SELECT t.id, t.title_english, t.title_language, t.languageFROM (    SELECT         a.id,        a.title_english,        a.title_language,        a.language,        @rn := IF(@prev = a.title_language, @rn + 1, 1) AS rn,        @prev := a.title_language AS prev_tl    FROM amethyst_1 a    JOIN (        SELECT title_language        FROM amethyst_1        WHERE title_language IS NOT NULL        GROUP BY title_language        HAVING COUNT(*) > 1        ORDER BY COUNT(*) DESC        LIMIT 10000   -- top X duplicated titles    ) top_dup         ON a.title_language = top_dup.title_language    CROSS JOIN (SELECT @rn := 0, @prev := '') vars    ORDER BY a.title_language, a.id) AS tWHERE t.rn <= 5       -- first Y rows per duplicated titleORDER BY t.title_language, t.rn;