Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tags AS tags_3
FROM
  sous_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.tags AS tags_3 FROM sous_type t0;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.refannonce AS refannonce_1,
          e0_.identifiant_technique AS identifiant_technique_2,
          e0_.numeromandat AS numeromandat_3,
          e0_.mandat_at AS mandat_at_4,
          e0_.statut AS statut_5,
          e0_.statut_name AS statut_name_6,
          e0_.slug AS slug_7,
          e0_.typebien AS typebien_8,
          e0_.si_mandatexclusif AS si_mandatexclusif_9,
          e0_.libelle AS libelle_10,
          e0_.descriptif AS descriptif_11,
          e0_.prix AS prix_12,
          e0_.surface AS surface_13,
          e0_.surf_terrain AS surf_terrain_14,
          e0_.nbpieces AS nbpieces_15,
          e0_.nbchambres AS nbchambres_16,
          e0_.latitude AS latitude_17,
          e0_.longitude AS longitude_18,
          e0_.orientation AS orientation_19,
          e0_.photos AS photos_20,
          e0_.features AS features_21,
          e0_.icones AS icones_22,
          e0_.is_new_checked AS is_new_checked_23,
          e0_.is_delete_checked AS is_delete_checked_24,
          e0_.import_type AS import_type_25,
          e0_.ca AS ca_26,
          e0_.ebe AS ebe_27,
          e0_.created_at AS created_at_28,
          e0_.updated_at AS updated_at_29,
          e0_.deleted_at AS deleted_at_30,
          a1_.id AS id_31,
          a1_.code_negociateur AS code_negociateur_32,
          a1_.slug AS slug_33,
          a1_.prenom AS prenom_34,
          a1_.nom AS nom_35,
          a1_.is_actif AS is_actif_36,
          a1_.siret AS siret_37,
          a1_.raison_sociale AS raison_sociale_38,
          a1_.cos_id AS cos_id_39,
          a1_.photo AS photo_40,
          a1_.bio AS bio_41,
          a1_.secteur AS secteur_42,
          a1_.cp AS cp_43,
          a1_.latitude AS latitude_44,
          a1_.longitude AS longitude_45,
          a1_.email AS email_46,
          a1_.telephone AS telephone_47,
          a1_.whatsapp AS whatsapp_48,
          a1_.facebook AS facebook_49,
          a1_.twitter AS twitter_50,
          a1_.linkedin AS linkedin_51,
          a1_.instagram AS instagram_52,
          a1_.video AS video_53,
          a1_.comment AS comment_54,
          a1_.rating AS rating_55,
          a1_.fonction AS fonction_56,
          a1_.created_at AS created_at_57,
          a1_.updated_at AS updated_at_58,
          a1_.deleted_at AS deleted_at_59
        FROM
          estate e0_
          INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
          AND (a1_.deleted_at IS NULL)
        WHERE
          (
            e0_.statut_name NOT IN ('under_contract')
            AND a1_.is_actif = 1
            AND e0_.statut_name IN ('available', 'under_offer')
            AND e0_.typebien IN (?)
          )
          AND (e0_.deleted_at IS NULL)
        ORDER BY
          e0_.numeromandat DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN ('appartement', 'studio', 'loft/atelier/surface', 'maison', 'terrain', 'parking/box', 'immeuble', 'chateau')) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC) dctrn_result) dctrn_table;

SELECT
  e0_.prix AS prix_0,
  e0_.typebien AS typebien_1
FROM
  estate e0_
  INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
  AND (a1_.deleted_at IS NULL)
