SELECT 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,register t2 WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=t2.sample_no AND genus='Epiaster' GROUP BY t.sample_no SELECT 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 (life_forms LIKE '%Epiaster%') GROUP BY t.sample_no SELECT 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 (sample_name LIKE '%Epiaster%' OR sample_aka LIKE '%Epiaster%') GROUP BY t.sample_no SELECT 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.country LIKE 'Epiaster%' GROUP BY t.sample_no SELECT sql FROM sqlite_master WHERE tbl_name='samples'; SELECT DISTINCT(life_forms) FROM samples; SELECT DISTINCT(life_forms) AS val FROM samples SELECT sql FROM sqlite_master WHERE tbl_name='samples'; SELECT sql FROM sqlite_master WHERE tbl_name='samples'; SELECT genus FROM register WHERE register_no IN (92726,55193,65263,11653,27474,51330,27453,24554,32076,57111) AND species REGEXP '^[a-z]*$'
Search samples
