Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5,
  t6.ht AS ht_7,
  t6.prod_type AS prod_type_8,
  t6.enabled AS enabled_9,
  t6.id AS id_10,
  t6.projecttool_id AS projecttool_id_11
FROM
  products_translation t0
  LEFT JOIN products t6 ON t0.translatable_id = t6.id
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 26;

SELECT
  p0_.date_end AS date_end_0,
  p0_.status AS status_1,
  p0_.pending_order AS pending_order_2,
  p1_.id AS id_3,
  p1_.name AS name_4,
  p1_.description AS description_5,
  p1_.address AS address_6,
  p1_.additional_address AS additional_address_7,
  p1_.postcode AS postcode_8,
  p1_.identify_number AS identify_number_9,
  p1_.website AS website_10,
  p1_.prepaid_amount AS prepaid_amount_11,
  p1_.sponsor_code AS sponsor_code_12,
  p1_.sponsor_points AS sponsor_points_13,
  p1_.reference AS reference_14,
  p1_.sepa_name AS sepa_name_15,
  p1_.population AS population_16,
  p1_.typology AS typology_17,
  p1_.is_rdc AS is_rdc_18,
  p1_.is_contract_historic AS is_contract_historic_19,
  p1_.collectivity_service_code AS collectivity_service_code_20,
  p1_.is_number_ej AS is_number_ej_21,
  p1_.demo AS demo_22,
  p1_.vat AS vat_23,
  p1_.logo AS logo_24,
  p1_.is_data_different_invoice AS is_data_different_invoice_25,
  p1_.other_name AS other_name_26,
  p1_.other_address AS other_address_27,
  p1_.other_identify_number AS other_identify_number_28,
  p1_.manual_renewal AS manual_renewal_29,
  p1_.testimony_answered AS testimony_answered_30,
  p1_.is_cmd AS is_cmd_31,
  p1_.notes AS notes_32,
  p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33,
  p1_.date_ceo_interview AS date_ceo_interview_34,
  p1_.top_ranking AS top_ranking_35,
  p1_.rdc_feeling AS rdc_feeling_36,
  p1_.created_at AS created_at_37,
  p1_.updated_at AS updated_at_38,
  p1_.deleted_at AS deleted_at_39,
  p1_.lat AS lat_40,
  p1_.lng AS lng_41,
  m2_.id AS id_42,
  m2_.name AS name_43,
  m2_.status AS status_44,
  m2_.menu_key AS menu_key_45,
  m2_.route_name AS route_name_46,
  m2_.is_front_page AS is_front_page_47,
  m2_.is_widget AS is_widget_48,
  m2_.is_feed AS is_feed_49,
  p0_.projecttool_id AS projecttool_id_50,
  p0_.mod_id AS mod_id_51,
  p0_.project_id AS project_id_52,
  p1_.type_id AS type_id_53,
  p1_.category_id AS category_id_54,
  p1_.city_id AS city_id_55,
  p1_.user_id AS user_id_56,
  p1_.othet_city_id AS othet_city_id_57,
  p1_.intercommunality_id AS intercommunality_id_58,
  p1_.attachments AS attachments_59,
  m2_.projecttool_id AS projecttool_id_60,
  m2_.prod_id AS prod_id_61
FROM
  projects_mods p0_
  INNER JOIN projects p1_ ON p0_.project_id = p1_.id
  INNER JOIN mods m2_ ON p0_.mod_id = m2_.id
WHERE
  p0_.project_id = ?
  AND m2_.route_name = ?

SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = 1445 AND m2_.route_name = 'news';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.always_checked AS always_checked_2,
  p0_.projecttool_key AS projecttool_key_3,
  p0_.max_size AS max_size_4,
  p0_.index_route AS index_route_5,
  p0_.enabled AS enabled_6
FROM
  projecttools p0_
  INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id)
  INNER JOIN projects p2_ ON (p2_.id = p1_.project_id)
