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=1328 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1328SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=888SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1328 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachliopta' AND (junior_species='hector' OR junior_species='hector')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachliopta' AND (species='hector' OR species='hector') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachliopta' AND (species='hector' OR species='hector')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachliopta' AND (junior_species='hector' OR junior_species='hector')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='Pachliopta' AND (species='hector' OR species='hector') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachliopta' AND (junior_species='aristolachiae' OR junior_species='aristolachiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachliopta' AND (species='aristolachiae' OR species='aristolachiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachliopta' AND (species='aristolachiae' OR species='aristolachiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachliopta' AND (junior_species='aristolachiae' OR junior_species='aristolachiae')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='Pachliopta' AND (species='aristolachiae' OR species='aristolachiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polytes' OR species='polytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polytes' OR species='polytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')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='Papilio' AND (species='polytes' OR species='polytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polymnestor' OR junior_species='polymnestor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polymnestor' OR species='polymnestor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polymnestor' OR species='polymnestor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polymnestor' OR junior_species='polymnestor')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='Papilio' AND (species='polymnestor' OR species='polymnestor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='doson' OR junior_species='doson')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='doson' OR species='doson') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='doson' OR species='doson')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='doson' OR junior_species='doson')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='Graphium' AND (species='doson' OR species='doson') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')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='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='nina' OR species='nina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')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='Leptosia' AND (species='nina' OR species='nina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebomoia' AND (junior_species='glaucippe' OR junior_species='glaucippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hebomoia' AND (species='glaucippe' OR species='glaucippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hebomoia' AND (species='glaucippe' OR species='glaucippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hebomoia' AND (junior_species='glaucippe' OR junior_species='glaucippe')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='Hebomoia' AND (species='glaucippe' OR species='glaucippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')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='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='philomela' OR junior_species='philomela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='philomela' OR species='philomela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='philomela' OR species='philomela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='philomela' OR junior_species='philomela')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='Ypthima' AND (species='philomela' OR species='philomela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='drypetis' OR junior_species='drypetis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='drypetis' OR species='drypetis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='drypetis' OR species='drypetis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='drypetis' OR junior_species='drypetis')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='Lethe' AND (species='drypetis' OR species='drypetis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='patnia' OR junior_species='patnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='patnia' OR species='patnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='patnia' OR species='patnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='patnia' OR junior_species='patnia')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='Mycalesis' AND (species='patnia' OR species='patnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='mineus' OR species='mineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')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='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='hylas' OR species='hylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')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='Neptis' AND (species='hylas' OR species='hylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libythea' AND (species='lepita' OR species='lepita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libythea' AND (species='lepita' OR species='lepita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')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='Libythea' AND (species='lepita' OR species='lepita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='iphita' OR junior_species='iphita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='iphita' OR species='iphita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='iphita' OR species='iphita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='iphita' OR junior_species='iphita')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='Junonia' AND (species='iphita' OR species='iphita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='lemonias' OR junior_species='lemonias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='lemonias' OR species='lemonias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='lemonias' OR species='lemonias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='lemonias' OR junior_species='lemonias')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='Junonia' AND (species='lemonias' OR species='lemonias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallima' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='horsfieldi' OR species='horsfieldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')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='Kallima' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='genutia' OR junior_species='genutia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='genutia' OR species='genutia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='genutia' OR species='genutia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='genutia' OR junior_species='genutia')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='Danaus' AND (species='genutia' OR species='genutia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='septentrionis' OR junior_species='septentrionis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='septentrionis' OR species='septentrionis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='septentrionis' OR species='septentrionis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='septentrionis' OR junior_species='septentrionis')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='Danaus' AND (species='septentrionis' OR species='septentrionis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aglea' OR junior_species='aglea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='aglea' OR species='aglea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='aglea' OR species='aglea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aglea' OR junior_species='aglea')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='Parantica' AND (species='aglea' OR species='aglea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tirumala' AND (junior_species='limniace' OR junior_species='limniace')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tirumala' AND (species='limniace' OR species='limniace') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tirumala' AND (species='limniace' OR species='limniace')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tirumala' AND (junior_species='limniace' OR junior_species='limniace')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='Tirumala' AND (species='limniace' OR species='limniace') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='core' OR junior_species='core')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='core' OR species='core') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='core' OR species='core')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='core' OR junior_species='core')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='Euploea' AND (species='core' OR species='core') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizula' AND (species='hylax' OR species='hylax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizula' AND (species='hylax' OR species='hylax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='hylax' OR junior_species='hylax')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='Zizula' AND (species='hylax' OR species='hylax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='bochus' OR junior_species='bochus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='bochus' OR species='bochus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='bochus' OR species='bochus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='bochus' OR junior_species='bochus')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='Jamides' AND (species='bochus' OR species='bochus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='celeno' OR species='celeno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')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='Jamides' AND (species='celeno' OR species='celeno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblypodia' AND (junior_species='anita' OR junior_species='anita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblypodia' AND (species='anita' OR species='anita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblypodia' AND (species='anita' OR species='anita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblypodia' AND (junior_species='anita' OR junior_species='anita')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='Amblypodia' AND (species='anita' OR species='anita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celanorrhinus' AND (junior_species='leucocera' OR junior_species='leucocera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celanorrhinus' AND (species='leucocera' OR species='leucocera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celanorrhinus' AND (species='leucocera' OR species='leucocera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celanorrhinus' AND (junior_species='leucocera' OR junior_species='leucocera')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='Celanorrhinus' AND (species='leucocera' OR species='leucocera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coladenia' AND (junior_species='indrani' OR junior_species='indranii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coladenia' AND (species='indrani' OR species='indranii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coladenia' AND (species='indrani' OR species='indranii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coladenia' AND (junior_species='indrani' OR junior_species='indranii')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='Coladenia' AND (species='indrani' OR species='indranii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='salsala' OR junior_species='salsala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iambrix' AND (species='salsala' OR species='salsala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iambrix' AND (species='salsala' OR species='salsala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iambrix' AND (junior_species='salsala' OR junior_species='salsala')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='Iambrix' AND (species='salsala' OR species='salsala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='homolea' OR junior_species='homolea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halpe' AND (species='homolea' OR species='homolea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halpe' AND (species='homolea' OR species='homolea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halpe' AND (junior_species='homolea' OR junior_species='homolea')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='Halpe' AND (species='homolea' OR species='homolea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telicota' AND (junior_species='ancilla' OR junior_species='ancilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telicota' AND (species='ancilla' OR species='ancilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telicota' AND (species='ancilla' OR species='ancilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telicota' AND (junior_species='ancilla' OR junior_species='ancilla')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='Telicota' AND (species='ancilla' OR species='ancilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psolos' AND (junior_species='fuligo' OR junior_species='fuligo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psolos' AND (species='fuligo' OR species='fuligo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psolos' AND (species='fuligo' OR species='fuligo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psolos' AND (junior_species='fuligo' OR junior_species='fuligo')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='Psolos' AND (species='fuligo' OR species='fuligo') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1328 The Ecological Register: Siruvattukadu Kombei (F1)
Siruvattukadu Kombei (F1)
Basic information
Sample name: Siruvattukadu Kombei (F1)

Sample aka: Palni Hills

Reference: G. Shahabuddin and R. Ali. 2001. Impacts of land use change on forest butterfly communities in the Western Ghats of southern India. Journal of Tropical Forest Science 13(3):434-449 [ER 888]
Geography
Country: India

State: Tamil Nadu


Coordinate: 10° 23' N, 77° 40' E
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges given in the text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAP: 1000.0

Habitat comments: "a mix of moist and dry deciduous associations, with an evergreen understorey layer in many places"

Methods
Life forms: butterflies

Site length: 200

Site width: 10

Sampling methods: line transect,visual

Sample size: 181 individuals

Years: 1992

Days: 20

Sampling comments: 200 m line transect surveyed during 20 different days

Metadata
Sample number: 1328

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-21 13:57:33

Modified: 2015-02-21 02:57:33

Abundance distribution
33 species
14 singletons
total count 181
extrapolated richness: 75.6
Fisher's α: 11.819
geometric series k: 0.8965
Hurlbert's PIE: 0.9089
Shannon's H: 2.8141
Good's u: 0.9230
Each square represents a species. Square sizes are proportional to counts.
Register