Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.libelle AS libelle_3,
  t0.kind AS kind_4,
  t0.type_api AS type_api_5,
  t0.url AS url_6
FROM
  menu_libelle t0
WHERE
  t0.ordre = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = 0;

SELECT
  m0_.libelle AS libelle_0,
  m0_.url AS url_1
FROM
  menu_libelle m0_
WHERE
  m0_.ordre <> 0
ORDER BY
  m0_.ordre ASC

SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.lien_acceo AS lien_acceo_3,
  t0.telephone AS telephone_4,
  t0.telephone_url AS telephone_url_5,
  t0.reseaux_sociaux AS reseaux_sociaux_6
FROM
  footer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.lien_acceo AS lien_acceo_3, t0.telephone AS telephone_4, t0.telephone_url AS telephone_url_5, t0.reseaux_sociaux AS reseaux_sociaux_6 FROM footer t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.illustrationfil_name AS illustrationfil_name_2,
  t0.illustrationdetail_name AS illustrationdetail_name_3,
  t0.document_name1 AS document_name1_4,
  t0.document_name2 AS document_name2_5,
  t0.document_name3 AS document_name3_6,
  t0.image_url AS image_url_7,
  t0.thumb_url AS thumb_url_8,
  t0.title AS title_9,
  t0.short_description AS short_description_10,
  t0.content_duration AS content_duration_11,
  t0.restriction AS restriction_12,
  t0.state AS state_13,
  t0.suggested_by AS suggested_by_14,
  t0.published_at AS published_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.link1 AS link1_18,
  t0.url1 AS url1_19,
  t0.link2 AS link2_20,
  t0.url2 AS url2_21,
  t0.link3 AS link3_22,
  t0.url3 AS url3_23,
  t0.date_debut AS date_debut_24,
  t0.date_fin AS date_fin_25,
  t0.commentaires AS commentaires_26,
  t0.subtitle AS subtitle_27,
  t0.chapo AS chapo_28,
  t0.horaires AS horaires_29,
  t0.tarifs AS tarifs_30,
  t0.lieu AS lieu_31,
  t0.ville AS ville_32,
  t0.credits AS credits_33,
  t0.content AS content_34,
  t0.defaut_fil AS defaut_fil_35,
  t0.epingle1 AS epingle1_36,
  t0.epingle2 AS epingle2_37,
  t0.organized_by AS organized_by_38,
  t0.bool_date_maj AS bool_date_maj_39,
  t0.updated_date_display AS updated_date_display_40,
  t0.slug AS slug_41,
  t0.date_dernier_statut AS date_dernier_statut_42,
  t0.duree AS duree_43,
  t0.bool_actu AS bool_actu_44,
  t0.grand_format AS grand_format_45,
  t0.like_count AS like_count_46,
  t0.comment_count AS comment_count_47,
  t0.in_use AS in_use_48,
  t0.edit_date AS edit_date_49,
  t0.organisation4 AS organisation4_50,
  t0.affichage_type_map AS affichage_type_map_51,
  t0.affichage_type_map2 AS affichage_type_map2_52,
  t0.affichage_type_map3 AS affichage_type_map3_53,
  t0.musee_name AS musee_name_54,
  t0.musee_id AS musee_id_55,
  t0.order_folder AS order_folder_56,
  t0.order_tag AS order_tag_57,
  t0.openagenda_id AS openagenda_id_58,
  t0.archive AS archive_59,
  t0.date_update AS date_update_60,
  t0.json AS json_61,
  t0.openagenda_lieu AS openagenda_lieu_62,
  t0.openagenda_name AS openagenda_name_63,
  t0.markdown_description AS markdown_description_64,
  t0.musee_type AS musee_type_65,
  t0.type_id AS type_id_66,
  t0.created_by_id AS created_by_id_67,
  t0.updated_by_id AS updated_by_id_68,
  t0.status_id AS status_id_69,
  t0.contact1_id AS contact1_id_70,
  t0.contact2_id AS contact2_id_71,
  t0.contact3_id AS contact3_id_72,
  t0.organisation1_id AS organisation1_id_73,
  t0.organisation2_id AS organisation2_id_74,
  t0.organisation3_id AS organisation3_id_75,
  t0.related_post1_id AS related_post1_id_76,
  t0.related_post2_id AS related_post2_id_77,
  t0.related_post3_id AS related_post3_id_78,
  t0.palettecouleur_id AS palettecouleur_id_79,
  t0.old_status_id AS old_status_id_80,
  t0.edit_user_id AS edit_user_id_81,
  t0.position_image_id AS position_image_id_82,
  t0.lieu_new_id AS lieu_new_id_83,
  t0.couleur_id AS couleur_id_84,
  t0.couleur_mode_nuit_id AS couleur_mode_nuit_id_85,
  t0.couleur_texte_id AS couleur_texte_id_86
