706 offres d'emploi en santé dans 65 spécialités

Achats/Approvisionnement 4
Administration en santé 55
Administration | Santé 40
Agents de sécurité et surveillants 0
Alimentation et cuisines 36
Analyses biomédicales 2
Animation et loisirs 13
Archivistes médicaux 0
Ass. à la pers. à domicile (Aides et auxiliaires) 9
Ass. à la pers. en étab. de santé (PAB) 38
Assistants dentaires 1
Audiologie 0
Avocats 5
Biologie et microbiologie 3
Communications 7
Construction - Santé 1
Criminologie 11

Dentistes 2
Éducateurs spécialisés 58
Électrophysiologie médicale 2
Entretien ménager 40
Ergothérapie 29
Finance et comptabilité 18
Génie biomédical 0
Hygiénistes dentaires 4
Imagerie médicale 0
Informatique 12
Inhalothérapeutes 12
Intervention psychosociale/dépendances 34
Kinésiologie 5
Massothérapie 0
Médecine 18
Médecine nucléaire 0

Recherche et enseignement 3
Récréologie 4
Répartition des services d'urgences 4
Ressources humaines 35
Sages-femmes 2
Santé au travail 10
Santé publique 20
Santé, ass. et soins infirmiers (Infirmières auxiliaires) 23
Secrétariat 30
Sexologie 4
Soins infirmiers 146
Stérilisation 1
Technologistes médicaux 3
Télétravail - Santé et services sociaux 4
Travail social 108
Ventes - santé et services sociaux 3

152 emplois

2 emplois

5 emplois

1 emplois

28 emplois

118 emplois

1 emplois

156 emplois

35 emplois

59 emplois

4 emplois

1^er site d'emploi en santé au Québec, emploisprofessionnelsensante.com est

l’un des 35 sites d’Emplois spécialisés, une division de Techno-Communication.

EN PLUS DE POUVOIR VISUALISER ET PUBLIER DES ANNONCES D'OFFRES D'EMPLOI EN SANTÉ SUR NOTRE SITE, VOUS POURREZ BÉNÉFICIER DE TOUS NOS SERVICES TECHNOLOGIQUES ET PERSONNALISÉS.

Que vous soyez candidat à titre d’infirmière, travailleur social, psychologue, physiothérapeute, pharmacien, cadre, désiriez occuper une fonction ou un métier dans le réseau de la santé ou encore recruteur, notre site dédié à l’emploi en santé vous offre des possibilités quasi illimitées.

CANDIDATS: DÉCOUVREZ NOS APPLICATIONS UNIQUES 2.0!

mission d'emploisprofessionnelsensante.com

Nos filtres intelligents pour la recherche d’emploi santé avec géolocalisation vous permettent de faire une recherche rapide et efficace en quelques secondes seulement. Nos portails d’employeurs avec photos et vidéos vous permettent de mieux connaître votre futur milieu de travail.

Grâce à notre CV automatisé avec photo et vidéo, vous obtiendrez un CV professionnel gratuit, recevrez des alertes d’emploi santé selon vos préférences et pourrez faire le suivi sur vos CV envoyés avec nos employeurs.

Bref, en utilisant tous nos services d’agence emploi en santé, vous pourrez trouver un emploi santé qui répond en tous points à vos attentes et incontestablement changer votre style de vie !

RECRUTEURS: OPTEZ POUR UN PROCESSUS D'EMBAUCHE PLUS EFFICACE!

Pour les recruteurs, notre système interne de gestion de candidatures gratuit et notre approche incomparable sur les réseaux sociaux (LinkedIn, Twitter, YouTube, Facebook) rendront votre processus d’embauche beaucoup plus efficace et vos postes seront comblés plus rapidement.

Vous pourrez ainsi : « Maîtriser le changement et recruter différemment ! ». Suivant les tendances mondiales de consommation, nous invitons tous nos clients à participer au développement de nos produits, services et applications pour que vous soyez partie prenante de notre succès !

