sql = "(SELECT comite.id, comite.numero, comite.fecha_apertura, comite.vigente,"
    sql += "(SELECT count(*) FROM solicitud, comite WHERE solicitud.estatus_id = 3 AND (solicitud.comite_id IS NULL OR solicitud.comite_id = comite.id)) AS cantidad,"
    sql += "(SELECT sum(solicitud.monto_cliente) FROM solicitud, comite WHERE solicitud.estatus_id = 3 AND (solicitud.comite_id IS NULL OR solicitud.comite_id = comite.id)) AS monto,"
    sql += "1 AS orden FROM comite where comite.id = #{ultimo_comite.id} GROUP BY comite.numero, comite.id, comite.fecha_apertura, comite.vigente)"
    sql += "UNION (SELECT c.id, c.numero, c.fecha_apertura, c.vigente, count(s.*) AS cantidad, sum(s.monto_cliente) AS monto,  2 AS orden FROM comite as c,  solicitud as s "
    sql += "WHERE  s.comite_id = c.id and c.id not in (#{ultimo_comite.id}) GROUP BY c.id, c.numero, c.fecha_apertura, c.vigente) "


    @list = Comite.find_by_sql("#{sql}")