Coordinate: 0.11353° N, 32.220348° E
climate data are for Kabanyolo University Farm in Mpigi District and are from Okorio et al (1994, Agroforestry Systems)
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=2403 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2403SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2297SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2403 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='argenteopunctatus' OR junior_species='argenteopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='argenteopunctatus' OR species='argenteopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='argenteopunctatus' OR species='argenteopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='argenteopunctatus' OR junior_species='argenteopunctatus')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='Aedes' AND (species='argenteopunctatus' OR species='argenteopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='cumminsii' OR junior_species='cumminsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='cumminsii' OR species='cumminsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='cumminsii' OR species='cumminsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='cumminsii' OR junior_species='cumminsi')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='Aedes' AND (species='cumminsii' OR species='cumminsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='phyllolabis' OR junior_species='phyllolabis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='phyllolabis' OR species='phyllolabis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='phyllolabis' OR species='phyllolabis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='phyllolabis' OR junior_species='phyllolabis')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='Aedes' AND (species='phyllolabis' OR species='phyllolabis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='ingrami' OR junior_species='ingramii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='ingrami' OR species='ingramii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='ingrami' OR species='ingramii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='ingrami' OR junior_species='ingramii')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='Aedes' AND (species='ingrami' OR species='ingramii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='circumluteolus' OR junior_species='circumluteolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='circumluteolus' OR species='circumluteolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='circumluteolus' OR species='circumluteolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='circumluteolus' OR junior_species='circumluteolus')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='Aedes' AND (species='circumluteolus' OR species='circumluteolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='mcintoshi' OR junior_species='mcintoshii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='mcintoshi' OR species='mcintoshii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='mcintoshi' OR species='mcintoshii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='mcintoshi' OR junior_species='mcintoshii')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='Aedes' AND (species='mcintoshi' OR species='mcintoshii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='aegypti' OR junior_species='aegyptii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='aegypti' OR species='aegyptii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='aegypti' OR species='aegyptii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='aegypti' OR junior_species='aegyptii')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='Aedes' AND (species='aegypti' OR species='aegyptii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='simpsoni' OR junior_species='simpsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='simpsoni' OR species='simpsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='simpsoni' OR species='simpsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='simpsoni' OR junior_species='simpsonii')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='Aedes' AND (species='simpsoni' OR species='simpsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='coustani' OR junior_species='coustanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='coustani' OR species='coustanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='coustani' OR species='coustanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='coustani' OR junior_species='coustanii')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='Anopheles' AND (species='coustani' OR species='coustanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='implexus' OR junior_species='implexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='implexus' OR species='implexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='implexus' OR species='implexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='implexus' OR junior_species='implexus')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='Anopheles' AND (species='implexus' OR species='implexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='aurites' OR junior_species='aurites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='aurites' OR species='aurites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='aurites' OR species='aurites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='aurites' OR junior_species='aurites')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='Coquillettidia' AND (species='aurites' OR species='aurites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='fraseri' OR junior_species='fraserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='fraseri' OR species='fraserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='fraseri' OR species='fraserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='fraseri' OR junior_species='fraserii')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='Coquillettidia' AND (species='fraseri' OR species='fraserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='fuscopennata' OR junior_species='fuscopennata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='fuscopennata' OR species='fuscopennata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='fuscopennata' OR species='fuscopennata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='fuscopennata' OR junior_species='fuscopennata')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='Coquillettidia' AND (species='fuscopennata' OR species='fuscopennata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='maculipennis' OR junior_species='maculipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='maculipennis' OR species='maculipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='maculipennis' OR species='maculipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='maculipennis' OR junior_species='maculipennis')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='Coquillettidia' AND (species='maculipennis' OR species='maculipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='metallica' OR junior_species='metallica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='metallica' OR species='metallica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='metallica' OR species='metallica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='metallica' OR junior_species='metallica')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='Coquillettidia' AND (species='metallica' OR species='metallica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='pseudoconopas' OR junior_species='pseudoconopas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='pseudoconopas' OR species='pseudoconopas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='pseudoconopas' OR species='pseudoconopas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='pseudoconopas' OR junior_species='pseudoconopas')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='Coquillettidia' AND (species='pseudoconopas' OR species='pseudoconopas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coquillettidia' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' AND (junior_species='versicolor' OR junior_species='versicolor')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='Coquillettidia' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' 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='Coquillettidia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coquillettidia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coquillettidia' 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='Coquillettidia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='antennatus' OR junior_species='antennatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='antennatus' OR species='antennatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='antennatus' OR species='antennatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='antennatus' OR junior_species='antennatus')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='Culex' AND (species='antennatus' OR species='antennatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='decens' OR junior_species='decens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='decens' OR species='decens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='decens' OR species='decens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='decens' OR junior_species='decens')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='Culex' AND (species='decens' OR species='decens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='ornatothoracis' OR junior_species='ornatothoracis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='ornatothoracis' OR species='ornatothoracis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='ornatothoracis' OR species='ornatothoracis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='ornatothoracis' OR junior_species='ornatothoracis')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='Culex' AND (species='ornatothoracis' OR species='ornatothoracis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='cinereus' OR species='cinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='cinereus' OR junior_species='cinereus')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='Culex' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='nebulosus' OR junior_species='nebulosus')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='Culex' AND (species='nebulosus' OR species='nebulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='insignis' OR junior_species='insignis')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='Culex' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='rubinotus' OR junior_species='rubinotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='rubinotus' OR species='rubinotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='rubinotus' OR species='rubinotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='rubinotus' OR junior_species='rubinotus')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='Culex' AND (species='rubinotus' OR species='rubinotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='annulioris' OR species='annulioris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')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='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='annulioris' OR species='annulioris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='annulioris' OR junior_species='annulioris')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='Culex' AND (species='annulioris' OR species='annulioris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='poicilipes' OR junior_species='poicilipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='poicilipes' OR species='poicilipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='poicilipes' OR species='poicilipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='poicilipes' OR junior_species='poicilipes')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='Culex' AND (species='poicilipes' OR species='poicilipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hodgesia' AND (junior_species='sanguinae' OR junior_species='sanguinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hodgesia' AND (species='sanguinae' OR species='sanguinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hodgesia' AND (species='sanguinae' OR species='sanguinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hodgesia' AND (junior_species='sanguinae' OR junior_species='sanguinae')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='Hodgesia' AND (species='sanguinae' OR species='sanguinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hodgesia' 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='Hodgesia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hodgesia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hodgesia' 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='Hodgesia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='tigripes' OR junior_species='tigripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lutzia' AND (species='tigripes' OR species='tigripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lutzia' AND (species='tigripes' OR species='tigripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='tigripes' OR junior_species='tigripes')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='Lutzia' AND (species='tigripes' OR species='tigripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')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='Mansonia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='africana' OR junior_species='africana')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='Mansonia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='uniformis' OR junior_species='uniformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mansonia' AND (species='uniformis' OR species='uniformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mansonia' AND (species='uniformis' OR species='uniformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mansonia' AND (junior_species='uniformis' OR junior_species='uniformis')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='Mansonia' AND (species='uniformis' OR species='uniformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='mashonaensis' OR junior_species='mashonaensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='mashonaensis' OR species='mashonaensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='mashonaensis' OR species='mashonaensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='mashonaensis' OR junior_species='mashonaensis')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='Uranotaenia' AND (species='mashonaensis' OR species='mashonaensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='alboabdominalis' OR junior_species='alboabdominalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='alboabdominalis' OR species='alboabdominalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='alboabdominalis' OR species='alboabdominalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='alboabdominalis' OR junior_species='alboabdominalis')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='Uranotaenia' AND (species='alboabdominalis' OR species='alboabdominalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='palidocephala' OR junior_species='palidocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='palidocephala' OR species='palidocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='palidocephala' OR species='palidocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='palidocephala' OR junior_species='palidocephala')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='Uranotaenia' AND (species='palidocephala' OR species='palidocephala') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2403