select
tblinventory.id,
tblinventory.datesigned,
tblproducttypes.type,
tblinventory.title,
tbleventnames.eventname,
tbleventlocations.eventlocation,
group_concat(distinct tblmusicgenres.genre) as musicgenres,
group_concat(distinct tblcelebritytypes.type) as celebritytypes,
group_concat(distinct tblcelebrities.firstname,  " ",tblcelebrities.lastname) as celebritynames,
group_concat(distinct tblgroupnames.groupname) as groupnames,
group_concat(distinct substring(lower(tblcontributors.firstname),1,1),substring(lower(tblcontributors.lastname) FROM 1)) as
contributors from tblinventory
left join tblproducttypes on tblproducttypes.id=tblinventory.typeid
left join tbleventnames on tbleventnames.id=tblinventory.eventnameid
left join tbleventlocations on tbleventlocations.id=tblinventory.locationid
left join tblinventorycelebrityassignments on tblinventorycelebrityassignments.inventoryid=tblinventory.id
left join tblcelebrities on tblinventorycelebrityassignments.celebrityid=tblcelebrities.id
left join tblcelebritytypeassignments on tblcelebritytypeassignments.celebrityid=tblcelebrities.id
left join tblcelebritytypes on tblcelebritytypes.id=tblcelebritytypeassignments.typeid
left join tblmusicgenreassignments on tblmusicgenreassignments.celebrityid=tblcelebrities.id
left join tblmusicgenres on tblmusicgenres.id=tblmusicgenreassignments.musicgenreid
left join tblgroupassociations on tblgroupassociations.celebrityid=tblcelebrities.id
left join tblgroupnames on tblgroupassociations.groupid=tblgroupnames.id
left join tblconsignments on tblconsignments.inventoryid=tblinventory.id
left join tblcontributors on tblcontributors.id=tblconsignments.contributorid
group by tblinventory.id order by tblcelebrities.firstname;