WHERE
  (
    e0_.statut_name IN ('available', 'under_offer')
    AND a1_.is_actif = 1
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.prix ASC

SELECT e0_.prix AS prix_0, e0_.typebien AS typebien_1 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name IN ('available', 'under_offer') AND a1_.is_actif = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.prix ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      numeromandat_3
    FROM
      (
        SELECT
          e0_.id AS id_0,
          e0_.refannonce AS refannonce_1,
          e0_.identifiant_technique AS identifiant_technique_2,
          e0_.numeromandat AS numeromandat_3,
          e0_.mandat_at AS mandat_at_4,
          e0_.statut AS statut_5,
          e0_.statut_name AS statut_name_6,
          e0_.slug AS slug_7,
          e0_.typebien AS typebien_8,
          e0_.si_mandatexclusif AS si_mandatexclusif_9,
          e0_.libelle AS libelle_10,
          e0_.descriptif AS descriptif_11,
          e0_.prix AS prix_12,
          e0_.surface AS surface_13,
          e0_.surf_terrain AS surf_terrain_14,
          e0_.nbpieces AS nbpieces_15,
          e0_.nbchambres AS nbchambres_16,
          e0_.latitude AS latitude_17,
          e0_.longitude AS longitude_18,
          e0_.orientation AS orientation_19,
          e0_.photos AS photos_20,
          e0_.features AS features_21,
          e0_.icones AS icones_22,
          e0_.is_new_checked AS is_new_checked_23,
          e0_.is_delete_checked AS is_delete_checked_24,
          e0_.import_type AS import_type_25,
          e0_.ca AS ca_26,
          e0_.ebe AS ebe_27,
          e0_.created_at AS created_at_28,
          e0_.updated_at AS updated_at_29,
          e0_.deleted_at AS deleted_at_30,
          a1_.id AS id_31,
          a1_.code_negociateur AS code_negociateur_32,
          a1_.slug AS slug_33,
          a1_.prenom AS prenom_34,
          a1_.nom AS nom_35,
          a1_.is_actif AS is_actif_36,
          a1_.siret AS siret_37,
          a1_.raison_sociale AS raison_sociale_38,
          a1_.cos_id AS cos_id_39,
          a1_.photo AS photo_40,
          a1_.bio AS bio_41,
          a1_.secteur AS secteur_42,
          a1_.cp AS cp_43,
          a1_.latitude AS latitude_44,
          a1_.longitude AS longitude_45,
          a1_.email AS email_46,
          a1_.telephone AS telephone_47,
          a1_.whatsapp AS whatsapp_48,
          a1_.facebook AS facebook_49,
          a1_.twitter AS twitter_50,
          a1_.linkedin AS linkedin_51,
          a1_.instagram AS instagram_52,
          a1_.video AS video_53,
          a1_.comment AS comment_54,
          a1_.rating AS rating_55,
          a1_.fonction AS fonction_56,
          a1_.created_at AS created_at_57,
          a1_.updated_at AS updated_at_58,
          a1_.deleted_at AS deleted_at_59
        FROM
          estate e0_
          INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
          AND (a1_.deleted_at IS NULL)
        WHERE
          (
            e0_.statut_name NOT IN ('under_contract')
            AND a1_.is_actif = 1
            AND e0_.statut_name IN ('available', 'under_offer')
            AND e0_.typebien IN (?)
          )
          AND (e0_.deleted_at IS NULL)
      ) dctrn_result_inner
    ORDER BY
      numeromandat_3 DESC
  ) dctrn_result
LIMIT
  99999999999

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, numeromandat_3 FROM (SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN ('appartement', 'studio', 'loft/atelier/surface', 'maison', 'terrain', 'parking/box', 'immeuble', 'chateau')) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY numeromandat_3 DESC) dctrn_result LIMIT 99999999999;

SELECT
  e0_.id AS id_0,
  e0_.refannonce AS refannonce_1,
  e0_.identifiant_technique AS identifiant_technique_2,
  e0_.numeromandat AS numeromandat_3,
  e0_.mandat_at AS mandat_at_4,
  e0_.statut AS statut_5,
  e0_.statut_name AS statut_name_6,
  e0_.slug AS slug_7,
  e0_.typebien AS typebien_8,
  e0_.si_mandatexclusif AS si_mandatexclusif_9,
  e0_.libelle AS libelle_10,
  e0_.descriptif AS descriptif_11,
  e0_.prix AS prix_12,
  e0_.surface AS surface_13,
  e0_.surf_terrain AS surf_terrain_14,
  e0_.nbpieces AS nbpieces_15,
  e0_.nbchambres AS nbchambres_16,
  e0_.latitude AS latitude_17,
  e0_.longitude AS longitude_18,
  e0_.orientation AS orientation_19,
  e0_.photos AS photos_20,
  e0_.features AS features_21,
  e0_.icones AS icones_22,
  e0_.is_new_checked AS is_new_checked_23,
  e0_.is_delete_checked AS is_delete_checked_24,
  e0_.import_type AS import_type_25,
  e0_.ca AS ca_26,
  e0_.ebe AS ebe_27,
  e0_.created_at AS created_at_28,
  e0_.updated_at AS updated_at_29,
  e0_.deleted_at AS deleted_at_30,
  a1_.id AS id_31,
  a1_.code_negociateur AS code_negociateur_32,
  a1_.slug AS slug_33,
  a1_.prenom AS prenom_34,
  a1_.nom AS nom_35,
  a1_.is_actif AS is_actif_36,
  a1_.siret AS siret_37,
  a1_.raison_sociale AS raison_sociale_38,
  a1_.cos_id AS cos_id_39,
  a1_.photo AS photo_40,
  a1_.bio AS bio_41,
  a1_.secteur AS secteur_42,
  a1_.cp AS cp_43,
  a1_.latitude AS latitude_44,
  a1_.longitude AS longitude_45,
  a1_.email AS email_46,
  a1_.telephone AS telephone_47,
  a1_.whatsapp AS whatsapp_48,
  a1_.facebook AS facebook_49,
  a1_.twitter AS twitter_50,
  a1_.linkedin AS linkedin_51,
  a1_.instagram AS instagram_52,
  a1_.video AS video_53,
  a1_.comment AS comment_54,
  a1_.rating AS rating_55,
  a1_.fonction AS fonction_56,
  a1_.created_at AS created_at_57,
  a1_.updated_at AS updated_at_58,
  a1_.deleted_at AS deleted_at_59,
  e0_.agent_id AS agent_id_60,
  e0_.sous_type_id AS sous_type_id_61