Que vous soyez candidat ou recruteur, emploisprofessionnelsensante.com

constitue véritablement votre 1^er site d'emploi en santé au Québec!

Tweets de @jobssante

Request

Response

Settings

app_country_setup: ca
app_facebook_app_id: 241749253051494
app_facebook_app_secret: 6de6bf5662b14ff2739c4985102fa9d7
app_mp_reality_admin_categories:
  Bloc1: { label: Moderation, class: medium, items: { Articles: { url: jobeet_job, image: email.png, badge: { model: JobeetJob, table_method: getActiveJobs }, credentials: [[admin, publisher]] }, Comments: { url: product, image: basket.png, badge: { model: Product, table_method: findAll }, credentials: [admin] } } }
  Bloc2: { label: Activity, class: medium, items: { Articles1: { url: product_test2, image: coins.png, credentials: [[admin, publisher]] }, Comments1: { url: jobeet_category, image: user.png, credentials: [admin] } } }
  Bloc3: { label: 'Console 3', class: medium, items: { Articles1: { url: product_test2, image: coins.png, credentials: [[admin, publisher]] }, Comments2: { url: jobeet_category, image: user.png, credentials: [admin] } } }
app_mp_reality_admin_css_reset: false
app_mp_reality_admin_image_dir: /mpRealityAdminPlugin/images/icondock/
app_mp_reality_admin_max_per_page:
  - '3'
  - '5'
  - '10'
  - '20'
  - '50'
  - '100'
  - ∞
app_mp_reality_admin_site_tile: mpRealityAdminPlugin
app_mp_reality_admin_use_jquery: true
app_mp_reality_admin_web_dir: /mpRealityAdminPlugin
app_sfImageTransformPlugin_default_adapter: GD
app_sfImageTransformPlugin_default_image:
  mime_type: image/png
  filename: Untitled.png
  width: 100
  height: 100
  color: '#FFFFFF'
app_sfImageTransformPlugin_font_dir: /usr/share/fonts/truetype/msttcorefonts
app_sfImageTransformPlugin_mime_type:
  auto_detect: true
  library: gd_mime_type
app_sf_guard_plugin_profile_class: Profile
app_sf_guard_plugin_profile_field_name: user_id
app_sf_guard_plugin_remember_cookie_name: technocomm
app_sf_guard_plugin_remember_key_expiration_age: 25920000
mod_offres_enabled: true
mod_offres_view_class: sfPHP
mod_page_enabled: true
mod_page_view_class: sfPHP
mod_pub_enabled: true
mod_pub_view_class: sfPHP
sfTCPDFPlugin_dir: /var/www/symfony/dev/plugins/sfTCPDFPlugin/lib/tcpdf/
sfTCPDFPlugin_font_dir: /var/www/symfony/dev/plugins/sfTCPDFPlugin/lib/tcpdf/fonts/
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/symfony/dev/cache/frontend
sf_app_cache_dir: /var/www/symfony/dev/cache/frontend/dev
sf_app_config_dir: /var/www/symfony/dev/apps/frontend/config
sf_app_dir: /var/www/symfony/dev/apps/frontend
sf_app_i18n_dir: /var/www/symfony/dev/apps/frontend/i18n
sf_app_lib_dir: /var/www/symfony/dev/apps/frontend/lib
sf_app_module_dir: /var/www/symfony/dev/apps/frontend/modules
sf_app_template_dir: /var/www/symfony/dev/apps/frontend/templates
sf_apps_dir: /var/www/symfony/dev/apps
sf_cache: false
sf_cache_dir: /var/www/symfony/dev/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/symfony/dev/cache/frontend/dev/config
sf_config_dir: /var/www/symfony/dev/config
sf_csrf_secret: FrogSoft2012
sf_data_dir: /var/www/symfony/dev/data
sf_debug: true
sf_default_culture: fr_FR
sf_enabled_modules:
  - default
  - sfGuardAuth
  - contact
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: page
sf_error_reporting: 32767
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: on
sf_i18n_cache_dir: /var/www/symfony/dev/cache/frontend/dev/i18n
sf_lib_dir: /var/www/symfony/dev/lib
sf_log_dir: /var/www/symfony/dev/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_module_cache_dir: /var/www/symfony/dev/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /var/www/symfony/dev/plugins
sf_root_dir: /var/www/symfony/dev
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - Text
sf_symfony_lib_dir: /var/www/symfony/dev/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/symfony/dev/cache/frontend/dev/template
sf_test_cache_dir: /var/www/symfony/dev/cache/frontend/dev/test
sf_test_dir: /var/www/symfony/dev/test
sf_upload_dir: /var/www/symfony/dev/../../public_html/uploads
sf_upload_dir_name: uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/symfony/dev/../../public_html
sf_web_dir_name: public_html
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true

