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='Bulimina' AND species='inflata' 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 '%Bulimina inflata%') 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 '%Bulimina inflata%' OR sample_aka LIKE '%Bulimina inflata%') 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 'Bulimina inflata%' 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 (83764,33262,4189,66783,69563,75414,81989,93313,2076,95968) AND species REGEXP '^[a-z]*$'
Search samples
