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