mysql> EXPLAIN SELECT count(*) from Specimen s join ColRange cr on cr.Id = s.ColrangeId join LocalityNew ln on ln.Id = cr.LocalityId join Taxa t on t.Id = s.TaxaId join Genus g on g.Id =  t.GenusId left join Collector c on c.id = s.CollectorId left join SpecimenType st on s.SpecimenType = st.SPecimenType left join Island i on i.id = ln.IslandId left join Eparchia e on e.Id = ln.EparchiaID left join Nomos n on n.Id = e.NomosId left join Family f on f.Id = g.FamilyId left join Mountain m on m.Id = ln.MountainId  left join Litterature li on li.Id = s.LittId;
+----+-------------+-------+--------+-------------------------------------------------------------------------------+-----------------+---------+-------------------------------+------+-------------+
| id | select_type | table | type   | possible_keys                                                                 | key             | key_len | ref                           | rows | Extra       |
+----+-------------+-------+--------+-------------------------------------------------------------------------------+-----------------+---------+-------------------------------+------+-------------+
|  1 | SIMPLE      | g     | index  | PRIMARY                                                                       | genus_FamilyId  |       4 | NULL                          | 1113 | Using index |
|  1 | SIMPLE      | t     | ref    | PRIMARY,IX_Taxa,taxa_GenusId                                                  | taxa_GenusId    |       4 | florahellenica.g.Id           |    4 | Using index |
|  1 | SIMPLE      | s     | ref    | IX_Specimen_ColRangeId,IX_Specimen_TaxaId,specimen_TaxaId,specimen_ColRangeId | specimen_TaxaId |       4 | florahellenica.t.Id           |   31 |             |
|  1 | SIMPLE      | cr    | eq_ref | PRIMARY,colrange_LocalityId,IX_ColRange_LocalityId                            | PRIMARY         |       4 | florahellenica.s.ColRangeId   |    1 |             |
|  1 | SIMPLE      | ln    | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.cr.LocalityId  |    1 |             |
|  1 | SIMPLE      | c     | eq_ref | PRIMARY,id                                                                    | PRIMARY         |       4 | florahellenica.s.CollectorId  |    1 | Using index |
|  1 | SIMPLE      | st    | eq_ref | PRIMARY                                                                       | PRIMARY         |       1 | florahellenica.s.SpecimenType |    1 | Using index |
|  1 | SIMPLE      | i     | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.ln.IslandId    |    1 | Using index |
|  1 | SIMPLE      | e     | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.ln.EparchiaId  |    1 |             |
|  1 | SIMPLE      | n     | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.e.NomosId      |    1 | Using index |
|  1 | SIMPLE      | f     | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.g.FamilyId     |    1 | Using index |
|  1 | SIMPLE      | m     | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.ln.MountainId  |    1 | Using index |
|  1 | SIMPLE      | li    | eq_ref | PRIMARY                                                                       | PRIMARY         |       4 | florahellenica.s.LittId       |    1 | Using index |
+----+-------------+-------+--------+-------------------------------------------------------------------------------+-----------------+---------+-------------------------------+------+-------------+
13 rows in set (0.00 sec)