Select (group by)

group.sql

select collection.uid, orgs.name,
group_concat(ifnull(attributes.name,"") separator "\0"), 
group_concat(ifnull(collection.value,"") separator "\0"),
group_concat(ifnull(variants.value,"") separator "\0")
from collection
left join orgs on orgs.uid=collection.uid
left join variants on collection.variant=variants.id
left join attributes on collection.attr_id=attributes.id
where orgs.proj_id = ?
group by collection.uid