Errors

Notice (8): Array to string conversion [APP/Controller/AgregatsController.php, line 190]

                $ville_id = $this->request['named']['ville'];    

                        

                $conditions .= ' AND Ville.slug = "'.$ville_id.'"';

$id = '4'
$slug = 'maisons-de-retraite-ehpad-ehpa'
$dep = 'www.santeenfrance.fr'
$tri = 'annuaire'
$d = array(
	'departements' => array(
		(int) 0 => 'Tous les départements',
		'01' => '01 - Ain',
		'02' => '02 - Aisne',
		'03' => '03 - Allier',
		'04' => '04 - Alpes-de-Haute-Provence',
		'05' => '05 - Hautes-Alpes',
		'06' => '06 - Alpes-Maritimes',
		'07' => '07 - Ardèche',
		'08' => '08 - Ardennes',
		'09' => '09 - Ariège',
		(int) 10 => '10 - Aube',
		(int) 11 => '11 - Aude',
		(int) 12 => '12 - Aveyron',
		(int) 13 => '13 - Bouches-du-Rhône',
		(int) 14 => '14 - Calvados',
		(int) 15 => '15 - Cantal',
		(int) 16 => '16 - Charente',
		(int) 17 => '17 - Charente-Maritime',
		(int) 18 => '18 - Cher',
		(int) 19 => '19 - Corrèze',
		(int) 21 => '21 - Côte-d'or',
		(int) 22 => '22 - Côtes-d'armor',
		(int) 23 => '23 - Creuse',
		(int) 24 => '24 - Dordogne',
		(int) 25 => '25 - Doubs',
		(int) 26 => '26 - Drôme',
		(int) 27 => '27 - Eure',
		(int) 28 => '28 - Eure-et-Loir',
		(int) 29 => '29 - Finistère',
		'2A' => '2A - Corse-du-sud',
		'2B' => '2B - Haute-corse',
		(int) 30 => '30 - Gard',
		(int) 31 => '31 - Haute-Garonne',
		(int) 32 => '32 - Gers',
		(int) 33 => '33 - Gironde',
		(int) 34 => '34 - Hérault',
		(int) 35 => '35 - Ille-et-Vilaine',
		(int) 36 => '36 - Indre',
		(int) 37 => '37 - Indre-et-Loire',
		(int) 38 => '38 - Isère',
		(int) 39 => '39 - Jura',
		(int) 40 => '40 - Landes',
		(int) 41 => '41 - Loir-et-Cher',
		(int) 42 => '42 - Loire',
		(int) 43 => '43 - Haute-Loire',
		(int) 44 => '44 - Loire-Atlantique',
		(int) 45 => '45 - Loiret',
		(int) 46 => '46 - Lot',
		(int) 47 => '47 - Lot-et-Garonne',
		(int) 48 => '48 - Lozère',
		(int) 49 => '49 - Maine-et-Loire',
		(int) 50 => '50 - Manche',
		(int) 51 => '51 - Marne',
		(int) 52 => '52 - Haute-Marne',
		(int) 53 => '53 - Mayenne',
		(int) 54 => '54 - Meurthe-et-Moselle',
		(int) 55 => '55 - Meuse',
		(int) 56 => '56 - Morbihan',
		(int) 57 => '57 - Moselle',
		(int) 58 => '58 - Nièvre',
		(int) 59 => '59 - Nord',
		(int) 60 => '60 - Oise',
		(int) 61 => '61 - Orne',
		(int) 62 => '62 - Pas-de-Calais',
		(int) 63 => '63 - Puy-de-Dôme',
		(int) 64 => '64 - Pyrénées-Atlantiques',
		(int) 65 => '65 - Hautes-Pyrénées',
		(int) 66 => '66 - Pyrénées-Orientales',
		(int) 67 => '67 - Bas-Rhin',
		(int) 68 => '68 - Haut-Rhin',
		(int) 69 => '69 - Rhône',
		(int) 70 => '70 - Haute-Saône',
		(int) 71 => '71 - Saône-et-Loire',
		(int) 72 => '72 - Sarthe',
		(int) 73 => '73 - Savoie',
		(int) 74 => '74 - Haute-Savoie',
		(int) 75 => '75 - Paris',
		(int) 76 => '76 - Seine-Maritime',
		(int) 77 => '77 - Seine-et-Marne',
		(int) 78 => '78 - Yvelines',
		(int) 79 => '79 - Deux-Sèvres',
		(int) 80 => '80 - Somme',
		(int) 81 => '81 - Tarn',
		(int) 82 => '82 - Tarn-et-Garonne',
		(int) 83 => '83 - Var',
		(int) 84 => '84 - Vaucluse',
		(int) 85 => '85 - Vendée',
		(int) 86 => '86 - Vienne',
		(int) 87 => '87 - Haute-Vienne',
		(int) 88 => '88 - Vosges',
		(int) 89 => '89 - Yonne',
		(int) 90 => '90 - Territoire de Belfort',
		(int) 91 => '91 - Essonne',
		(int) 92 => '92 - Hauts-de-Seine',
		(int) 93 => '93 - Seine-Saint-Denis',
		(int) 94 => '94 - Val-de-Marne',
		(int) 95 => '95 - Val-d'oise',
		(int) 971 => '971 - Guadeloupe',
		(int) 972 => '972 - Martinique',
		(int) 973 => '973 - Guyane',
		(int) 974 => '974 - Réunion',
		(int) 975 => '975 - Saint Pierre et Miquelon',
		(int) 976 => '976 - Mayotte'
	),
	'dep' => array(
		(int) 0 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 46 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 47 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 48 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 49 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 50 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 51 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 52 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 53 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 54 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 55 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 56 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 57 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 58 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 59 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 60 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 61 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 62 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 63 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 64 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 65 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 66 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 67 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 68 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 69 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 70 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 71 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 72 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 73 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 74 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 75 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 76 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 77 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 78 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 79 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 80 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 81 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 82 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 83 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 84 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 85 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 86 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 87 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 88 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 89 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 90 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 91 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 92 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 93 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 94 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 95 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 96 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 97 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 98 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 99 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 100 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 101 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		)
	),
	'regions' => array(
		(int) 1 => 'Aquitaine',
		(int) 2 => 'Auvergne',
		(int) 3 => 'Bourgogne',
		(int) 4 => 'Bretagne',
		(int) 5 => 'Centre',
		(int) 6 => 'Champagne Ardenne',
		(int) 7 => 'Corse',
		(int) 8 => 'DOM/TOM',
		(int) 9 => 'Franche Comté',
		(int) 10 => 'Ile de France',
		(int) 11 => 'Languedoc Roussillon',
		(int) 12 => 'Limousin',
		(int) 13 => 'Lorraine',
		(int) 14 => 'Midi Pyrénées',
		(int) 15 => 'Nord Pas de Calais',
		(int) 17 => 'Haute Normandie ',
		(int) 18 => 'Pays de la Loire',
		(int) 19 => 'Picardie',
		(int) 20 => 'Poitou Charentes',
		(int) 21 => 'Provence Alpes Côte d'azur',
		(int) 22 => 'Rhône Alpes',
		(int) 23 => 'Alsace',
		(int) 24 => 'Basse-Normandie'
	),
	'departements2' => array(
		'Aquitaine' => array(
			(int) 24 => 'Dordogne',
			(int) 33 => 'Gironde',
			(int) 40 => 'Landes',
			(int) 47 => 'Lot-et-Garonne',
			(int) 64 => 'Pyrénées-Atlantiques'
		),
		'Auvergne' => array(
			'03' => 'Allier',
			(int) 15 => 'Cantal',
			(int) 43 => 'Haute-Loire',
			(int) 63 => 'Puy-de-Dôme'
		),
		'Bourgogne' => array(
			(int) 21 => 'Côte-d'or',
			(int) 58 => 'Nièvre',
			(int) 71 => 'Saône-et-Loire',
			(int) 89 => 'Yonne'
		),
		'Bretagne' => array(
			(int) 22 => 'Côtes-d'armor',
			(int) 29 => 'Finistère',
			(int) 35 => 'Ille-et-Vilaine',
			(int) 56 => 'Morbihan'
		),
		'Centre' => array(
			(int) 18 => 'Cher',
			(int) 28 => 'Eure-et-Loir',
			(int) 36 => 'Indre',
			(int) 37 => 'Indre-et-Loire',
			(int) 41 => 'Loir-et-Cher',
			(int) 45 => 'Loiret'
		),
		'Champagne Ardenne' => array(
			'08' => 'Ardennes',
			(int) 10 => 'Aube',
			(int) 51 => 'Marne',
			(int) 52 => 'Haute-Marne'
		),
		'Corse' => array(
			'2A' => 'Corse-du-sud',
			'2B' => 'Haute-corse'
		),
		'DOM/TOM' => array(
			(int) 976 => 'Mayotte',
			(int) 971 => 'Guadeloupe',
			(int) 973 => 'Guyane',
			(int) 972 => 'Martinique',
			(int) 974 => 'Réunion'
		),
		'Franche Comté' => array(
			(int) 25 => 'Doubs',
			(int) 39 => 'Jura',
			(int) 70 => 'Haute-Saône',
			(int) 90 => 'Territoire de Belfort'
		),
		'Ile de France' => array(
			(int) 75 => 'Paris',
			(int) 77 => 'Seine-et-Marne',
			(int) 78 => 'Yvelines',
			(int) 91 => 'Essonne',
			(int) 92 => 'Hauts-de-Seine',
			(int) 93 => 'Seine-Saint-Denis',
			(int) 94 => 'Val-de-Marne',
			(int) 95 => 'Val-d'oise'
		),
		'Languedoc Roussillon' => array(
			(int) 11 => 'Aude',
			(int) 30 => 'Gard',
			(int) 34 => 'Hérault',
			(int) 48 => 'Lozère',
			(int) 66 => 'Pyrénées-Orientales'
		),
		'Limousin' => array(
			(int) 19 => 'Corrèze',
			(int) 23 => 'Creuse',
			(int) 87 => 'Haute-Vienne'
		),
		'Lorraine' => array(
			(int) 54 => 'Meurthe-et-Moselle',
			(int) 55 => 'Meuse',
			(int) 57 => 'Moselle',
			(int) 88 => 'Vosges'
		),
		'Midi Pyrénées' => array(
			'09' => 'Ariège',
			(int) 12 => 'Aveyron',
			(int) 31 => 'Haute-Garonne',
			(int) 32 => 'Gers',
			(int) 46 => 'Lot',
			(int) 65 => 'Hautes-Pyrénées',
			(int) 81 => 'Tarn',
			(int) 82 => 'Tarn-et-Garonne'
		),
		'Nord Pas de Calais' => array(
			(int) 59 => 'Nord',
			(int) 62 => 'Pas-de-Calais'
		),
		'Haute Normandie ' => array(
			(int) 27 => 'Eure',
			(int) 76 => 'Seine-Maritime'
		),
		'Pays de la Loire' => array(
			(int) 44 => 'Loire-Atlantique',
			(int) 49 => 'Maine-et-Loire',
			(int) 53 => 'Mayenne',
			(int) 72 => 'Sarthe',
			(int) 85 => 'Vendée'
		),
		'Picardie' => array(
			'02' => 'Aisne',
			(int) 60 => 'Oise',
			(int) 80 => 'Somme'
		),
		'Poitou Charentes' => array(
			(int) 16 => 'Charente',
			(int) 17 => 'Charente-Maritime',
			(int) 79 => 'Deux-Sèvres',
			(int) 86 => 'Vienne'
		),
		'Provence Alpes Côte d'azur' => array(
			'04' => 'Alpes-de-Haute-Provence',
			'05' => 'Hautes-Alpes',
			'06' => 'Alpes-Maritimes',
			(int) 13 => 'Bouches-du-Rhône',
			(int) 83 => 'Var',
			(int) 84 => 'Vaucluse'
		),
		'Rhône Alpes' => array(
			'01' => 'Ain',
			'07' => 'Ardèche',
			(int) 26 => 'Drôme',
			(int) 38 => 'Isère',
			(int) 42 => 'Loire',
			(int) 69 => 'Rhône',
			(int) 73 => 'Savoie',
			(int) 74 => 'Haute-Savoie'
		),
		'Alsace' => array(
			(int) 67 => 'Bas-Rhin',
			(int) 68 => 'Haut-Rhin'
		),
		'Basse-Normandie' => array(
			(int) 14 => 'Calvados',
			(int) 50 => 'Manche',
			(int) 61 => 'Orne'
		)
	)
)
$k = (int) 24
$v = 'Basse-Normandie'
$deps = array(
	(int) 14 => 'Calvados',
	(int) 50 => 'Manche',
	(int) 61 => 'Orne'
)
$i = (int) 101
$r = array(
	'id' => '102',
	'code' => '975',
	'nom' => 'Saint Pierre et Miquelon',
	'nom_uppercase' => 'ST PIERRE ET MIQUELON',
	'slug' => 'saint-pierre-et-miquelon',
	'nom_soundex' => null,
	'region_id' => '0',
	'view' => '917',
	'presentation' => '',
	'lib' => '975 - Saint Pierre et Miquelon'
)
$ttPartners = (int) 0
$conditions = 'Etablissement.agregat_id = 4'
$joins = array(
	(int) 0 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$title_dep = ''
$baliseTitle_dep = ''
$title_tri = ''
$ville_id = array(
	(int) 0 => 'montelimarhttps:',
	(int) 1 => 'montelimar'
)

AgregatsController::index() - APP/Controller/AgregatsController.php, line 190
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 112

Notice (8): Array to string conversion [APP/Controller/AgregatsController.php, line 192]

Code Context

                $conditions .= ' AND Ville.slug = "'.$ville_id.'"';

                $this->loadModel('Ville');

                $maville = current($this->Ville->find('first', array('conditions'=>'slug = "'.$ville_id.'"')));

$id = '4'
$slug = 'maisons-de-retraite-ehpad-ehpa'
$dep = 'www.santeenfrance.fr'
$tri = 'annuaire'
$d = array(
	'departements' => array(
		(int) 0 => 'Tous les départements',
		'01' => '01 - Ain',
		'02' => '02 - Aisne',
		'03' => '03 - Allier',
		'04' => '04 - Alpes-de-Haute-Provence',
		'05' => '05 - Hautes-Alpes',
		'06' => '06 - Alpes-Maritimes',
		'07' => '07 - Ardèche',
		'08' => '08 - Ardennes',
		'09' => '09 - Ariège',
		(int) 10 => '10 - Aube',
		(int) 11 => '11 - Aude',
		(int) 12 => '12 - Aveyron',
		(int) 13 => '13 - Bouches-du-Rhône',
		(int) 14 => '14 - Calvados',
		(int) 15 => '15 - Cantal',
		(int) 16 => '16 - Charente',
		(int) 17 => '17 - Charente-Maritime',
		(int) 18 => '18 - Cher',
		(int) 19 => '19 - Corrèze',
		(int) 21 => '21 - Côte-d'or',
		(int) 22 => '22 - Côtes-d'armor',
		(int) 23 => '23 - Creuse',
		(int) 24 => '24 - Dordogne',
		(int) 25 => '25 - Doubs',
		(int) 26 => '26 - Drôme',
		(int) 27 => '27 - Eure',
		(int) 28 => '28 - Eure-et-Loir',
		(int) 29 => '29 - Finistère',
		'2A' => '2A - Corse-du-sud',
		'2B' => '2B - Haute-corse',
		(int) 30 => '30 - Gard',
		(int) 31 => '31 - Haute-Garonne',
		(int) 32 => '32 - Gers',
		(int) 33 => '33 - Gironde',
		(int) 34 => '34 - Hérault',
		(int) 35 => '35 - Ille-et-Vilaine',
		(int) 36 => '36 - Indre',
		(int) 37 => '37 - Indre-et-Loire',
		(int) 38 => '38 - Isère',
		(int) 39 => '39 - Jura',
		(int) 40 => '40 - Landes',
		(int) 41 => '41 - Loir-et-Cher',
		(int) 42 => '42 - Loire',
		(int) 43 => '43 - Haute-Loire',
		(int) 44 => '44 - Loire-Atlantique',
		(int) 45 => '45 - Loiret',
		(int) 46 => '46 - Lot',
		(int) 47 => '47 - Lot-et-Garonne',
		(int) 48 => '48 - Lozère',
		(int) 49 => '49 - Maine-et-Loire',
		(int) 50 => '50 - Manche',
		(int) 51 => '51 - Marne',
		(int) 52 => '52 - Haute-Marne',
		(int) 53 => '53 - Mayenne',
		(int) 54 => '54 - Meurthe-et-Moselle',
		(int) 55 => '55 - Meuse',
		(int) 56 => '56 - Morbihan',
		(int) 57 => '57 - Moselle',
		(int) 58 => '58 - Nièvre',
		(int) 59 => '59 - Nord',
		(int) 60 => '60 - Oise',
		(int) 61 => '61 - Orne',
		(int) 62 => '62 - Pas-de-Calais',
		(int) 63 => '63 - Puy-de-Dôme',
		(int) 64 => '64 - Pyrénées-Atlantiques',
		(int) 65 => '65 - Hautes-Pyrénées',
		(int) 66 => '66 - Pyrénées-Orientales',
		(int) 67 => '67 - Bas-Rhin',
		(int) 68 => '68 - Haut-Rhin',
		(int) 69 => '69 - Rhône',
		(int) 70 => '70 - Haute-Saône',
		(int) 71 => '71 - Saône-et-Loire',
		(int) 72 => '72 - Sarthe',
		(int) 73 => '73 - Savoie',
		(int) 74 => '74 - Haute-Savoie',
		(int) 75 => '75 - Paris',
		(int) 76 => '76 - Seine-Maritime',
		(int) 77 => '77 - Seine-et-Marne',
		(int) 78 => '78 - Yvelines',
		(int) 79 => '79 - Deux-Sèvres',
		(int) 80 => '80 - Somme',
		(int) 81 => '81 - Tarn',
		(int) 82 => '82 - Tarn-et-Garonne',
		(int) 83 => '83 - Var',
		(int) 84 => '84 - Vaucluse',
		(int) 85 => '85 - Vendée',
		(int) 86 => '86 - Vienne',
		(int) 87 => '87 - Haute-Vienne',
		(int) 88 => '88 - Vosges',
		(int) 89 => '89 - Yonne',
		(int) 90 => '90 - Territoire de Belfort',
		(int) 91 => '91 - Essonne',
		(int) 92 => '92 - Hauts-de-Seine',
		(int) 93 => '93 - Seine-Saint-Denis',
		(int) 94 => '94 - Val-de-Marne',
		(int) 95 => '95 - Val-d'oise',
		(int) 971 => '971 - Guadeloupe',
		(int) 972 => '972 - Martinique',
		(int) 973 => '973 - Guyane',
		(int) 974 => '974 - Réunion',
		(int) 975 => '975 - Saint Pierre et Miquelon',
		(int) 976 => '976 - Mayotte'
	),
	'dep' => array(
		(int) 0 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 46 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 47 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 48 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 49 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 50 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 51 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 52 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 53 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 54 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 55 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 56 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 57 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 58 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 59 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 60 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 61 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 62 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 63 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 64 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 65 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 66 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 67 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 68 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 69 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 70 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 71 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 72 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 73 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 74 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 75 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 76 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 77 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 78 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 79 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 80 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 81 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 82 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 83 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 84 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 85 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 86 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 87 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 88 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 89 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 90 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 91 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 92 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 93 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 94 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 95 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 96 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 97 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 98 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 99 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 100 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 101 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		)
	),
	'regions' => array(
		(int) 1 => 'Aquitaine',
		(int) 2 => 'Auvergne',
		(int) 3 => 'Bourgogne',
		(int) 4 => 'Bretagne',
		(int) 5 => 'Centre',
		(int) 6 => 'Champagne Ardenne',
		(int) 7 => 'Corse',
		(int) 8 => 'DOM/TOM',
		(int) 9 => 'Franche Comté',
		(int) 10 => 'Ile de France',
		(int) 11 => 'Languedoc Roussillon',
		(int) 12 => 'Limousin',
		(int) 13 => 'Lorraine',
		(int) 14 => 'Midi Pyrénées',
		(int) 15 => 'Nord Pas de Calais',
		(int) 17 => 'Haute Normandie ',
		(int) 18 => 'Pays de la Loire',
		(int) 19 => 'Picardie',
		(int) 20 => 'Poitou Charentes',
		(int) 21 => 'Provence Alpes Côte d'azur',
		(int) 22 => 'Rhône Alpes',
		(int) 23 => 'Alsace',
		(int) 24 => 'Basse-Normandie'
	),
	'departements2' => array(
		'Aquitaine' => array(
			(int) 24 => 'Dordogne',
			(int) 33 => 'Gironde',
			(int) 40 => 'Landes',
			(int) 47 => 'Lot-et-Garonne',
			(int) 64 => 'Pyrénées-Atlantiques'
		),
		'Auvergne' => array(
			'03' => 'Allier',
			(int) 15 => 'Cantal',
			(int) 43 => 'Haute-Loire',
			(int) 63 => 'Puy-de-Dôme'
		),
		'Bourgogne' => array(
			(int) 21 => 'Côte-d'or',
			(int) 58 => 'Nièvre',
			(int) 71 => 'Saône-et-Loire',
			(int) 89 => 'Yonne'
		),
		'Bretagne' => array(
			(int) 22 => 'Côtes-d'armor',
			(int) 29 => 'Finistère',
			(int) 35 => 'Ille-et-Vilaine',
			(int) 56 => 'Morbihan'
		),
		'Centre' => array(
			(int) 18 => 'Cher',
			(int) 28 => 'Eure-et-Loir',
			(int) 36 => 'Indre',
			(int) 37 => 'Indre-et-Loire',
			(int) 41 => 'Loir-et-Cher',
			(int) 45 => 'Loiret'
		),
		'Champagne Ardenne' => array(
			'08' => 'Ardennes',
			(int) 10 => 'Aube',
			(int) 51 => 'Marne',
			(int) 52 => 'Haute-Marne'
		),
		'Corse' => array(
			'2A' => 'Corse-du-sud',
			'2B' => 'Haute-corse'
		),
		'DOM/TOM' => array(
			(int) 976 => 'Mayotte',
			(int) 971 => 'Guadeloupe',
			(int) 973 => 'Guyane',
			(int) 972 => 'Martinique',
			(int) 974 => 'Réunion'
		),
		'Franche Comté' => array(
			(int) 25 => 'Doubs',
			(int) 39 => 'Jura',
			(int) 70 => 'Haute-Saône',
			(int) 90 => 'Territoire de Belfort'
		),
		'Ile de France' => array(
			(int) 75 => 'Paris',
			(int) 77 => 'Seine-et-Marne',
			(int) 78 => 'Yvelines',
			(int) 91 => 'Essonne',
			(int) 92 => 'Hauts-de-Seine',
			(int) 93 => 'Seine-Saint-Denis',
			(int) 94 => 'Val-de-Marne',
			(int) 95 => 'Val-d'oise'
		),
		'Languedoc Roussillon' => array(
			(int) 11 => 'Aude',
			(int) 30 => 'Gard',
			(int) 34 => 'Hérault',
			(int) 48 => 'Lozère',
			(int) 66 => 'Pyrénées-Orientales'
		),
		'Limousin' => array(
			(int) 19 => 'Corrèze',
			(int) 23 => 'Creuse',
			(int) 87 => 'Haute-Vienne'
		),
		'Lorraine' => array(
			(int) 54 => 'Meurthe-et-Moselle',
			(int) 55 => 'Meuse',
			(int) 57 => 'Moselle',
			(int) 88 => 'Vosges'
		),
		'Midi Pyrénées' => array(
			'09' => 'Ariège',
			(int) 12 => 'Aveyron',
			(int) 31 => 'Haute-Garonne',
			(int) 32 => 'Gers',
			(int) 46 => 'Lot',
			(int) 65 => 'Hautes-Pyrénées',
			(int) 81 => 'Tarn',
			(int) 82 => 'Tarn-et-Garonne'
		),
		'Nord Pas de Calais' => array(
			(int) 59 => 'Nord',
			(int) 62 => 'Pas-de-Calais'
		),
		'Haute Normandie ' => array(
			(int) 27 => 'Eure',
			(int) 76 => 'Seine-Maritime'
		),
		'Pays de la Loire' => array(
			(int) 44 => 'Loire-Atlantique',
			(int) 49 => 'Maine-et-Loire',
			(int) 53 => 'Mayenne',
			(int) 72 => 'Sarthe',
			(int) 85 => 'Vendée'
		),
		'Picardie' => array(
			'02' => 'Aisne',
			(int) 60 => 'Oise',
			(int) 80 => 'Somme'
		),
		'Poitou Charentes' => array(
			(int) 16 => 'Charente',
			(int) 17 => 'Charente-Maritime',
			(int) 79 => 'Deux-Sèvres',
			(int) 86 => 'Vienne'
		),
		'Provence Alpes Côte d'azur' => array(
			'04' => 'Alpes-de-Haute-Provence',
			'05' => 'Hautes-Alpes',
			'06' => 'Alpes-Maritimes',
			(int) 13 => 'Bouches-du-Rhône',
			(int) 83 => 'Var',
			(int) 84 => 'Vaucluse'
		),
		'Rhône Alpes' => array(
			'01' => 'Ain',
			'07' => 'Ardèche',
			(int) 26 => 'Drôme',
			(int) 38 => 'Isère',
			(int) 42 => 'Loire',
			(int) 69 => 'Rhône',
			(int) 73 => 'Savoie',
			(int) 74 => 'Haute-Savoie'
		),
		'Alsace' => array(
			(int) 67 => 'Bas-Rhin',
			(int) 68 => 'Haut-Rhin'
		),
		'Basse-Normandie' => array(
			(int) 14 => 'Calvados',
			(int) 50 => 'Manche',
			(int) 61 => 'Orne'
		)
	)
)
$k = (int) 24
$v = 'Basse-Normandie'
$deps = array(
	(int) 14 => 'Calvados',
	(int) 50 => 'Manche',
	(int) 61 => 'Orne'
)
$i = (int) 101
$r = array(
	'id' => '102',
	'code' => '975',
	'nom' => 'Saint Pierre et Miquelon',
	'nom_uppercase' => 'ST PIERRE ET MIQUELON',
	'slug' => 'saint-pierre-et-miquelon',
	'nom_soundex' => null,
	'region_id' => '0',
	'view' => '917',
	'presentation' => '',
	'lib' => '975 - Saint Pierre et Miquelon'
)
$ttPartners = (int) 0
$conditions = 'Etablissement.agregat_id = 4 AND Ville.slug = "Array"'
$joins = array(
	(int) 0 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$title_dep = ''
$baliseTitle_dep = ''
$title_tri = ''
$ville_id = array(
	(int) 0 => 'montelimarhttps:',
	(int) 1 => 'montelimar'
)

AgregatsController::index() - APP/Controller/AgregatsController.php, line 192
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 112

Notice (8): Array to string conversion [APP/Controller/AgregatsController.php, line 206]

Code Context

                'fields'     => 'Ville.nom,Ville.slug,'.$sql_distance,

                'joins'      => $joinsSim,

                'conditions' => 'Ville.slug != "'.$ville_id.'" AND agregat_id = '.$id.'',

$id = '4'
$slug = 'maisons-de-retraite-ehpad-ehpa'
$dep = 'www.santeenfrance.fr'
$tri = 'annuaire'
$d = array(
	'departements' => array(
		(int) 0 => 'Tous les départements',
		'01' => '01 - Ain',
		'02' => '02 - Aisne',
		'03' => '03 - Allier',
		'04' => '04 - Alpes-de-Haute-Provence',
		'05' => '05 - Hautes-Alpes',
		'06' => '06 - Alpes-Maritimes',
		'07' => '07 - Ardèche',
		'08' => '08 - Ardennes',
		'09' => '09 - Ariège',
		(int) 10 => '10 - Aube',
		(int) 11 => '11 - Aude',
		(int) 12 => '12 - Aveyron',
		(int) 13 => '13 - Bouches-du-Rhône',
		(int) 14 => '14 - Calvados',
		(int) 15 => '15 - Cantal',
		(int) 16 => '16 - Charente',
		(int) 17 => '17 - Charente-Maritime',
		(int) 18 => '18 - Cher',
		(int) 19 => '19 - Corrèze',
		(int) 21 => '21 - Côte-d'or',
		(int) 22 => '22 - Côtes-d'armor',
		(int) 23 => '23 - Creuse',
		(int) 24 => '24 - Dordogne',
		(int) 25 => '25 - Doubs',
		(int) 26 => '26 - Drôme',
		(int) 27 => '27 - Eure',
		(int) 28 => '28 - Eure-et-Loir',
		(int) 29 => '29 - Finistère',
		'2A' => '2A - Corse-du-sud',
		'2B' => '2B - Haute-corse',
		(int) 30 => '30 - Gard',
		(int) 31 => '31 - Haute-Garonne',
		(int) 32 => '32 - Gers',
		(int) 33 => '33 - Gironde',
		(int) 34 => '34 - Hérault',
		(int) 35 => '35 - Ille-et-Vilaine',
		(int) 36 => '36 - Indre',
		(int) 37 => '37 - Indre-et-Loire',
		(int) 38 => '38 - Isère',
		(int) 39 => '39 - Jura',
		(int) 40 => '40 - Landes',
		(int) 41 => '41 - Loir-et-Cher',
		(int) 42 => '42 - Loire',
		(int) 43 => '43 - Haute-Loire',
		(int) 44 => '44 - Loire-Atlantique',
		(int) 45 => '45 - Loiret',
		(int) 46 => '46 - Lot',
		(int) 47 => '47 - Lot-et-Garonne',
		(int) 48 => '48 - Lozère',
		(int) 49 => '49 - Maine-et-Loire',
		(int) 50 => '50 - Manche',
		(int) 51 => '51 - Marne',
		(int) 52 => '52 - Haute-Marne',
		(int) 53 => '53 - Mayenne',
		(int) 54 => '54 - Meurthe-et-Moselle',
		(int) 55 => '55 - Meuse',
		(int) 56 => '56 - Morbihan',
		(int) 57 => '57 - Moselle',
		(int) 58 => '58 - Nièvre',
		(int) 59 => '59 - Nord',
		(int) 60 => '60 - Oise',
		(int) 61 => '61 - Orne',
		(int) 62 => '62 - Pas-de-Calais',
		(int) 63 => '63 - Puy-de-Dôme',
		(int) 64 => '64 - Pyrénées-Atlantiques',
		(int) 65 => '65 - Hautes-Pyrénées',
		(int) 66 => '66 - Pyrénées-Orientales',
		(int) 67 => '67 - Bas-Rhin',
		(int) 68 => '68 - Haut-Rhin',
		(int) 69 => '69 - Rhône',
		(int) 70 => '70 - Haute-Saône',
		(int) 71 => '71 - Saône-et-Loire',
		(int) 72 => '72 - Sarthe',
		(int) 73 => '73 - Savoie',
		(int) 74 => '74 - Haute-Savoie',
		(int) 75 => '75 - Paris',
		(int) 76 => '76 - Seine-Maritime',
		(int) 77 => '77 - Seine-et-Marne',
		(int) 78 => '78 - Yvelines',
		(int) 79 => '79 - Deux-Sèvres',
		(int) 80 => '80 - Somme',
		(int) 81 => '81 - Tarn',
		(int) 82 => '82 - Tarn-et-Garonne',
		(int) 83 => '83 - Var',
		(int) 84 => '84 - Vaucluse',
		(int) 85 => '85 - Vendée',
		(int) 86 => '86 - Vienne',
		(int) 87 => '87 - Haute-Vienne',
		(int) 88 => '88 - Vosges',
		(int) 89 => '89 - Yonne',
		(int) 90 => '90 - Territoire de Belfort',
		(int) 91 => '91 - Essonne',
		(int) 92 => '92 - Hauts-de-Seine',
		(int) 93 => '93 - Seine-Saint-Denis',
		(int) 94 => '94 - Val-de-Marne',
		(int) 95 => '95 - Val-d'oise',
		(int) 971 => '971 - Guadeloupe',
		(int) 972 => '972 - Martinique',
		(int) 973 => '973 - Guyane',
		(int) 974 => '974 - Réunion',
		(int) 975 => '975 - Saint Pierre et Miquelon',
		(int) 976 => '976 - Mayotte'
	),
	'dep' => array(
		(int) 0 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 46 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 47 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 48 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 49 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 50 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 51 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 52 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 53 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 54 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 55 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 56 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 57 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 58 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 59 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 60 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 61 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 62 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 63 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 64 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 65 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 66 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 67 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 68 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 69 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 70 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 71 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 72 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 73 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 74 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 75 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 76 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 77 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 78 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 79 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 80 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 81 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 82 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 83 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 84 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 85 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 86 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 87 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 88 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 89 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 90 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 91 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 92 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 93 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 94 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 95 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 96 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 97 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 98 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 99 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 100 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		),
		(int) 101 => array(
			'Departement' => array(
				[maximum depth reached]
			)
		)
	),
	'regions' => array(
		(int) 1 => 'Aquitaine',
		(int) 2 => 'Auvergne',
		(int) 3 => 'Bourgogne',
		(int) 4 => 'Bretagne',
		(int) 5 => 'Centre',
		(int) 6 => 'Champagne Ardenne',
		(int) 7 => 'Corse',
		(int) 8 => 'DOM/TOM',
		(int) 9 => 'Franche Comté',
		(int) 10 => 'Ile de France',
		(int) 11 => 'Languedoc Roussillon',
		(int) 12 => 'Limousin',
		(int) 13 => 'Lorraine',
		(int) 14 => 'Midi Pyrénées',
		(int) 15 => 'Nord Pas de Calais',
		(int) 17 => 'Haute Normandie ',
		(int) 18 => 'Pays de la Loire',
		(int) 19 => 'Picardie',
		(int) 20 => 'Poitou Charentes',
		(int) 21 => 'Provence Alpes Côte d'azur',
		(int) 22 => 'Rhône Alpes',
		(int) 23 => 'Alsace',
		(int) 24 => 'Basse-Normandie'
	),
	'departements2' => array(
		'Aquitaine' => array(
			(int) 24 => 'Dordogne',
			(int) 33 => 'Gironde',
			(int) 40 => 'Landes',
			(int) 47 => 'Lot-et-Garonne',
			(int) 64 => 'Pyrénées-Atlantiques'
		),
		'Auvergne' => array(
			'03' => 'Allier',
			(int) 15 => 'Cantal',
			(int) 43 => 'Haute-Loire',
			(int) 63 => 'Puy-de-Dôme'
		),
		'Bourgogne' => array(
			(int) 21 => 'Côte-d'or',
			(int) 58 => 'Nièvre',
			(int) 71 => 'Saône-et-Loire',
			(int) 89 => 'Yonne'
		),
		'Bretagne' => array(
			(int) 22 => 'Côtes-d'armor',
			(int) 29 => 'Finistère',
			(int) 35 => 'Ille-et-Vilaine',
			(int) 56 => 'Morbihan'
		),
		'Centre' => array(
			(int) 18 => 'Cher',
			(int) 28 => 'Eure-et-Loir',
			(int) 36 => 'Indre',
			(int) 37 => 'Indre-et-Loire',
			(int) 41 => 'Loir-et-Cher',
			(int) 45 => 'Loiret'
		),
		'Champagne Ardenne' => array(
			'08' => 'Ardennes',
			(int) 10 => 'Aube',
			(int) 51 => 'Marne',
			(int) 52 => 'Haute-Marne'
		),
		'Corse' => array(
			'2A' => 'Corse-du-sud',
			'2B' => 'Haute-corse'
		),
		'DOM/TOM' => array(
			(int) 976 => 'Mayotte',
			(int) 971 => 'Guadeloupe',
			(int) 973 => 'Guyane',
			(int) 972 => 'Martinique',
			(int) 974 => 'Réunion'
		),
		'Franche Comté' => array(
			(int) 25 => 'Doubs',
			(int) 39 => 'Jura',
			(int) 70 => 'Haute-Saône',
			(int) 90 => 'Territoire de Belfort'
		),
		'Ile de France' => array(
			(int) 75 => 'Paris',
			(int) 77 => 'Seine-et-Marne',
			(int) 78 => 'Yvelines',
			(int) 91 => 'Essonne',
			(int) 92 => 'Hauts-de-Seine',
			(int) 93 => 'Seine-Saint-Denis',
			(int) 94 => 'Val-de-Marne',
			(int) 95 => 'Val-d'oise'
		),
		'Languedoc Roussillon' => array(
			(int) 11 => 'Aude',
			(int) 30 => 'Gard',
			(int) 34 => 'Hérault',
			(int) 48 => 'Lozère',
			(int) 66 => 'Pyrénées-Orientales'
		),
		'Limousin' => array(
			(int) 19 => 'Corrèze',
			(int) 23 => 'Creuse',
			(int) 87 => 'Haute-Vienne'
		),
		'Lorraine' => array(
			(int) 54 => 'Meurthe-et-Moselle',
			(int) 55 => 'Meuse',
			(int) 57 => 'Moselle',
			(int) 88 => 'Vosges'
		),
		'Midi Pyrénées' => array(
			'09' => 'Ariège',
			(int) 12 => 'Aveyron',
			(int) 31 => 'Haute-Garonne',
			(int) 32 => 'Gers',
			(int) 46 => 'Lot',
			(int) 65 => 'Hautes-Pyrénées',
			(int) 81 => 'Tarn',
			(int) 82 => 'Tarn-et-Garonne'
		),
		'Nord Pas de Calais' => array(
			(int) 59 => 'Nord',
			(int) 62 => 'Pas-de-Calais'
		),
		'Haute Normandie ' => array(
			(int) 27 => 'Eure',
			(int) 76 => 'Seine-Maritime'
		),
		'Pays de la Loire' => array(
			(int) 44 => 'Loire-Atlantique',
			(int) 49 => 'Maine-et-Loire',
			(int) 53 => 'Mayenne',
			(int) 72 => 'Sarthe',
			(int) 85 => 'Vendée'
		),
		'Picardie' => array(
			'02' => 'Aisne',
			(int) 60 => 'Oise',
			(int) 80 => 'Somme'
		),
		'Poitou Charentes' => array(
			(int) 16 => 'Charente',
			(int) 17 => 'Charente-Maritime',
			(int) 79 => 'Deux-Sèvres',
			(int) 86 => 'Vienne'
		),
		'Provence Alpes Côte d'azur' => array(
			'04' => 'Alpes-de-Haute-Provence',
			'05' => 'Hautes-Alpes',
			'06' => 'Alpes-Maritimes',
			(int) 13 => 'Bouches-du-Rhône',
			(int) 83 => 'Var',
			(int) 84 => 'Vaucluse'
		),
		'Rhône Alpes' => array(
			'01' => 'Ain',
			'07' => 'Ardèche',
			(int) 26 => 'Drôme',
			(int) 38 => 'Isère',
			(int) 42 => 'Loire',
			(int) 69 => 'Rhône',
			(int) 73 => 'Savoie',
			(int) 74 => 'Haute-Savoie'
		),
		'Alsace' => array(
			(int) 67 => 'Bas-Rhin',
			(int) 68 => 'Haut-Rhin'
		),
		'Basse-Normandie' => array(
			(int) 14 => 'Calvados',
			(int) 50 => 'Manche',
			(int) 61 => 'Orne'
		)
	)
)
$k = (int) 24
$v = 'Basse-Normandie'
$deps = array(
	(int) 14 => 'Calvados',
	(int) 50 => 'Manche',
	(int) 61 => 'Orne'
)
$i = (int) 101
$r = array(
	'id' => '102',
	'code' => '975',
	'nom' => 'Saint Pierre et Miquelon',
	'nom_uppercase' => 'ST PIERRE ET MIQUELON',
	'slug' => 'saint-pierre-et-miquelon',
	'nom_soundex' => null,
	'region_id' => '0',
	'view' => '917',
	'presentation' => '',
	'lib' => '975 - Saint Pierre et Miquelon'
)
$ttPartners = (int) 0
$conditions = 'Etablissement.agregat_id = 4 AND Ville.slug = "Array"'
$joins = array(
	(int) 0 => array(
		'table' => 'departements',
		'alias' => 'Departement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Departement.id = Ville.departement_id'
		)
	)
)
$title_dep = ''
$baliseTitle_dep = ''
$title_tri = ''
$ville_id = array(
	(int) 0 => 'montelimarhttps:',
	(int) 1 => 'montelimar'
)
$maville = false
$mondepart = false
$lat = null
$lng = null
$sql_distance = '(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance'
$joinsSim = array(
	(int) 0 => array(
		'table' => 'etablissements',
		'alias' => 'Etablissement',
		'type' => 'LEFT',
		'conditions' => array(
			(int) 0 => 'Etablissement.ville_id = Ville.id'
		)
	)
)

