Overall - Records (individuals)
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 39: ORDER BY "records" LIMIT 21
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Zambezi' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, GSN' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, South' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North Central' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Kavango' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Greater Fish River' and
CONCAT(p.surname, ', ', p.first_name) !='Event Book, HWC data' and
CONCAT(p.surname, ', ', p.first_name) !='Carnivore Tracker, App' and
CONCAT(p.surname, ', ', p.first_name) !='Museums, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Warden, Moewe Bay' and
CONCAT(p.surname, ', ', p.first_name) !='Nest records, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Kwando Carnivore, Project' and
CONCAT(p.surname, ', ', p.first_name) !='Brown Hyena Research, Project' and
CONCAT(p.surname, ', ', p.first_name) not like 'Cheetah Conservation, Fund' and
CONCAT(p.surname, ', ', p.first_name) !='IZW, Berlin' and
CONCAT(p.surname, ', ', p.first_name) not like 'Naankuse, Group' and
CONCAT(p.surname, ', ', p.first_name) !='AfriCat, North' and
CONCAT(p.surname, ', ', p.first_name) !='Ongava, Research Centre' and
CONCAT(p.surname, ', ', p.first_name) !='Gondwana, Collection' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, Nyae Nyae' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Otjozondjupa' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Zambezi'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 21
Overall - Species (individuals)
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 40: ORDER BY "records" LIMIT 21
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Zambezi' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, GSN' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, South' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, North Central' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Kavango' and
CONCAT(p.surname, ', ', p.first_name) !='Game Count, Greater Fish River' and
CONCAT(p.surname, ', ', p.first_name) !='Event Book, HWC data' and
CONCAT(p.surname, ', ', p.first_name) !='Carnivore Tracker, App' and
CONCAT(p.surname, ', ', p.first_name) !='Museums, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Warden, Moewe Bay' and
CONCAT(p.surname, ', ', p.first_name) !='Nest records, Various' and
CONCAT(p.surname, ', ', p.first_name) !='Kwando Carnivore, Project' and
CONCAT(p.surname, ', ', p.first_name) !='Brown Hyena Research, Project' and
CONCAT(p.surname, ', ', p.first_name) not like 'Cheetah Conservation, Fund' and
CONCAT(p.surname, ', ', p.first_name) !='IZW, Berlin' and
CONCAT(p.surname, ', ', p.first_name) not like 'Naankuse, Group' and
CONCAT(p.surname, ', ', p.first_name) !='AfriCat, North' and
CONCAT(p.surname, ', ', p.first_name) !='Ongava, Research Centre' and
CONCAT(p.surname, ', ', p.first_name) !='Gondwana, Collection' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, North West' and
CONCAT(p.surname, ', ', p.first_name) !='Waterhole Count, Nyae Nyae' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Otjozondjupa' and
CONCAT(p.surname, ', ', p.first_name) !='Game Guard Patrol, Zambezi'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 21
Overall - Records (groups)
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 36: ORDER BY "records" LIMIT 21
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) = 'Game Count, Zambezi' and
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Zambezi' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, North West' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, GSN' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, South' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Kavango' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, North Central' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Greater Fish River' or
CONCAT(p.surname, ', ', p.first_name) ='Event Book, HWC data' or
CONCAT(p.surname, ', ', p.first_name) ='Carnivore Tracker, App' or
CONCAT(p.surname, ', ', p.first_name) ='Museums, Various' or
CONCAT(p.surname, ', ', p.first_name) ='Warden, Moewe Bay' or
CONCAT(p.surname, ', ', p.first_name) ='Nest records, Various' or
CONCAT(p.surname, ', ', p.first_name) ='Kwando Carnivore, Project' or
CONCAT(p.surname, ', ', p.first_name) ='Brown Hyena Research, Project' or
CONCAT(p.surname, ', ', p.first_name) like 'Cheetah Conservation, Fund' or
CONCAT(p.surname, ', ', p.first_name) ='IZW, Berlin' or
CONCAT(p.surname, ', ', p.first_name) like 'Naankuse, Group' or
CONCAT(p.surname, ', ', p.first_name) ='AfriCat, North' or
CONCAT(p.surname, ', ', p.first_name) ='Ongava, Research Centre' or
CONCAT(p.surname, ', ', p.first_name) ='Gondwana, Collection' or
CONCAT(p.surname, ', ', p.first_name) ='Waterhole Count, North West' or
CONCAT(p.surname, ', ', p.first_name) ='Waterhole Count, Nyae Nyae' or
CONCAT(p.surname, ', ', p.first_name) ='Game Guard Patrol, Otjozondjupa' or
CONCAT(p.surname, ', ', p.first_name) ='Game Guard Patrol, Zambezi'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 21
Overall - Species (groups)
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 37: ORDER BY "records" LIMIT 21
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) = 'Game Count, Zambezi' and
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Zambezi' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, North West' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, GSN' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, South' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Kavango' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, North Central' or
CONCAT(p.surname, ', ', p.first_name) ='Game Count, Greater Fish River' or
CONCAT(p.surname, ', ', p.first_name) ='Event Book, HWC data' or
CONCAT(p.surname, ', ', p.first_name) ='Carnivore Tracker, App' or
CONCAT(p.surname, ', ', p.first_name) ='Museums, Various' or
CONCAT(p.surname, ', ', p.first_name) ='Warden, Moewe Bay' or
CONCAT(p.surname, ', ', p.first_name) ='Nest records, Various' or
CONCAT(p.surname, ', ', p.first_name) ='Kwando Carnivore, Project' or
CONCAT(p.surname, ', ', p.first_name) ='Brown Hyena Research, Project' or
CONCAT(p.surname, ', ', p.first_name) like 'Cheetah Conservation, Fund' or
CONCAT(p.surname, ', ', p.first_name) ='IZW, Berlin' or
CONCAT(p.surname, ', ', p.first_name) like 'Naankuse, Group'or
CONCAT(p.surname, ', ', p.first_name) ='AfriCat, North' or
CONCAT(p.surname, ', ', p.first_name) ='Ongava, Research Centre' or
CONCAT(p.surname, ', ', p.first_name) ='Gondwana, Collection' or
CONCAT(p.surname, ', ', p.first_name) ='Waterhole Count, North West' or
CONCAT(p.surname, ', ', p.first_name) ='Waterhole Count, Nyae Nyae' or
CONCAT(p.surname, ', ', p.first_name) ='Game Guard Patrol, Otjozondjupa' or
CONCAT(p.surname, ', ', p.first_name) ='Game Guard Patrol, Zambezi'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 21
Land Mammals (including bats and carnivores) - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='10' or taxon_group_id='5' or taxon_group_id='12'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Land Mammal (including bats and carnivores) - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='10' or taxon_group_id='5' or taxon_group_id='12'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Marine Mammals - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='8'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Marine Mammals - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='8'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Indigenous Plants - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='20'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Indigenous Plants - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='20'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Alien Plants - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='6'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Alien Plants - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='6'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Snakes - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='14'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Snakes - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='14'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Other Reptiles - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='15'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Other Reptiles - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='15'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Butterflies - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='17'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Butterflies - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 16: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='17'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Dragonflies and damselflies - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='21'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Dragonflies and damselflies - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 16: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='21'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Amphibians - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='4'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Amphibians - Species
Ranked by number of speciesThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 17: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Transmitter' and
CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='Old carnivore atlas' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='4'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Archaeology and heritage - Records
Ranked by number of recordsThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 15: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(of.id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='18'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11
Archaeology and heritage - Features
Ranked by number of types of featuresThere was an SQL error: ERROR: syntax error at or near "ORDER"
LINE 15: ORDER BY "records" LIMIT 11
^ -
SELECT CONCAT(p.surname, ', ', p.first_name) as recorders, count(distinct of.taxon_meaning_id) as records
FROM cache_occurrences_functional of
JOIN users u on u.id=of.created_by_id
JOIN people p on p.id=u.person_id
WHERE CONCAT(p.surname, ', ', p.first_name) !='Jarvis, Alice' and
CONCAT(p.surname, ', ', p.first_name) !='admin'
AND taxon_group_id='18'
GROUP BY p.first_name, p.surname, of.created_by_id, u.id ORDER by records DESC
ORDER BY "records" LIMIT 11