SELECT
ifnull(CODE, 'total') AS CODE,
sum(IF(dd = '1', quantity, 0)) AS '1',
sum(IF(dd = '2', quantity, 0)) AS '2',
sum(IF(dd = '3', quantity, 0)) AS '3',
sum(IF(dd = '4', quantity, 0)) AS '4',
sum(IF(dd = '5', quantity, 0)) AS '5',
sum(IF(dd = '6', quantity, 0)) AS '6',
sum(IF(dd = '7', quantity, 0)) AS '7',
sum(IF(dd = '8', quantity, 0)) AS '8',
sum(IF(dd = '9', quantity, 0)) AS '9',
sum(IF(dd = '10', quantity, 0)) AS '10',
sum(IF(dd = '11', quantity, 0)) AS '11',
sum(IF(dd = '12', quantity, 0)) AS '12',
sum(IF(dd = '13', quantity, 0)) AS '13',
sum(IF(dd = '14', quantity, 0)) AS '14',
sum(IF(dd = '15', quantity, 0)) AS '15',
sum(IF(dd = '16', quantity, 0)) AS '16',
sum(IF(dd = '17', quantity, 0)) AS '17',
sum(IF(dd = '18', quantity, 0)) AS '18',
sum(IF(dd = '19', quantity, 0)) AS '19',
sum(IF(dd = '20', quantity, 0)) AS '20',
sum(IF(dd = '21', quantity, 0)) AS '21',
sum(IF(dd = '22', quantity, 0)) AS '22',
sum(IF(dd = '23', quantity, 0)) AS '23',
sum(IF(dd = '24', quantity, 0)) AS '24',
sum(IF(dd = '25', quantity, 0)) AS '25',
sum(IF(dd = '26', quantity, 0)) AS '26',
sum(IF(dd = '27', quantity, 0)) AS '27',
sum(IF(dd = '28', quantity, 0)) AS '28',
sum(IF(dd = '29', quantity, 0)) AS '29',
sum(IF(dd = '30', quantity, 0)) AS '30',
sum(IF(dd = '30', quantity, 0)) AS '30',
SUM(quantity) AS TOTAL
FROM
instock
WHERE
mm = 8
GROUP BY
CODE WITH ROLLUP;
ifnull(CODE, 'total') AS CODE,
sum(IF(dd = '1', quantity, 0)) AS '1',
sum(IF(dd = '2', quantity, 0)) AS '2',
sum(IF(dd = '3', quantity, 0)) AS '3',
sum(IF(dd = '4', quantity, 0)) AS '4',
sum(IF(dd = '5', quantity, 0)) AS '5',
sum(IF(dd = '6', quantity, 0)) AS '6',
sum(IF(dd = '7', quantity, 0)) AS '7',
sum(IF(dd = '8', quantity, 0)) AS '8',
sum(IF(dd = '9', quantity, 0)) AS '9',
sum(IF(dd = '10', quantity, 0)) AS '10',
sum(IF(dd = '11', quantity, 0)) AS '11',
sum(IF(dd = '12', quantity, 0)) AS '12',
sum(IF(dd = '13', quantity, 0)) AS '13',
sum(IF(dd = '14', quantity, 0)) AS '14',
sum(IF(dd = '15', quantity, 0)) AS '15',
sum(IF(dd = '16', quantity, 0)) AS '16',
sum(IF(dd = '17', quantity, 0)) AS '17',
sum(IF(dd = '18', quantity, 0)) AS '18',
sum(IF(dd = '19', quantity, 0)) AS '19',
sum(IF(dd = '20', quantity, 0)) AS '20',
sum(IF(dd = '21', quantity, 0)) AS '21',
sum(IF(dd = '22', quantity, 0)) AS '22',
sum(IF(dd = '23', quantity, 0)) AS '23',
sum(IF(dd = '24', quantity, 0)) AS '24',
sum(IF(dd = '25', quantity, 0)) AS '25',
sum(IF(dd = '26', quantity, 0)) AS '26',
sum(IF(dd = '27', quantity, 0)) AS '27',
sum(IF(dd = '28', quantity, 0)) AS '28',
sum(IF(dd = '29', quantity, 0)) AS '29',
sum(IF(dd = '30', quantity, 0)) AS '30',
sum(IF(dd = '30', quantity, 0)) AS '30',
SUM(quantity) AS TOTAL
FROM
instock
WHERE
mm = 8
GROUP BY
CODE WITH ROLLUP;