WHERE
  p2_.id = ?
  AND p1_.status = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = 1445 AND p1_.status = 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.status AS status_2,
  m0_.menu_key AS menu_key_3,
  m0_.route_name AS route_name_4,
  m0_.is_front_page AS is_front_page_5,
  m0_.is_widget AS is_widget_6,
  m0_.is_feed AS is_feed_7,
  p1_.ht AS ht_8,
  p1_.prod_type AS prod_type_9,
  p1_.enabled AS enabled_10,
  p1_.id AS id_11,
  p2_.id AS id_12,
  p2_.name AS name_13,
  p2_.always_checked AS always_checked_14,
  p2_.projecttool_key AS projecttool_key_15,
  p2_.max_size AS max_size_16,
  p2_.index_route AS index_route_17,
  p2_.enabled AS enabled_18,
  m0_.projecttool_id AS projecttool_id_19,
  m0_.prod_id AS prod_id_20,
  p1_.projecttool_id AS projecttool_id_21
FROM
  mods m0_
  LEFT JOIN products p1_ ON m0_.prod_id = p1_.id
  INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id
WHERE
  m0_.projecttool_id = ?
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = 3 ORDER BY m0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.value AS value_2
FROM
  configuration c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.address AS address_4,
  t0.additional_address AS additional_address_5,
  t0.postcode AS postcode_6,
  t0.identify_number AS identify_number_7,
  t0.website AS website_8,
  t0.prepaid_amount AS prepaid_amount_9,
  t0.sponsor_code AS sponsor_code_10,
  t0.sponsor_points AS sponsor_points_11,
  t0.reference AS reference_12,
  t0.sepa_name AS sepa_name_13,
  t0.population AS population_14,
  t0.typology AS typology_15,
  t0.is_rdc AS is_rdc_16,
  t0.is_contract_historic AS is_contract_historic_17,
  t0.collectivity_service_code AS collectivity_service_code_18,
  t0.is_number_ej AS is_number_ej_19,
  t0.demo AS demo_20,
  t0.vat AS vat_21,
  t0.logo AS logo_22,
  t0.is_data_different_invoice AS is_data_different_invoice_23,
  t0.other_name AS other_name_24,
  t0.other_address AS other_address_25,
  t0.other_identify_number AS other_identify_number_26,
  t0.manual_renewal AS manual_renewal_27,
  t0.testimony_answered AS testimony_answered_28,
  t0.is_cmd AS is_cmd_29,
  t0.notes AS notes_30,
  t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31,
  t0.date_ceo_interview AS date_ceo_interview_32,
  t0.top_ranking AS top_ranking_33,
  t0.rdc_feeling AS rdc_feeling_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.deleted_at AS deleted_at_37,
  t0.lat AS lat_38,
  t0.lng AS lng_39,
  t0.type_id AS type_id_40,
  t0.category_id AS category_id_41,
  t0.city_id AS city_id_42,
  t0.user_id AS user_id_43,
  t0.othet_city_id AS othet_city_id_44,
  t0.intercommunality_id AS intercommunality_id_45,
  t0.attachments AS attachments_46
FROM
  projects t0
WHERE
  t0.id = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = '1445' AND t0.deleted_at IS NULL LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      favoris_14,
      publish_date_5
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.title AS title_1,
          s0_.header AS header_2,
          s0_.vignette AS vignette_3,
          s0_.contents AS contents_4,
          s0_.publish_date AS publish_date_5,
          s0_.de_publish_date AS de_publish_date_6,
          s0_.status AS status_7,
          s0_.is_temporary AS is_temporary_8,
          s0_.is_draft AS is_draft_9,
          s0_.contents_front AS contents_front_10,
          s0_.id_front AS id_front_11,
          s0_.url_vignette AS url_vignette_12,
          s0_.slug AS slug_13,
          s0_.favoris AS favoris_14,
          s0_.created_at AS created_at_15,
          s0_.updated_at AS updated_at_16
        FROM
          site_news s0_
        WHERE
          s0_.project_id = ?
      ) dctrn_result_inner
    ORDER BY
      favoris_14 DESC,
      publish_date_5 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, favoris_14, publish_date_5 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = 1445) dctrn_result_inner ORDER BY favoris_14 DESC, publish_date_5 DESC) dctrn_result LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.new_email AS new_email_5,
  t0.roles AS roles_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.newsletter_accepted AS newsletter_accepted_9,
  t0.terms_accepted AS terms_accepted_10,
  t0.is_valid AS is_valid_11,
  t0.confirmation_token AS confirmation_token_12,
  t0.shortcuts AS shortcuts_13,
  t0.lastlogin AS lastlogin_14,
  t0.locale AS locale_15,
  t0.birthday AS birthday_16,
  t0.description AS description_17,
  t0.gender_id AS gender_id_18,
  t0.picture_name AS picture_name_19,
  t0.password_request_at AS password_request_at_20,
  t0.enabled AS enabled_21,
  t0.come_from AS come_from_22,
  t0.display_scenario AS display_scenario_23,
  t0.phone AS phone_24,
  t0.info_shared_neopse AS info_shared_neopse_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.city_id AS city_id_28,
  t0.admin_group_id AS admin_group_id_29
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = 'jean-sebastien.leleu@epicture.fr' LIMIT 1;

