Changes between Initial Version and Version 1 of Ticket #476, comment 1


Ignore:
Timestamp:
Mar 14, 2013, 3:35:25 PM (11 years ago)
Author:
Nicklas Nordborg

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #476, comment 1

    initial v1  
    22
    33{{{
    4 select count(distinct blood.id), year(spreg.entry_date)
     4select year(spreg.entry_date), count(distinct blood.id), count(distinct blood.parent_id)
    55from `BioMaterials` rna
    66inner join `BioMaterials` sp on substring(rna.name, 1, 9)=substring(sp.name, 1, 9)