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.