Changes between Initial Version and Version 1 of Ticket #476, comment 1
- Timestamp:
- Mar 14, 2013, 3:35:25 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #476, comment 1
initial v1 2 2 3 3 {{{ 4 select count(distinct blood.id), year(spreg.entry_date)4 select year(spreg.entry_date), count(distinct blood.id), count(distinct blood.parent_id) 5 5 from `BioMaterials` rna 6 6 inner join `BioMaterials` sp on substring(rna.name, 1, 9)=substring(sp.name, 1, 9)