Globals

Php

Logs

#	type	message
1	sfPatternRouting	Connect sfRoute "sf_guard_signin" (/guard/login)
2	sfPatternRouting	Connect sfRoute "sf_guard_signout" (/guard/logout)
3	Doctrine_Connection_Mysql	exec : SET NAMES 'UTF8' - ()
4	Doctrine_Connection_Mysql	query : SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')) - ()
5	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.domain = ?) LIMIT 1 - (emploisprofessionnelsensante.com)
6	sfPatternRouting	Match route "localized_homepage" (/:sf_culture/) for /fr/ with parameters array ( 'website_id' => '1', 'website_short_code' => 'sante', 'module' => 'page', 'action' => 'homepage', 'sf_culture' => 'fr',)
7	sfFilterChain	Executing filter "sfRenderingFilter"
8	sfFilterChain	Executing filter "sfExecutionFilter"
9	pageActions	Call "pageActions->executeHomepage()"
10	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
11	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.nom AS s2__nom FROM specialite s LEFT JOIN specialite_translation s2 ON s.id = s2.id LEFT JOIN website_specialite w ON s.id = w.specialite_id WHERE (s2.lang = ? AND w.website_id = ?) ORDER BY s2.nom ASC - (fr, 1)
12	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.website_id AS c2__website_id, c2.company_id AS c2__company_id, c2.show_on_homepage AS c2__show_on_homepage, c2.video AS c2__video, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at FROM company c LEFT JOIN company_portail c2 ON c.id = c2.company_id WHERE (c2.website_id = ? AND c2.show_on_homepage = 1) - (1)
13	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND LOWER(p2.titre) LIKE ? AND p.website_id = ?) - (fr, %accueil%, 1)
14	sfPHPView	Render "sf_app_dir/modules/page/templates/homepageSuccess.php"
15	Doctrine_Connection_Statement	execute : SELECT w.website_id AS w__website_id, w.specialite_id AS w__specialite_id FROM website_specialite w WHERE (w.website_id IN (?)) - (1)
16	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o INNER JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON (o.id = o3.offre_id) INNER JOIN specialite s ON s.id = o3.specialite_id INNER JOIN specialite_translation s2 ON s.id = s2.id INNER JOIN company c ON o.company_id = c.id INNER JOIN company_portail c2 ON c.id = c2.company_id WHERE s2.lang = ? AND s.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c2.website_id = ? AND o.actif = 1 GROUP BY o.id) dctrn_count_query - (fr, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
17	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.titre AS w__titre, w.video_employeur AS w__video_employeur, w.video_candidat AS w__video_candidat, w.meta_title AS w__meta_title, w.meta_description AS w__meta_description, w.meta_keywords AS w__meta_keywords, w.id_analytics AS w__id_analytics, w.titre_section_tendances AS w__titre_section_tendances, w.lang AS w__lang FROM website_translation w WHERE (w.id IN (?)) - (1)
18	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 689, 1)
19	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 657, 1)
20	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23617, 1)
21	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 71, 1)
22	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 38, 1)
23	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 10, 1)
24	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23, 1)
25	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 7, 1)
26	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 44, 1)
27	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 43, 1)
28	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 918, 1)
29	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 11, 1)
30	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 374, 1)
31	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 683, 1)
32	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 37, 1)
33	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23634, 1)
34	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 415, 1)
35	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 1043, 1)
36	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 28, 1)
37	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 25, 1)
38	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 41, 1)
39	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 16, 1)
40	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 32, 1)
41	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 693, 1)
42	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 39, 1)
43	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23645, 1)
44	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 6, 1)
45	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 36, 1)
46	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 295, 1)
47	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 402, 1)
48	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 887, 1)
49	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 85, 1)
50	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23646, 1)
51	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 1079, 1)
52	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 30, 1)
53	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 707, 1)
54	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 15, 1)
55	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 878, 1)
56	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 1085, 1)
57	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 806, 1)
58	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 19, 1)
59	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 2, 1)
60	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 17, 1)
61	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 160, 1)
62	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 924, 1)
63	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 21, 1)
64	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 20, 1)
65	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 23640, 1)
66	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 27, 1)
67	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 42, 1)
68	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 925, 1)
69	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 990, 1)
70	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 5, 1)
71	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 710, 1)
72	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 29, 1)
73	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 706, 1)
74	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 45, 1)
75	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 4, 1)
76	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 500, 1)
77	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 31, 1)
78	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 40, 1)
79	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 9, 1)
80	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 1194, 1)
81	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 22, 1)
82	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o3.specialite_id = ? AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = ? GROUP BY o.id) dctrn_count_query - (fr, 1084, 1)
83	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
84	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 23, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
85	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
86	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 834, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
87	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
88	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 2964, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
89	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
90	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 2431, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
91	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
92	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 1862, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
93	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
94	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 732, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
95	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
96	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 3462, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
97	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
98	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 4528, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
99	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
100	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 5012, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
101	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
102	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 2287, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
103	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
104	Doctrine_Connection_Statement	execute : SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = ? AND o.company_id = ? AND o3.specialite_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND o2.titre != '' AND o.actif = ? GROUP BY o.id) dctrn_count_query - (fr, 5269, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 71, 85, 160, 295, 374, 402, 415, 421, 500, 592, 612, 614, 657, 669, 683, 689, 690, 693, 706, 707, 710, 806, 820, 878, 886, 887, 918, 924, 925, 990, 1043, 1079, 1084, 1085, 1194, 23617, 23634, 23640, 23645, 23646, 1)
105	main	Call "pub->executeDfpBodyTag()"
106	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
107	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
108	sfPHPView	Render "sf_app_dir/templates/layout.php"
109	main	Call "page->executeTitle()"
110	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
111	sfPartialView	Render "sf_app_dir/modules/page/templates/_title.php"
112	main	Get slot "og_tags"
113	main	Call "pub->executeDfpHeadTag()"
114	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
115	main	Call "page->executeFacebookInitScript()"
116	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
117	sfPartialView	Render "sf_app_dir/modules/page/templates/_facebookInitScript.php"
118	main	Call "page->executeMenu()"
119	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, haut)
120	sfPartialView	Render "sf_app_dir/modules/page/templates/_menu.php"
121	main	Call "page->executeSocialIcons()"
122	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
123	sfPartialView	Render "sf_app_dir/modules/page/templates/_socialIcons.php"
124	main	Call "page->executeCarrousel()"
125	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.carrousel_id AS w__carrousel_id, w.website_id AS w__website_id, w.target_url AS w__target_url, w.views AS w__views, w.published AS w__published, c.id AS c__id, c.ordre AS c__ordre, c.image AS c__image FROM website_carrousel w LEFT JOIN carrousel c ON w.carrousel_id = c.id WHERE (w.website_id = ? AND w.published = 1 AND c.id IS NOT NULL) ORDER BY c.ordre ASC - (1)
126	sfPartialView	Render "sf_app_dir/modules/page/templates/_carrousel.php"
127	main	Call "page->executeMenu()"
128	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, navigation_principale)
129	sfPartialView	Render "sf_app_dir/modules/page/templates/_menu.php"
130	main	Call "page->executeSousMenu()"
131	sfPartialView	Render "sf_app_dir/modules/page/templates/_sousMenu.php"
132	main	Call "offres->executeSearchBar()"
133	sfPartialView	Render "sf_app_dir/modules/offres/templates/_searchBar.php"
134	main	Call "pub->executeLeaderboard()"
135	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
136	main	Call "page->executeMenu()"
137	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_gauche)
138	sfPartialView	Render "sf_app_dir/modules/page/templates/_menu.php"
139	main	Call "page->executeMenu()"
140	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_milieu)
141	sfPartialView	Render "sf_app_dir/modules/page/templates/_menu.php"
142	main	Call "page->executeMenu()"
143	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.afficher = ? AND p.website_id = ? AND p.ou = ?) ORDER BY p.ordre ASC - (fr, 1, 1, bas_droite)
144	sfPartialView	Render "sf_app_dir/modules/page/templates/_menu.php"
145	main	Call "page->executeAnalytics()"
146	Doctrine_Connection_Statement	execute : SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = ?) LIMIT 1 - (1)
147	sfPartialView	Render "sf_app_dir/modules/page/templates/_analytics.php"
148	sfWebResponse	Send status "HTTP/1.1 200 OK"
149	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	41	512.28	59
Factories	1	274.52	31
Database (Doctrine)	110	0.04	0
Action "page/homepage"	1	14.60	1
View "Success" for "page/homepage"	1	294.89	34
Component "pub/dfpBodyTag"	1	1.01	0
Component "page/title"	1	0.93	0
Partial "page/_title"	1	0.11	0
Component "pub/dfpHeadTag"	1	0.95	0
Component "page/facebookInitScript"	1	0.93	0
Partial "page/_facebookInitScript"	1	0.12	0
Component "page/menu"	5	7.74	0
Partial "page/_menu"	5	4.75	0
Component "page/socialIcons"	1	0.94	0
Partial "page/_socialIcons"	1	0.19	0
Component "page/carrousel"	1	1.04	0
Partial "page/_carrousel"	1	0.28	0
Component "page/sousMenu"	1	0.01	0
Partial "page/_sousMenu"	1	0.09	0
Component "offres/searchBar"	1	1.12	0
Partial "offres/_searchBar"	1	0.23	0
Component "pub/leaderboard"	1	0.96	0
Component "page/analytics"	1	1.01	0
Partial "page/_analytics"	1	0.10	0

