Coordinate: 0° 38' S, 76° 9' W
climate data are based on sample 2306
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=2285 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2285SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2238SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2285 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='forattinii' OR junior_species='forattini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='forattinii' OR species='forattini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='forattinii' OR species='forattini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='forattinii' OR junior_species='forattini')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='forattinii' OR species='forattini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='mattogrossensis' OR junior_species='mattogrossensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='mattogrossensis' OR species='mattogrossensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='mattogrossensis' OR species='mattogrossensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='mattogrossensis' OR junior_species='mattogrossensis')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='mattogrossensis' OR species='mattogrossensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='fluminensis' OR junior_species='fluminensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='fluminensis' OR species='fluminensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='fluminensis' OR species='fluminensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='fluminensis' OR junior_species='fluminensis')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='fluminensis' OR species='fluminensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='bambusicolus' OR junior_species='bambusicolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='bambusicolus' OR species='bambusicolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='bambusicolus' OR species='bambusicolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='bambusicolus' OR junior_species='bambusicolus')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='bambusicolus' OR species='bambusicolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='lepidotus' OR junior_species='lepidotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='lepidotus' OR species='lepidotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='lepidotus' OR species='lepidotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='lepidotus' OR junior_species='lepidotus')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='lepidotus' OR species='lepidotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='squamifemur' OR junior_species='squamifemur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='squamifemur' OR species='squamifemur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='squamifemur' OR species='squamifemur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='squamifemur' OR junior_species='squamifemur')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='squamifemur' OR species='squamifemur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='konderi' OR junior_species='konderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='konderi' OR species='konderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='konderi' OR species='konderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='konderi' OR junior_species='konderii')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='konderi' OR species='konderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' 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='Anopheles' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' 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='Anopheles' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chagasia' AND (junior_species='fajardoi' OR junior_species='fajardoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chagasia' AND (species='fajardoi' OR species='fajardoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chagasia' AND (species='fajardoi' OR species='fajardoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chagasia' AND (junior_species='fajardoi' OR junior_species='fajardoii')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='Chagasia' AND (species='fajardoi' OR species='fajardoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bamborum' OR junior_species='bamborum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='bamborum' OR species='bamborum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='bamborum' OR species='bamborum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bamborum' OR junior_species='bamborum')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='bamborum' OR species='bamborum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='browni' OR junior_species='brownii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='browni' OR species='brownii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='browni' OR species='brownii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='browni' OR junior_species='brownii')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='browni' OR species='brownii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='conservator' OR junior_species='conservator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='conservator' OR species='conservator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='conservator' OR species='conservator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='conservator' OR junior_species='conservator')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='conservator' OR species='conservator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bonnei' OR junior_species='bonneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='bonnei' OR species='bonneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='bonnei' OR species='bonneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bonnei' OR junior_species='bonneii')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='bonnei' OR species='bonneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='iridescens' OR junior_species='iridescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='iridescens' OR species='iridescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='iridescens' OR species='iridescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='iridescens' OR junior_species='iridescens')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='iridescens' OR species='iridescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='secundus' OR junior_species='secundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='secundus' OR species='secundus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='secundus' OR species='secundus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='secundus' OR junior_species='secundus')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='secundus' OR species='secundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='urichii' OR junior_species='urichi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='urichii' OR species='urichi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='urichii' OR species='urichi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='urichii' OR junior_species='urichi')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='urichii' OR species='urichi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='wilsoni' OR junior_species='wilsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='wilsoni' OR species='wilsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='wilsoni' OR species='wilsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='wilsoni' OR junior_species='wilsonii')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='wilsoni' OR species='wilsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bonneae' OR junior_species='bonneae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='bonneae' OR species='bonneae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='bonneae' OR species='bonneae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bonneae' OR junior_species='bonneae')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='bonneae' OR species='bonneae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='camposi' OR junior_species='camposii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='camposi' OR species='camposii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='camposi' OR species='camposii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='camposi' OR junior_species='camposii')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='camposi' OR species='camposii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='coronator' OR junior_species='coronator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='coronator' OR species='coronator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='coronator' OR species='coronator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='coronator' OR junior_species='coronator')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='coronator' OR species='coronator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='mollis' OR junior_species='mollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='mollis' OR species='mollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='mollis' OR species='mollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='mollis' OR junior_species='mollis')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='mollis' OR species='mollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='usquatus' OR junior_species='usquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='usquatus' OR species='usquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='usquatus' OR species='usquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='usquatus' OR junior_species='usquatus')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='usquatus' OR species='usquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='chryselatus' OR junior_species='chryselatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='chryselatus' OR species='chryselatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='chryselatus' OR species='chryselatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='chryselatus' OR junior_species='chryselatus')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='chryselatus' OR species='chryselatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pleuristriatus' OR junior_species='pleuristriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pleuristriatus' OR species='pleuristriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pleuristriatus' OR species='pleuristriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pleuristriatus' OR junior_species='pleuristriatus')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='pleuristriatus' OR species='pleuristriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='stonei' OR junior_species='stoneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='stonei' OR species='stoneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='stonei' OR species='stoneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='stonei' OR junior_species='stoneii')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='stonei' OR species='stoneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='eastor' OR junior_species='eastor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='eastor' OR species='eastor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='eastor' OR species='eastor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='eastor' OR junior_species='eastor')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='eastor' OR species='eastor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='elevator' OR junior_species='elevator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='elevator' OR species='elevator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='elevator' OR species='elevator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='elevator' OR junior_species='elevator')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='elevator' OR species='elevator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='evansae' OR junior_species='evansae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='evansae' OR species='evansae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='evansae' OR species='evansae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='evansae' OR junior_species='evansae')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='evansae' OR species='evansae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='iolambdis' OR junior_species='iolambdis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='iolambdis' OR species='iolambdis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='iolambdis' OR species='iolambdis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='iolambdis' OR junior_species='iolambdis')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='iolambdis' OR species='iolambdis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pilosus' OR junior_species='pilosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pilosus' OR species='pilosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pilosus' OR species='pilosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pilosus' OR junior_species='pilosus')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='pilosus' OR species='pilosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='serratimarge' OR junior_species='serratimarge')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='serratimarge' OR species='serratimarge') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='serratimarge' OR species='serratimarge')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='serratimarge' OR junior_species='serratimarge')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='serratimarge' OR species='serratimarge') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='symbletos' OR junior_species='symbletos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='symbletos' OR species='symbletos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='symbletos' OR species='symbletos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='symbletos' OR junior_species='symbletos')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='symbletos' OR species='symbletos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='theobaldi' OR junior_species='theobaldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='theobaldi' OR species='theobaldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='theobaldi' OR species='theobaldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='theobaldi' OR junior_species='theobaldii')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='theobaldi' OR species='theobaldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='vomerifer' OR junior_species='vomerifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='vomerifer' OR species='vomerifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='vomerifer' OR species='vomerifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='vomerifer' OR junior_species='vomerifer')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='vomerifer' OR species='vomerifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haemagogus' AND (junior_species='janthinomys' OR junior_species='janthinomys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haemagogus' AND (species='janthinomys' OR species='janthinomys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haemagogus' AND (species='janthinomys' OR species='janthinomys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haemagogus' AND (junior_species='janthinomys' OR junior_species='janthinomys')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='Haemagogus' AND (species='janthinomys' OR species='janthinomys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='durhamii' OR junior_species='durhami')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limatus' AND (species='durhamii' OR species='durhami') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limatus' AND (species='durhamii' OR species='durhami')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='durhamii' OR junior_species='durhami')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='Limatus' AND (species='durhamii' OR species='durhami') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='flavisetosus' OR junior_species='flavisetosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limatus' AND (species='flavisetosus' OR species='flavisetosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limatus' AND (species='flavisetosus' OR species='flavisetosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limatus' AND (junior_species='flavisetosus' OR junior_species='flavisetosus')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='Limatus' AND (species='flavisetosus' OR species='flavisetosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='allostigma' OR junior_species='allostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lutzia' AND (species='allostigma' OR species='allostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lutzia' AND (species='allostigma' OR species='allostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lutzia' AND (junior_species='allostigma' OR junior_species='allostigma')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='allostigma' OR species='allostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='fulvus' OR junior_species='fulvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='fulvus' OR species='fulvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='fulvus' OR species='fulvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='fulvus' OR junior_species='fulvus')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='Ochlerotatus' AND (species='fulvus' OR species='fulvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='serratus' OR junior_species='serratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='serratus' OR species='serratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='serratus' OR species='serratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='serratus' OR junior_species='serratus')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='Ochlerotatus' AND (species='serratus' OR species='serratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='argyrothorax' OR junior_species='argyrothorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='argyrothorax' OR species='argyrothorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='argyrothorax' OR species='argyrothorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='argyrothorax' OR junior_species='argyrothorax')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='Ochlerotatus' AND (species='argyrothorax' OR species='argyrothorax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onirion' AND (junior_species='imparis' OR junior_species='imparis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onirion' AND (species='imparis' OR species='imparis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onirion' AND (species='imparis' OR species='imparis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onirion' AND (junior_species='imparis' OR junior_species='imparis')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='Onirion' AND (species='imparis' OR species='imparis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthopodomyia' AND (junior_species='fascipes' OR junior_species='fascipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthopodomyia' AND (species='fascipes' OR species='fascipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthopodomyia' AND (species='fascipes' OR species='fascipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthopodomyia' AND (junior_species='fascipes' OR junior_species='fascipes')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='Orthopodomyia' AND (species='fascipes' OR species='fascipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='cingulata' OR junior_species='cingulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='cingulata' OR species='cingulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='cingulata' OR species='cingulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='cingulata' OR junior_species='cingulata')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='Psorophora' AND (species='cingulata' OR species='cingulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='albigenu' OR junior_species='albigenu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='albigenu' OR species='albigenu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='albigenu' OR species='albigenu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='albigenu' OR junior_species='albigenu')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='Psorophora' AND (species='albigenu' OR species='albigenu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='albipes' OR junior_species='albipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='albipes' OR species='albipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='albipes' OR species='albipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='albipes' OR junior_species='albipes')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='Psorophora' AND (species='albipes' OR species='albipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='lanei' OR junior_species='laneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorophora' AND (species='lanei' OR species='laneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorophora' AND (species='lanei' OR species='laneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorophora' AND (junior_species='lanei' OR junior_species='laneii')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='Psorophora' AND (species='lanei' OR species='laneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runchomyia' AND (junior_species='magna' OR junior_species='magna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Runchomyia' AND (species='magna' OR species='magna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Runchomyia' AND (species='magna' OR species='magna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Runchomyia' AND (junior_species='magna' OR junior_species='magna')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='Runchomyia' AND (species='magna' OR species='magna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='luxodens' OR junior_species='luxodens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sabethes' AND (species='luxodens' OR species='luxodens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='luxodens' OR species='luxodens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' AND (junior_species='luxodens' OR junior_species='luxodens')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='Sabethes' AND (species='luxodens' OR species='luxodens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' 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='Sabethes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sabethes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sabethes' 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='Sabethes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhynchites' AND (junior_species='bambusicola' OR junior_species='bambusicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxorhynchites' AND (species='bambusicola' OR species='bambusicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxorhynchites' AND (species='bambusicola' OR species='bambusicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhynchites' AND (junior_species='bambusicola' OR junior_species='bambusicola')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='Toxorhynchites' AND (species='bambusicola' OR species='bambusicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhynchites' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxorhynchites' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxorhynchites' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhynchites' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='Toxorhynchites' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='digitatum' OR junior_species='digitatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichoprosopon' AND (species='digitatum' OR species='digitatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoprosopon' AND (species='digitatum' OR species='digitatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='digitatum' OR junior_species='digitatum')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='Trichoprosopon' AND (species='digitatum' OR species='digitatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='lampropus' OR junior_species='lampropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichoprosopon' AND (species='lampropus' OR species='lampropus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoprosopon' AND (species='lampropus' OR species='lampropus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoprosopon' AND (junior_species='lampropus' OR junior_species='lampropus')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='Trichoprosopon' AND (species='lampropus' OR species='lampropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='calosomata' OR junior_species='calosomata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uranotaenia' AND (species='calosomata' OR species='calosomata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uranotaenia' AND (species='calosomata' OR species='calosomata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uranotaenia' AND (junior_species='calosomata' OR junior_species='calosomata')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='calosomata' OR species='calosomata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='pseudopecten' OR junior_species='pseudopecten')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='pseudopecten' OR species='pseudopecten') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='pseudopecten' OR species='pseudopecten')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='pseudopecten' OR junior_species='pseudopecten')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='Wyeomyia' AND (species='pseudopecten' OR species='pseudopecten') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='ulocoma' OR junior_species='ulocoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='ulocoma' OR species='ulocoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='ulocoma' OR species='ulocoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='ulocoma' OR junior_species='ulocoma')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='Wyeomyia' AND (species='ulocoma' OR species='ulocoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' 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='Wyeomyia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' 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='Wyeomyia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='aphobema' OR junior_species='aphobema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='aphobema' OR species='aphobema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='aphobema' OR species='aphobema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='aphobema' OR junior_species='aphobema')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='Wyeomyia' AND (species='aphobema' OR species='aphobema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='aphobema' OR junior_species='aphobema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='aphobema' OR species='aphobema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='aphobema' OR species='aphobema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='aphobema' OR junior_species='aphobema')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='Wyeomyia' AND (species='aphobema' OR species='aphobema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='autocratica' OR junior_species='autocratica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='autocratica' OR species='autocratica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='autocratica' OR species='autocratica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='autocratica' OR junior_species='autocratica')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='Wyeomyia' AND (species='autocratica' OR species='autocratica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='lamellata' OR junior_species='lamellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='lamellata' OR species='lamellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='lamellata' OR species='lamellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='lamellata' OR junior_species='lamellata')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='Wyeomyia' AND (species='lamellata' OR species='lamellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='codiocampa' OR junior_species='codiocampa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='codiocampa' OR species='codiocampa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='codiocampa' OR species='codiocampa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='codiocampa' OR junior_species='codiocampa')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='Wyeomyia' AND (species='codiocampa' OR species='codiocampa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='oblita' OR junior_species='oblita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='oblita' OR species='oblita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='oblita' OR species='oblita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='oblita' OR junior_species='oblita')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='Wyeomyia' AND (species='oblita' OR species='oblita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='codiocampa' OR junior_species='codiocampa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='codiocampa' OR species='codiocampa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='codiocampa' OR species='codiocampa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='codiocampa' OR junior_species='codiocampa')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='Wyeomyia' AND (species='codiocampa' OR species='codiocampa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='albosquamata' OR junior_species='albosquamata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='albosquamata' OR species='albosquamata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='albosquamata' OR species='albosquamata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='albosquamata' OR junior_species='albosquamata')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='Wyeomyia' AND (species='albosquamata' OR species='albosquamata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='medioalbipes' OR junior_species='medioalbipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wyeomyia' AND (species='medioalbipes' OR species='medioalbipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wyeomyia' AND (species='medioalbipes' OR species='medioalbipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wyeomyia' AND (junior_species='medioalbipes' OR junior_species='medioalbipes')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='Wyeomyia' AND (species='medioalbipes' OR species='medioalbipes') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2285