BEGIN

    SELECT GROUP_CONCAT(
          DISTINCT CONCAT(
                'MAX(IF(fieldName = '',
                m.fieldName,
                '', fieldValue, NULL)) AS '',
                m.fieldName,
                '''
            )
          )
      INTO @columns
      FROM part p
        INNER JOIN batch b ON p.partId = b.partId
        INNER JOIN measurement m ON m.batchId = b.batchId
      WHERE
        p.number = partNum
        AND EXISTS
          (SELECT 1
             FROM part p
                  INNER JOIN batch B ON p.partId = B.partId
                  INNER JOIN measurement M ON M.BATCHID = B.BATCHID
            WHERE p.number = partNum);
      IF(@columns IS NOT NULL) THEN
      SELECT
        GROUP_CONCAT(
          CONCAT(
            'SELECT b.serialNumber, b.uploadDate, u.email, '
           ,@columns
           ,' FROM batch b'
           ,' inner join measurement m on m.batchId = b.batchId'
           ,' left join part p on p.partId = b.partId'
           ,' left join users u on b.userId = u.userId'
           ,' WHERE p.number = '
           ,partNum
           ,'      AND (b.good = 1 OR b.waived = 1)'
           ,' GROUP BY b.batchId'
           ,' ORDER BY b.uploadDate;'))
      INTO
        @sql;
      PREPARE stmt FROM @sql;
      EXECUTE stmt;
      DEALLOCATE PREPARE stmt;
      ELSE
        SELECT number, description, customerPartNumber, 'There are no measurements for this part.' AS 'Measurements'
        FROM part
        WHERE number  = partNum;
      END IF;
END */;;