Doctrine Version: 1.2.4

SET NAMES 'UTF8'

0.00s, "doctrine" connection
SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.domain = 'emploisprofessionnelsensante.com') LIMIT 1

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT s.id AS s__id, s2.id AS s2__id, s2.lang AS s2__lang, s2.nom AS s2__nom FROM specialite s LEFT JOIN specialite_translation s2 ON s.id = s2.id LEFT JOIN website_specialite w ON s.id = w.specialite_id WHERE (s2.lang = 'fr' AND w.website_id = '1') ORDER BY s2.nom ASC

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.nom AS c__nom, c.company_profile_id AS c__company_profile_id, c.company_sector_id AS c__company_sector_id, c.methode_facturation AS c__methode_facturation, c.methode_candidature AS c__methode_candidature, c.logo AS c__logo, c.pays AS c__pays, c.adresse1 AS c__adresse1, c.adresse2 AS c__adresse2, c.ville AS c__ville, c.province_id AS c__province_id, c.region_id AS c__region_id, c.codepostal AS c__codepostal, c.latitude AS c__latitude, c.longitude AS c__longitude, c.siteweb AS c__siteweb, c.email AS c__email, c.tel AS c__tel, c.tel_ext AS c__tel_ext, c.fax AS c__fax, c.user_id AS c__user_id, c.featured AS c__featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.website_id AS c2__website_id, c2.company_id AS c2__company_id, c2.show_on_homepage AS c2__show_on_homepage, c2.video AS c2__video, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at FROM company c LEFT JOIN company_portail c2 ON c.id = c2.company_id WHERE (c2.website_id = '1' AND c2.show_on_homepage = 1)

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND LOWER(p2.titre) LIKE '%accueil%' AND p.website_id = '1')

