SELECT
  f0_.id AS id_0,
  f0_.first_name AS first_name_1,
  f0_.last_name AS last_name_2,
  f0_.address_street AS address_street_3,
  f0_.address_city AS address_city_4,
  f0_.address_postcode AS address_postcode_5,
  f0_.id_document_number AS id_document_number_6,
  (
    SELECT
      COUNT(r1_.id) AS dctrn__1
    FROM
      rent_order r1_
    WHERE
      r1_.finalCarUser_id = f0_.id
      AND r1_.status = 2
  ) AS sclr_7,
  (
    SELECT
      COUNT(q2_.id) AS dctrn__2
    FROM
      questionnaire q2_
    WHERE
      q2_.finalCarUser_id = f0_.id
      AND q2_.status = 4
  ) AS sclr_8,
  (
    SELECT
      COUNT(q3_.id) AS dctrn__3
    FROM
      questionnaire q3_
    WHERE
      q3_.finalCarUser_id = f0_.id
  ) AS sclr_9,
  COUNT(f4_.id) AS sclr_10
FROM
  final_car_user f0_
  LEFT JOIN questionnaire q5_ ON f0_.id = q5_.finalCarUser_id
  INNER JOIN final_car_user f4_ ON (
    f4_.first_name = f0_.first_name
    AND f4_.last_name = f0_.last_name
  )
GROUP BY
  f0_.id
HAVING
  sclr_10 > 1
ORDER BY
  f0_.first_name ASC,
  f0_.last_name ASC
LIMIT
  10