Partager sur Facebook
Partager sur Twitter
Partager sur Google+

Jared Leto: filmographie et extraits vidéos

Ex : Meilleur film 2016, X-Men: Apocalypse, Ben Affleck

Artiste
Jared Leto

Je suis fan

Acteur , 11 fans

> Toutes les photos

Filmographie sélective de Jared Leto

Notice: Undefined index: filmGenre in /home/symfony/lib/view/escaper/sfOutputEscaperArrayDecorator.class.php on line 162

Fight Club

(1999, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Requiem for a Dream

(2001, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Mr Nobody

(2009, Canada)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Lord of War

(2005, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

American Psycho

(2000, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Dallas Buyers Club

(2013, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Panic Room

(2002, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

Suicide Squad

(2016, Etats-Unis)

Fan

Dernier bon film

Notez le film :

A voir

Pas intéressé

> Voir la filmographie complète

Extraits de films, bande-annonces

Vous pouvez ajouter un extrait de film de Jared Leto

Notice: Undefined variable: ofMovie in /home/cinetrafic/dev/apps/frontend/modules/media/templates/_videoBlock.php on line 15

Toutes les vidéos (12)

Bandes-annonces (3)

Extraits de Films (7)

Autre (2)

Commentaires

Ajouter un commentaire à l'artiste Jared Leto

Ils sont fans

nicopod

kroutchyki

Loup

> Tous les fans

Response

Settings

app_Indexation_Class: Indexation
app_Indexation_FilmCulture:
  fr_FR: Filmfr
  en_US: Filmus
app_Indexation_Filmfr:
  - Titre
  - TitreOriginal
  - 'Culture_=_''fr_FR'''
  - IsActivated_=_1
app_Indexation_Filmus:
  - Titre
  - TitreOriginal
  - 'Culture_=_''en_US'''
  - IsActivated_=_1
app_Indexation_ListeCulture:
  fr_FR: Listefr
  en_US: Listeus
app_Indexation_Listefr:
  - Name
  - 'Culture_=_''fr_FR'''
  - IsSaved_=_1
app_Indexation_Listeus:
  - Name
  - 'Culture_=_''en_US'''
  - IsSaved_=_1
app_Indexation_Pagegen:
  'Description,': Title
app_Indexation_Personne:
  - Name
app_Indexation_RegEx: '([a-zA-Z0-9]{1,})'
app_Indexation_Seriefr:
  - Titre
  - TitreOriginal
  - 'Culture_=_''fr_FR'''
  - IsActivated_=_1
app_Indexation_Serieus:
  - Titre
  - TitreOriginal
  - 'Culture_=_''en_US'''
  - IsActivated_=_1
app_Indexation_Structure:
  Users: Users
  Personne: Personne
  Video: Media
  Filmfr: Film
  Listefr: Liste
  Seriesfr: Film
  Pagegen: Page
app_Indexation_Tables:
  Users: Users
  Personne: Personne
  Video: Media
  Filmfr: Film
  Listefr: Liste
  Pagegen: Page
app_Indexation_Users:
  - Login
  - FirstName
  - LastName
app_Indexation_Video:
  - Titre
  - IsVideo_=_1
  - IsAffiche_=_0
  - IsPhoto_=_0
app_PropositionChampsToTranslate_Film:
  - Titre
  - Synopsis
app_PropositionChampsToTranslate_Media:
  - Titre
  - Description
app_PropositionChampsToTranslate_Tag:
  - Name
app_PropositionChamps_Film:
  - Titre
  - TitreOriginal
  - Synopsis
  - Duree
  - DateSortie
app_PropositionChamps_Media:
  - MediaIs
  - File
  - Type
  - Description
  - Thumbnail
  - Duree
app_PropositionChamps_Personne:
  - Name
app_PropositionChamps_Tag:
  - Name
app_Proposition_Categories:
  - Film
  - Personne
  - Tag
  - FilmActeur
  - FilmProducteur
  - FilmRealisateur
  - FilmScenariste
  - FilmTag
  - FilmGenre
  - FilmCountry
  - Media
app_Proposition_Film:
  Type: Object
  Add: 1
  Edit: 1
  Delete: 0
  Class: FilmPeer
app_Proposition_FilmActeur:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmPersonnePeer
app_Proposition_FilmCountry:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmCountryPeer
app_Proposition_FilmGenre:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmGenrePeer
app_Proposition_FilmProducteur:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmPersonnePeer
app_Proposition_FilmRealisateur:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmPersonnePeer
app_Proposition_FilmScenariste:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 1
  Class: FilmPersonnePeer
app_Proposition_FilmTag:
  Type: Association
  Add: 1
  Edit: 0
  Delete: 0
  Class: FilmTagPeer
app_Proposition_Media:
  Type: Object
  Add: 1
  Edit: 0
  Delete: 1
  Class: MediaPeer
app_Proposition_Personne:
  Type: Object
  Add: 1
  Edit: 1
  Delete: 0
  Class: PersonnePeer
app_Proposition_Tag:
  Type: Object
  Add: 1
  Edit: 0
  Delete: 0
  Class: TagPeer
app_Proposition_TranslateWord: (translate_me)
app_Search_CategoriesAjaxen_US:
  Filmus: Movies
  Seriesus: Séries
  Personne: Artists
  Listeus: Lists
app_Search_CategoriesAjaxfr_FR:
  Filmfr: Films
  Seriesfr: Séries
  Personne: Artistes
  Listefr: Listes
app_Search_Categoriesen_US:
  All: All
  Filmus: Movies
  Seriesus: Séries
  Personne: Artists
  Pagegen: Génériques
  Listeus: Lists
  Video: Videos
  Users: Members
app_Search_Categoriesfr_FR:
  All: Tous
  Filmfr: Films
  Seriesfr: Séries
  Personne: Artistes
  Pagegen: Génériques
  Listefr: Listes
  Video: Vidéos
  Users: Membres
app_Search_Filmfr:
  - Titre
  - TitreOriginal
  - 'Culture_=_''fr_FR'''
  - IsActivated_=_1
app_Search_Filmus:
  - Titre
  - TitreOriginal
  - 'Culture_=_''en_US'''
  - IsActivated_=_1
app_Search_Listefr:
  - Name
  - 'Culture_=_''fr_FR'''
  - IsSaved_=_1
app_Search_Listeus:
  - Name
  - 'Culture_=_''en_US'''
  - IsSaved_=_1
app_Search_NbTuplesAll:
  Filmfr: 4
  Filmus: 4
  SeriesFr: 4
  SeriesUs: 4
  Personne: 4
  Listefr: 6
  Listeus: 6
  Video: 8
  Users: 12
  Pagegen: 4
app_Search_NbTuplesOne:
  Filmfr: 10
  Filmus: 10
  SeriesFr: 10
  SeriesUs: 10
  Personne: 10
  Listefr: 6
  Listeus: 6
  Video: 8
  Users: 12
  Pagegen: 10
app_Search_Pagegen:
  - Title
  - Description
app_Search_Partials:
  Filmfr: film
  Filmus: film
  Seriesfr: serie
  Personne: personne
  Users: users
  Video: video
  Listefr: liste
  Listeus: liste
  Pagegen: page
app_Search_Personne:
  - Name
app_Search_Seriesfr:
  - Titre
  - TitreOriginal
  - 'Culture_=_''fr_FR'''
  - IsActivated_=_1
app_Search_Seriesus:
  - Titre
  - TitreOriginal
  - 'Culture_=_''en_US'''
  - IsActivated_=_1
app_Search_Users:
  - Login
  - FirstName
  - LastName
app_Search_Video:
  - Titre
  - IsVideo_=_1
  - IsAffiche_=_0
  - IsPhoto_=_0
app_activity_days: 10
app_activity_prepared_actu:
  path: prepared/mon_actu/%s
  file: mon_actu_%d.php
app_advertisement_images_path: advertisement/images
app_advertisement_images_spath: advertisement/images/s
app_advertisement_images_xpath: advertisement/images/x
app_advertisement_swf_path: advertisement/swf
app_affiche_bigCrop: false
app_affiche_bigMaxHeight: 260
app_affiche_bigMaxWidth: 195
app_affiche_bigPath: images/affiches/big
app_affiche_formats:
  - original
  - big
  - medium
  - thumbnail
app_affiche_maxWeight: 2097152
app_affiche_maxWeightMessage: 'Taille Maximale 2Mo'
app_affiche_mediumCrop: false
app_affiche_mediumMaxHeight: 191
app_affiche_mediumMaxWidth: 143
app_affiche_mediumPath: images/affiches/medium
app_affiche_originalCrop: false
app_affiche_originalMaxHeight: 2800
app_affiche_originalMaxWidth: 2800
app_affiche_originalPath: images/affiches/original
app_affiche_path: images/affiches
app_affiche_prefixe: aff_
app_affiche_saison_formats:
  - original
  - thumbnail
app_affiche_saison_maxWeight: 5242880
app_affiche_saison_maxWeightMessage: 'Taille Maximale 5Mo'
app_affiche_saison_originalCrop: false
app_affiche_saison_originalMaxHeight: 1000
app_affiche_saison_originalMaxWidth: 1000
app_affiche_saison_originalPath: images/series/original
app_affiche_saison_path: images/series
app_affiche_saison_prefixe: aff_
app_affiche_saison_thumbnailCrop: false
app_affiche_saison_thumbnailMaxHeight: 97
app_affiche_saison_thumbnailMaxWidth: 176
app_affiche_saison_thumbnailPath: images/series/thumb
app_affiche_thumbnailCrop: false
app_affiche_thumbnailMaxHeight: 99
app_affiche_thumbnailMaxWidth: 75
app_affiche_thumbnailPath: images/affiches/thumb
app_affiche_vod_bigCrop: false
app_affiche_vod_bigMaxHeight: 600
app_affiche_vod_bigMaxWidth: 600
app_affiche_vod_bigPath: images/affiches_vod/big
app_affiche_vod_formats:
  - original
  - big
  - medium
  - thumbnail
app_affiche_vod_maxWeight: 2097152
app_affiche_vod_maxWeightMessage: 'Taille Maximale 2Mo'
app_affiche_vod_mediumCrop: false
app_affiche_vod_mediumMaxHeight: 191
app_affiche_vod_mediumMaxWidth: 143
app_affiche_vod_mediumPath: images/affiches_vod/medium
app_affiche_vod_originalCrop: false
app_affiche_vod_originalMaxHeight: 4800
app_affiche_vod_originalMaxWidth: 4800
app_affiche_vod_originalPath: images/affiches_vod/original
app_affiche_vod_path: images/affiches_vod
app_affiche_vod_prefixe: aff_
app_affiche_vod_thumbnailCrop: false
app_affiche_vod_thumbnailMaxHeight: 99
app_affiche_vod_thumbnailMaxWidth: 75
app_affiche_vod_thumbnailPath: images/affiches_vod/thumb
app_avatar_bigMaxHeight: 191
app_avatar_bigMaxWidth: 143
app_avatar_bigPath: images/avatar/big
app_avatar_default: inconnu.jpg
app_avatar_maxHeight: 70
app_avatar_maxWeight: 2097152
app_avatar_maxWeightMessage: 'Taille Maximale 2Mo'
app_avatar_maxWidth: 70
app_avatar_mediumMaxHeight: 136
app_avatar_mediumMaxWidth: 100
app_avatar_mediumPath: images/avatar/medium
app_bobinz_bug_report_mail: julien@cinetrafic.fr
app_bobinz_cultures:
  - en_US
  - fr_FR
app_bobinz_key: 'the bobinz super key that no one can find it except chuck norris'
app_bobinz_mail_no_reply: no-reply@cinetrafic.fr
app_carousel_slide_path: carousel_slide
app_en_ce_moment_bandes_annonces: 65
app_en_ce_moment_dvd_id: 11398
app_en_ce_moment_liste_ba_id: 4222
app_en_ce_moment_liste_serie_id: 10032
app_en_ce_moment_liste_serie_id2: 10227
app_en_ce_moment_new_film_page_id: 21
app_en_ce_moment_top_fim_page_id: 74
app_facebook_app_id: 498169053584808
app_facebook_fields: 'id,first_name,last_name,email'
app_file_bestFilm: file/meilleurs
app_file_fanFilm: file/fan
app_groupe_maxWeight: 2097152
app_groupe_maxWeightMessage: 'Taille Maximale 2Mo'
app_groupe_mediumMaxHeight: 125
app_groupe_mediumMaxWidth: 92
app_groupe_mediumPath: images/groupe/medium
app_groupe_prefixe: groupe_img_
app_groupe_thumbnailMaxHeight: 75
app_groupe_thumbnailMaxWidth: 55
app_groupe_thumbnailPath: images/groupe/thumb
app_home_film1_culture: fr_FR
app_home_film1_id: 13428
app_home_film2_culture: fr_FR
app_home_film2_id: 1709
app_home_liste_culture: fr_FR
app_home_liste_id: 1
app_home_user_id: 16
app_hub_country:
  - 41
  - 138
  - 74
  - 59
app_hub_genre:
  - 6
  - 629
  - 103
  - 12
  - 7
  - 11
  - 34
  - 9
  - 598
  - 13
  - 158
  - 4
  - 1
  - 213
app_hub_keywords:
  - '1079,1114,5395,5417,5418,5523,5532,5538,6590'
  - '35'
  - '5414'
  - '1020,1362,1915,2375,5414,5439,6566,7183'
  - '5496,5497'
  - '982'
  - '1445,2335,5389,5394,5403,5439'
  - '965,1111,1112,2090,7029'
  - '2323'
  - '2326'
  - '2318'
  - '6136'
  - '6288'
  - '1258'
  - '7229'
  - '1939'
  - '5458'
  - '991'
  - '1647,7269,7552'
  - '1061,1062,5538,7044,7168'
  - '28'
  - '1386'
  - '1194'
  - '1022'
  - '5399,5401'
  - '1404'
  - '1878,1879,5392,7238'
  - '1076'
  - '978'
  - '1004,1793,2150'
  - '5547'
  - '6280,6286'
  - '1530,1928,7376'
  - '5478'
app_hub_liste_culte: 9493
app_hub_liste_culte_kw: 7039
app_hub_liste_recent: 8067
app_hub_liste_serie_a_voir: 10889
app_hub_liste_serie_nlle: 10881
app_hub_liste_serie_recent: 10890
app_list_last_film: 4144
app_list_new_film: 4144
app_list_recent_film: 4144
app_liste_maxWeight: 2097152
app_liste_maxWeightMessage: 'Taille Maximale 2Mo'
app_liste_mediumMaxHeight: 191
app_liste_mediumMaxWidth: 143
app_liste_mediumPath: images/liste/medium
app_liste_prefixe: liste_img_
app_liste_thumbnailMaxHeight: 99
app_liste_thumbnailMaxWidth: 74
app_liste_thumbnailPath: images/liste/thumb
app_news_img_path: images/news_img
app_np_assets_optimizer_plugin_class: npAssetsOptimizerService
app_np_assets_optimizer_plugin_configuration:
  javascript: { enabled: false, class: npOptimizerJavascript, params: { driver: JSMin, destination: /js/optimized.js, timestamp: true, files: {  } } }
  stylesheet: { enabled: true, class: npOptimizerStylesheet, params: { driver: Cssmin, destination: /css/optimized.css, timestamp: true, files: [main.css, fonts.css, modalbox.css, jquery.rating.css, jquery.bxslider_small.css] } }
  png_image: { enabled: false, class: npOptimizerPngImage, params: { driver: Pngout, folders: [/home/cinetrafic/dev/web/images] } }
app_np_assets_optimizer_plugin_enabled: true
app_partenaire_images_path: images/partenaires
app_path_affiches: images/affiches
app_path_avatar: images/avatar
app_path_dico: dico
app_path_icons: images/icons
app_path_images: images
app_path_photos: images/photos
app_path_service_vod: images/service_vod
app_path_theme: images/theme
app_photo_bigCrop: false
app_photo_bigMaxHeight: 580
app_photo_bigMaxWidth: 620
app_photo_bigPath: images/photos/big
app_photo_formats:
  - big
  - medium
  - thumbnail
app_photo_maxWeight: 2097152
app_photo_maxWeightMessage: 'Taille Maximale 2Mo'
app_photo_mediumCrop: false
app_photo_mediumMaxHeight: 320
app_photo_mediumMaxWidth: 450
app_photo_mediumPath: images/photos/medium
app_photo_path: images/photos
app_photo_prefixe: pic_
app_photo_thumbnailCrop: true
app_photo_thumbnailMaxHeight: 100
app_photo_thumbnailMaxWidth: 100
app_photo_thumbnailPath: images/photos/thumb
app_recommendation_grid_emotions_id: 19
app_recommendation_grid_genre_id: 20
app_recommendation_grid_id_1: 7
app_recommendation_grid_id_5: 18
app_recommendation_listes_envie_1:
  - 10033
  - 10034
  - 10035
  - 10036
  - 10037
  - 10038
  - 10039
  - 10040
  - 10041
  - 10042
  - 10043
  - 10044
  - 10045
  - 10046
  - 10047
  - 10048
app_recommendation_listes_envie_5:
  - 10033
app_recommendation_listes_envie_emotions:
  - 10105
  - 10106
  - 10107
  - 10108
  - 10109
  - 10110
  - 10111
  - 10112
  - 10113
  - 10114
  - 10115
  - 10116
app_recommendation_listes_envie_genre:
  - 10077
  - 10079
  - 10082
  - 10084
  - 10085
  - 10088
  - 10091
  - 10096
  - 10097
  - 10098
  - 10099
  - 10100
  - 10101
  - 10102
  - 10103
  - 10104
app_selenium_browserurl: 'http://test.cinetrafic.popdevelopment.sg/'
app_sfSimpleForumPlugin_allow_new_topic_outside_forum: false
app_sfSimpleForumPlugin_breadcrumb_separator: ' > '
app_sfSimpleForumPlugin_count_views: true
app_sfSimpleForumPlugin_display_categories: false
app_sfSimpleForumPlugin_feed_max: 10
app_sfSimpleForumPlugin_forum_name: 'Forum CinéTraffic'
app_sfSimpleForumPlugin_include_breadcrumb: true
app_sfSimpleForumPlugin_link_to_remote_border_div: popUpDivContent
app_sfSimpleForumPlugin_link_to_remote_loading_div: waitPlease
app_sfSimpleForumPlugin_link_to_remote_modal_div: modalDiv
app_sfSimpleForumPlugin_link_to_remote_update_div: myContent
app_sfSimpleForumPlugin_main_container: forum_film
app_sfSimpleForumPlugin_max_per_block: 10
app_sfSimpleForumPlugin_max_per_page: 10
app_sfSimpleForumPlugin_pages_displayed: 10
app_sfSimpleForumPlugin_show_author_details: true
app_sfSimpleForumPlugin_use_feeds: false
app_sfSimpleForumPlugin_user_class: Users
app_sfSimpleForumPlugin_user_retrieve_by_name_method: popRetrieveByLogin
app_url_freebase: 'http://www.freebase.com/api/trans/image_thumb/'
app_user_login_max_length: 20
app_user_login_min_lingth: 4
app_user_login_pattern: '^[a-zA-Z0-9_-]+$'
app_video_height: 385
app_video_thumbnailMaxHeight: 153
app_video_thumbnailMaxWidth: 194
app_video_thumbnailPath: images/thumbnailvideo
app_video_thumbnailPathTemp: images/thumbnailvideoTemp
app_video_thumbnailShareMaxHeight: 120
app_video_thumbnailShareMaxWidth: 152
app_video_thumbnailSharePath: images/thumbnailvideo/share
app_video_width: 640
app_wallpaper_bigCrop: false
app_wallpaper_bigMaxHeight: 600
app_wallpaper_bigMaxWidth: 600
app_wallpaper_bigPath: images/wallpaper/big
app_wallpaper_formats:
  - original
  - big
  - medium
  - thumbnail
app_wallpaper_maxWeight: 5242880
app_wallpaper_maxWeightMessage: 'Taille Maximale 5Mo'
app_wallpaper_mediumCrop: false
app_wallpaper_mediumMaxHeight: 191
app_wallpaper_mediumMaxWidth: 143
app_wallpaper_mediumPath: images/wallpaper/medium
app_wallpaper_originalCrop: false
app_wallpaper_originalMaxHeight: 4800
app_wallpaper_originalMaxWidth: 4800
app_wallpaper_originalPath: images/wallpaper/original
app_wallpaper_path: images/wallpaper
app_wallpaper_prefixe: aff_
app_wallpaper_thumbnailCrop: false
app_wallpaper_thumbnailMaxHeight: 99
app_wallpaper_thumbnailMaxWidth: 75
app_wallpaper_thumbnailPath: images/wallpaper/thumb
app_web_service_recommendation_admin_mail: julien.batifoulier@gmail.com
app_web_service_recommendation_csv_path: '/home/cinetrafic/dev/web/csv/webservice/:client_id/'
app_web_service_recommendation_file_path: 'xml/webservice/:client_name'
app_web_service_recommendation_logo:
  root: images/webservice_client_logo
  path: images/webservice_client_logo/%id%/
  width: 100
  height: 100
app_web_service_recommendation_root_path: xml
app_web_service_recommendation_webservice_path: /home/cinetrafic/dev/web/xml/webservice/
mod_advertisement_enabled: true
mod_advertisement_is_internal: false
mod_advertisement_view_class: sfPHP
mod_main_enabled: true
mod_main_is_internal: false
mod_main_view_class: sfPHP
mod_menu_enabled: true
mod_menu_is_internal: false
mod_menu_view_class: sfPHP
mod_personne_enabled: true
mod_personne_is_internal: false
mod_personne_view_class: sfPHP
mod_similar_link_enabled: true
mod_similar_link_is_internal: false
mod_similar_link_view_class: sfPHP
pop_sf_FlowPlayer_css_dir: /popSfFlowPlayerPlugin/css
pop_sf_FlowPlayer_images_dir: /popSfFlowPlayerPlugin/images
pop_sf_FlowPlayer_js_dir: /popSfFlowPlayerPlugin/js
pop_sf_FlowPlayer_player: FlowPlayer.swf
pop_sf_FlowPlayer_swf_dir: /popSfFlowPlayerPlugin/swf
pop_sf_FlowPlayer_web_dir: /popSfFlowPlayerPlugin
sf_admin_module_web_dir: /sfPropelPlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/cinetrafic/dev/cache/frontend
sf_app_cache_dir: /home/cinetrafic/dev/cache/frontend/dev
sf_app_config_dir: /home/cinetrafic/dev/apps/frontend/config
sf_app_dir: /home/cinetrafic/dev/apps/frontend
sf_app_i18n_dir: /home/cinetrafic/dev/apps/frontend/i18n
sf_app_lib_dir: /home/cinetrafic/dev/apps/frontend/lib
sf_app_module_dir: /home/cinetrafic/dev/apps/frontend/modules
sf_app_template_dir: /home/cinetrafic/dev/apps/frontend/templates
sf_apps_dir: /home/cinetrafic/dev/apps
sf_cache: true
sf_cache_dir: /home/cinetrafic/dev/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compressed: false
sf_config_cache_dir: /home/cinetrafic/dev/cache/frontend/dev/config
sf_config_dir: /home/cinetrafic/dev/config
sf_csrf_secret: false
sf_data_dir: /home/cinetrafic/dev/data
sf_debug: true
sf_default_culture: fr_FR
sf_doc_dir: /home/cinetrafic/dev/doc
sf_enabled_modules:
  - sfSimpleForum
  - keyword
  - sfFacebookConnectAuth
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: main
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_i18n: true
sf_i18n_cache_dir: /home/cinetrafic/dev/cache/frontend/dev/i18n
sf_keyword_web_dir: /popKeywordPlugin
sf_lazy_cache_key: false
sf_lib_dir: /home/cinetrafic/dev/lib
sf_lightbox_css_dir: /sfLightboxPlugin/css/
sf_lightbox_images_dir: /sfLightboxPlugin/images/
sf_lightbox_is_loaded: true
sf_lightbox_js_dir: /sfLightboxPlugin/js/
sf_log_dir: /home/cinetrafic/dev/log
sf_logging_enabled: true
sf_login_action: signIn
sf_login_module: users
sf_max_forwards: 5
sf_module_cache_dir: /home/cinetrafic/dev/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: true
sf_orm: propel
sf_plugins_dir: /home/cinetrafic/dev/plugins
sf_rich_text_js_dir: /js/tiny_mce
sf_root_dir: /home/cinetrafic/dev
sf_secure_action: secure
sf_secure_module: default
sf_simple_forum_css_dir: /sfSimpleForumPlugin/css
sf_simple_forum_js_dir: /sfSimpleForumPlugin/js
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - npOptimizer
sf_strip_comments: true
sf_symfony_lib_dir: /home/symfony/lib
sf_template_cache_dir: /home/cinetrafic/dev/cache/frontend/dev/template
sf_test_cache_dir: /home/cinetrafic/dev/cache/frontend/dev/test
sf_test_dir: /home/cinetrafic/dev/test
sf_upload_dir: /home/cinetrafic/dev/web/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' &darr;&nbsp;'
sf_validation_error_suffix: ' &nbsp;&darr;'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /home/cinetrafic/dev/web
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false

Globals

Php

Logs

#	type	message
1	PatternRouting	Connect sfRoute "test_flow_player" (/testFlowPlayerSimpleMultiple)
2	PatternRouting	Connect sfRoute "test_flow_player_js" (/testFlowPlayerJS)
3	PatternRouting	Connect sfRoute "test_flow_player_js_tabs" (/testFlowPlayerJSTabs)
4	PatternRouting	Connect sfRoute "forum_home" (/forum)
5	PatternRouting	Connect sfRoute "forum_topic_remote" (/forum/topic/remote)
6	PatternRouting	Connect sfRoute "forum_latest_post_for_user_remote" (/forum/latest/for/user)
7	PatternRouting	Connect sfRoute "forum_new_topic_remote" (/forum/new_topic/remote)
8	PatternRouting	Connect sfRoute "forum_post_remote" (/forum_message/remote)
9	PatternRouting	Connect sfRoute "forum_moderator_delete_topic_remote" (/forum/delete/topic/remote)
10	PatternRouting	Connect sfRoute "forum_forum_remote" (/forum/remote)
11	PatternRouting	Connect sfRoute "forum_moderator_delete_post_remote" (/forum/delete/post/remote)
12	PatternRouting	Connect sfRoute "forum_post_edit_remote" (/forum/post/edit/remote)
13	PatternRouting	Connect sfRoute "forum_moderator_toggle_stick_remote" (/forum/stick/unstick/remote)
14	PatternRouting	Connect sfRoute "forum_moderator_toggle_lock_remote" (/forum/lock/unlock/remote)
15	PatternRouting	Connect sfRoute "forum_list" (/forum/list)
16	PatternRouting	Connect sfRoute "forum_latest_messages" (/forum/latest/messages/:page)
17	PatternRouting	Connect sfRoute "forum_latest_messages_feed" (/forum/latest/feed)
18	PatternRouting	Connect sfRoute "forum_forum" (/forum/:forum_name/:page)
19	PatternRouting	Connect sfRoute "forum_latest_messages_for_forum" (/forum/:forum_name/latest/:page)
20	PatternRouting	Connect sfRoute "forum_latest_messages_for_forum_feed" (/forum/:forum_name/latest/feed)
21	PatternRouting	Connect sfRoute "forum_topic" (/forum/topic/:id/:stripped_title/:page)
22	PatternRouting	Connect sfRoute "forum_topic_feed" (/forum/topic/:id/:stripped_title/feed)
23	PatternRouting	Connect sfRoute "forum_new_topic" (/forum/new_topic/:forum_name)
24	PatternRouting	Connect sfRoute "forum_add_topic" (/forum/add/topic)
25	PatternRouting	Connect sfRoute "forum_latest_messages_by_user" (/forum/user/:username/:page)
26	PatternRouting	Connect sfRoute "forum_latest_messages_by_user_feed" (/forum/user/:username/rss)
27	PatternRouting	Connect sfRoute "forum_post" (/forum_message/:id)
28	PatternRouting	Connect sfRoute "forum_post_edit" (/forum/post/edit/:post_id/:post_author)
29	PatternRouting	Connect sfRoute "forum_post_update" (/forum/post/update)
30	PatternRouting	Connect sfRoute "forum_post_add" (/forum/post/add)
31	PatternRouting	Connect sfRoute "forum_latest_topic" (/forum/latest/topic)
32	PatternRouting	Connect sfRoute "forum_latest_post_for_user" (/forum/latest/:username)
33	PatternRouting	Connect sfRoute "forum_moderator_delete_topic" (/forum/delete/topic/:id)
34	PatternRouting	Connect sfRoute "forum_moderator_delete_post" (/forum/delete/post/:id)
35	PatternRouting	Connect sfRoute "forum_moderator_toggle_stick" (/forum/stick/unstick/:id)
36	PatternRouting	Connect sfRoute "forum_moderator_toggle_lock" (/forum/lock/unlock/:id)
37	PatternRouting	Connect sfRoute "forum_user_latestTopics" (/forum/user/latest/topics/:username)
38	PatternRouting	Connect sfRoute "forum_user_latestPosts" (/forum/user/latest/posts/:username/:page)
39	PatternRouting	Connect sfRoute "forum_latest_posts" (/forum/latest/posts/:forum_name/:page)
40	PatternRouting	Connect sfRoute "forum_latest_posts_feed" (/forum/latest/posts/feed/:forum_name/:page)
41	PatternRouting	Connect sfRoute "keyword" (/keyword)
42	PatternRouting	Connect sfRoute "categorie_keyword_content" (/keyword/content)
43	PatternRouting	Connect sfRoute "add_categorie" (/keyword/add_categorie)
44	PatternRouting	Connect sfRoute "move_categorie" (/keyword/move_categorie)
45	PatternRouting	Connect sfRoute "delete_categorie" (/keyword/delete_categorie)
46	PatternRouting	Connect sfRoute "add_new_keyword" (/keyword/add_new_keyword)
47	PatternRouting	Connect sfRoute "add_existing_keyword" (/keyword/add_existing_keyword)
48	PatternRouting	Connect sfRoute "remove_keyword" (/keyword/remove_keyword)
49	PatternRouting	Connect sfRoute "lock_keyword_film" (/keyword/lock_keyword_film)
50	PatternRouting	Connect sfRoute "unlock_keyword_film" (/keyword/unlock_keyword_film)
51	PatternRouting	Connect sfRoute "lock_keyword_liste" (/keyword/lock_keyword_liste)
52	PatternRouting	Connect sfRoute "lock_keyword_liste_to_film" (/keyword/lock_keyword_liste_to_film)
53	PatternRouting	Connect sfRoute "unlock_keyword_liste" (/keyword/unlock_keyword_liste)
54	PatternRouting	Connect sfRoute "move_keyword" (/keyword/move_keyword)
55	PatternRouting	Connect sfRoute "edit_keyword" (/keyword/edit_keyword)
56	PatternRouting	Connect sfRoute "add_selection" (/keyword/add_selection)
57	PatternRouting	Connect sfRoute "remove_selection" (/keyword/remove_selection)
58	PatternRouting	Connect sfRoute "save_selection" (/keyword/save_selection)
59	PatternRouting	Connect sfRoute "homepage" (/)
60	PatternRouting	Connect sfRoute "newsletter_stats" (/nl_stats)
61	PatternRouting	Connect sfRoute "share_button" (/get_share_buttons)
62	PatternRouting	Connect sfRoute "savePlay" (/save/play_video)
63	PatternRouting	Connect sfRoute "get_social_links" (/get_social_links)
64	PatternRouting	Connect sfRoute "reco_envie" (/recommandation-film)
65	PatternRouting	Connect sfRoute "reco_share" (/film-reco/share)
66	PatternRouting	Connect sfRoute "reco_collection" (/selection-:slug)
67	PatternRouting	Connect sfRoute "reco_envie_spe" (/recommandation-envie/:case_id/:page)
68	PatternRouting	Connect sfRoute "reco_genre" (/recommandation-genre)
69	PatternRouting	Connect sfRoute "reco_emotion" (/recommandation-emotion)
70	PatternRouting	Connect sfRoute "selection_top" (/top/:page)
71	PatternRouting	Connect sfRoute "selection" (/selections/:stripped_name/:page)
72	PatternRouting	Connect sfRoute "get_ba_content" (/film-get-ba)
73	PatternRouting	Connect sfRoute "get_reco_content" (/film-reco-content)
74	PatternRouting	Connect sfRoute "film_feedback" (/film_feedback)
75	PatternRouting	Connect sfRoute "film_feedback_info" (/film_feedback_info/:film_id)
76	PatternRouting	Connect sfRoute "film_feedback_get_buttons" (/film_feedback_buttons/:film_id)
77	PatternRouting	Connect sfRoute "presentation_service" (/presentation)
78	PatternRouting	Connect sfRoute "a_propos" (/contact)
79	PatternRouting	Connect sfRoute "error_404" (/not-found)
80	PatternRouting	Connect sfRoute "conditions_utilisation" (/conditions)
81	PatternRouting	Connect sfRoute "others_partners" (/partenaires)
82	PatternRouting	Connect sfRoute "search_ajax" (/recherche-ajax)
83	PatternRouting	Connect sfRoute "search_result" (/recherche/:categorie/:keywords/:page)
84	PatternRouting	Connect sfRoute "search_for_liste" (/search-for/liste)
85	PatternRouting	Connect sfRoute "login_required" (/login-required)
86	PatternRouting	Connect sfRoute "signup" (/inscription)
87	PatternRouting	Connect sfRoute "facebook-connect-login" (/facebook-connect-login)
88	PatternRouting	Connect sfRoute "fb-select-login" (/fb-select-login)
89	PatternRouting	Connect sfRoute "signup_validation" (/validation/:hash)
90	PatternRouting	Connect sfRoute "check_free_login" (/signup/check/login)
91	PatternRouting	Connect sfRoute "signin" (/connexion)
92	PatternRouting	Connect sfRoute "signout" (/deconnexion)
93	PatternRouting	Connect sfRoute "retrieve_pwd" (/lost)
94	PatternRouting	Connect sfRoute "form_change_password" (/form/update/password)
95	PatternRouting	Connect sfRoute "users_profil" (/profil-membre/editer)
96	PatternRouting	Connect sfRoute "users_page" (/profil-membre/:member_id/:member_login)
97	PatternRouting	Connect sfRoute "form_ask_for_friend" (/form/ask/for/friend)
98	PatternRouting	Connect sfRoute "ask_for_friend" (/ask/for/friend)
99	PatternRouting	Connect sfRoute "show_pending_friends" (/show/pending/friends)
100	PatternRouting	Connect sfRoute "validate_pending_friends" (/validate/pending/friend)
101	PatternRouting	Connect sfRoute "cancel_pending_friends" (/cancel/pending/friends)
102	PatternRouting	Connect sfRoute "liste_add_to_fav" (/liste/add/to/fav)
103	PatternRouting	Connect sfRoute "liste_drop_from_fav" (/liste/drop/from/fav)
104	PatternRouting	Connect sfRoute "page_add_to_fav" (/page/add/to/fav)
105	PatternRouting	Connect sfRoute "page_drop_from_fav" (/page/drop/from/fav)
106	PatternRouting	Connect sfRoute "media_add_to_fav" (/media/add/to/fav)
107	PatternRouting	Connect sfRoute "media_drop_from_fav" (/media/drop/from/fav)
108	PatternRouting	Connect sfRoute "film_vod" (/film/:id/:stripped_title/vod)
109	PatternRouting	Connect sfRoute "film_note" (/film/note)
110	PatternRouting	Connect sfRoute "user_film_note" (/film/note_film)
111	PatternRouting	Connect sfRoute "user_films_status" (/film/get_film_user_status)
112	PatternRouting	Connect sfRoute "user_film_status_detail" (/film/get_film_user_status_detail)
113	PatternRouting	Connect sfRoute "user_get_curent_status" (/film/get_film_user_current_status)
114	PatternRouting	Connect sfRoute "get_film_user_infos" (/film/get_film_user_infos)
115	PatternRouting	Connect sfRoute "film_fan" (/set/fan/film)
116	PatternRouting	Connect sfRoute "film_user_status" (/film/user/status)
117	PatternRouting	Connect sfRoute "set_user_point" (/set/user/point)
118	PatternRouting	Connect sfRoute "users_recommandation" (/users/recommendation)
119	PatternRouting	Connect sfRoute "user_delete_recommendation" (/user/delete/recom)
120	PatternRouting	Connect sfRoute "user_give_point" (/user/give/point)
121	PatternRouting	Connect sfRoute "list_fans" (/film/:id/:stripped_title/:page/fans)
122	PatternRouting	Connect sfRoute "share_form" (/member/share/form)
123	PatternRouting	Connect sfRoute "share" (/member/share)
124	PatternRouting	Connect sfRoute "auto_complete_share" (/autocomplete/share/element)
125	PatternRouting	Connect sfRoute "all_users_friends" (/profil-membre/:user_id/:user_login/:page/amis)
126	PatternRouting	Connect sfRoute "favorite_personnes" (/profil-membre/:user_id/:user_login/:page/artistes-preferes)
127	PatternRouting	Connect sfRoute "listes_events" (/liste/events/:user_id)
128	PatternRouting	Connect sfRoute "show_friends_recommendation" (/show/friends/reco)
129	PatternRouting	Connect sfRoute "film_comment_add" (/film/add/comment)
130	PatternRouting	Connect sfRoute "personne_comment_add" (/personne/add/comment)
131	PatternRouting	Connect sfRoute "media_comment_add" (/media/add/comment)
132	PatternRouting	Connect sfRoute "liste_comment_add" (/liste/add/comment)
133	PatternRouting	Connect sfRoute "member_comment_add" (/member/add/comment)
134	PatternRouting	Connect sfRoute "edit_comment" (/comment/edit)
135	PatternRouting	Connect sfRoute "edit_media_comment" (/comment/media/edit)
136	PatternRouting	Connect sfRoute "delete_comment" (/comment/delete)
137	PatternRouting	Connect sfRoute "film_list_comments" (/film/:id/:stripped_title/:page/commentaires)
138	PatternRouting	Connect sfRoute "personne_list_comments" (/artiste/:id/:stripped_name/:page/commentaires)
139	PatternRouting	Connect sfRoute "member_list_comments" (/profil-membre/:id/:login/:page/commentaires)
140	PatternRouting	Connect sfRoute "media_list_comments" (/video/:id/:stripped_title/commentaires)
141	PatternRouting	Connect sfRoute "media_list_comments_popin" (/media/show/comments)
142	PatternRouting	Connect sfRoute "liste_list_comments" (/liste-film/:id/:stripped_name/:page/commentaires)
143	PatternRouting	Connect sfRoute "film_critique_add" (/critique/add)
144	PatternRouting	Connect sfRoute "film_critique_edit" (/critique/edit/:critique_id)
145	PatternRouting	Connect sfRoute "film_critique_delete" (/critique/delete/:critique_id)
146	PatternRouting	Connect sfRoute "all_list_critiques" (/critique-film/:page/:order/:periode)
147	PatternRouting	Connect sfRoute "all_list_critiques_date" (/critique-film/:page/:order/:periode)
148	PatternRouting	Connect sfRoute "film_list_critiques" (/film/:film_id/:stripped_title/critiques/:type_user/:page/:order/:periode)
149	PatternRouting	Connect sfRoute "users_list_critiques" (/profil-membre/:users_id/:users_login/critique-film/:page/:order/:periode)
150	PatternRouting	Connect sfRoute "update_one_critique" (/critique/update/one)
151	PatternRouting	Connect sfRoute "update_film_critique" (/critique/update/for_film)
152	PatternRouting	Connect sfRoute "update_element_comment" (/comment/update/for)
153	PatternRouting	Connect sfRoute "update_single_element_comment" (/comment/update/one)
154	PatternRouting	Connect sfRoute "add_film" (/add/film)
155	PatternRouting	Connect sfRoute "addfilm_personne_add" (/addfilm/personne)
156	PatternRouting	Connect sfRoute "form_film_edit" (/film/edit)
157	PatternRouting	Connect sfRoute "film_add_info" (/film/add/info)
158	PatternRouting	Connect sfRoute "film_delete_info" (/film/delete/info)
159	PatternRouting	Connect sfRoute "save_film_acteur_rank" (/film/:filmId/save/actors/rank)
160	PatternRouting	Connect sfRoute "film_list_tags" (/film/:film_id/:stripped_title/tags)
161	PatternRouting	Connect sfRoute "auto_complete_personne" (/autocompletion/personne)
162	PatternRouting	Connect sfRoute "auto_complete_film" (/autocompletion/film)
163	PatternRouting	Connect sfRoute "mon_cinema_mon_actu" (/profil-membre/:id/:login/mon-actu)
164	PatternRouting	Connect sfRoute "mon_cinema_mes_film_tous" (/profil-membre/:user_id/:user_login/film-tous/:page/:order_col/:order_mode/:recherche/:recherche_col)
165	PatternRouting	Connect sfRoute "mon_cinema_mes_series_tous" (/profil-membre/:user_id/:user_login/series-toutes/:page/:order_col/:order_mode/:recherche/:recherche_col)
166	PatternRouting	Connect sfRoute "mon_cinema_mes_film_encours" (/profil-membre/:user_id/:user_login/film-encours/:page/:order_col/:order_mode/:recherche/:recherche_col)
167	PatternRouting	Connect sfRoute "mon_cinema_mes_series_encours" (/profil-membre/:user_id/:user_login/series-encours/:page/:order_col/:order_mode/:recherche/:recherche_col)
168	PatternRouting	Connect sfRoute "mon_cinema_mes_film_vus" (/profil-membre/:user_id/:user_login/film-vus/:page/:order_col/:order_mode/:recherche/:recherche_col)
169	PatternRouting	Connect sfRoute "mon_cinema_mes_series_vus" (/profil-membre/:user_id/:user_login/series-vus/:page/:order_col/:order_mode/:recherche/:recherche_col)
170	PatternRouting	Connect sfRoute "mon_cinema_mes_film_a_voir" (/profil-membre/:user_id/:user_login/film-a-voir/:page/:order_col/:order_mode/:recherche/:recherche_col)
171	PatternRouting	Connect sfRoute "mon_cinema_mes_series_a_voir" (/profil-membre/:user_id/:user_login/series-a-voir/:page/:order_col/:order_mode/:recherche/:recherche_col)
172	PatternRouting	Connect sfRoute "mon_cinema_mes_film_bons" (/profil-membre/:user_id/:user_login/film-bons/:page/:order_col/:order_mode/:recherche/:recherche_col)
173	PatternRouting	Connect sfRoute "mon_cinema_mes_series_bons" (/profil-membre/:user_id/:user_login/series-bons/:page/:order_col/:order_mode/:recherche/:recherche_col)
174	PatternRouting	Connect sfRoute "mon_cinema_mes_film_fan" (/profil-membre/:user_id/:user_login/film-fan/:page/:order_col/:order_mode/:recherche/:recherche_col)
175	PatternRouting	Connect sfRoute "mon_cinema_mes_series_fan" (/profil-membre/:user_id/:user_login/series-fan/:page/:order_col/:order_mode/:recherche/:recherche_col)
176	PatternRouting	Connect sfRoute "mon_cinema_mes_film_pense_bete" (/profil-membre/:user_id/:user_login/film-pense-bete/:page/:order_col/:order_mode/:recherche/:recherche_col)
177	PatternRouting	Connect sfRoute "mon_cinema_mes_series_pense_bete" (/profil-membre/:user_id/:user_login/series-pense-bete/:page/:order_col/:order_mode/:recherche/:recherche_col)
178	PatternRouting	Connect sfRoute "mon_cinema_mes_film_pas_interesse" (/profil-membre/:user_id/:user_login/film-pas-interesse/:page/:order_col/:order_mode/:recherche/:recherche_col)
179	PatternRouting	Connect sfRoute "mon_cinema_mes_series_pas_interesse" (/profil-membre/:user_id/:user_login/series-pas-interesse/:page/:order_col/:order_mode/:recherche/:recherche_col)
180	PatternRouting	Connect sfRoute "mon_cinema_mes_series_nlle_saison" (/profil-membre/:user_id/:user_login/series-nouvelle-saison/:page/:order_col/:order_mode/:recherche/:recherche_col)
181	PatternRouting	Connect sfRoute "mon_cinema_mes_film_tags" (/profil-membre/:user_id/:user_login/film-tags/:view/:page/:order_col/:order_mode/:recherche/:recherche_col)
182	PatternRouting	Connect sfRoute "mon_cinema_mes_listes" (/profil-membre/:member_id/:member_login/liste-film/:page/:type/:order/:periode)
183	PatternRouting	Connect sfRoute "mon_cinema_mes_videos" (/profil-membre/:member_id/:member_login/video-extrait/:page/:type/:order/:category)
184	PatternRouting	Connect sfRoute "mon_cinema_mes_photos" (/profil-membre/:member_id/:member_login/photo/:page/:type/:order/:periode)
185	PatternRouting	Connect sfRoute "mon_cinema_mon_profil" (/mon-cinema/mon-profil)
186	PatternRouting	Connect sfRoute "plus_cinema_moment" (/)
187	PatternRouting	Connect sfRoute "plus_cinema_recent" (/plus-de-cinema/recent)
188	PatternRouting	Connect sfRoute "plus_cinema_meilleur" (/plus-de-cinema/le-meilleur)
189	PatternRouting	Connect sfRoute "liste_contains_film" (/film/:id/listes/:page/:order/:periode/:type)
190	PatternRouting	Connect sfRoute "listes_around_film" (/film/:film_id/:stripped_title/liste-film/:page/:order/:periode)
191	PatternRouting	Connect sfRoute "film_list_photo" (/film/:film_id/:stripped_title/photo/:page/:order/:periode)
192	PatternRouting	Connect sfRoute "section_films_fiche" (/film/:id/:stripped_title/:new_recommendation)
193	PatternRouting	Connect sfRoute "serie_fiche" (/serie-tv/:id/:stripped_title/:new_recommendation)
194	PatternRouting	Connect sfRoute "saison_serie" (/serie-tv-saison/:id/:stripped_title/:id_saison)
195	PatternRouting	Connect sfRoute "serie_24h" (/serie-a-voir/:page)
196	PatternRouting	Connect sfRoute "film_best" (/derniers-bons-films/:page/:periode/:order)
197	PatternRouting	Connect sfRoute "member_reco_film_home" (/membre/:user_id/film-recommandes-home)
198	PatternRouting	Connect sfRoute "member_recommendation_film" (/membre/:user_id/:page/film-recommandes)
199	PatternRouting	Connect sfRoute "member_recommendation_film_list" (/membre/:user_id/:page/listes-recomandees)
200	PatternRouting	Connect sfRoute "films_not_seen_by_user" (/membre/:user_id/:page/pas-vu-film)
201	PatternRouting	Connect sfRoute "films_friends_are_fan" (/membre/:user_id/:page/amis-fans-film)
202	PatternRouting	Connect sfRoute "best_films_of_user" (/membre/:user_id/:page/meilleurs-films)
203	PatternRouting	Connect sfRoute "add_film_to_liste" (/add/to/liste)
204	PatternRouting	Connect sfRoute "form_add_film_to_liste" (/form/add/to/liste)
205	PatternRouting	Connect sfRoute "delete_film_from_liste" (/delete/film/from/liste)
206	PatternRouting	Connect sfRoute "add_liste_to_liste" (/add/to/listeOfListe)
207	PatternRouting	Connect sfRoute "form_add_liste_to_liste" (/form/add/to/listeOfListe)
208	PatternRouting	Connect sfRoute "delete_liste_from_liste" (/delete/liste/from/liste)
209	PatternRouting	Connect sfRoute "save_relevance" (/liste/relevance)
210	PatternRouting	Connect sfRoute "form_new_liste" (/liste-film/creation)
211	PatternRouting	Connect sfRoute "form_new_liste_with" (/liste-film/creation/:with_type/:with_elmt)
212	PatternRouting	Connect sfRoute "form_edit_liste" (/liste-film/:liste_id/:stripped_name/editer)
213	PatternRouting	Connect sfRoute "show_liste_film" (/liste-film/:liste_id/:page/:stripped_name/:validate/:validation_id)
214	PatternRouting	Connect sfRoute "all_liste_films" (/liste-film/:page/:order/:periode)
215	PatternRouting	Connect sfRoute "all_liste_films_date" (/liste-film/:page/:order/:periode)
216	PatternRouting	Connect sfRoute "save_liste_title" (/liste/save/title)
217	PatternRouting	Connect sfRoute "save_liste_description" (/liste/save/description)
218	PatternRouting	Connect sfRoute "save_liste_website" (/liste/save/website)
219	PatternRouting	Connect sfRoute "save_liste_file" (/liste/save/file/:id)
220	PatternRouting	Connect sfRoute "save_liste_film" (/liste/save/film)
221	PatternRouting	Connect sfRoute "delete_liste_film" (/liste/delete/film)
222	PatternRouting	Connect sfRoute "valide_liste_film" (/liste/validate/film/:liste_film_id,:liste_id,:type)
223	PatternRouting	Connect sfRoute "do_save_liste" (/liste/do/save)
224	PatternRouting	Connect sfRoute "do_delete_liste" (/liste/do/detele)
225	PatternRouting	Connect sfRoute "organize_liste_films" (/liste/organize/films)
226	PatternRouting	Connect sfRoute "save_liste_film_comment" (/liste/save/liste-film/comment)
227	PatternRouting	Connect sfRoute "listes_open" (/liste-film/ouverte/:page/:order/:periode)
228	PatternRouting	Connect sfRoute "export_liste" (/liste/export)
229	PatternRouting	Connect sfRoute "auto_complete_liste" (/liste/autoComplete)
230	PatternRouting	Connect sfRoute "tag_film" (/tag/film)
231	PatternRouting	Connect sfRoute "tag_news" (/tag/news)
232	PatternRouting	Connect sfRoute "tag_film_form" (/tag/film/form)
233	PatternRouting	Connect sfRoute "tag_news_form" (/tag/news/form)
234	PatternRouting	Connect sfRoute "tag_film_delete" (/tag/film/delete)
235	PatternRouting	Connect sfRoute "tag_news_delete" (/tag/news/delete)
236	PatternRouting	Connect sfRoute "submit_tag_form" (/sumbit/tag/form)
237	PatternRouting	Connect sfRoute "submit_tag" (/sumbit/tag)
238	PatternRouting	Connect sfRoute "auto_complete_tag" (/tag/autoComplete)
239	PatternRouting	Connect sfRoute "tag_all_film" (/tag/:tag_id/:stripped_name/:page)
240	PatternRouting	Connect sfRoute "tag_all_news" (/tag-actu/:tag_id/:stripped_name/:filter/:page)
241	PatternRouting	Connect sfRoute "change_video_page" (/videos/page)
242	PatternRouting	Connect sfRoute "list_videos" (/video-extrait/:category/:page/:order/:periode)
243	PatternRouting	Connect sfRoute "personne_list_videos" (/artiste/:personne_id/:stripped_name/video-extrait/:category/:page/:order/:periode)
244	PatternRouting	Connect sfRoute "personne_list_photo" (/artiste/:personne_id/:stripped_name/photo/:page/:order/:periode)
245	PatternRouting	Connect sfRoute "all_photo" (/photo/:page/:order/:periode)
246	PatternRouting	Connect sfRoute "all_photo_date" (/photo/:page/:order/:periode)
247	PatternRouting	Connect sfRoute "form_video_add" (/film/video/add)
248	PatternRouting	Connect sfRoute "form_video_edit" (/film/video/edit)
249	PatternRouting	Connect sfRoute "form_video_delete" (/film/video/delete)
250	PatternRouting	Connect sfRoute "video_get_thumb" (/video/get/thumbnail)
251	PatternRouting	Connect sfRoute "form_photo_add" (/film/photo/add)
252	PatternRouting	Connect sfRoute "form_photo_add_file" (/film/photo/save/file/:cible_type/:cible_id)
253	PatternRouting	Connect sfRoute "form_photo_edit" (/film/photo/edit)
254	PatternRouting	Connect sfRoute "form_photo_delete" (/film/photo/delete)
255	PatternRouting	Connect sfRoute "form_affiche_add" (/film/affiche/add)
256	PatternRouting	Connect sfRoute "form_affiche_add_file" (/film/affiche/save/file/:cible_type/:cible_id)
257	PatternRouting	Connect sfRoute "img_file_saved" (/media/file/saved)
258	PatternRouting	Connect sfRoute "show_video" (/film/video/show/:idvideo)
259	PatternRouting	Connect sfRoute "embed_video" (/video/embed/:idvideo/:width/:height)
260	PatternRouting	Connect sfRoute "display_advs" (/media/display/advs)
261	PatternRouting	Connect sfRoute "edit_source_video" (/video/update_source/:id/:source)
262	PatternRouting	Connect sfRoute "related_videos" (/video/related/:id)
263	PatternRouting	Connect sfRoute "video_embed" (/video/embed/:id/:stripped_title/:width/:height)
264	PatternRouting	Connect sfRoute "show_video_full_page" (/video/:category/:id/:stripped_title)
265	PatternRouting	Connect sfRoute "add_photo_view" (/add-photo-view/:id)
266	PatternRouting	Connect sfRoute "add_media_view" (/add-media-view/:id)
267	PatternRouting	Connect sfRoute "media_in_favorite" (/media-in-favorite)
268	PatternRouting	Connect sfRoute "add_to_liste_film" (/media/add/to/liste-film)
269	PatternRouting	Connect sfRoute "personne_list_fans" (/artiste/:id/:stripped_name/:page/fans)
270	PatternRouting	Connect sfRoute "personne_list_films" (/artiste/:personne_id/:stripped_name/filmographie/:selection/:order)
271	PatternRouting	Connect sfRoute "personne" (/artiste/:id/:stripped_name)
272	PatternRouting	Connect sfRoute "personne_add_to_fav" (/personne/add/to/fav)
273	PatternRouting	Connect sfRoute "personne_drop_from_fav" (/personne/drop/to/fav)
274	PatternRouting	Connect sfRoute "bug_report" (/report/bug)
275	PatternRouting	Connect sfRoute "share_cinetrafic" (/share/cinetrafic)
276	PatternRouting	Connect sfRoute "get_certain_film_for_keyword_grid" (/certain_keyword_grid_movies)
277	PatternRouting	Connect sfRoute "random_film_ids_for_keyword_grid" (/random_keyword_grid_movies)
278	PatternRouting	Connect sfRoute "get_films_for_keyword_grid" (/keyword_grid_movies)
279	PatternRouting	Connect sfRoute "keyword_grid" (/keyword_grid/:grid)
280	PatternRouting	Connect sfRoute "keyword_cluster" (/keyword_cluster)
281	PatternRouting	Connect sfRoute "display_keyword_cluster_films" (/display_keyword_cluster_films/:client_id/:keyword_cluster_id/:page)
282	PatternRouting	Connect sfRoute "get_certain_keyword_cluster_films" (/get_certain_keyword_cluster_films)
283	PatternRouting	Connect sfRoute "get_keyword_cluster_film_data" (/get_keyword_cluster_film_data)
284	PatternRouting	Connect sfRoute "news_buzz_show" (/actu-cine/:id_news/:titre_news/:page)
285	PatternRouting	Connect sfRoute "news_buzz_show_old" (/news-buzz/:id_news/:titre_news/:page)
286	PatternRouting	Connect sfRoute "news_buzz_list" (/actu-cine/:filter/:page)
287	PatternRouting	Connect sfRoute "news_add_share" (/news/add/share)
288	PatternRouting	Connect sfRoute "get_highlight_news" (/news/get/highlight)
289	PatternRouting	Connect sfRoute "page_add_view" (/page_view/add_page_view)
290	PatternRouting	Connect sfRoute "hub_genre" (/tous-les-films)
291	PatternRouting	Connect sfRoute "hub_country" (/tous-les-films/2)
292	PatternRouting	Connect sfRoute "hub_annee" (/tous-les-films/3)
293	PatternRouting	Connect sfRoute "hub_kw" (/tous-les-films/4)
294	PatternRouting	Connect sfRoute "cookies_law" (/cookies)
295	PatternRouting	Connect pageObjectRoute "page_index" (/:page_url/:page/:periode/:order)
296	PatternRouting	Match route "personne" (/artiste/:id/:stripped_name) for /artiste/20609/jared-leto with parameters array ( 'module' => 'personne', 'action' => 'show', 'stripped_name' => 'jared-leto', 'id' => '20609',)
297	FilterChain	Executing filter "sfRenderingFilter"
298	FilterChain	Executing filter "rememberFilter"
299	FilterChain	Executing filter "conditionalCacheFilter"
300	FilterChain	Executing filter "sfCacheFilter"
301	FilterChain	Executing filter "sfCommonFilter"
302	FilterChain	Executing filter "sfExecutionFilter"
303	personneActions	Call "personneActions->executeShow()"
304	PHPView	Render "sf_app_dir/modules/personne/templates/showSuccess.php"
305	ViewCacheManager	Generate cache key
306	main	Call "main->executeBreadcrumb()"
307	PartialView	Render "sf_app_dir/modules/main/templates/_breadcrumb.php"
308	ViewCacheManager	Generate cache key
309	main	Call "main->executeSearch()"
310	PartialView	Render "sf_app_dir/modules/main/templates/_search.php"
311	ViewCacheManager	Generate cache key
312	PartialView	Render "sf_app_dir/modules/advertisement/templates/_topAdv.php"
313	ViewCacheManager	Generate cache key
314	main	Call "advertisement->executeAdvs()"
315	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
316	ViewCacheManager	Generate cache key
317	PartialView	Render "sf_app_dir/modules/personne/templates/_affichePersonne.php"
318	ViewCacheManager	Generate cache key
319	PartialView	Render "sf_app_dir/modules/film/templates/_film_small_bloc.php"
320	ViewCacheManager	Generate cache key
321	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
322	ViewCacheManager	Generate cache key
323	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
324	ViewCacheManager	Generate cache key
325	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
326	ViewCacheManager	Generate cache key
327	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
328	ViewCacheManager	Generate cache key
329	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
330	ViewCacheManager	Generate cache key
331	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
332	ViewCacheManager	Generate cache key
333	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
334	ViewCacheManager	Generate cache key
335	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
336	ViewCacheManager	Generate cache key
337	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
338	ViewCacheManager	Generate cache key
339	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
340	ViewCacheManager	Generate cache key
341	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
342	ViewCacheManager	Generate cache key
343	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
344	ViewCacheManager	Generate cache key
345	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
346	ViewCacheManager	Generate cache key
347	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
348	ViewCacheManager	Generate cache key
349	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
350	ViewCacheManager	Generate cache key
351	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
352	ViewCacheManager	Generate cache key
353	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
354	ViewCacheManager	Generate cache key
355	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
356	ViewCacheManager	Generate cache key
357	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
358	ViewCacheManager	Generate cache key
359	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
360	ViewCacheManager	Generate cache key
361	main	Call "advertisement->executeAdvs()"
362	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
363	ViewCacheManager	Generate cache key
364	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
365	ViewCacheManager	Generate cache key
366	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
367	ViewCacheManager	Generate cache key
368	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
369	ViewCacheManager	Generate cache key
370	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
371	ViewCacheManager	Generate cache key
372	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
373	ViewCacheManager	Generate cache key
374	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
375	ViewCacheManager	Generate cache key
376	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
377	ViewCacheManager	Generate cache key
378	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
379	ViewCacheManager	Generate cache key
380	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
381	ViewCacheManager	Generate cache key
382	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
383	ViewCacheManager	Generate cache key
384	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
385	ViewCacheManager	Generate cache key
386	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
387	ViewCacheManager	Generate cache key
388	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
389	ViewCacheManager	Generate cache key
390	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
391	ViewCacheManager	Generate cache key
392	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
393	ViewCacheManager	Generate cache key
394	PartialView	Render "sf_app_dir/modules/film/templates/_blockSmallFilmPageItem.php"
395	ViewCacheManager	Generate cache key
396	PartialView	Render "sf_app_dir/modules/film/templates/_afficheFilmSmall.php"
397	ViewCacheManager	Generate cache key
398	PartialView	Render "sf_app_dir/modules/film/templates/_filmActions.php"
399	ViewCacheManager	Generate cache key
400	PartialView	Render "sf_app_dir/modules/film/templates/_filmActionsMob.php"
401	ViewCacheManager	Generate cache key
402	PartialView	Render "sf_app_dir/modules/film/templates/_usersStatusContainer.php"
403	ViewCacheManager	Generate cache key
404	PartialView	Render "sf_app_dir/modules/media/templates/_videoBlock.php"
405	ViewCacheManager	Generate cache key
406	PartialView	Render "sf_app_dir/modules/media/templates/_videoPage.php"
407	ViewCacheManager	Generate cache key
408	PartialView	Render "sf_app_dir/modules/media/templates/_videoDiv.php"
409	ViewCacheManager	Generate cache key
410	PartialView	Render "sf_app_dir/modules/media/templates/_videoThumb.php"
411	ViewCacheManager	Generate cache key
412	PartialView	Render "sf_app_dir/modules/media/templates/_videoDiv.php"
413	ViewCacheManager	Generate cache key
414	PartialView	Render "sf_app_dir/modules/media/templates/_videoThumb.php"
415	ViewCacheManager	Generate cache key
416	PartialView	Render "sf_app_dir/modules/media/templates/_videoDiv.php"
417	ViewCacheManager	Generate cache key
418	PartialView	Render "sf_app_dir/modules/media/templates/_videoThumb.php"
419	ViewCacheManager	Generate cache key
420	PartialView	Render "sf_app_dir/modules/comment/templates/_listCommentaires.php"
421	ViewCacheManager	Generate cache key
422	PartialView	Render "sf_app_dir/modules/main/templates/_addThis.php"
423	ViewCacheManager	Generate cache key
424	PartialView	Render "sf_app_dir/modules/users/templates/_listFans.php"
425	ViewCacheManager	Generate cache key
426	PartialView	Render "sf_app_dir/modules/users/templates/_avatar.php"
427	ViewCacheManager	Generate cache key
428	PartialView	Render "sf_app_dir/modules/users/templates/_avatar.php"
429	ViewCacheManager	Generate cache key
430	PartialView	Render "sf_app_dir/modules/users/templates/_avatar.php"
431	ViewCacheManager	Generate cache key
432	main	Call "advertisement->executeAdvs()"
433	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
434	ViewCacheManager	Generate cache key
435	main	Call "advertisement->executeAdvs()"
436	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
437	ViewCacheManager	Generate cache key
438	main	Call "similar_link->executeLinks()"
439	PartialView	Render "sf_app_dir/modules/similar_link/templates/_links.php"
440	ViewCacheManager	Generate cache key
441	main	Call "advertisement->executeAdvs()"
442	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
443	PHPView	Decorate content with "sf_app_dir/templates/layout.php"
444	PHPView	Render "sf_app_dir/templates/layout.php"
445	ViewCacheManager	Generate cache key
446	main	Call "advertisement->executeAdvs()"
447	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
448	ViewCacheManager	Generate cache key
449	main	Call "advertisement->executeAdvs()"
450	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
451	ViewCacheManager	Generate cache key
452	main	Call "advertisement->executeAdvs()"
453	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
454	ViewCacheManager	Generate cache key
455	main	Call "main->executeHeader()"
456	PartialView	Render "sf_app_dir/modules/main/templates/_header.php"
457	ViewCacheManager	Generate cache key
458	PartialView	Render "sf_app_dir/modules/main/templates/_sharePageMob.php"
459	ViewCacheManager	Generate cache key
460	main	Call "menu->executeTopMenu()"
461	PartialView	Render "sf_app_dir/modules/menu/templates/_topMenu.php"
462	ViewCacheManager	Generate cache key
463	main	Call "advertisement->executeAdvs()"
464	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
465	ViewCacheManager	Generate cache key
466	main	Call "main->executeFooter()"
467	PartialView	Render "sf_app_dir/modules/main/templates/_footer.php"
468	ViewCacheManager	Generate cache key
469	PartialView	Render "sf_app_dir/modules/main/templates/_popupFrame.php"
470	ViewCacheManager	Generate cache key
471	main	Call "advertisement->executeAdvs()"
472	PartialView	Render "sf_app_dir/modules/advertisement/templates/_advs.php"
473	WebResponse	Send status "HTTP/1.0 200 OK"
474	WebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	34	4.83	0
Action "personne/show"	1	255.69	17
View "Success" for "personne/show"	1	954.36	65
Component "main/breadcrumb"	1	0.01	0
Partial "main/_breadcrumb"	1	1.19	0
Component "main/search"	1	0.01	0
Partial "main/_search"	1	0.53	0
Partial "advertisement/_topAdv"	1	36.49	2
Component "advertisement/advs"	10	114.17	7
Partial "advertisement/_advs"	10	10.26	0
Partial "personne/_affichePersonne"	1	7.68	0
Partial "film/_film_small_bloc"	1	286.66	19
Partial "film/_blockSmallFilmPageItem"	8	256.45	17
Partial "film/_afficheFilmSmall"	8	42.79	2
Partial "film/_filmActions"	8	36.88	2
Partial "film/_filmActionsMob"	8	36.31	2
Partial "film/_usersStatusContainer"	8	37.15	2
Partial "media/_videoBlock"	1	53.74	3
Partial "media/_videoPage"	1	48.18	3
Partial "media/_videoDiv"	3	41.74	2
Partial "media/_videoThumb"	3	23.59	1
Partial "comment/_listCommentaires"	1	5.89	0
Partial "main/_addThis"	1	0.61	0
Partial "users/_listFans"	1	5.58	0
Partial "users/_avatar"	3	2.91	0
Component "similar_link/links"	1	8.34	0
Partial "similar_link/_links"	1	0.81	0
Component "main/header"	1	0.01	0
Partial "main/_header"	1	1.55	0
Partial "main/_sharePageMob"	1	0.60	0
Component "menu/topMenu"	1	4.14	0
Partial "menu/_topMenu"	1	13.14	0
Component "main/footer"	1	3.59	0
Partial "main/_footer"	1	2.67	0
Partial "main/_popupFrame"	1	0.55	0

SET NAMES 'utf8'
SELECT * FROM sum_personne WHERE sum_personne.PERSONNE_ID = :id
SELECT * FROM personne LEFT JOIN sum_personne ON personne.ID = sum_personne.PERSONNE_ID WHERE personne.ID = :personne_id
SELECT group_concat(film_acteur.film_id) as idsFilm FROM film_acteur WHERE 20609 = :20609 UNION SELECT group_concat(film_realisateur.film_id) as idsFilm FROM film_realisateur WHERE 20609 = :20609
SELECT film.* , film_country.*, country.*, film_users.* FROM film LEFT JOIN sum_film ON sum_film.FILM_ID = film.ID LEFT JOIN film_country ON film_country.FILM_ID = film.ID LEFT JOIN country ON country.ID = film_country.COUNTRY_ID LEFT JOIN film_users ON film_users.FILM_ID = film.ID AND film_users.USER_ID = :'-1' WHERE film.id IN (4723,7152,7235,7991,8155,9005,9500,12309,13104,13362,13610,15486,15500,16150,32142,37114,38956,42637,43124) AND (film_country.RANK = 0 OR film_country.RANK IS NULL) AND film.CULTURE = :'fr_FR' AND film.IS_ACTIVATED = 1 GROUP BY film_country.film_id ORDER BY sum_film.NB_FANS DESC, sum_film.NOTE_GLOBAL DESC, sum_film.NB_NOTES DESC LIMIT 0, :8
SELECT f.id AS film_id, m.id AS media_id FROM media m LEFT JOIN film_media fm ON (fm.media_id = m.id) LEFT JOIN film f ON (fm.film_id = f.id AND f.culture = fm.film_culture) WHERE f.culture = 'fr_FR' AND m.is_video = 1 AND m.is_default = 1 AND f.id IN (9005,13610,4723,12309,7235,38956,13104,43124) GROUP BY f.id ORDER BY m.average DESC;
SELECT f.id AS film_id, m.id AS media_id FROM media m LEFT JOIN film_media fm ON (fm.media_id = m.id) LEFT JOIN film f ON (fm.film_id = f.id AND f.culture = fm.film_culture) LEFT JOIN category_media cm ON (m.id = cm.media_id) LEFT JOIN category c ON (c.id = cm.category_id) WHERE f.culture = 'fr_FR' AND m.is_video = 1 AND c.stripped_name = 'bande-annonce' AND f.id IN (9005,13610,4723,12309,7235,38956,13104,43124) ORDER BY m.created_at ASC;
SELECT f.id AS film_id, m.id AS media_id FROM media m LEFT JOIN film_media fm ON (fm.media_id = m.id) LEFT JOIN film f ON (fm.film_id = f.id AND f.culture = fm.film_culture) LEFT JOIN category_media cm ON (m.id = cm.media_id) LEFT JOIN category c ON (c.id = cm.category_id) WHERE f.culture = 'fr_FR' AND m.is_video = 1 AND c.stripped_name = 'extrait-film' AND f.id IN (9005,13610,4723,12309,7235,38956,13104,43124) ORDER BY m.average ASC;
SELECT * FROM media LEFT JOIN category_media ON media.ID = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) LEFT JOIN film ON (film_media.FILM_ID = film.ID AND film.CULTURE = film_media.FILM_CULTURE) LEFT JOIN users ON media.USER_ID = users.ID LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE WHERE media.ID IN (42370,104861,58285,118155,52256,58873,139608,74388) AND media.CULTURE = :culture ;
SELECT genre.id, genre.name, film_genre.film_id FROM genre INNER JOIN film_genre ON film_genre.genre_id = genre.id WHERE film_id IN (9005,13610,4723,12309,7235,38956,13104,43124) AND genre_culture = :culture AND film_culture = :culture AND genre.culture = :culture ORDER BY genre.id
SELECT * FROM sum_film WHERE sum_film.FILM_ID IN (9005,13610,4723,12309,7235,38956,13104,43124) AND sum_film.FILM_CULTURE = :culture
SELECT page.id, page.slug, page_genre.genre_id FROM page INNER JOIN page_genre ON page_genre.page_id = page.id WHERE page_genre.genre_id IN (1,2,3,7,11,12,13,32,34) AND page.type = 2 AND page.is_main_for_genre = 1
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = false AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = true AND media.CULTURE = 'fr_FR' AND personne_media.PERSONNE_ID = 20609 ORDER BY media.AVERAGE DESC LIMIT 0, 3 ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT count(*) FROM media JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.CULTURE = 'fr_FR' AND personne_media.PERSONNE_ID = 20609 AND media.IS_AFFICHE = false AND media.IS_PHOTO = false AND media.IS_VIDEO = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = false AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = true AND media.IS_VIDEO = false AND media.CULTURE = 'fr_FR' AND personne_media.PERSONNE_ID = 20609 ORDER BY media.AVERAGE DESC LIMIT 0, 4 ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT * FROM category LEFT JOIN sum_category_personne ON (personne_id = :id AND sum_category_personne.category_id = category.id AND sum_category_personne.category_culture = category.culture) WHERE category.CULTURE = :culture
SELECT * FROM (SELECT * FROM personne_users_commentaire WHERE personne_users_commentaire.PERSONNE_ID = :personne ORDER BY personne_users_commentaire.CREATED_AT DESC LIMIT 0, 4) as puc LEFT JOIN users ON puc.USER_ID = users.ID
SELECT count(film_acteur.PERSONNE_ID) as acteur, count(film_realisateur.PERSONNE_ID) as realisateur, count(film_scenariste.PERSONNE_ID) as scenariste, count(film_producteur.PERSONNE_ID) as producteur FROM personne LEFT JOIN film_acteur ON film_acteur.PERSONNE_ID = personne.ID LEFT JOIN film_realisateur ON film_realisateur.PERSONNE_ID = personne.ID LEFT JOIN film_scenariste ON film_scenariste.PERSONNE_ID = personne.ID LEFT JOIN film_producteur ON film_producteur.PERSONNE_ID = personne.ID WHERE personne.ID = :personne_id ;
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND media.IS_DEFAULT = 1 AND personne_media.PERSONNE_ID = 20609 ORDER BY media.CREATED_AT DESC LIMIT 0, 1 ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND media.IS_DEFAULT = 1 AND personne_media.PERSONNE_ID = 20609 ORDER BY media.CREATED_AT DESC LIMIT 0, 1 ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 4
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='4'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 4
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='4'
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = media.ID AND personne_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND media.IS_DEFAULT = 1 AND personne_media.PERSONNE_ID = 20609 ORDER BY media.CREATED_AT DESC LIMIT 0, 1 ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT film_media.film_id, media.file FROM media INNER JOIN film_media ON film_media.media_id = media.id WHERE film_media.film_id IN(9005, 13610, 4723, 12309, 7235, 38956, 13104, 43124) AND media.id = ( SELECT m.id FROM media m LEFT JOIN film_media fm ON (fm.media_id = m.id) LEFT JOIN film f ON (fm.film_id = f.id AND f.culture = fm.film_culture) WHERE f.culture = 'fr_FR' AND m.is_affiche = 1 AND f.id = film_media.film_id ORDER BY m.is_default DESC, m.updated_at DESC, m.average DESC LIMIT 1);
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 9005 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 9005 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 13610 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 13610 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 4723 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 4723 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 12309 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 12309 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 15
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_PAGE_GEN_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='15'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 15
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_PAGE_GEN_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='15'
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 7235 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 7235 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 38956 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 38956 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 13104 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 13104 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT myMedia.*, category_media.*, category.* , film_media.*, film.* , personne_media.*, personne.* FROM ( SELECT media.*, sum_media.ID AS sm_id, sum_media.MEDIA_ID AS sm_media_id, sum_media.MEDIA_CULTURE AS sm_media_culture, sum_media.NB_POINTS AS sm_nb_points, sum_media.NB_COMMENTAIRES AS sm_nb_commentaires, sum_media.NB_FAVORIS AS sm_nb_favoris, sum_media.CREATED_AT AS sm_created_at, sum_media.UPDATED_AT AS sm_updated_at FROM media LEFT JOIN sum_media ON sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = media.ID AND film_media.MEDIA_CULTURE = media.CULTURE WHERE media.IS_AFFICHE = true AND media.IS_AFFICHE_VOD = false AND media.IS_WALLPAPER = false AND media.IS_PHOTO = false AND media.IS_VIDEO = false AND film_media.FILM_ID = 43124 ORDER BY media.AVERAGE DESC ) AS myMedia LEFT JOIN category_media ON myMedia.ID = category_media.MEDIA_ID AND myMedia.CULTURE = category_media.MEDIA_CULTURE LEFT JOIN category ON category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE LEFT JOIN film_media ON film_media.MEDIA_ID = myMedia.ID AND film_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN film ON film.ID = film_media.FILM_ID AND film.CULTURE = film_media.FILM_CULTURE LEFT JOIN personne_media ON personne_media.MEDIA_ID = myMedia.ID AND personne_media.MEDIA_CULTURE = myMedia.CULTURE LEFT JOIN personne ON personne.ID = personne_media.PERSONNE_ID
SELECT media.*, sum_media.*, category_media.*, category.* FROM media LEFT JOIN sum_media ON (sum_media.MEDIA_ID = media.ID AND sum_media.MEDIA_CULTURE = media.CULTURE) LEFT JOIN category_media ON (media.id = category_media.MEDIA_ID AND media.CULTURE = category_media.MEDIA_CULTURE) LEFT JOIN category ON (category_media.CATEGORY_ID = category.ID AND category_media.CATEGORY_CULTURE = category.CULTURE) LEFT JOIN film_media ON (media.ID = film_media.MEDIA_ID AND media.CULTURE = film_media.MEDIA_CULTURE) WHERE media.IS_VIDEO = '1' AND media.is_vf = true AND film_media.FILM_ID = 43124 AND media.CULTURE = 'fr_FR' AND (category.STRIPPED_NAME = 'bande-annonce' OR category.STRIPPED_NAME = 'extrait-film') ORDER BY media.IS_DEFAULT DESC, category.STRIPPED_NAME ASC
SELECT film_media.MEDIA_ID, film_media.MEDIA_CULTURE, film_media.FILM_ID, film_media.FILM_CULTURE, film_media.CREATED_BY_USER, film_media.CREATED_AT, film.ID, film.CULTURE, film.TITRE, film.TITRE_ORIGINAL, film.SYNOPSIS, film.DESCRIPTION, film.DUREE, film.DATE_SORTIE, film.DATE_PROD, film.DATE_SORTIE_DVD, film.DATE_SORTIE_CINE, film.FREEBASE_ID, film.URL_UNCINE, film.IS_ACTIVATED, film.STATUS_RECO, film.CREATED_BY_USER, film.CREATED_AT, film.UPDATED_AT, film.BA_VF, film.BA_VO, film.INTERDICTION_LEGALE, film.IS_HIGHLIGHT, film.SYNOPSIS_VOD, film.NOTE_VOD, film.CATCH_PHRASE, film.ID_AC, film.CATCH_PHRASE_OK, film.IS_SERIE, film.HAS_VOD, film.ID_SAMMY, film.ID_SC FROM `film_media` LEFT JOIN film ON (film_media.FILM_ID=film.ID AND film_media.FILM_CULTURE=film.CULTURE) WHERE film_media.MEDIA_ID=66702 AND film_media.MEDIA_CULTURE='fr_FR'
SELECT film_media.MEDIA_ID, film_media.MEDIA_CULTURE, film_media.FILM_ID, film_media.FILM_CULTURE, film_media.CREATED_BY_USER, film_media.CREATED_AT, film.ID, film.CULTURE, film.TITRE, film.TITRE_ORIGINAL, film.SYNOPSIS, film.DESCRIPTION, film.DUREE, film.DATE_SORTIE, film.DATE_PROD, film.DATE_SORTIE_DVD, film.DATE_SORTIE_CINE, film.FREEBASE_ID, film.URL_UNCINE, film.IS_ACTIVATED, film.STATUS_RECO, film.CREATED_BY_USER, film.CREATED_AT, film.UPDATED_AT, film.BA_VF, film.BA_VO, film.INTERDICTION_LEGALE, film.IS_HIGHLIGHT, film.SYNOPSIS_VOD, film.NOTE_VOD, film.CATCH_PHRASE, film.ID_AC, film.CATCH_PHRASE_OK, film.IS_SERIE, film.HAS_VOD, film.ID_SAMMY, film.ID_SC FROM `film_media` LEFT JOIN film ON (film_media.FILM_ID=film.ID AND film_media.FILM_CULTURE=film.CULTURE) WHERE film_media.MEDIA_ID=58873 AND film_media.MEDIA_CULTURE='fr_FR'
SELECT film_media.MEDIA_ID, film_media.MEDIA_CULTURE, film_media.FILM_ID, film_media.FILM_CULTURE, film_media.CREATED_BY_USER, film_media.CREATED_AT, film.ID, film.CULTURE, film.TITRE, film.TITRE_ORIGINAL, film.SYNOPSIS, film.DESCRIPTION, film.DUREE, film.DATE_SORTIE, film.DATE_PROD, film.DATE_SORTIE_DVD, film.DATE_SORTIE_CINE, film.FREEBASE_ID, film.URL_UNCINE, film.IS_ACTIVATED, film.STATUS_RECO, film.CREATED_BY_USER, film.CREATED_AT, film.UPDATED_AT, film.BA_VF, film.BA_VO, film.INTERDICTION_LEGALE, film.IS_HIGHLIGHT, film.SYNOPSIS_VOD, film.NOTE_VOD, film.CATCH_PHRASE, film.ID_AC, film.CATCH_PHRASE_OK, film.IS_SERIE, film.HAS_VOD, film.ID_SAMMY, film.ID_SC FROM `film_media` LEFT JOIN film ON (film_media.FILM_ID=film.ID AND film_media.FILM_CULTURE=film.CULTURE) WHERE film_media.MEDIA_ID=68899 AND film_media.MEDIA_CULTURE='fr_FR'
SELECT * FROM personne_users INNER JOIN users ON personne_users.user_id = users.id LEFT JOIN film_users ON film_users.user_id = users.id LEFT JOIN film ON film_users.film_id = film.id WHERE personne_users.20609 = :20609 GROUP BY users.id LIMIT :0, :3
SELECT * FROM personne_users INNER JOIN users ON personne_users.user_id = users.id LEFT JOIN film_users ON film_users.user_id = users.id LEFT JOIN film ON film_users.film_id = film.id WHERE personne_users.20609 = :20609 GROUP BY users.id LIMIT :0, :3
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 13
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='13'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 13
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='13'
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 1
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT=1
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 1
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT=1
SELECT sim.*, src.id as src_id, src.url as src_url, src.type as src_type , bl.id_block as id_block, bl.url as block_url, bl.block_title as block_title, IF(bl.rank IS NULL,1000,bl.rank) as block_rank FROM src_link src INNER JOIN similar_link sim ON sim.id_src_link = src.id LEFT JOIN block_link_src bls ON bls.id_src_link = src.id LEFT JOIN block_links bl ON bl.id_block = bls.id_block WHERE src.type=2 AND src.url = '/artiste/20609/jared-leto' AND (bl.id_block IS NULL OR bl.url = '/artiste/20609/jared-leto') ORDER BY block_rank ASC, sim.rank ASC
SELECT sim.*, src.id as src_id, src.url as src_url, src.type as src_type , bl.id_block as id_block, bl.url as block_url, bl.block_title as block_title, IF(bl.rank IS NULL,1000,bl.rank) as block_rank FROM src_link src INNER JOIN similar_link sim ON sim.id_src_link = src.id LEFT JOIN block_link_src bls ON bls.id_src_link = src.id LEFT JOIN block_links bl ON bl.id_block = bls.id_block WHERE src.type=1 AND INSTR('/artiste/20609/jared-leto', src.url) = 1 AND (bl.id_block IS NULL OR INSTR('/artiste/20609/jared-leto', bl.url) = 1) ORDER BY block_rank ASC, sim.rank ASC
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 14
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_PAGE_GEN_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='14'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 14
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_PAGE_GEN_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='14'
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 12
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='12'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 12
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='12'
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 11
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='11'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 11
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='11'
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 3
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='3'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 3
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='3'
SELECT menu_selection.ID, menu_selection.NAME, menu_selection.RANK FROM `menu_selection` ORDER BY menu_selection.RANK ASC LIMIT 1
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 2
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='2'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 2
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='2'
SELECT * FROM partner WHERE partner.ON_FOOTER = 1
SELECT id FROM country WHERE code_pays = :code;
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 6
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND adv_url.ADV_ID IN ('') AND advertisement.REVERSE_RULE=0 AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='6'
SELECT adv_id FROM adv_country INNER JOIN advertisement on advertisement.id = adv_country.adv_id WHERE country_id = :country_id AND advertisement.format = :adv_format
SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/artiste/20609/jared-leto' AND url_exact = 1) OR (INSTR('/artiste/20609/jared-leto', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 6
SELECT DISTINCT advertisement.ID, advertisement.FILE, advertisement.NAME, advertisement.FORMAT, advertisement.IMAGE_URL, advertisement.JSCODE, advertisement.TYPE, advertisement.IS_ACTIVE, advertisement.REVERSE_RULE, advertisement.ON_HOMEPAGE, advertisement.ON_OTHER_PAGES, advertisement.ON_VIDEO_PAGES, advertisement.ON_FILM_PAGES, advertisement.ON_PAGE_GEN_PAGES, advertisement.ON_LISTE_PAGES, advertisement.ON_ACTU_PAGES, advertisement.HOME_PERCENTAGE, advertisement.OTHERS_PERCENTAGE, advertisement.VIDEO_PERCENTAGE, advertisement.FILM_PERCENTAGE, advertisement.PAGE_GEN_PERCENTAGE, advertisement.LISTE_PERCENTAGE, advertisement.ACTU_PERCENTAGE, advertisement.IS_FOR_MEMBER, advertisement.HEIGHT, advertisement.BACKGROUND_COLOR, advertisement.CREATED_AT, advertisement.UPDATED_AT FROM `advertisement` LEFT JOIN adv_url ON (advertisement.ID=adv_url.ADV_ID) LEFT JOIN adv_country ON (advertisement.ID=adv_country.ADV_ID) WHERE advertisement.ON_OTHER_PAGES=1 AND (adv_url.URL IS NULL OR (advertisement.REVERSE_RULE=1 AND adv_url.ADV_ID NOT IN (''))) AND advertisement.IS_ACTIVE=1 AND adv_country.ADV_ID IS NULL AND advertisement.FORMAT='6'

Artiste
Jared Leto

Filmographie sélective de Jared Leto

Extraits de films, bande-annonces

Commentaires

Ils sont fans

reload and ignore cache

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

Artiste Jared Leto

Filmographie sélective de Jared Leto

Extraits de films, bande-annonces

Commentaires

Ils sont fans

reload and ignore cache

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

Logs

Timers

SQL queries

Artiste
Jared Leto