0.00s, "doctrine" connection
SELECT w.website_id AS w__website_id, w.specialite_id AS w__specialite_id FROM website_specialite w WHERE (w.website_id IN ('1'))

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o INNER JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON (o.id = o3.offre_id) INNER JOIN specialite s ON s.id = o3.specialite_id INNER JOIN specialite_translation s2 ON s.id = s2.id INNER JOIN company c ON o.company_id = c.id INNER JOIN company_portail c2 ON c.id = c2.company_id WHERE s2.lang = 'fr' AND s.id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND c2.website_id = '1' AND o.actif = 1 GROUP BY o.id) dctrn_count_query

0.06s, "doctrine" connection
SELECT w.id AS w__id, w.titre AS w__titre, w.video_employeur AS w__video_employeur, w.video_candidat AS w__video_candidat, w.meta_title AS w__meta_title, w.meta_description AS w__meta_description, w.meta_keywords AS w__meta_keywords, w.id_analytics AS w__id_analytics, w.titre_section_tendances AS w__titre_section_tendances, w.lang AS w__lang FROM website_translation w WHERE (w.id IN ('1'))

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '689' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '657' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23617' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '71' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '38' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '10' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '7' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '44' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '43' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '918' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '11' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '374' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '683' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '37' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23634' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '415' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '1043' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '28' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '25' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '41' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '16' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '32' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '693' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '39' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23645' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '6' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '36' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '295' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '402' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '887' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '85' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23646' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '1079' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '30' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '707' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '15' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '878' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '1085' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '806' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '19' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '2' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '17' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '160' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '924' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '21' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '20' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '23640' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '27' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '42' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '925' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '990' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '5' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '710' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '29' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '706' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '45' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '4' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '500' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '31' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.01s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '40' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '9' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '1194' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '22' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id LEFT JOIN company c ON o.company_id = c.id LEFT JOIN company_portail c2 ON c.id = c2.company_id LEFT JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o3.specialite_id = '1084' AND LENGTH(o2.titre) > 0 AND o.actif = 1 AND c2.website_id = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '23' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '834' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '2964' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '2431' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '1862' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '732' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '3462' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '4528' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.01s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '5012' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '2287' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT o.id FROM offre o LEFT JOIN offre_translation o2 ON o.id = o2.id INNER JOIN offre_specialite o3 ON o.id = o3.offre_id WHERE o2.lang = 'fr' AND o.company_id = '5269' AND o3.specialite_id IN ('1', '2', '4', '5', '6', '7', '8', '9', '10', '11', '12', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '27', '28', '29', '30', '31', '32', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '71', '85', '160', '295', '374', '402', '415', '421', '500', '592', '612', '614', '657', '669', '683', '689', '690', '693', '706', '707', '710', '806', '820', '878', '886', '887', '918', '924', '925', '990', '1043', '1079', '1084', '1085', '1194', '23617', '23634', '23640', '23645', '23646') AND o2.titre != '' AND o.actif = '1' GROUP BY o.id) dctrn_count_query

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'haut') ORDER BY p.ordre ASC

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.carrousel_id AS w__carrousel_id, w.website_id AS w__website_id, w.target_url AS w__target_url, w.views AS w__views, w.published AS w__published, c.id AS c__id, c.ordre AS c__ordre, c.image AS c__image FROM website_carrousel w LEFT JOIN carrousel c ON w.carrousel_id = c.id WHERE (w.website_id = '1' AND w.published = 1 AND c.id IS NOT NULL) ORDER BY c.ordre ASC

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'navigation_principale') ORDER BY p.ordre ASC

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_gauche') ORDER BY p.ordre ASC

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_milieu') ORDER BY p.ordre ASC

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.website_id AS p__website_id, p.ordre AS p__ordre, p.afficher AS p__afficher, p.ou AS p__ou, p2.id AS p2__id, p2.titre AS p2__titre, p2.contenu AS p2__contenu, p2.meta_title AS p2__meta_title, p2.meta_description AS p2__meta_description, p2.meta_keywords AS p2__meta_keywords, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p2.lang = 'fr' AND p.afficher = '1' AND p.website_id = '1' AND p.ou = 'bas_droite') ORDER BY p.ordre ASC

