[
"sql" => "SELECT p0_.id AS id_0, p0_.vorname AS vorname_1, p0_.nachname AS nachname_2, p0_.email AS email_3, p0_.anschrift AS anschrift_4, p0_.strasse AS strasse_5, p0_.hausnummer AS hausnummer_6, p0_.plz AS plz_7, p0_.ort AS ort_8, p0_.adel AS adel_9, p0_.works_at AS works_at_10, p0_.parsed_from AS parsed_from_11, p0_.quelle AS quelle_12, p0_.ordnr AS ordnr_13, p0_.rechtsgebiete AS rechtsgebiete_14, p0_.protokoll_datum AS protokoll_datum_15, p0_.appeared_first_at AS appeared_first_at_16, p0_.created_at AS created_at_17, p0_.pdf_need_update AS pdf_need_update_18, p0_.pdf_need_update_examen AS pdf_need_update_examen_19, p0_.slug AS slug_20, d1_.id AS id_21, d1_.name AS name_22, d1_.slug AS slug_23, d2_.id AS id_24, d2_.name AS name_25, d2_.slug AS slug_26, t3_.id AS id_27, t3_.name AS name_28, t3_.slug AS slug_29, t4_.id AS id_30, t4_.name AS name_31, t4_.slug AS slug_32, p5_.id AS id_33, p5_.anzahl_seiten AS anzahl_seiten_34, p5_.path AS path_35, p5_.size AS size_36, p5_.mimeType AS mimeType_37, p5_.anzahl_protokolle AS anzahl_protokolle_38, p5_.examen AS examen_39, p5_.created_at AS created_at_40, p5_.updated_at AS updated_at_41, p0_.titel_id AS titel_id_42, p0_.dienststellung_id AS dienststellung_id_43, p0_.creator_id AS creator_id_44, p0_.alias_id AS alias_id_45, d1_.alias_id AS alias_id_46, d2_.alias_id AS alias_id_47, t3_.alias_id AS alias_id_48, t4_.alias_id AS alias_id_49, p5_.pruefer_id AS pruefer_id_50 FROM pruefer p0_ INNER JOIN pruefer_pruefungsamt p7_ ON p0_.id = p7_.pruefer_id INNER JOIN pruefungsamt p6_ ON p6_.id = p7_.pruefungsamt_id AND (p6_.id = ?) LEFT JOIN dienststellung d1_ ON p0_.dienststellung_id = d1_.id LEFT JOIN dienststellung d2_ ON d1_.alias_id = d2_.id LEFT JOIN titel t3_ ON p0_.titel_id = t3_.id LEFT JOIN titel t4_ ON t3_.alias_id = t4_.id INNER JOIN pdf_protokollmappe_pruefer p5_ ON p0_.id = p5_.pruefer_id AND (p5_.anzahl_protokolle > 0) WHERE p0_.alias_id IS NULL ORDER BY p0_.nachname ASC, p0_.vorname ASC, p0_.adel ASC"
"params" => [
1 => 24
]
"types" => [
1 => 1
]
]