parameterHolder:
  action: index
  module: page
  order: plus
  page: '1'
  page_url: nouvelle-serie
  periode: semaine
  slug: nouvelle-serie
attributeHolder:
  sf_route: 'pageObjectRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery/jquery-1.9.1.js: {  }
  jquery/jquery-migrate-1.1.1.js: {  }
  jquery/jquery-cookie-master/jquery.cookie.min.js: {  }
  jquery/jquery.sly.js: {  }
  jquery/jquery-ui-1.10.2.custom.js: {  }
  jquery-scrolltofixed.js: {  }
  fakeSelectPage.js: {  }
  jquery/jquery.bxslider/jquery.bxslider.min.js: {  }
stylesheets:
  /css/optimized.css?1517385210: {  }
  page: {  }
  page.css: {  }
  fakeSelectPage.css: {  }
metas:
  title: 'Nouvelle série : nouveautés séries TV et VOD'
  description: 'Nouveauté séries : Toutes les nouvelles séries TV sorties ou qui sortiront bientôt sur TV et VOD à ne pas manquer.'
  keywords: Cinetrafic
  language: fr_FR
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: null
  default_culture: fr_FR
  use_flash: true
  logging: '1'
  timeout: false
attributeHolder: {  }
culture: fr_FR

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_carousel_enabled: true
mod_carousel_is_internal: false
mod_carousel_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_page_enabled: true
mod_page_is_internal: false
mod_page_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_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: ' ↓ '
sf_validation_error_suffix: '  ↓'
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

cookie: {  }
env: {  }
files: {  }
get: {  }
post: {  }
server:
  APPLICATION: frontend
  DOCUMENT_ROOT: /home/cinetrafic/dev/web
  ENVIRONNEMENT: dev
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_ACCEPT_ENCODING: 'x-gzip, gzip, deflate'
  HTTP_HOST: dev.cinetrafic.fr
  HTTP_USER_AGENT: 'CCBot/2.0 (http://commoncrawl.org/faq/)'
  HTTP_X_FORWARDED_FOR: 54.167.230.68
  HTTP_X_FORWARDED_PROTO: http
  HTTP_X_HOST: dev.cinetrafic.fr
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PHP_SELF: /index.php
  QUERY_STRING: ''
  REDIRECT_ENVIRONNEMENT: dev
  REDIRECT_STATUS: '200'
  REDIRECT_URL: /nouvelle-serie
  REMOTE_ADDR: 127.0.0.1
  REMOTE_PORT: '43006'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1529562277
  REQUEST_TIME_FLOAT: 1529562277.256
  REQUEST_URI: /nouvelle-serie
  SCRIPT_FILENAME: /home/cinetrafic/dev/web/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: root@localhost
  SERVER_NAME: dev.cinetrafic.fr
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: "<address>Apache/2.2.15 (CentOS) Server at dev.cinetrafic.fr Port 80</address>\n"
  SERVER_SOFTWARE: 'Apache/2.2.15 (CentOS)'
session: {  }

php: 5.4.45
os: 'Linux ns236615.ovh.net 3.2.13-grsec-xxxx-grs-ipv6-64 #1 SMP Thu Mar 29 09:48:59 UTC 2012 x86_64'
extensions:
  - 'Core (5.4.45)'
  - 'date (5.4.45)'
  - ereg
  - libxml
  - openssl
  - pcre
  - 'zlib (2.0)'
  - bz2
  - calendar
  - ctype
  - 'hash (1.0)'
  - 'filter (0.11.0)'
  - ftp
  - gettext
  - 'SPL (0.2)'
  - iconv
  - 'Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $)'
  - session
  - 'standard (5.4.45)'
  - shmop
  - 'SimpleXML (0.1)'
  - sockets
  - mbstring
  - 'tokenizer (0.1)'
  - xml
  - apache2handler
  - 'ssh2 (0.13)'
  - 'OAuth (1.2.3)'
  - curl
  - 'dom (20031129)'
  - 'fileinfo (1.0.5)'
  - gd
  - gmp
  - 'json (1.2.1)'
  - 'exif (1.4 $Id: 05041c5f0094cb46d9b516bd624d593b90cc38f9 $)'
  - mcrypt
  - 'mysql (1.0)'
  - 'mysqli (0.1)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_sqlite (1.0.1)'
  - 'Phar (2.0.1)'
  - pspell
  - 'snmp (0.1)'
  - 'sqlite3 (0.7)'
  - 'tidy (2.0)'
  - wddx
  - 'xmlreader (0.1)'
  - 'xmlwriter (0.1)'
  - 'xsl (0.1)'
  - 'zip (1.11.0)'
  - mhash