0.00s, "doctrine" connection
SELECT w.id AS w__id, w.short_code AS w__short_code, w.domain AS w__domain, w.domain_en AS w__domain_en, w.social_fb_url AS w__social_fb_url, w.social_fb_app_id AS w__social_fb_app_id, w.social_tw_username AS w__social_tw_username, w.social_tw_widget_id AS w__social_tw_widget_id, w.social_in_url AS w__social_in_url, w.social_gg_url AS w__social_gg_url, w.social_yt_url AS w__social_yt_url, w.couverture_tendances AS w__couverture_tendances, w.dfp_tag_home_head AS w__dfp_tag_home_head, w.dfp_tag_home_body AS w__dfp_tag_home_body, w.dfp_tag_t_liste_head AS w__dfp_tag_t_liste_head, w.dfp_tag_t_liste_body AS w__dfp_tag_t_liste_body, w.dfp_tag_t_details_head AS w__dfp_tag_t_details_head, w.dfp_tag_t_details_body AS w__dfp_tag_t_details_body, w.dfp_tag_emp_banneer_head AS w__dfp_tag_emp_banneer_head, w.dfp_tag_emp_banneer_body AS w__dfp_tag_emp_banneer_body, w.dfp_tag_emp_sidebar_head AS w__dfp_tag_emp_sidebar_head, w.dfp_tag_emp_sidebar_body AS w__dfp_tag_emp_sidebar_body, w.dfp_tag_eta_banneer_head AS w__dfp_tag_eta_banneer_head, w.dfp_tag_eta_banneer_body AS w__dfp_tag_eta_banneer_body, w.dfp_tag_eta_sidebar_head AS w__dfp_tag_eta_sidebar_head, w.dfp_tag_eta_sidebar_body AS w__dfp_tag_eta_sidebar_body FROM website w WHERE (w.id = '1') LIMIT 1