FROM
  post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.illustrationfil_name AS illustrationfil_name_2, t0.illustrationdetail_name AS illustrationdetail_name_3, t0.document_name1 AS document_name1_4, t0.document_name2 AS document_name2_5, t0.document_name3 AS document_name3_6, t0.image_url AS image_url_7, t0.thumb_url AS thumb_url_8, t0.title AS title_9, t0.short_description AS short_description_10, t0.content_duration AS content_duration_11, t0.restriction AS restriction_12, t0.state AS state_13, t0.suggested_by AS suggested_by_14, t0.published_at AS published_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.link1 AS link1_18, t0.url1 AS url1_19, t0.link2 AS link2_20, t0.url2 AS url2_21, t0.link3 AS link3_22, t0.url3 AS url3_23, t0.date_debut AS date_debut_24, t0.date_fin AS date_fin_25, t0.commentaires AS commentaires_26, t0.subtitle AS subtitle_27, t0.chapo AS chapo_28, t0.horaires AS horaires_29, t0.tarifs AS tarifs_30, t0.lieu AS lieu_31, t0.ville AS ville_32, t0.credits AS credits_33, t0.content AS content_34, t0.defaut_fil AS defaut_fil_35, t0.epingle1 AS epingle1_36, t0.epingle2 AS epingle2_37, t0.organized_by AS organized_by_38, t0.bool_date_maj AS bool_date_maj_39, t0.updated_date_display AS updated_date_display_40, t0.slug AS slug_41, t0.date_dernier_statut AS date_dernier_statut_42, t0.duree AS duree_43, t0.bool_actu AS bool_actu_44, t0.grand_format AS grand_format_45, t0.like_count AS like_count_46, t0.comment_count AS comment_count_47, t0.in_use AS in_use_48, t0.edit_date AS edit_date_49, t0.organisation4 AS organisation4_50, t0.affichage_type_map AS affichage_type_map_51, t0.affichage_type_map2 AS affichage_type_map2_52, t0.affichage_type_map3 AS affichage_type_map3_53, t0.musee_name AS musee_name_54, t0.musee_id AS musee_id_55, t0.order_folder AS order_folder_56, t0.order_tag AS order_tag_57, t0.openagenda_id AS openagenda_id_58, t0.archive AS archive_59, t0.date_update AS date_update_60, t0.json AS json_61, t0.openagenda_lieu AS openagenda_lieu_62, t0.openagenda_name AS openagenda_name_63, t0.markdown_description AS markdown_description_64, t0.musee_type AS musee_type_65, t0.type_id AS type_id_66, t0.created_by_id AS created_by_id_67, t0.updated_by_id AS updated_by_id_68, t0.status_id AS status_id_69, t0.contact1_id AS contact1_id_70, t0.contact2_id AS contact2_id_71, t0.contact3_id AS contact3_id_72, t0.organisation1_id AS organisation1_id_73, t0.organisation2_id AS organisation2_id_74, t0.organisation3_id AS organisation3_id_75, t0.related_post1_id AS related_post1_id_76, t0.related_post2_id AS related_post2_id_77, t0.related_post3_id AS related_post3_id_78, t0.palettecouleur_id AS palettecouleur_id_79, t0.old_status_id AS old_status_id_80, t0.edit_user_id AS edit_user_id_81, t0.position_image_id AS position_image_id_82, t0.lieu_new_id AS lieu_new_id_83, t0.couleur_id AS couleur_id_84, t0.couleur_mode_nuit_id AS couleur_mode_nuit_id_85, t0.couleur_texte_id AS couleur_texte_id_86 FROM post t0 WHERE t0.slug = 'steve-vai-paganini-5th-caprice-crossroads-blindfolded-cover' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  target_public t0
  INNER JOIN post_target_public ON t0.id = post_target_public.target_public_id
