Chart : Years By Countries (Columns)

The sign (*) represents mandatory fields

*Name

*Request SELECT CONCAT_WS(',',`dvd`.`Countries`) AS `COUNTRY` , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`!='' AND !(`dvd`.`Countries` LIKE '%,%') GROUP BY `dvd`.`Countries` UNION SELECT 'MULTIPLE' , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`!='' AND (`dvd`.`Countries` LIKE '%,%') UNION SELECT 'N/A' , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`='' GROUP BY `dvd`.`Countries`

*Type Column chartLine chartArea chartPie chartPie chart

*Number

*Display NoYes