mysql group by id returning multiple rows code example

Example 1: mysql multiple group by

GROUP BY col1, col2

Example 2: mysql group rows with same value

/**
 * Used <br> to list itens one below the other in HTML page
 */
group_concat(p.nameItem separator '<br>') as listProdItem