mysql> select f.feature_id, f.uniquename, a.uniquename, fl.fmin, fl.fmax, fp.value  from featureprop fp, cvterm cfp, cvterm ca, cvterm cf, featureloc fl, feature f, feature a  where a.feature_id = fl.srcfeature_id and fl.feature_id = f.feature_id  and ca.name = 'assembly' and ca.cvterm_id = a.type_id  and cf.name = 'tRNA' and cf.cvterm_id = f.type_id  and fp.type_id = cfp.cvterm_id and cfp.name = 'gene_product_name'  and fp.feature_id = f.feature_id limit 2;
+------------+-----------------------+-----------------+---------+---------+----------+
| feature_id | uniquename            | uniquename      | fmin    | fmax    | value    |
+------------+-----------------------+-----------------+---------+---------+----------+
|      15010 | cgsp.tRNA.141873552.1 | cgsp.assembly.1 | 1245540 | 1245627 | tRNA-Leu |
|      29056 | cgsp.tRNA.141873840.1 | cgsp.assembly.1 | 2687481 | 2687558 | tRNA-Asp |
+------------+-----------------------+-----------------+---------+---------+----------+
2 rows in set (0.03 sec)