AgregatsController::index() - APP/Controller/AgregatsController.php, line 206
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 191
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 165
[main] - APP/webroot/index.php, line 112

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/clients/client2/web13/web/lib/Cake/Utility/Debugger.php:801) [CORE/Cake/Network/CakeResponse.php, line 448]

Code Context

                $name, $c['value'], $c['expire'], $c['path'],
                $c['domain'], $c['secure'], $c['httpOnly']
            );

$name = 'CakeCookie[autologin]'
$c = array(
	'name' => 'CakeCookie[autologin]',
	'value' => '',
	'expire' => (int) 1714220635,
	'path' => '/',
	'domain' => '',
	'secure' => false,
	'httpOnly' => false
)

setcookie - [internal], line ??
CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 448
CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 418
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 280
ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 267
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 176
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 119
[main] - [internal], line ??

Database Error

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/1' at line 1

SQL Query: SELECT `Ville`.`nom`, `Ville`.`slug`, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `c2_sef_db`.`villes` AS `Ville` LEFT JOIN `c2_sef_db`.`etablissements` AS `Etablissement` ON (`Etablissement`.`ville_id` = `Ville`.`id`) WHERE `Ville`.`slug` != "Array" AND agregat_id = 4 GROUP BY `Ville`.`id` HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1 ORDER BY `distance` ASC LIMIT 7

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 458 → PDOStatement->execute(array)

        try {
            $query = $this->_connection->prepare($sql, $prepareOptions);
            $query->setFetchMode(PDO::FETCH_LAZY);
            if (!$query->execute($params)) {
                $this->_results = $query;

array()

CORE/Cake/Model/Datasource/DboSource.php line 424 → DboSource->_execute(string, array)

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

'SELECT `Ville`.`nom`, `Ville`.`slug`, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `c2_sef_db`.`villes` AS `Ville` LEFT JOIN `c2_sef_db`.`etablissements` AS `Etablissement` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE `Ville`.`slug` != "Array" AND agregat_id = 4  GROUP BY `Ville`.`id` HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1  ORDER BY `distance` ASC  LIMIT 7'
array()

CORE/Cake/Model/Datasource/DboSource.php line 666 → DboSource->execute(string, array, array)

        if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
            return $cached;
        }
        $result = $this->execute($sql, array(), $params);
        if ($result) {

'SELECT `Ville`.`nom`, `Ville`.`slug`, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `c2_sef_db`.`villes` AS `Ville` LEFT JOIN `c2_sef_db`.`etablissements` AS `Etablissement` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE `Ville`.`slug` != "Array" AND agregat_id = 4  GROUP BY `Ville`.`id` HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1  ORDER BY `distance` ASC  LIMIT 7'
array()
array()

CORE/Cake/Model/Datasource/DboSource.php line 1106 → DboSource->fetchAll(string, boolean)

        // Build SQL statement with the primary model, plus hasOne and belongsTo associations
        $query = $this->buildAssociationQuery($Model, $queryData);

        $resultSet = $this->fetchAll($query, $Model->cacheQueries);
        unset($query);

'SELECT `Ville`.`nom`, `Ville`.`slug`, (((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance FROM `c2_sef_db`.`villes` AS `Ville` LEFT JOIN `c2_sef_db`.`etablissements` AS `Etablissement` ON (`Etablissement`.`ville_id` = `Ville`.`id`)  WHERE `Ville`.`slug` != "Array" AND agregat_id = 4  GROUP BY `Ville`.`id` HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1  ORDER BY `distance` ASC  LIMIT 7'
false

CORE/Cake/Model/Model.php line 2947 → DboSource->read(Ville, array)

 * @return array
 */
    protected function _readDataSource($type, $query) {
        $results = $this->getDataSource()->read($this, $query);
        $this->resetAssociations();

object(Ville) {
	belongsTo => array(
		[maximum depth reached]
	)
	hasMany => array(
		[maximum depth reached]
	)
	validate => array(
		[maximum depth reached]
	)
	recursive => (int) -1
	actsAs => array(
		[maximum depth reached]
	)
	useDbConfig => 'default'
	useTable => 'villes'
	id => false
	data => array([maximum depth reached])
	schemaName => 'c2_sef_db'
	table => 'villes'
	primaryKey => 'id'
	validationErrors => array([maximum depth reached])
	validationDomain => null
	tablePrefix => ''
	plugin => null
	name => 'Ville'
	alias => 'Ville'
	tableToModel => array(
		[maximum depth reached]
	)
	cacheQueries => false
	hasOne => array([maximum depth reached])
	hasAndBelongsToMany => array([maximum depth reached])
	Behaviors => object(BehaviorCollection) {}
	whitelist => array([maximum depth reached])
	cacheSources => true
	findQueryType => 'all'
	order => null
	virtualFields => array([maximum depth reached])
	__backAssociation => array([maximum depth reached])
	__backInnerAssociation => array([maximum depth reached])
	__backOriginalAssociation => array([maximum depth reached])
	__backContainableAssociation => array([maximum depth reached])
	__safeUpdateMode => false
	findMethods => array(
		[maximum depth reached]
	)
	[protected] _schema => null
	[protected] _associationKeys => array(
		[maximum depth reached]
	)
	[protected] _associations => array(
		[maximum depth reached]
	)
	[protected] _insertID => null
	[protected] _sourceConfigured => true
	[protected] _eventManager => object(CakeEventManager) {}
	[protected] _validator => null
}
array(
	'conditions' => 'Ville.slug != "Array" AND agregat_id = 4',
	'fields' => 'Ville.nom,Ville.slug,(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => 'distance'
	),
	'page' => (int) 1,
	'group' => 'Ville.id HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1',
	'callbacks' => true
)

CORE/Cake/Model/Model.php line 2919 → Model->_readDataSource(string, array)

            return null;
        }

        return $this->_readDataSource($type, $query);
    }