version: 1.2.13-DEV
path: /home/symfony/lib

1. SET NAMES 'utf8'
2. SELECT p.id, p.title, p.breadcumb, p.description, p.slug, p.page_title, p.page_meta_description, p.use_nb_film_in_meta, p.use_title_film_in_meta, p.pager_text, p.type, p.order_by,p.page_type,p.video_type, p.page_template, p.nb_view, p.use_date_prod, p.use_highlight, p.use_canonical, p.is_meilleur_page, p.limit_nb_film, p.anchor_page, p.display_menu_select, p.is_meilleur_page, p.nb_film_per_page, p.exclude_serie, p.vod_only, p.is_cine_page, p.title_hub FROM page p WHERE p.slug = :slug AND p.is_active = 1
3. SELECT p.id, p.title, p.breadcumb, p.description, p.slug, p.page_title, p.page_meta_description, p.use_nb_film_in_meta, p.use_title_film_in_meta, p.pager_text, p.type, p.order_by,p.page_type,p.video_type, p.page_template, p.nb_view, p.use_date_prod, p.use_highlight, p.use_canonical, p.is_meilleur_page, p.limit_nb_film, p.anchor_page, p.display_menu_select, p.is_meilleur_page, p.nb_film_per_page, p.exclude_serie, p.vod_only, p.is_cine_page, p.title_hub FROM page p WHERE p.slug = :slug AND p.is_active = 1
4. SELECT page.ID, page.TITLE, page.BREADCUMB, page.DESCRIPTION, page.SLUG, page.USE_PAGE, page.DEFAULT_FILM, page.PAGE_TITLE, page.PAGE_META_DESCRIPTION, page.USE_NB_FILM_IN_META, page.USE_TITLE_FILM_IN_META, page.IS_ACTIVE, page.PAGER_TEXT, page.TYPE, page.ORDER_BY, page.PAGE_TYPE, page.VIDEO_TYPE, page.PAGE_TEMPLATE, page.FROM_MULTI, page.NB_VIEW, page.AFFICHE_PATH, page.USE_DATE_PROD, page.USE_HIGHLIGHT, page.USE_CANONICAL, page.ANCHOR_PAGE, page.DISPLAY_MENU_SELECT, page.IS_MEILLEUR_PAGE, page.LIMIT_NB_FILM, page.IS_MAIN_FOR_GENRE, page.USE_IN_ADN, page.NB_FILM_PER_PAGE, page.EXCLUDE_SERIE, page.VOD_ONLY, page.IS_CINE_PAGE, page.TITLE_HUB FROM `page` WHERE page.ID='21974'
5. SELECT film.id as f_id, film.culture as f_culture, film.titre as f_titre, film.titre_original as f_titre_original, film.synopsis as f_synopsis, film.description as f_description, film.duree as f_duree, film.date_sortie as f_date_sortie, film.date_prod as f_date_prod, film.date_sortie_dvd as f_date_dvd, film.date_sortie_cine as f_date_cine, film.freebase_id as f_freebase_id, film.url_uncine as f_url_uncine, film.is_activated as f_is_activated, film.status_reco as f_status_reco, film.created_by_user as f_created_by_user, film.created_at as f_created_at, film.updated_at as f_updated_at, film.ba_vf as f_ba_vf, film.ba_vo as f_ba_vo, film.interdiction_legale as f_interdiction_legale, film.is_highlight as f_is_highlight, film.synopsis_vod as syno_vod, film.note_vod as note_vod, film.catch_phrase, film.id_ac, film.catch_phrase_ok, film.is_serie, film.has_vod, film.id_sammy, film_country.film_id as fc_film_id, film_country.country_id as fc_country_id, film_country.rank as fc_rank, film_country.created_by_user as fc_created_by_user, film_country.created_at as fc_created_at, country.id, country.c_fr as c_c_fr, country.c_en as c_c_en, country.code_pays as c_code_pays, country.langue as c_langue, sum_film.nb_notes as sf_nb_notes, sum_film.nb_like as sf_nb_like, sum_film.quality_note as sf_quality_note, media.nb_view as m_nb_view, media.created_at as m_created_at FROM film LEFT JOIN sum_film ON film.id = sum_film.film_id AND film.culture = sum_film.film_culture LEFT JOIN film_country ON film_country.film_id = film.id LEFT JOIN country ON country.id = film_country.country_id RIGHT JOIN liste_film ON film.id = liste_film.film_id RIGHT JOIN page_liste ON liste_film.liste_id = page_liste.liste_id INNER JOIN liste ON liste.id = liste_film.liste_id LEFT JOIN film_media ON film_media.film_id = film.id LEFT JOIN media ON (media.id = film_media.media_id AND media.is_video = 1) WHERE liste_film.liste_culture = :culture AND film.culture = :culture AND liste.culture = :culture AND liste_film.is_saved != 0 AND page_liste.page_id = :page_id AND (film_media.media_culture = :culture OR film_media.media_culture IS NULL) AND ((media.id = (SELECT media_id FROM film_media fms INNER JOIN media ms ON ms.id = fms.media_id WHERE ms.culture = :culture AND fms.film_id = film.id AND is_video = 1 ORDER BY is_default DESC LIMIT 1)) OR media.id IS NULL) AND (film_country.rank = 0 OR film_country.rank IS NULL) GROUP BY film.id ORDER BY (!(is_open)*liste_film.rank) ASC, points DESC LIMIT :offset, :limit
6. SELECT COUNT(DISTINCT film.id) as nb FROM film RIGHT JOIN liste_film ON film.id = liste_film.film_id RIGHT JOIN page_liste ON liste_film.liste_id = page_liste.liste_id LEFT JOIN film_country ON film_country.film_id = film.id WHERE film.culture = :culture AND page_liste.page_id = :page_id AND liste_film.liste_culture = :culture AND liste_film.film_culture = :culture
7. SELECT * FROM sum_film WHERE sum_film.FILM_ID IN (44753,44101,44408,44599,44754,43710,44424,44598,44410,44705,43655,40459,40476,45342,45343,45436,45439,45444,45446,45466) AND sum_film.FILM_CULTURE = :culture
8. 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 (44753,44101,44408,44599,44754,43710,44424,44598,44410,44705,43655,40459,40476,45342,45343,45436,45439,45444,45446,45466) AND genre_culture = :culture AND film_culture = :culture AND genre.culture = :culture ORDER BY genre.id
9. 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,5,6,7,9,11,12,13,59,629,631) AND page.type = 2 AND page.is_main_for_genre = 1
10. SELECT id, slug, is_meilleur_page, IF(INSTR(slug, 'top-')> 0, 1, 0 ) as is_top, IF(INSTR(slug, '-culte')> 0, 1, 0 ) as is_culte, COUNT(pl.liste_id) as nb_liste, IF(page.page_type = 4, 1, 0) as dernier_bon, IF(page.page_type = 6, 1, 0) as a_voir, IF(INSTR(slug, '-recent')> 0, 1, 0 ) as p_recent, COUNT(pk.keyword_id) as nb_keyword, COUNT(pds.date_sortie) as nb_date, COUNT(pg.genre_id) as nb_genre, GROUP_CONCAT(pg.genre_id) as liste_genre, COUNT(pc.country_id) as nb_country, GROUP_CONCAT(pds.date_sortie) as liste_date, GROUP_CONCAT(pc.country_id) as liste_country, GROUP_CONCAT(pk.keyword_id) as liste_keywords, IF(INSTR(GROUP_CONCAT(pg.genre_id), '629')>0, 1, 0) as type_serie, anchor_page, is_cine_page, vod_only, breadcumb FROM page LEFT JOIN page_liste pl ON pl.page_id = page.id LEFT JOIN page_date_sortie pds ON pds.page_id = page.id LEFT JOIN page_genre pg ON pg.page_id = page.id LEFT JOIN page_keyword pk ON pk.page_id = page.id LEFT JOIN page_country pc ON pc.page_id = page.id WHERE is_active = 1 AND page.id = 21974 GROUP BY page.id
11. SELECT page_menu_id FROM page_menu_url WHERE page_url = '/nouvelle-serie'
12. SELECT page_menu_id FROM page_menu_url WHERE page_url = '/nouvelle-serie'
13. SELECT id FROM country WHERE code_pays = :code;
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
15. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 4
16. 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='4'
17. 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
18. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 4
19. 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='4'
20. SELECT * FROM pg_menu INNER JOIN pg_menu_item p_item ON p_item.id_pg_menu = pg_menu.id_pg_menu WHERE pg_menu.id_page = :page_id ORDER BY item_position ASC
21. SELECT date_sortie FROM page_date_sortie WHERE page_id = :page_id
22. SELECT genre_id FROM page_genre WHERE page_id = :page_id
23. SELECT distinct(country_id) FROM page_country WHERE page_id = :page_id
24. SELECT liste_id FROM page_liste WHERE page_id = :page_id
25. SELECT keyword_id FROM page_keyword WHERE page_id = :page_id
26. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2015' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
27. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2014' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
28. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2013' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
29. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2012' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
30. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2011' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
31. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2010' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
32. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2009' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
33. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2008' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
34. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2007' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
35. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2006' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
36. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2005' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
37. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2004' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
38. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2003' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
39. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2002' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
40. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2001' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
41. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2010,2011,2012,2013,2014,2015' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
42. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '2000,2001,2002,2003,2004,2005,2006,2007,2008,2009' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
43. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '1990,1991,1992,1993,1994,1995,1996,1997,1998,1999' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
44. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '1980,1981,1982,1983,1984,1985,1986,1987,1988,1989' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
45. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '1970,1971,1972,1973,1974,1975,1976,1977,1978,1979' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
46. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '1960,1961,1962,1963,1964,1965,1966,1967,1968,1969' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
47. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '1950,1951,1952,1953,1954,1955,1956,1957,1958,1959' AND linked_g = '' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
48. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '41' AND linked_l = '10889' AND linked_k = ''
49. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '138' AND linked_l = '10889' AND linked_k = ''
50. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '5,9,16,19,24,28,35,49,51,52,53,54,57,59,60,62,63,65,69,71,77,80,86,88,89,95,104,110,111,114,115,118,122,123,129,130,141,142,144,153,155,158,170,172,185,189,190,191,283,407,409' AND linked_l = '10889' AND linked_k = ''
51. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '6,11,13,15,23,26,29,31,36,46,48,76,81,90,92,94,101,109,120,121,149,160,161,184,192' AND linked_l = '10889' AND linked_k = ''
52. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '1,2,4,12,14,18,20,22,27,30,33,34,39,42,43,44,47,61,66,67,70,72,75,78,79,82,83,87,100,102,103,105,106,112,113,116,117,125,126,139,140,171,408' AND linked_l = '10889' AND linked_k = ''
53. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '58' AND linked_l = '10889' AND linked_k = ''
54. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '37' AND linked_l = '10889' AND linked_k = ''
55. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = ' 99,231' AND linked_l = '10889' AND linked_k = ''
56. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '10' AND linked_l = '10889' AND linked_k = ''
57. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '' AND linked_c = '59' AND linked_l = '10889' AND linked_k = ''
58. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '6' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
59. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '4' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
60. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '7' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
61. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '8' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
62. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '9' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
63. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '11' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
64. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '12' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
65. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '13' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
66. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '34' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
67. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '103' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
68. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '213' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
69. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '5' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
70. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '1' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
71. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '158' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
72. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '568' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
73. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '598' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
74. SELECT page_id, slug FROM page_sum_info INNER JOIN page ON page.id = page_sum_info.page_id WHERE page.is_active = 1 AND linked_ds = '' AND linked_g = '629' AND linked_c = '' AND linked_l = '10889' AND linked_k = ''
75. 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(44753, 44101, 44408, 44599, 44754, 43710, 44424, 44598, 44410, 44705, 43655, 40459, 40476, 45342, 45343, 45436, 45439, 45444, 45446, 45466) 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);
76. 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 = 44753 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
77. 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 = 44753 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
78. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44753
79. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=51945 LIMIT 1
80. SELECT personne.name, personne.id FROM personne INNER JOIN 44753_acteur ON 44753_acteur.personne_id = personne.id WHERE 44753_acteur.FILM_ID = :44753 ORDER BY RANK ASC LIMIT 2
81. 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 = 44101 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
82. 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 = 44101 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
83. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44101
84. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=25181 LIMIT 1
85. SELECT personne.name, personne.id FROM personne INNER JOIN 44101_acteur ON 44101_acteur.personne_id = personne.id WHERE 44101_acteur.FILM_ID = :44101 ORDER BY RANK ASC LIMIT 2
86. 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 = 44408 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
87. 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 = 44408 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
88. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44408
89. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=145581 LIMIT 1
90. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=145582 LIMIT 1
91. SELECT personne.name, personne.id FROM personne INNER JOIN 44408_acteur ON 44408_acteur.personne_id = personne.id WHERE 44408_acteur.FILM_ID = :44408 ORDER BY RANK ASC LIMIT 2
92. 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 = 44599 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
93. 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 = 44599 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
94. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44599
95. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=36573 LIMIT 1
96. SELECT personne.name, personne.id FROM personne INNER JOIN 44599_acteur ON 44599_acteur.personne_id = personne.id WHERE 44599_acteur.FILM_ID = :44599 ORDER BY RANK ASC LIMIT 2
97. SELECT id FROM country WHERE code_pays = :code;
98. 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
99. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 15
100. 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'
101. 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
102. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 15
103. 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'
104. 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 = 44754 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
105. 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 = 44754 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
106. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44754
107. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=32686 LIMIT 1
108. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=123477 LIMIT 1
109. SELECT personne.name, personne.id FROM personne INNER JOIN 44754_acteur ON 44754_acteur.personne_id = personne.id WHERE 44754_acteur.FILM_ID = :44754 ORDER BY RANK ASC LIMIT 2
110. 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 = 43710 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
111. 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 = 43710 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
112. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=43710
113. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=22015 LIMIT 1
114. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=39594 LIMIT 1
115. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=130829 LIMIT 1
116. SELECT personne.name, personne.id FROM personne INNER JOIN 43710_acteur ON 43710_acteur.personne_id = personne.id WHERE 43710_acteur.FILM_ID = :43710 ORDER BY RANK ASC LIMIT 2
117. 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 = 44424 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
118. 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 = 44424 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
119. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44424
120. SELECT personne.name, personne.id FROM personne INNER JOIN 44424_acteur ON 44424_acteur.personne_id = personne.id WHERE 44424_acteur.FILM_ID = :44424 ORDER BY RANK ASC LIMIT 2
121. 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 = 44598 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
122. 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 = 44598 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
123. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44598
124. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=143711 LIMIT 1
125. SELECT personne.name, personne.id FROM personne INNER JOIN 44598_acteur ON 44598_acteur.personne_id = personne.id WHERE 44598_acteur.FILM_ID = :44598 ORDER BY RANK ASC LIMIT 2
126. 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 = 44410 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
127. 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 = 44410 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
128. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44410
129. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=115776 LIMIT 1
130. SELECT personne.name, personne.id FROM personne INNER JOIN 44410_acteur ON 44410_acteur.personne_id = personne.id WHERE 44410_acteur.FILM_ID = :44410 ORDER BY RANK ASC LIMIT 2
131. 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 = 44705 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
132. 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 = 44705 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
133. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=44705
134. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=148772 LIMIT 1
135. SELECT personne.name, personne.id FROM personne INNER JOIN 44705_acteur ON 44705_acteur.personne_id = personne.id WHERE 44705_acteur.FILM_ID = :44705 ORDER BY RANK ASC LIMIT 2
136. SELECT id FROM country WHERE code_pays = :code;
137. 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
138. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 16
139. 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='16'
140. 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
141. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 16
142. 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='16'
143. 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 = 43655 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
144. 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 = 43655 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
145. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=43655
146. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=139486 LIMIT 1
147. SELECT personne.name, personne.id FROM personne INNER JOIN 43655_acteur ON 43655_acteur.personne_id = personne.id WHERE 43655_acteur.FILM_ID = :43655 ORDER BY RANK ASC LIMIT 2
148. 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 = 40459 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
149. 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 = 40459 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
150. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=40459
151. SELECT personne.name, personne.id FROM personne INNER JOIN 40459_acteur ON 40459_acteur.personne_id = personne.id WHERE 40459_acteur.FILM_ID = :40459 ORDER BY RANK ASC LIMIT 2
152. 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 = 40476 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
153. 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 = 40476 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
154. 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 = 40476 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
155. 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 = 40476 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
156. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=40476
157. SELECT personne.name, personne.id FROM personne INNER JOIN 40476_acteur ON 40476_acteur.personne_id = personne.id WHERE 40476_acteur.FILM_ID = :40476 ORDER BY RANK ASC LIMIT 2
158. 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 = 45342 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
159. 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 = 45342 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
160. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45342
161. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=150269 LIMIT 1
162. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=150270 LIMIT 1
163. SELECT personne.name, personne.id FROM personne INNER JOIN 45342_acteur ON 45342_acteur.personne_id = personne.id WHERE 45342_acteur.FILM_ID = :45342 ORDER BY RANK ASC LIMIT 2
164. 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 = 45343 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
165. 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 = 45343 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
166. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45343
167. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=150271 LIMIT 1
168. SELECT personne.name, personne.id FROM personne INNER JOIN 45343_acteur ON 45343_acteur.personne_id = personne.id WHERE 45343_acteur.FILM_ID = :45343 ORDER BY RANK ASC LIMIT 2
169. 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 = 45436 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
170. 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 = 45436 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
171. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45436
172. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=18267 LIMIT 1
173. SELECT personne.name, personne.id FROM personne INNER JOIN 45436_acteur ON 45436_acteur.personne_id = personne.id WHERE 45436_acteur.FILM_ID = :45436 ORDER BY RANK ASC LIMIT 2
174. 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 = 45439 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
175. 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 = 45439 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
176. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45439
177. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=115522 LIMIT 1
178. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=150473 LIMIT 1
179. SELECT personne.name, personne.id FROM personne INNER JOIN 45439_acteur ON 45439_acteur.personne_id = personne.id WHERE 45439_acteur.FILM_ID = :45439 ORDER BY RANK ASC LIMIT 2
180. 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 = 45444 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
181. 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 = 45444 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
182. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45444
183. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=130506 LIMIT 1
184. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=137514 LIMIT 1
185. SELECT personne.name, personne.id FROM personne INNER JOIN 45444_acteur ON 45444_acteur.personne_id = personne.id WHERE 45444_acteur.FILM_ID = :45444 ORDER BY RANK ASC LIMIT 2
186. 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 = 45446 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
187. 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 = 45446 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
188. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45446
189. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=150502 LIMIT 1
190. SELECT personne.name, personne.id FROM personne INNER JOIN 45446_acteur ON 45446_acteur.personne_id = personne.id WHERE 45446_acteur.FILM_ID = :45446 ORDER BY RANK ASC LIMIT 2
191. 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 = 45466 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
192. 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 = 45466 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
193. SELECT film_realisateur.FILM_ID, film_realisateur.PERSONNE_ID, film_realisateur.CREATED_BY_USER, film_realisateur.CREATED_AT FROM `film_realisateur` WHERE film_realisateur.FILM_ID=45466
194. SELECT personne.ID, personne.NAME, personne.STRIPPED_NAME, personne.CREATED_BY_USER, personne.BORN_AT, personne.BORN_PLACE, personne.DEATH_AT, personne.DEATH_PLACE, personne.CREATED_AT, personne.UPDATED_AT FROM `personne` WHERE personne.ID=132276 LIMIT 1
195. SELECT personne.name, personne.id FROM personne INNER JOIN 45466_acteur ON 45466_acteur.personne_id = personne.id WHERE 45466_acteur.FILM_ID = :45466 ORDER BY RANK ASC LIMIT 2
196. SELECT id FROM country WHERE code_pays = :code;
197. 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
198. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 13
199. 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='13'
200. 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
201. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 13
202. 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='13'
203. SELECT carousel.ID, carousel.NAME, carousel.WIDTH, carousel.HEIGHT, carousel.IS_ACTIVE, carousel.DISPLAY_TYPE FROM `carousel` WHERE carousel.ID='2'
204. SELECT * FROM carousel_slide INNER JOIN carousel ON carousel_slide.id_carousel = carousel.id WHERE id_carousel = 2 AND carousel.is_active = 1 ORDER BY `ordre` ASC
205. SELECT id FROM country WHERE code_pays = :code;
206. 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
207. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 1
208. 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=1
209. 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
210. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 1
211. 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=1
212. 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 = '/nouvelle-serie' AND (bl.id_block IS NULL OR bl.url = '/nouvelle-serie') ORDER BY block_rank ASC, sim.rank ASC
213. 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('/nouvelle-serie', src.url) = 1 AND (bl.id_block IS NULL OR INSTR('/nouvelle-serie', bl.url) = 1) ORDER BY block_rank ASC, sim.rank ASC
214. SELECT id FROM country WHERE code_pays = :code;
215. 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
216. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 14
217. 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'
218. 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
219. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 14
220. 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'
221. SELECT id FROM country WHERE code_pays = :code;
222. 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
223. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 5
224. 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='5'
225. 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
226. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 5
227. 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='5'
228. SELECT id FROM country WHERE code_pays = :code;
229. 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
230. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 12
231. 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='12'
232. 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
233. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 12
234. 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='12'
235. SELECT id FROM country WHERE code_pays = :code;
236. 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
237. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 11
238. 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='11'
239. 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
240. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 11
241. 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='11'
242. SELECT id FROM country WHERE code_pays = :code;
243. 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
244. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 3
245. 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='3'
246. 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
247. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 3
248. 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='3'
249. SELECT menu_selection.ID, menu_selection.NAME, menu_selection.RANK FROM `menu_selection` ORDER BY menu_selection.RANK ASC LIMIT 1
250. SELECT id FROM country WHERE code_pays = :code;
251. 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
252. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 2
253. 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'
254. 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
255. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 2
256. 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'
257. SELECT * FROM partner WHERE partner.ON_FOOTER = 1
258. SELECT id FROM country WHERE code_pays = :code;
259. 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
260. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 6
261. 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='6'
262. 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
263. SELECT adv_id FROM adv_url INNER JOIN advertisement on advertisement.id = adv_url.adv_id WHERE ((url = '/nouvelle-serie' AND url_exact = 1) OR (INSTR('/nouvelle-serie', url) AND url_exact = 0)) AND advertisement.is_active = 1 AND advertisement.format = 6
264. 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='6'