Group Concat mysql loses the order BY

0

I have the following SQL Query but the order by the GROUP Concat in some results does not have the expected order as I would like it to be by the date as shown in the image below.

SELECT objects.*, 
GROUP_CONCAT(mvalues.value ORDER BY mvalues.value ASC SEPARATOR ", ") as value 
    FROM objects 
    JOIN metadata_values mvalues ON mvalues.idObject = objects.idObject 
    JOIN metadata_descriptors mdescriptor ON mvalues.idDescriptor = mdescriptor.idDescriptor 
   WHERE objectType = 'EMBED' 
     AND mdescriptor.name IN ('Year Created', 'Thumbnail Patch') 
   GROUP BY objects.idObject ORDER BY objects.title ASC'

This would be the result obtained from the column that I am interested in ordering.

    
asked by Arielperez 11.09.2018 в 14:18
source

0 answers