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='Lamna' AND species='acuminata' 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 '%Lamna acuminata%') 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 '%Lamna acuminata%' OR sample_aka LIKE '%Lamna acuminata%') 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 'Lamna acuminata%' 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 (97635,83623,92733,5833,76057,72148,67979,46659,8531,73439) AND species REGEXP '^[a-z]*$'
Search samples
