QUERY (1140) Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
select GROUP_CONCAT(dmp_pcode) from ONEDAY.smart_display_main_product where (dmp_dmsuid=12) order by dmp_sort_group, dmp_sort_idx