0.00s, "doctrine" connection

Vous recrutez ?

706 offres d'emploi en santé dans 65 spécialités

Candidats

Recruteurs

Techno-Communication

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: page … homepageSuccess.php

Partial: page … _title.php

Partial: page … _facebookInitScript.php

Partial: page … _menu.php

Partial: page … _socialIcons.php

Partial: page … _carrousel.php

Partial: page … _menu.php

Partial: page … _sousMenu.php

Partial: offres … _searchBar.php

Partial: page … _menu.php

Partial: page … _menu.php

Partial: page … _menu.php

Partial: page … _analytics.php

Logs

Timers

SQL queries

Doctrine Version: 1.2.4

Vous recrutez ?

Trouvez un emploi

706 offres d'emploi en santé dans 65 spécialités

Candidats

Recruteurs

Techno-Communication

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: page … homepageSuccess.php

Partial: page … _title.php

Partial: page … _facebookInitScript.php

Partial: page … _menu.php

Partial: page … _socialIcons.php

Partial: page … _carrousel.php

Partial: page … _menu.php

Partial: page … _sousMenu.php

Partial: offres … _searchBar.php

Partial: page … _menu.php

Partial: page … _menu.php

Partial: page … _menu.php

Partial: page … _analytics.php

Logs

Timers

SQL queries

Doctrine Version: 1.2.4