selecttblinventory.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)) ascontributors from tblinventoryleft join tblproducttypes on tblproducttypes.id=tblinventory.typeidleft join tbleventnames on tbleventnames.id=tblinventory.eventnameidleft join tbleventlocations on tbleventlocations.id=tblinventory.locationidleft join tblinventorycelebrityassignments on tblinventorycelebrityassignments.inventoryid=tblinventory.idleft join tblcelebrities on tblinventorycelebrityassignments.celebrityid=tblcelebrities.idleft join tblcelebritytypeassignments on tblcelebritytypeassignments.celebrityid=tblcelebrities.idleft join tblcelebritytypes on tblcelebritytypes.id=tblcelebritytypeassignments.typeidleft join tblmusicgenreassignments on tblmusicgenreassignments.celebrityid=tblcelebrities.idleft join tblmusicgenres on tblmusicgenres.id=tblmusicgenreassignments.musicgenreidleft join tblgroupassociations on tblgroupassociations.celebrityid=tblcelebrities.idleft join tblgroupnames on tblgroupassociations.groupid=tblgroupnames.idleft join tblconsignments on tblconsignments.inventoryid=tblinventory.idleft join tblcontributors on tblcontributors.id=tblconsignments.contributoridgroup by tblinventory.id order by tblcelebrities.firstname;