WHERE
  post_target_public.post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM target_public t0 INNER JOIN post_target_public ON t0.id = post_target_public.target_public_id WHERE post_target_public.post_id = 8137;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.display_name AS display_name_3
FROM
  post_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3 FROM post_type t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.kind AS kind_2,
  t0.display_name AS display_name_3
FROM
  topic t0
  INNER JOIN post_topic ON t0.id = post_topic.topic_id
WHERE
  post_topic.post_id = ?

SELECT t0.id AS id_1, t0.kind AS kind_2, t0.display_name AS display_name_3 FROM topic t0 INNER JOIN post_topic ON t0.id = post_topic.topic_id WHERE post_topic.post_id = 8137;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.kind AS kind_3,
  t0.ordre AS ordre_4
FROM
  territory t0
  INNER JOIN post_territory ON t0.id = post_territory.territory_id
WHERE
  post_territory.post_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.kind AS kind_3, t0.ordre AS ordre_4 FROM territory t0 INNER JOIN post_territory ON t0.id = post_territory.territory_id WHERE post_territory.post_id = 8137;

SELECT
  p0_.id AS id_0,
  p0_.illustrationfil_name AS illustrationfil_name_1,
  p0_.illustrationdetail_name AS illustrationdetail_name_2,
  p0_.document_name1 AS document_name1_3,
  p0_.document_name2 AS document_name2_4,
  p0_.document_name3 AS document_name3_5,
  p0_.image_url AS image_url_6,
  p0_.thumb_url AS thumb_url_7,
  p0_.title AS title_8,
  p0_.short_description AS short_description_9,
  p0_.content_duration AS content_duration_10,
  p0_.restriction AS restriction_11,
  p0_.state AS state_12,
  p0_.suggested_by AS suggested_by_13,
  p0_.published_at AS published_at_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p0_.link1 AS link1_17,
  p0_.url1 AS url1_18,
  p0_.link2 AS link2_19,
  p0_.url2 AS url2_20,
  p0_.link3 AS link3_21,
  p0_.url3 AS url3_22,
  p0_.date_debut AS date_debut_23,
  p0_.date_fin AS date_fin_24,
  p0_.commentaires AS commentaires_25,
  p0_.subtitle AS subtitle_26,
  p0_.chapo AS chapo_27,
  p0_.horaires AS horaires_28,
  p0_.tarifs AS tarifs_29,
  p0_.lieu AS lieu_30,
  p0_.ville AS ville_31,
  p0_.credits AS credits_32,
  p0_.content AS content_33,
  p0_.defaut_fil AS defaut_fil_34,
  p0_.epingle1 AS epingle1_35,
  p0_.epingle2 AS epingle2_36,
  p0_.organized_by AS organized_by_37,
  p0_.bool_date_maj AS bool_date_maj_38,
  p0_.updated_date_display AS updated_date_display_39,
  p0_.slug AS slug_40,
  p0_.date_dernier_statut AS date_dernier_statut_41,
  p0_.duree AS duree_42,
  p0_.bool_actu AS bool_actu_43,
  p0_.grand_format AS grand_format_44,
  p0_.like_count AS like_count_45,
  p0_.comment_count AS comment_count_46,
  p0_.in_use AS in_use_47,
  p0_.edit_date AS edit_date_48,
  p0_.organisation4 AS organisation4_49,
  p0_.affichage_type_map AS affichage_type_map_50,
  p0_.affichage_type_map2 AS affichage_type_map2_51,
  p0_.affichage_type_map3 AS affichage_type_map3_52,
  p0_.musee_name AS musee_name_53,
  p0_.musee_id AS musee_id_54,
  p0_.order_folder AS order_folder_55,
  p0_.order_tag AS order_tag_56,
  p0_.openagenda_id AS openagenda_id_57,
  p0_.archive AS archive_58,
  p0_.date_update AS date_update_59,
  p0_.json AS json_60,
  p0_.openagenda_lieu AS openagenda_lieu_61,
  p0_.openagenda_name AS openagenda_name_62,
  p0_.markdown_description AS markdown_description_63,
  p0_.musee_type AS musee_type_64,
  p0_.type_id AS type_id_65,
  p0_.created_by_id AS created_by_id_66,
  p0_.updated_by_id AS updated_by_id_67,
  p0_.status_id AS status_id_68,
  p0_.contact1_id AS contact1_id_69,
  p0_.contact2_id AS contact2_id_70,
  p0_.contact3_id AS contact3_id_71,
  p0_.organisation1_id AS organisation1_id_72,
  p0_.organisation2_id AS organisation2_id_73,
  p0_.organisation3_id AS organisation3_id_74,
  p0_.related_post1_id AS related_post1_id_75,
  p0_.related_post2_id AS related_post2_id_76,
  p0_.related_post3_id AS related_post3_id_77,
  p0_.palettecouleur_id AS palettecouleur_id_78,
  p0_.old_status_id AS old_status_id_79,
  p0_.edit_user_id AS edit_user_id_80,
  p0_.position_image_id AS position_image_id_81,
  p0_.lieu_new_id AS lieu_new_id_82,
  p0_.couleur_id AS couleur_id_83,
  p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_84,
  p0_.couleur_texte_id AS couleur_texte_id_85