'all'
array(
	'conditions' => 'Ville.slug != "Array" AND agregat_id = 4',
	'fields' => 'Ville.nom,Ville.slug,(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	),
	'limit' => (int) 7,
	'offset' => null,
	'order' => array(
		(int) 0 => 'distance'
	),
	'page' => (int) 1,
	'group' => 'Ville.id HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1',
	'callbacks' => true
)

APP/Controller/AgregatsController.php line 210 → Model->find(string, array)

                'group'      => 'Ville.id HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1',

                'order'      => 'distance',

                'limit'      => 7

                ));

'all'
array(
	'fields' => 'Ville.nom,Ville.slug,(((acos(sin((*pi()/180)) * sin((Ville.lat*pi()/180))+cos((*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance',
	'joins' => array(
		(int) 0 => array(
			[maximum depth reached]
		)
	),
	'conditions' => 'Ville.slug != "Array" AND agregat_id = 4',
	'group' => 'Ville.id HAVING distance < 50000 and COUNT(`Ville`.`slug`) > 1',
	'order' => 'distance',
	'limit' => (int) 7
)

[internal function] → AgregatsController->index(string, string, string, string, string)

'4'
'maisons-de-retraite-ehpad-ehpa'
'www.santeenfrance.fr'
'annuaire'
'4-maisons-de-retraite-ehpad-ehpa'

CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(AgregatsController, array)

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

object(AgregatsController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Agregats'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Agregats'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'index'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Agregat'
	modelKey => 'agregat'
	validationErrors => null
	AutoLogin => object(AutoLoginComponent) {}
	Auth => object(AuthComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	Session => object(SessionComponent) {}
	Img => object(ImgComponent) {}
	Paginator => object(PaginatorComponent) {}
	Agregat => object(Agregat) {}
	Etablissement => object(Etablissement) {}
	Departement => object(Departement) {}
	Region => object(AppModel) {}
	Ville => object(Ville) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
array(
	(int) 0 => '4',
	(int) 1 => 'maisons-de-retraite-ehpad-ehpa',
	(int) 2 => 'www.santeenfrance.fr',
	(int) 3 => 'annuaire',
	(int) 4 => '4-maisons-de-retraite-ehpad-ehpa'
)

CORE/Cake/Routing/Dispatcher.php line 191 → Controller->invokeAction(CakeRequest)


        $response = $controller->response;
        $render = true;
        $result = $controller->invokeAction($request);
        if ($result instanceof CakeResponse) {

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	base => ''
	webroot => '/'
	here => '/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

CORE/Cake/Routing/Dispatcher.php line 165 → Dispatcher->_invoke(AgregatsController, CakeRequest)

            ));
        }

        $response = $this->_invoke($controller, $request);
        if (isset($request->params['return'])) {

object(AgregatsController) {
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Agregats'
	uses => array(
		[maximum depth reached]
	)
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Agregats'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'index'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Agregat'
	modelKey => 'agregat'
	validationErrors => null
	AutoLogin => object(AutoLoginComponent) {}
	Auth => object(AuthComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	Session => object(SessionComponent) {}
	Img => object(ImgComponent) {}
	Paginator => object(PaginatorComponent) {}
	Agregat => object(Agregat) {}
	Etablissement => object(Etablissement) {}
	Departement => object(Departement) {}
	Region => object(AppModel) {}
	Ville => object(Ville) {}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {}
}
object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	base => ''
	webroot => '/'
	here => '/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}

APP/webroot/index.php line 112 → Dispatcher->dispatch(CakeRequest, CakeResponse)

$Dispatcher->dispatch(
    new CakeRequest(),
    new CakeResponse()
);

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	base => ''
	webroot => '/'
	here => '/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimarhttps:/www.santeenfrance.fr/annuaire/4-maisons-de-retraite-ehpad-ehpa/ville:montelimar'
	[protected] _detectors => array(
		[maximum depth reached]
	)
	[protected] _input => ''
}
object(CakeResponse) {
	[protected] _statusCodes => array(
		[maximum depth reached]
	)
	[protected] _mimeTypes => array(
		[maximum depth reached]
	)
	[protected] _protocol => 'HTTP/1.1'
	[protected] _status => (int) 200
	[protected] _contentType => 'text/html'
	[protected] _headers => array([maximum depth reached])
	[protected] _body => null
	[protected] _file => null
	[protected] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array([maximum depth reached])
	[protected] _cookies => array(
		[maximum depth reached]
	)
}