Oclaje DB SQL Query

SELECT c.id,

       c.nome,

       DATE_FORMAT(c.nascimento,'%Y/%m/%d') AS nasc,
       DATE_FORMAT(c.nascimento,'%Y<span class=\"slash\">/</span>%m<span class=\"slash\">/</span>%d') AS html_nasc,

       s.id_tiposituacao,
       s.situacao,

       DATE_FORMAT(s.ts,'%Y/%m/%d') AS ts_sit,
       DATE_FORMAT(s.ts,'%Y<span class=\"slash\">/</span>%m<span class=\"slash\">/</span>%d') AS html_ts_sit,

       c.rg_numero AS num,

       o.sigla AS org,
       u.sigla AS uf,
       CONCAT(
               IF(ISNULL(o.sigla),'<td>','<td class=\"rg_org\">'),
                  IFNULL(o.sigla ,''),
               '</td>',
               IF(ISNULL(o.sigla),'<td colspan=\"2\">','<td class=\"slash\">/</td><td class=\"rg_uf\">'),
                  IFNULL(u.sigla ,''),
               '</td>'
             ) AS html_org_uf,

       F.fones,

       CONCAT(
                  IFNULL(c.email_usuario ,''),
               IF(ISNULL(c.email_usuario),'','@'),
                  IFNULL(c.email_dominio ,'')
             ) AS email,
       CONCAT(
               IF(ISNULL(c.email_usuario),'<td>','<td class=\"email_usuario\">'),
                  IFNULL(c.email_usuario ,''),
               '</td>',
               IF(ISNULL(c.email_usuario),'<td colspan=\"2\">','<td class=\"at\">@</td><td class=\"email_dominio\">'),
                  IFNULL(c.email_dominio ,''),
               '</td>'
             ) AS html_email

  FROM cadastro AS c
  LEFT  JOIN rg_orgao AS o ON o.id = c.rg_id_orgao
  LEFT  JOIN uf       AS u ON u.id = c.rg_id_uf
  INNER JOIN (
               SELECT id_cadastro,
                      GROUP_CONCAT(
                                    CONCAT( IFNULL(prefixo,''), '-', IFNULL(numero,''), IF(ISNULL(ramal),'',' r'), IFNULL(ramal,'') )
                                    SEPARATOR '<br />'
                                  ) AS fones
               FROM     fone
               GROUP BY id_cadastro
             ) AS F ON F.id_cadastro = c.id
  INNER JOIN (
               SELECT DISTINCT(a.id_cadastro),
                      t.nome AS situacao,
                      a.id_tiposituacao,
                      a.ts
               FROM   situacao AS a
               INNER JOIN (
                            SELECT   id_cadastro,
                                     MAX(ts) AS ts
                            FROM     situacao
                            GROUP BY id_cadastro
                          ) AS b ON ( a.id_cadastro = b.id_cadastro AND a.ts = b.ts )
               INNER JOIN tiposituacao AS t ON t.id = a.id_tiposituacao
               WHERE  a.id_tiposituacao =  1 OR
                      a.id_tiposituacao =  2 OR
                      a.id_tiposituacao =  3 OR
                      a.id_tiposituacao =  4 OR
                      a.id_tiposituacao =  5 OR
                      a.id_tiposituacao =  9 OR
                      a.id_tiposituacao = 11
               GROUP BY a.id_cadastro
             ) AS s ON s.id_cadastro = c.id
  WHERE      s.id_tiposituacao IS NOT NULL
  ORDER BY   c.nome