FROM
  estate e0_
  INNER JOIN agent a1_ ON e0_.agent_id = a1_.id
  AND (a1_.deleted_at IS NULL)
WHERE
  (
    e0_.statut_name NOT IN ('under_contract')
    AND a1_.is_actif = 1
    AND e0_.statut_name IN ('available', 'under_offer')
    AND e0_.typebien IN (?)
    AND e0_.id IN (?)
  )
  AND (e0_.deleted_at IS NULL)
ORDER BY
  e0_.numeromandat DESC

SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59, e0_.agent_id AS agent_id_60, e0_.sous_type_id AS sous_type_id_61 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN ('appartement', 'studio', 'loft/atelier/surface', 'maison', 'terrain', 'parking/box', 'immeuble', 'chateau') AND e0_.id IN (5843, 5204, 5782, 5781, 5842, 5819, 5841, 4634, 5797, 5847, 5780, 5779, 5786, 5787, 5835, 5778, 5824, 5840, 5827, 5837, 5832, 5839, 5834, 5838, 5536, 5836, 5846, 5077, 5076, 5111, 5078, 5788, 5777, 5833, 5803, 5793, 5831, 5829, 5790, 5776, 2667, 5830, 5828, 5795, 5826, 5825, 5775, 5815, 5823, 5774, 5804, 5822, 5821, 5553, 5820, 5818, 5817, 5845, 5814, 5813, 5807, 5816, 5812, 5180, 5792, 5773, 5811, 5805, 5810, 5772, 5771, 5769, 5765, 5770, 5713, 5806, 5021, 5801, 5809, 5767, 5808, 5784, 5789, 5844, 5794, 5783, 5768, 5738, 5723, 5744, 5743, 5722, 5466, 5766, 5608, 5543, 5721, 5785, 5741, 5066, 5802, 5800, 5542, 5520, 5720, 5719, 5798, 5718, 5707, 5717, 5799, 5740, 5739, 5716, 5715, 5791, 5796, 5607, 5682, 5530, 5694, 5708, 5714, 5019, 5711, 5632, 5763, 5490, 5736, 5712, 5539, 5709, 5514, 5703, 5511, 5519, 5706, 5704, 5705, 5538, 4851, 5700, 5552, 5734, 5690, 4775, 4984, 5701, 5702, 5699, 5698, 5683, 5685, 5624, 5695, 5696, 5518, 5517, 5691, 5164, 5693, 5548, 5687, 5652, 5659, 5516, 5689, 5662, 5697, 5513, 5686, 5684, 5522, 5505, 5674, 5670, 5681, 5555, 5680, 5679, 5677, 5675, 5510, 5668, 4864, 5515, 5508, 5633, 5497, 5673, 5676, 5533, 4858, 4742, 5672, 5733, 5671, 5568, 5525, 5666, 5506, 5622, 5621, 5660, 5667, 5472, 5665, 4651, 5656, 5661, 5663, 5500, 5502, 5501, 5475, 5499, 5355, 5732, 5658, 5657, 5731, 5655, 5653, 5648, 5494, 5541, 5650, 5641, 5645, 5644, 5730, 5638, 5729, 5728, 5639, 5637, 5636, 5634, 5611, 5491, 5635, 5615, 5489, 5617, 5630, 5628, 5488, 5627, 5544, 5537, 5620, 5764, 5623, 4843, 5486, 5619, 5618, 5416, 4542, 5566, 5574, 5572, 5592, 5602, 5386, 5534, 5606, 5469, 4813, 5603, 2663, 5601, 5594, 4931, 4848, 5527, 5573, 5596, 5726, 5593, 5479, 5478, 5579, 5589, 5587, 5576, 5580, 5394, 5436, 5577, 4608, 5569, 5564, 4539, 2685, 4538, 5471, 5565, 5470, 5468, 5437, 5562, 5583, 5724, 5559, 5426, 5556, 5551, 5365, 5206, 5311, 5433, 5317, 5401, 5428, 5429, 5430, 5425, 5418, 5412, 5461, 5410, 5300, 5304, 5405, 5404, 5305, 5396, 5746, 5390, 5369, 5388, 5546, 5354, 5438, 5748, 5747, 4996, 5450, 5449, 5448, 5384, 5301, 5299, 5382, 5373, 5313, 5327, 5332, 5361, 5352, 5347, 5329, 5338, 5245, 5259, 5250, 5272, 5290, 4974, 5253, 5251, 5249, 2133, 5241, 5239, 2689, 4804, 5229, 5320, 5156, 5221, 5215, 5152, 5149, 5175, 2604, 5105, 5091, 5122, 4994, 5146, 5143, 4935, 4869)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 121 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 140 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 125 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 49 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 116 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 119 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 88 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 120 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 91 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.survey_id AS survey_id_2,
  t0.author AS author_3,
  t0.subject AS subject_4,
  t0.comment AS comment_5,
  t0.date AS date_6,
  t0.collaborator_id AS collaborator_id_7,
  t0.rating AS rating_8,
  t0.agent_id AS agent_id_9
FROM
  review t0
WHERE
  t0.agent_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = 175 ORDER BY t0.date DESC;