select this_.`ID` as ID1_70_2_, this_.`VERSIONID` as VERSIONID2_70_2_, this_.`AUTHOR` as AUTHOR3_70_2_, this_.`APPROVED` as APPROVED4_70_2_, this_.`LABELID` as LABELID5_70_2_, l1_.`ID` as ID1_34_0_, l1_.`VERSIONID` as VERSIONID2_34_0_, l1_.`NAME` as NAME3_34_0_, l1_.`DESCRIPTION` as DESCRIPT4_34_0_, l1_.`DISTRIBUTORID` as DISTRIBU5_34_0_, l1_.`WEBSITE` as WEBSITE6_34_0_, l1_.`COUNTRYID` as COUNTRYID7_34_0_, l1_.`DIGITAL` as DIGITAL8_34_0_, partners5_.`PARTNERLABELID` as PARTNERL2_, p2_.`ID` as PARTNERID1_, partners5_.`SORTINGID` as SORTINGID3_, p2_.`ID` as ID1_39_1_, p2_.`VERSIONID` as VERSIONID2_39_1_, p2_.`USERNAME` as USERNAME3_39_1_, p2_.`CONCEPTION` as CONCEPTION4_39_1_, p2_.`WEBSITE` as WEBSITE5_39_1_, p2_.`TAXID` as TAXID6_39_1_, p2_.`COMPANY` as COMPANY7_39_1_, p2_.`APPROVED` as APPROVED8_39_1_, p2_.`APPLIED` as APPLIED9_39_1_, p2_.`ADDRESSID` as ADDRESSID10_39_1_ from `PARTNERLABEL` this_ inner join `LABEL` l1_ on this_.`LABELID`=l1_.`ID`inner join `PARTNERLABELS` partners5_ on this_.`ID`=partners5_.`PARTNERLABELID`inner join `PARTNER` p2_ on partners5_.`PARTNERID`=p2_.`ID`order by l1_.`NAME` asc