SELECT
  s0_.url_thumb AS url_thumb_0,
  s0_.type_thumb AS type_thumb_1,
  s0_.cropped_data AS cropped_data_2,
  s0_.id AS id_3,
  s0_.name AS name_4,
  s0_.size AS size_5,
  s0_.mime_type AS mime_type_6,
  s0_.original_name AS original_name_7,
  s0_.uploaded_at AS uploaded_at_8,
  s0_.preview AS preview_9,
  s0_.preview_mime_type AS preview_mime_type_10,
  s0_.preview_size AS preview_size_11,
  s0_.deleted_at AS deleted_at_12,
  s0_.project_id AS project_id_13,
  s0_.original_file_id AS original_file_id_14
FROM
  site_thumbnails_files s0_
WHERE
  s0_.project_id = ?
  AND s0_.type_thumb = ?

SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = 1445 AND s0_.type_thumb = 0;

SELECT
  t0.date_end AS date_end_1,
  t0.status AS status_2,
  t0.additional_size AS additional_size_3,
  t0.free AS free_4,
  t0.next_data AS next_data_5,
  t0.pending_order AS pending_order_6,
  t0.size_platform AS size_platform_7,
  t0.pack AS pack_8,
  t0.reminded_at AS reminded_at_9,
  t0.delete_at AS delete_at_10,
  t0.locked AS locked_11,
  t0.renewal_refused AS renewal_refused_12,
  t0.renewal_refused_reason AS renewal_refused_reason_13,
  t0.renewal_refused_filename AS renewal_refused_filename_14,
  t0.projecttool_id AS projecttool_id_15,
  t0.project_id AS project_id_16
FROM
  projects_projecttools t0
WHERE
  t0.project_id = ?

SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = 1445;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url_prefix AS url_prefix_3,
  t0.url_domain AS url_domain_4,
  t0.template AS template_5,
  t0.template_favourites AS template_favourites_6,
  t0.template_widgets AS template_widgets_7,
  t0.template_settings AS template_settings_8,
  t0.template_updated_at AS template_updated_at_9,
  t0.template_custom_css AS template_custom_css_10,
  t0.search_enabled AS search_enabled_11,
  t0.feed_api_key AS feed_api_key_12,
  t0.project_id AS project_id_13
FROM
  site t0
WHERE
  t0.project_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = 1445 LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.title AS title_1,
          s0_.header AS header_2,
          s0_.vignette AS vignette_3,
          s0_.contents AS contents_4,
          s0_.publish_date AS publish_date_5,
          s0_.de_publish_date AS de_publish_date_6,
          s0_.status AS status_7,
          s0_.is_temporary AS is_temporary_8,
          s0_.is_draft AS is_draft_9,
          s0_.contents_front AS contents_front_10,
          s0_.id_front AS id_front_11,
          s0_.url_vignette AS url_vignette_12,
          s0_.slug AS slug_13,
          s0_.favoris AS favoris_14,
          s0_.created_at AS created_at_15,
          s0_.updated_at AS updated_at_16
        FROM
          site_news s0_
        WHERE
          s0_.project_id = ?
        ORDER BY
          s0_.favoris DESC,
          s0_.publish_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = 1445 ORDER BY s0_.favoris DESC, s0_.publish_date DESC) dctrn_result) dctrn_table;