SELECT
      GENERICO,
      DESCRIPCION,
      ARTICULO,
      COLOR,
      TALLE,
      DOC_ID,
      DOC_NUMERO,
      DOC_FECHA,
      SUM(CANTIDAD) AS CANTIDAD
    FROM
    (
      SELECT
        ARTICULOS.ARTICU_ID AS GENERICO,
        ITEMS.ARTICU_ID AS ARTICULO,
        COLORES.DENOMINACION AS COLOR,
        TALLES.DENOMINACION AS TALLE,
        ITEMS.DOC_ID AS DOC_ID,
        SUM(CANTIDAD) AS CANTIDAD
      FROM
        MASEFER.DOCUMENTOS_ITEMS ITEMS
        LEFT JOIN MASEFER.ARTICULOS ARTICULOS ON ARTICULOS.ID = ITEMS.ARTICU_ID
        LEFT JOIN MASEFER.ARTICULOS_COLOR COLORES ON ARTICULOS.COLOR = COLORES.ID
        LEFT JOIN MASEFER.TALLES TALLES ON ARTICULOS.TALLE_ID = TALLES.ID
        AND ARTICULOS.SUBFAMILIA_FAMILIAS_ID = TALLES.FAMILIA_ID
      WHERE
        DOC_ID IN (
          SELECT
            DOC_ITEMS_DOC_ID AS DOC_ID
          FROM
            MASEFER.ITEMRELA
          WHERE
            DOC_ITEMS_HIJO_DOC_ID IN (
              SELECT
                ID_DOCUMENTO_ARTICULO AS DOC_ITEMS_HIJO_DOC_ID
              FROM
                MASEFER.TALLER_ARTICULOS
              WHERE
                ID_ARTICULO = ${tareaId}
            )
        )
      GROUP BY
        ITEMS.ARTICU_ID,
        ARTICULOS.ARTICU_ID,
        COLORES.DENOMINACION,
        TALLES.DENOMINACION,
        ITEMS.DOC_ID
      ) ARTICULOS_DE_TAREA
      LEFT JOIN
        (
          SELECT
            DOCUMENTOS.NUMERO AS DOC_NUMERO,
            DOCUMENTOS.FECHA AS DOC_FECHA,
            DOCUMENTOS.ID
          FROM MASEFER.DOCUMENTOS
        ) DOCS_DETALLES
        ON DOCS_DETALLES.ID=ARTICULOS_DE_TAREA.DOC_ID
      INNER JOIN
      (
        SELECT DISTINCT
          ARTICU_ID AS ID,
          DENOMINACION AS DESCRIPCION
        FROM MASEFER.ARTICULOS ARTICULOS
        WHERE (
          ARTICULOS.ID = ARTICULOS.ARTICU_ID OR
          ARTICULOS.ARTICU_ID IS NULL
        )
      ) ARTICULOS_GENERICOS
        ON
          ARTICULOS_DE_TAREA.GENERICO = ARTICULOS_GENERICOS.ID
    GROUP BY
      ARTICULO,
      COLOR,
      TALLE,
      GENERICO,
      DESCRIPCION,
      DOC_NUMERO,
      DOC_FECHA,
      DOC_ID
    ORDER BY
      GENERICO,
      ARTICULO,
      COLOR,
      TALLE,
      DOC_ID