FROM
  post p0_
  LEFT JOIN post_topic p2_ ON p0_.id = p2_.post_id
  LEFT JOIN topic t1_ ON t1_.id = p2_.topic_id
  LEFT JOIN post_territory p4_ ON p0_.id = p4_.post_id
  LEFT JOIN territory t3_ ON t3_.id = p4_.territory_id
WHERE
  p0_.id <> ?
  AND p0_.status_id = 5
  AND p0_.slug IS NOT NULL
  AND p0_.type_id = ?
  AND (
    t1_.id IN (?)
    OR t3_.id IN (?)
  )
ORDER BY
  STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') DESC

SELECT p0_.id AS id_0, p0_.illustrationfil_name AS illustrationfil_name_1, p0_.illustrationdetail_name AS illustrationdetail_name_2, p0_.document_name1 AS document_name1_3, p0_.document_name2 AS document_name2_4, p0_.document_name3 AS document_name3_5, p0_.image_url AS image_url_6, p0_.thumb_url AS thumb_url_7, p0_.title AS title_8, p0_.short_description AS short_description_9, p0_.content_duration AS content_duration_10, p0_.restriction AS restriction_11, p0_.state AS state_12, p0_.suggested_by AS suggested_by_13, p0_.published_at AS published_at_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.link1 AS link1_17, p0_.url1 AS url1_18, p0_.link2 AS link2_19, p0_.url2 AS url2_20, p0_.link3 AS link3_21, p0_.url3 AS url3_22, p0_.date_debut AS date_debut_23, p0_.date_fin AS date_fin_24, p0_.commentaires AS commentaires_25, p0_.subtitle AS subtitle_26, p0_.chapo AS chapo_27, p0_.horaires AS horaires_28, p0_.tarifs AS tarifs_29, p0_.lieu AS lieu_30, p0_.ville AS ville_31, p0_.credits AS credits_32, p0_.content AS content_33, p0_.defaut_fil AS defaut_fil_34, p0_.epingle1 AS epingle1_35, p0_.epingle2 AS epingle2_36, p0_.organized_by AS organized_by_37, p0_.bool_date_maj AS bool_date_maj_38, p0_.updated_date_display AS updated_date_display_39, p0_.slug AS slug_40, p0_.date_dernier_statut AS date_dernier_statut_41, p0_.duree AS duree_42, p0_.bool_actu AS bool_actu_43, p0_.grand_format AS grand_format_44, p0_.like_count AS like_count_45, p0_.comment_count AS comment_count_46, p0_.in_use AS in_use_47, p0_.edit_date AS edit_date_48, p0_.organisation4 AS organisation4_49, p0_.affichage_type_map AS affichage_type_map_50, p0_.affichage_type_map2 AS affichage_type_map2_51, p0_.affichage_type_map3 AS affichage_type_map3_52, p0_.musee_name AS musee_name_53, p0_.musee_id AS musee_id_54, p0_.order_folder AS order_folder_55, p0_.order_tag AS order_tag_56, p0_.openagenda_id AS openagenda_id_57, p0_.archive AS archive_58, p0_.date_update AS date_update_59, p0_.json AS json_60, p0_.openagenda_lieu AS openagenda_lieu_61, p0_.openagenda_name AS openagenda_name_62, p0_.markdown_description AS markdown_description_63, p0_.musee_type AS musee_type_64, p0_.type_id AS type_id_65, p0_.created_by_id AS created_by_id_66, p0_.updated_by_id AS updated_by_id_67, p0_.status_id AS status_id_68, p0_.contact1_id AS contact1_id_69, p0_.contact2_id AS contact2_id_70, p0_.contact3_id AS contact3_id_71, p0_.organisation1_id AS organisation1_id_72, p0_.organisation2_id AS organisation2_id_73, p0_.organisation3_id AS organisation3_id_74, p0_.related_post1_id AS related_post1_id_75, p0_.related_post2_id AS related_post2_id_76, p0_.related_post3_id AS related_post3_id_77, p0_.palettecouleur_id AS palettecouleur_id_78, p0_.old_status_id AS old_status_id_79, p0_.edit_user_id AS edit_user_id_80, p0_.position_image_id AS position_image_id_81, p0_.lieu_new_id AS lieu_new_id_82, p0_.couleur_id AS couleur_id_83, p0_.couleur_mode_nuit_id AS couleur_mode_nuit_id_84, p0_.couleur_texte_id AS couleur_texte_id_85 FROM post p0_ LEFT JOIN post_topic p2_ ON p0_.id = p2_.post_id LEFT JOIN topic t1_ ON t1_.id = p2_.topic_id LEFT JOIN post_territory p4_ ON p0_.id = p4_.post_id LEFT JOIN territory t3_ ON t3_.id = p4_.territory_id WHERE p0_.id <> 8137 AND p0_.status_id = 5 AND p0_.slug IS NOT NULL AND p0_.type_id = 4 AND (t1_.id IN (4) OR t3_.id IN (2)) ORDER BY STR_TO_DATE(p0_.date_debut, '%d/%m/%Y') DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone_number AS phone_number_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.term_version AS term_version_8,
  t0.font_size AS font_size_9,
  t0.font_family AS font_family_10,
  t0.dark_mode AS dark_mode_11,
  t0.password AS password_12,
  t0.role AS role_13,
  t0.token_reset AS token_reset_14,
  t0.active AS active_15,
  t0.token_activation AS token_activation_16,
  t0.private_posts_only AS private_posts_only_17,
  t0.public_id AS public_id_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone_number AS phone_number_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.term_version AS term_version_8, t0.font_size AS font_size_9, t0.font_family AS font_family_10, t0.dark_mode AS dark_mode_11, t0.password AS password_12, t0.role AS role_13, t0.token_reset AS token_reset_14, t0.active AS active_15, t0.token_activation AS token_activation_16, t0.private_posts_only AS private_posts_only_17, t0.public_id AS public_id_18 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  statut t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM statut t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.active AS active_3,
  t0.couleur AS couleur_4,
  t0.contenu AS contenu_5,
  t0.visible_nordinfo AS visible_nordinfo_6,
  t0.visible_lenord AS visible_lenord_7,
  t0.visible_services AS visible_services_8,
  t0.visible_section_politiques AS visible_section_politiques_9,
  t0.visible_section_institution AS visible_section_institution_10,
  t0.visible_section_services AS visible_section_services_11,
  t0.visible_accueil_lenord AS visible_accueil_lenord_12,
  t0.visible_accueil_services AS visible_accueil_services_13,
  t0.visible_espace_documentaire AS visible_espace_documentaire_14,
  t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15,
  t0.visible_pages_legales_services AS visible_pages_legales_services_16,
  t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17,
  t0.visible_glossaire_lenord AS visible_glossaire_lenord_18,
  t0.visible_glossaire_services AS visible_glossaire_services_19,
  t0.visible_mesinfos AS visible_mesinfos_20,
  t0.visible_a_la_une AS visible_a_la_une_21,
  t0.visible_agenda AS visible_agenda_22,
  t0.visible_videos AS visible_videos_23,
  t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24,
  t0.visible_cartographie AS visible_cartographie_25,
  t0.color_id AS color_id_26
FROM
  epingle t0
WHERE
  t0.active = ?
  AND t0.visible_nordinfo = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = 1 AND t0.visible_nordinfo = 1;