Coordinate: 37.44° N, 127.08° E
climate data are for Gwangneung and are from Hong et al. (2012, Q. J. R. Meteorol. Soc.)
SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=1789 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1789SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1300SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1789 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphaenogaster' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='atrox' OR junior_species='atrox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='atrox' OR species='atrox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='atrox' OR species='atrox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='atrox' OR junior_species='atrox')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='atrox' OR species='atrox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='japonicus' OR species='japonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='japonicus' OR species='japonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='japonicus' OR species='japonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='kiusuensis' OR junior_species='kiusuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='kiusuensis' OR species='kiusuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='kiusuensis' OR species='kiusuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='kiusuensis' OR junior_species='kiusuensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camponotus' AND (species='kiusuensis' OR species='kiusuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnotus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campnotus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campnotus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnotus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campnotus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='matsumurai' OR junior_species='matsumuraii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='matsumurai' OR species='matsumuraii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='matsumurai' OR species='matsumuraii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='matsumurai' OR junior_species='matsumuraii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='matsumurai' OR species='matsumuraii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='teranishi' OR junior_species='teranishii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='teranishi' OR species='teranishii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='teranishi' OR species='teranishii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='teranishi' OR junior_species='teranishii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crematogaster' AND (species='teranishi' OR species='teranishii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptone' AND (junior_species='sauteri' OR junior_species='sauterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptone' AND (species='sauteri' OR species='sauterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptone' AND (species='sauteri' OR species='sauterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptone' AND (junior_species='sauteri' OR junior_species='sauterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cryptone' AND (species='sauteri' OR species='sauterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formica' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='sauteri' OR junior_species='sauterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoponera' AND (species='sauteri' OR species='sauterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoponera' AND (species='sauteri' OR species='sauterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoponera' AND (junior_species='sauteri' OR junior_species='sauterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoponera' AND (species='sauteri' OR species='sauterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='japonicus' OR species='japonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='japonicus' OR species='japonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='japonicus' OR junior_species='japonicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasius' AND (species='japonicus' OR species='japonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecina' AND (junior_species='nipponica' OR junior_species='nipponica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmecina' AND (species='nipponica' OR species='nipponica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmecina' AND (species='nipponica' OR species='nipponica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecina' AND (junior_species='nipponica' OR junior_species='nipponica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmecina' AND (species='nipponica' OR species='nipponica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nylanderia' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nylanderia' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nylanderia' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nylanderia' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nylanderia' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='javana' OR junior_species='javana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycondyla' AND (species='javana' OR species='javana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycondyla' AND (species='javana' OR species='javana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycondyla' AND (junior_species='javana' OR junior_species='javana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycondyla' AND (species='javana' OR species='javana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fervida' OR junior_species='fervida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='fervida' OR species='fervida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='fervida' OR species='fervida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='fervida' OR junior_species='fervida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheidole' AND (species='fervida' OR species='fervida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ponera' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ponera' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ponera' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ponera' AND (junior_species='japonica' OR junior_species='japonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ponera' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristomyrmex' AND (junior_species='pugens' OR junior_species='pugens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristomyrmex' AND (species='pugens' OR species='pugens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristomyrmex' AND (species='pugens' OR species='pugens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristomyrmex' AND (junior_species='pugens' OR junior_species='pugens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pristomyrmex' AND (species='pugens' OR species='pugens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='lewisi' OR junior_species='lewisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strumigenys' AND (species='lewisi' OR species='lewisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strumigenys' AND (species='lewisi' OR species='lewisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strumigenys' AND (junior_species='lewisi' OR junior_species='lewisii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strumigenys' AND (species='lewisi' OR species='lewisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnothorax' AND (junior_species='nassonovi' OR junior_species='nassonovii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temnothorax' AND (species='nassonovi' OR species='nassonovii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temnothorax' AND (species='nassonovi' OR species='nassonovii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnothorax' AND (junior_species='nassonovi' OR junior_species='nassonovii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Temnothorax' AND (species='nassonovi' OR species='nassonovii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vollenhovia' AND (junior_species='emryie' OR junior_species='emryie')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vollenhovia' AND (species='emryie' OR species='emryie') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vollenhovia' AND (species='emryie' OR species='emryie')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vollenhovia' AND (junior_species='emryie' OR junior_species='emryie')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vollenhovia' AND (species='emryie' OR species='emryie') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1789