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 '%Lima (Mantellum) elongata%') 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 '%Lima (Mantellum) elongata%' OR sample_aka LIKE '%Lima (Mantellum) elongata%') 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 'Lima (Mantellum) elongata%' 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 (87733,45763,60317,83125,36334,8932,67881,31055,50825,71442) AND species REGEXP '^[a-z]*$'
Search samples
