select this_.article_id as article1_0_5_,
this_1_.archived as archived0_5_,
this_1_.author_id as author5_0_5_,
this_1_.content_id as content6_0_5_,
this_1_.last_modified as last3_0_5_,
this_1_.schema_name as schema4_0_5_,
this_.approval_time_limit as approval2_2_5_,
this_.author_approval as author3_2_5_,
this_.base_article_id as base13_2_5_,
this_.category_id as category10_2_5_,
this_.comment_policy as comment4_2_5_,
this_.editor_id as editor12_2_5_,
this_.expiration_date as expiration5_2_5_,
this_.magazine_id as magazine11_2_5_,
this_.publication_date as publicat6_2_5_,
this_.published as published2_5_,
this_.superseded_article_id as superseded14_2_5_,
this_.temporarily_offline_date as temporar8_2_5_,
this_.temporarilyOffline as temporar9_2_5_,
author2_.person_id as person1_10_0_,
author2_.active as active10_0_,
author2_.mail_address as mail3_10_0_,
author2_.name as name10_0_,
content1_.content_id as content1_13_1_,
content1_.xml_data as xml2_13_1_,
content1_.external_author as external3_13_1_,
content1_.teaser as teaser13_1_,
content1_.teaser_image_id as teaser5_13_1_,
content1_.title as title13_1_,
basearticl3_.article_id as article1_0_2_,
basearticl3_1_.archived as archived0_2_,
basearticl3_1_.author_id as author5_0_2_,
basearticl3_1_.content_id as content6_0_2_,
basearticl3_1_.last_modified as last3_0_2_,
basearticl3_1_.schema_name as schema4_0_2_,
basearticl3_.publicly_visible as publicly2_1_2_,
basearticl3_.submission_date as submission3_1_2_,
baauthor4_.person_id as person1_10_3_,
baauthor4_.active as active10_3_,
baauthor4_.mail_address as mail3_10_3_,
baauthor4_.name as name10_3_,
articlecon10_.content_id as content1_13_4_,
articlecon10_.xml_data as xml2_13_4_,
articlecon10_.external_author as external3_13_4_,
articlecon10_.teaser as teaser13_4_,
articlecon10_.teaser_image_id as teaser5_13_4_,
articlecon10_.title as title13_4_
from edited_article this_
inner join article this_1_ on this_.article_id = this_1_.article_id
inner join person author2_ on this_1_.author_id = author2_.person_id
inner join content content1_ on this_1_.content_id = content1_.content_id
inner join base_article basearticl3_ on this_.base_article_id =
basearticl3_.article_id left
outer join article basearticl3_1_ on basearticl3_.article_id =
basearticl3_1_.article_id
inner join person baauthor4_ on basearticl3_1_.author_id =
baauthor4_.person_id left
outer join content articlecon10_ on basearticl3_1_.content_id =
articlecon10_.content_id
where
this_.magazine_id = ?
and this_.editor_id is null
and this_.author_approval = ?
and this_1_.archived = ?
and this_.published = ?
and this_.temporarilyOffline = ?
order by content1_.external_author desc,
author2_.name desc,
baauthor4_.name asc limit ?