MySql query explain

id  select_type  table       type    possible_keys    key              key_len  ref                    rows    Extra
1   PRIMARY      <derived4>  ALL                                                                       191441  Using join buffer
1   PRIMARY      n           eq_ref  PK_NOTE          PK_NOTE          8        np.note_id             1
1   PRIMARY      <derived2>  ALL                                                                       274992  Using where; Using join buffer
1   PRIMARY      cust        eq_ref  PRIMARY_97       PRIMARY_97       8        trans.CUSTOMER_ID      1
1   PRIMARY      <derived5>  ALL                                                                       2803
1   PRIMARY      <derived8>  ALL                                                                       14755
1   PRIMARY      <derived3>  ALL                                                                       2241
2   DERIVED      trans1      ALL                                                                       669955  Using where
3   DERIVED      ty          ALL                                                                       2348    Using where
4   DERIVED      np1         ALL                                                                       207662  Using temporary; Using filesort
5   DERIVED      <derived6>  ALL                                                                       314705  Using where; Using join buffer
5   DERIVED      <derived7>  ALL                                                                       98      Using temporary; Using filesort
6   DERIVED      trans4      ALL                                                                       669955  Using where
7   DERIVED      ty2         ALL                                                                       2348    Using where
8   DERIVED      <derived9>  ALL                                                                       2       Using temporary; Using filesort
8   DERIVED      tp          ref     TRANSACTIONTYPE  TRANSACTIONTYPE  9        lp.transactionTypesID  93      Using where
9   DERIVED      lp          ALL                                                                       2348    Using where