FISIOTERAPIA - NEÚFES CENTRO DE FISIOTERAPIA en Carmona, Sevilla

Notice (8): Undefined variable: specialties [APP/View/fisiosite/Establishments/show.ctp, line 13]

*/

    $meta_description = __('%s en Fisiosite. %s. %s', $establishment['Establishment']['name'], $establishment['Category']['name'], $specialties);

$viewFile = '/home/bkvtdvl/fisiosite/View/fisiosite/Establishments/show.ctp'
$dataForView = array(
	'validations_errors' => null,
	'establishment' => array(
		'Establishment' => array(
			'id' => '2493',
			'name' => 'NEÚFES CENTRO DE FISIOTERAPIA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'C/ Bodeguilla 2A, local 2',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955318287',
			'phone2' => null,
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.469707',
			'longitude' => '-5.645351',
			'slug' => 'neufes-centro-de-fisioterapia-c-bodeguilla-a-local',
			'canonical' => 'fisioterapia/carmona/neufes-centro-de-fisioterapia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '210a3fd60b69c6221568841c7714746b',
			'hash_old' => '0d09e336d87c009db55c2227d34c6a90',
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:16:16',
			'modified' => '2018-07-10 19:43:39',
			'sms' => null,
			'fulladdress' => 'C/ Bodeguilla 2A, local 2, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/neufes-centro-de-fisioterapia',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3',
			'ParentCategory' => array(
				[maximum depth reached]
			)
		),
		'Population' => array(
			'id' => '690',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'canonical' => 'sevilla/carmona',
			'canonical_town' => 'carmona',
			'is_footer' => '1',
			'capital_population_id' => null,
			'latitude_town' => null,
			'longitude_town' => null
		),
		'Bono' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'PopulationZone' => array(),
		'activities' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			),
			(int) 28 => array(
				[maximum depth reached]
			),
			(int) 29 => array(
				[maximum depth reached]
			),
			(int) 30 => array(
				[maximum depth reached]
			),
			(int) 31 => array(
				[maximum depth reached]
			),
			(int) 32 => array(
				[maximum depth reached]
			),
			(int) 33 => array(
				[maximum depth reached]
			),
			(int) 34 => array(
				[maximum depth reached]
			),
			(int) 35 => array(
				[maximum depth reached]
			),
			(int) 36 => array(
				[maximum depth reached]
			),
			(int) 37 => array(
				[maximum depth reached]
			),
			(int) 38 => array(
				[maximum depth reached]
			),
			(int) 39 => array(
				[maximum depth reached]
			),
			(int) 40 => array(
				[maximum depth reached]
			),
			(int) 41 => array(
				[maximum depth reached]
			),
			(int) 42 => array(
				[maximum depth reached]
			),
			(int) 43 => array(
				[maximum depth reached]
			),
			(int) 44 => array(
				[maximum depth reached]
			),
			(int) 45 => array(
				[maximum depth reached]
			)
		),
		'ServiceHours' => '<div class="fis_card_schedule_day text_center">Horario no disponible</div>'
	),
	'establishmentInfoData' => '{"id":"2493","releases":[],"coupons":[],"budget":[],"offers":[]}',
	'gallery' => '[]',
	'user' => false,
	'near_recommend' => array(
		(int) 0 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		)
	),
	'total_bonos' => (int) 7,
	'last_bonos' => array(
		(int) 0 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		)
	)
)
$validations_errors = null
$establishment = array(
	'Establishment' => array(
		'id' => '2493',
		'name' => 'NEÚFES CENTRO DE FISIOTERAPIA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => null,
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => '',
		'address1' => 'C/ Bodeguilla 2A, local 2',
		'address2' => '',
		'email' => null,
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '955318287',
		'phone2' => null,
		'zipcode' => '41410',
		'town' => 'Carmona',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.469707',
		'longitude' => '-5.645351',
		'slug' => 'neufes-centro-de-fisioterapia-c-bodeguilla-a-local',
		'canonical' => 'fisioterapia/carmona/neufes-centro-de-fisioterapia',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '210a3fd60b69c6221568841c7714746b',
		'hash_old' => '0d09e336d87c009db55c2227d34c6a90',
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => '1',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '690',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2016-07-07 13:16:16',
		'modified' => '2018-07-10 19:43:39',
		'sms' => null,
		'fulladdress' => 'C/ Bodeguilla 2A, local 2, Carmona ( 41410 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/carmona/neufes-centro-de-fisioterapia',
		'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
		'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
		'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//',
		'rating' => false,
		'is_open' => false
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3',
		'ParentCategory' => array(
			'id' => '31',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia-general',
			'description' => '',
			'parent_id' => '0',
			'created' => null,
			'modified' => null,
			'lft' => null,
			'rght' => null
		)
	),
	'Population' => array(
		'id' => '690',
		'town' => 'Carmona',
		'state' => 'Sevilla',
		'canonical' => 'sevilla/carmona',
		'canonical_town' => 'carmona',
		'is_footer' => '1',
		'capital_population_id' => null,
		'latitude_town' => null,
		'longitude_town' => null
	),
	'Bono' => array(),
	'EstablishmentsCategory' => array(),
	'Comment' => array(),
	'Service' => array(),
	'Staff' => array(),
	'Timetable' => array(),
	'Feature' => array(),
	'Specialty' => array(),
	'Insurance' => array(),
	'PopulationZone' => array(),
	'activities' => array(
		(int) 0 => array(
			'id' => '268',
			'name' => 'Migraña',
			'description' => '',
			'slug' => 'migrana',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'id' => '269',
			'name' => 'Radiculopatía',
			'description' => '',
			'slug' => 'radiculopatia',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'id' => '270',
			'name' => 'Vértigo',
			'description' => '',
			'slug' => 'vertigo',
			'featured' => null,
			'created' => '2017-05-22 16:08:04',
			'modified' => '2017-05-22 16:08:04',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'id' => '271',
			'name' => 'Artrosis',
			'description' => '',
			'slug' => 'artrosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:05',
			'modified' => '2017-05-22 16:08:05',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'id' => '272',
			'name' => 'Artritis',
			'description' => '',
			'slug' => 'artritis',
			'featured' => null,
			'created' => '2017-05-22 16:08:06',
			'modified' => '2017-05-22 16:08:06',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'id' => '273',
			'name' => 'Cervicalgia',
			'description' => '',
			'slug' => 'cervicalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:07',
			'modified' => '2017-05-22 16:08:07',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'id' => '274',
			'name' => 'Dolor de cuello',
			'description' => '',
			'slug' => 'dolor-de-cuello',
			'featured' => null,
			'created' => '2017-05-22 16:08:08',
			'modified' => '2017-05-22 16:08:08',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'id' => '275',
			'name' => 'Dorsalgia',
			'description' => '',
			'slug' => 'dorsalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:09',
			'modified' => '2017-05-22 16:08:09',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'id' => '276',
			'name' => 'Dolor de espalda',
			'description' => '',
			'slug' => 'dolor-de-espalda',
			'featured' => null,
			'created' => '2017-05-22 16:08:10',
			'modified' => '2017-05-22 16:08:10',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'id' => '277',
			'name' => 'Lumbalgia',
			'description' => '',
			'slug' => 'lumbalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:11',
			'modified' => '2017-05-22 16:08:11',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'id' => '278',
			'name' => 'Dolor lumbar',
			'description' => '',
			'slug' => 'dolor-lumbar',
			'featured' => null,
			'created' => '2017-05-22 16:08:12',
			'modified' => '2017-05-22 16:08:12',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'id' => '279',
			'name' => 'Diabetes mellitus',
			'description' => '',
			'slug' => 'diabetes-mellitus',
			'featured' => null,
			'created' => '2017-05-22 16:08:13',
			'modified' => '2017-05-22 16:08:13',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'id' => '282',
			'name' => 'Dolor crónico',
			'description' => '',
			'slug' => 'dolor-cronico',
			'featured' => null,
			'created' => '2017-05-22 16:08:14',
			'modified' => '2017-05-22 16:08:14',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'id' => '283',
			'name' => 'Sd del túnel carpiano',
			'description' => '',
			'slug' => 'sd-del-tunel-carpiano',
			'featured' => null,
			'created' => '2017-05-22 16:08:15',
			'modified' => '2017-05-22 16:08:15',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'id' => '284',
			'name' => 'Ciática',
			'description' => '',
			'slug' => 'ciatica',
			'featured' => null,
			'created' => '2017-05-22 16:08:16',
			'modified' => '2017-05-22 16:08:16',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'id' => '285',
			'name' => 'Bruxismo',
			'description' => '',
			'slug' => 'bruxismo',
			'featured' => null,
			'created' => '2017-05-22 16:08:17',
			'modified' => '2017-05-22 16:08:17',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'id' => '286',
			'name' => 'Mareos',
			'description' => '',
			'slug' => 'mareos',
			'featured' => null,
			'created' => '2017-05-22 16:08:18',
			'modified' => '2017-05-22 16:08:18',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'id' => '287',
			'name' => 'Dolor de cabeza',
			'description' => '',
			'slug' => 'dolor-de-cabeza',
			'featured' => null,
			'created' => '2017-05-22 16:08:19',
			'modified' => '2017-05-22 16:08:19',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'id' => '288',
			'name' => 'Cefalea',
			'description' => '',
			'slug' => 'cefalea',
			'featured' => null,
			'created' => '2017-05-22 16:08:20',
			'modified' => '2017-05-22 16:08:20',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'id' => '289',
			'name' => 'Fascitis plantar',
			'description' => '',
			'slug' => 'fascitis-plantar',
			'featured' => null,
			'created' => '2017-05-22 16:08:21',
			'modified' => '2017-05-22 16:08:21',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'id' => '290',
			'name' => 'Cefalea tensional',
			'description' => '',
			'slug' => 'cefalea-tensional',
			'featured' => null,
			'created' => '2017-05-22 16:08:23',
			'modified' => '2017-05-22 16:08:23',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'id' => '291',
			'name' => 'Esguince',
			'description' => '',
			'slug' => 'esguince',
			'featured' => null,
			'created' => '2017-05-22 16:08:24',
			'modified' => '2017-05-22 16:08:24',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'id' => '292',
			'name' => 'Esguince de tobillo',
			'description' => '',
			'slug' => 'esguince-de-tobillo',
			'featured' => null,
			'created' => '2017-05-22 16:08:25',
			'modified' => '2017-05-22 16:08:25',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'id' => '293',
			'name' => 'Desgarro muscular',
			'description' => '',
			'slug' => 'desgarro-muscular',
			'featured' => null,
			'created' => '2017-05-22 16:08:26',
			'modified' => '2017-05-22 16:08:26',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'id' => '294',
			'name' => 'Tendinitis',
			'description' => '',
			'slug' => 'tendinitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:27',
			'modified' => '2017-05-22 16:08:27',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'id' => '295',
			'name' => 'Tendinosis',
			'description' => '',
			'slug' => 'tendinosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:28',
			'modified' => '2017-05-22 16:08:28',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'id' => '296',
			'name' => 'Lesión del manguito rotador',
			'description' => '',
			'slug' => 'lesion-del-manguito-rotador',
			'featured' => null,
			'created' => '2017-05-22 16:08:30',
			'modified' => '2017-05-22 16:08:30',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'id' => '297',
			'name' => 'Epicondilitis',
			'description' => '',
			'slug' => 'epicondilitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:31',
			'modified' => '2017-05-22 16:08:31',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'id' => '298',
			'name' => 'Epitrocleitis',
			'description' => '',
			'slug' => 'epitrocleitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:32',
			'modified' => '2017-05-22 16:08:32',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'id' => '299',
			'name' => 'Periostitis',
			'description' => '',
			'slug' => 'periostitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:33',
			'modified' => '2017-05-22 16:08:33',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'id' => '300',
			'name' => 'Lesión meniscal',
			'description' => '',
			'slug' => 'lesion-meniscal',
			'featured' => null,
			'created' => '2017-05-22 16:08:34',
			'modified' => '2017-05-22 16:08:34',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'id' => '307',
			'name' => 'Espolón calcáneo',
			'description' => '',
			'slug' => 'espolon-calcaneo',
			'featured' => null,
			'created' => '2017-05-22 16:08:35',
			'modified' => '2017-05-22 16:08:35',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'id' => '308',
			'name' => 'Prótesis de rodilla',
			'description' => '',
			'slug' => 'protesis-de-rodilla',
			'featured' => null,
			'created' => '2017-05-22 16:08:36',
			'modified' => '2017-05-22 16:08:36',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'id' => '309',
			'name' => 'Prótesis de cadera',
			'description' => '',
			'slug' => 'protesis-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:37',
			'modified' => '2017-05-22 16:08:37',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'id' => '311',
			'name' => 'Fractura de cadera',
			'description' => '',
			'slug' => 'fractura-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:38',
			'modified' => '2017-05-22 16:08:38',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'id' => '312',
			'name' => 'Trastornos de equilibrio',
			'description' => '',
			'slug' => 'trastornos-de-equilibrio',
			'featured' => null,
			'created' => '2017-05-22 16:08:39',
			'modified' => '2017-05-22 16:08:39',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'id' => '313',
			'name' => 'Caídas',
			'description' => '',
			'slug' => 'caidas',
			'featured' => null,
			'created' => '2017-05-22 16:08:40',
			'modified' => '2017-05-22 16:08:40',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'id' => '323',
			'name' => 'Dolor pélvico',
			'description' => '',
			'slug' => 'dolor-pelvico',
			'featured' => null,
			'created' => '2017-05-22 16:08:41',
			'modified' => '2017-05-22 16:08:41',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'id' => '329',
			'name' => 'Fracturas',
			'description' => '',
			'slug' => 'fracturas',
			'featured' => null,
			'created' => '2017-05-22 16:08:42',
			'modified' => '2017-05-22 16:08:42',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'id' => '330',
			'name' => 'Lesión LCA (ligamento cruzado anterior)',
			'description' => '',
			'slug' => 'lesion-lca-ligamento-cruzado-anterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:43',
			'modified' => '2017-05-22 16:08:43',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'id' => '331',
			'name' => 'Lesión LCP (ligamento cruzado posterior)',
			'description' => '',
			'slug' => 'lesion-lcp-ligamento-cruzado-posterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:44',
			'modified' => '2017-05-22 16:08:44',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'id' => '332',
			'name' => 'Rotura del tendón de Aquiles',
			'description' => '',
			'slug' => 'rotura-del-tendon-de-aquiles',
			'featured' => null,
			'created' => '2017-05-22 16:08:45',
			'modified' => '2017-05-22 16:08:45',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'id' => '333',
			'name' => 'Luxación',
			'description' => '',
			'slug' => 'luxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:46',
			'modified' => '2017-05-22 16:08:46',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'id' => '334',
			'name' => 'Subluxación',
			'description' => '',
			'slug' => 'subluxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:47',
			'modified' => '2017-05-22 16:08:47',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'id' => '335',
			'name' => 'Condromalacia',
			'description' => '',
			'slug' => 'condromalacia',
			'featured' => null,
			'created' => '2017-05-22 16:08:48',
			'modified' => '2017-05-22 16:08:48',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'id' => '340',
			'name' => 'Linfedema Drenaje linfático',
			'description' => '',
			'slug' => 'linfedema-drenaje-linfatico',
			'featured' => null,
			'created' => '2017-05-22 16:08:49',
			'modified' => '2017-05-22 16:08:49',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		)
	),
	'ServiceHours' => '<div class="fis_card_schedule_day text_center">Horario no disponible</div>'
)
$establishmentInfoData = '{"id":"2493","releases":[],"coupons":[],"budget":[],"offers":[]}'
$gallery = '[]'
$user = false
$near_recommend = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '11246',
			'name' => 'Gracia Maria',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Bernardo Enrique Cerezo',
			'address2' => '13',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954191436',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.473713',
			'longitude' => '-5.643435',
			'slug' => null,
			'canonical' => 'fisioterapia/carmona/gracia-maria',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '81413032bbc2f1034085ec95d8d36e2f',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 12:27:00',
			'modified' => '2018-07-10 20:07:18',
			'sms' => null,
			'fulladdress' => 'Bernardo Enrique Cerezo, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/gracia-maria',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'FISIOTERAPIA'
		),
		(int) 0 => array(
			'distance' => '0.476451111415471'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11408',
			'name' => 'Centro de Pilates Carmona ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Guadalete',
			'address2' => '30',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '637414203',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.472252',
			'longitude' => '-5.651840',
			'slug' => null,
			'canonical' => 'pilates/carmona/centro-de-pilates-carmona',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8a1bb701bbf9676a0faa25078e02f4a1',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 13:19:00',
			'modified' => '2018-07-10 20:08:03',
			'sms' => null,
			'fulladdress' => 'Calle Guadalete, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/carmona/centro-de-pilates-carmona',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'PILATES'
		),
		(int) 0 => array(
			'distance' => '0.6387798968981186'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '11364',
			'name' => 'Instituto Médico de Carmona',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ SANTA ANA',
			'address2' => '31',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '619966040',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.475224',
			'longitude' => '-5.642756',
			'slug' => null,
			'canonical' => 'fisioterapia/carmona/instituto-medico-de-carmona',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ce1bd529fce750b8e9cf0039e25bf898',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 13:02:30',
			'modified' => '2018-07-10 20:07:51',
			'sms' => null,
			'fulladdress' => 'C/ SANTA ANA, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/instituto-medico-de-carmona',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'FISIOTERAPIA'
		),
		(int) 0 => array(
			'distance' => '0.6547659285852868'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	)
)
$total_bonos = (int) 7
$last_bonos = array(
	(int) 0 => array(
		'Bono' => array(
			'id' => '44',
			'establishment_id' => '12251',
			'name' => 'Bono 5 sesiones',
			'description' => '<p>Bono de 5 sesiones con un 10% de descuento.</p>',
			'num_sessions' => '5',
			'price' => '200',
			'price_old' => '225',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2019-02-28 02:02:00',
			'tag' => '',
			'image' => 'img_20190217_142642_605.jpg',
			'image_dir' => '44/33/51/15',
			'created' => '2019-02-17 17:06:53',
			'modified' => '2019-02-17 17:08:47'
		),
		'Establishment' => array(
			'id' => '12251',
			'name' => 'Fisiopraxis ',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => '<p>Centro de Servicios integrales de FISIOTERAPIA, ENTRENAMIENTO PERSONAL,&nbsp;ASESORAMIENTO NUTRICIONAL&nbsp;y PREPARACION FISICA.<br></p><p>-Tratamientos de Fisioterapia adaptados a la patología del paciente:</p><p></p><p>&nbsp; -Recuperación de lesiones</p><p>&nbsp; -Rehabilitación</p><p>&nbsp; -Terapia postural</p><p>&nbsp; -Readaptación del cuerpo</p><p>&nbsp; -Inducción Miofascial</p><p>&nbsp; -Terapia global</p><p>-En los Tratamientos referentes al Entrenamiento Personal y al Asesoramiento Nutricional, evaluamos en primera instancia el estado corporal de cada paciente.&nbsp;Realizamos una evaluación física (IMC, % de agua en el cuerpo, peso, masa grasa, masa muscular, grasa visceral y metabolismo basal saludable),con la que conseguimos&nbsp;los datos necesarios para hacer&nbsp;una estimación del consumo calórico en reposo y el necesario real&nbsp;adaptado a la vida de cada persona.En estos tratamientos, en la primera sesión,&nbsp;entregamos un plan de acción a&nbsp;4 semanas para conseguir los objetivos que nos requiera cada cliente.<br></p><p>-Nuestras recomendaciones siempre estarán enfocadas tanto en el ámbito de la recuperación corporal,&nbsp;preparación física&nbsp;y la nutrición saludable.</p>',
			'fiscalnumber' => '51073539s',
			'address1' => 'Trueba y Fernandez 16, 1D',
			'address2' => 'PROMOCION SEMANAL: VEN Y LLEVATE TU PRIMER ESTUDIO NUTRICIONAL DE FORMA GRATUITA.

Pide tu cita a cualquier hora del día cualquier día de la semana en el Tlf. 24H.(620152075).',
			'email' => 'Lucia.pascual@gmail.com',
			'fax' => null,
			'mobile' => '620152076',
			'mobile2' => null,
			'phone' => '620152076',
			'phone2' => '620152076',
			'zipcode' => '28016',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.454800',
			'longitude' => '-3.679500',
			'slug' => null,
			'canonical' => 'fisioterapia/madrid/fisiopraxis',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '6421757aee8fc8f44f16a93b2acfe8af',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5c5eed8e-4c38-4903-b7c0-ad520a3a8879',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => 'ES3502340001079015557146',
			'bank_cert' => '1360573960275006783.pdf',
			'bank_cert_dir' => '12251/79/88/01',
			'bank_cert_status' => null,
			'file_dni' => 'zip_dni.zip',
			'file_dni_dir' => '12251/54/87/23',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2019-02-09 16:19:06',
			'modified' => '2019-03-21 18:53:54',
			'sms' => null,
			'fulladdress' => 'Trueba y Fernandez 16, 1D, Madrid ( 28016 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia/madrid/fisiopraxis',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12251/79/88/01/1360573960275006783.pdf',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12251/54/87/23/zip_dni.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 1 => array(
		'Bono' => array(
			'id' => '38',
			'establishment_id' => '10174',
			'name' => 'Pack 5 sesiones de vapor (infantil)',
			'description' => '<p>

<!--StartFragment--><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><h4 class="av_iconlist_title iconlist_title  " itemprop="headline" style="display: block; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial; box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: 600; font-stretch: inherit; font-size: 18px; line-height: 1.1em; font-family: &quot;Terminal Dosis&quot;, HelveticaNeue, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; vertical-align: baseline; color: rgb(34, 34, 34); text-transform: uppercase; top: 4px; position: relative;">CALOR HÚMEDO (Vapor)</h4><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><div class="iconlist_content  " itemprop="text" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: 1.65em; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: rgb(141, 141, 141); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"><p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px rgb(225, 225, 225); font: inherit; vertical-align: baseline;">Chorro de vapor de agua de mar isotónica que actúa a nivel de las vías respiratorias altas y del oído hidratando y preparando la mucosa para los tratamientos posteriores. El vapor produce una agradable sensación de descongestión y tiene una gran acción mucolítica para ayudar a drenar la mucosidad, sobretodo en el caso de los niños.&nbsp;</p></div></p><p class="sceditor-nlf"><br></p>',
			'num_sessions' => '5',
			'price' => '81',
			'price_old' => '18',
			'status' => '0',
			'start' => null,
			'end' => '2018-11-30 02:00:00',
			'tag' => 'Pack F,Pack Vapores',
			'image' => 'nen_p.jpg',
			'image_dir' => '38/78/37/59',
			'created' => '2018-11-20 10:35:46',
			'modified' => '2018-11-20 10:35:46'
		),
		'Establishment' => array(
			'id' => '10174',
			'name' => 'BALNEARI RESPIRATORI METODE Dr. PROS',
			'category_id' => '6',
			'establishment_type' => '2',
			'image' => 'logo_br_m_dr.pros_nvcat.jpg',
			'image_dir' => '10174/86/81/02',
			'web' => 'http://balnearirespiratori.cat',
			'short_description' => 'En el centro tratamos todas las patologías de las vías respiratorias y del oído utilizando el agua de mar como herramienta terapéutica a través de vapores, nebulizaciones y duchas nasales, así como técnicas de fisioterapia para el drenaje de la mucosidad bronquial.',
			'description' => '<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2002 nació el Balneari Respiratori bajo la dirección del Dr. Miquel Pros, prestigioso médico naturista pionero en la introducción en España de las terapias procedentes de la escuela alemana de medicina naturista.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">El Dr. Pros afirma que la acumulación crónica de las mucosidades en el interior de las cavidades nasales las convierte en una zona altamente conflictiva, un foco infeccioso que puede llegar a generar más de 20 patologías respiratorias y del oído, además de afectar a otras partes de nuestro organismo, como el sistema digestivo y el sistema inmunológico. Es su&nbsp;Teoría de la Sinusitis Silenciosa.&nbsp;</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">Esta teoría lo llevó a sistematizar el uso del agua de mar para el tratamiento de las afecciones respiratorias y del oído en lo que hoy conocemos como Balneari Respiratori. A lo largo de estos 15 años y acompañado por la fisioterapeuta Núria Oliver, que actualmente dirige el centro, se ha demostrado la gran eficacia del método terapéutico del Dr. Pros, más de 6.000 pacientes han recibido los tratamientos con agua de mar.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2010 se realizó un estudio piloto con un grupo de niños de guardería de 0 a 6 años para constatar científicamente los beneficios de los tratamientos con agua de mar en niños, obteniendo unos resultados altamente satisfactorios, pues 9 de cada 10 niños y niñas mejoraron sus trastornos respiratorios respecto a su situación inicial.</p>
Alergias? Sinusitis? Oídos tapados? Dolor de garganta o de cabeza? Congestión nasal?

&nbsp;



<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Te podemos ayudar a disminuir y eliminar todos estos síntomas.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Ven y haremos una desensibilización de las mucosas respiratorias con agua de mar natural y INDIBA (hipertermia profunda). A través de nuestros tratamientos ayudamos a drenar la mucosidad estancada y disminuir la inflamación de las mucosas respiratorias.</p>

<p class="sceditor-nlf"><br></p>',
			'fiscalnumber' => '52593943G',
			'address1' => 'Carrer de Muntaner, 411',
			'address2' => '',
			'email' => 'info@balnearirespiratori.cat',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '932 11 07 95',
			'phone2' => '',
			'zipcode' => '08021',
			'town' => 'Barcelona',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.400227',
			'longitude' => '2.141209',
			'slug' => null,
			'canonical' => 'fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b15b72025c53132fa9f4d7177cf636d4',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '59d49439-e0a0-4f05-8bf9-75470a3a8836',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => 'https://www.facebook.com/balnearirespiratori/videos/vb.120248087989511/1142642909083352/?type=2&theater',
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4957',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 09:47:34',
			'modified' => '2019-09-16 13:01:21',
			'sms' => null,
			'fulladdress' => 'Carrer de Muntaner, 411, Barcelona ( 08021 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 2 => array(
		'Bono' => array(
			'id' => '32',
			'establishment_id' => '12044',
			'name' => '10 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '10',
			'price' => '450',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '32/14/58/99',
			'created' => '2018-11-09 21:17:41',
			'modified' => '2018-11-09 21:19:24'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Bono' => array(
			'id' => '29',
			'establishment_id' => '12044',
			'name' => '5 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '5',
			'price' => '237.5',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '29/68/63/77',
			'created' => '2018-11-09 21:15:55',
			'modified' => '2018-11-09 21:19:10'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	)
)

include - APP/View/fisiosite/Establishments/show.ctp, line 13
View::_evaluate() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 971
View::_render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 933
View::render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 473
Controller::render() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 968
EstablishmentsController::show() - APP/Controller/EstablishmentsController.php, line 322
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 135

Reserva tu cita Este establecimiento no tiene dado de altas citas online.

Horario

Horario no disponible

NEÚFES CENTRO DE FISIOTERAPIA C/ Bodeguilla 2A, local 2, Carmona ( 41410 ) , Sevilla

Notice (8): Undefined index: News [APP/View/fisiosite/Establishments/show.ctp, line 562]Code Context        </div>
            <?php //echo $this->element('Fisiosite/commons/bono_slide', ['bonos' => $establishment['Bono']]); ?>
            <?php echo $this->element('Fisiosite/commons/news_slide', ['news' => $establishment['News']]); ?>
$viewFile = '/home/bkvtdvl/fisiosite/View/fisiosite/Establishments/show.ctp'
$dataForView = array(
	'validations_errors' => null,
	'establishment' => array(
		'Establishment' => array(
			'id' => '2493',
			'name' => 'NEÚFES CENTRO DE FISIOTERAPIA',
			'category_id' => '1',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => null,
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => '',
			'address1' => 'C/ Bodeguilla 2A, local 2',
			'address2' => '',
			'email' => null,
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '955318287',
			'phone2' => null,
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.469707',
			'longitude' => '-5.645351',
			'slug' => 'neufes-centro-de-fisioterapia-c-bodeguilla-a-local',
			'canonical' => 'fisioterapia/carmona/neufes-centro-de-fisioterapia',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '210a3fd60b69c6221568841c7714746b',
			'hash_old' => '0d09e336d87c009db55c2227d34c6a90',
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2016-07-07 13:16:16',
			'modified' => '2018-07-10 19:43:39',
			'sms' => null,
			'fulladdress' => 'C/ Bodeguilla 2A, local 2, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/neufes-centro-de-fisioterapia',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//',
			'rating' => false,
			'is_open' => false
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3',
			'ParentCategory' => array(
				[maximum depth reached]
			)
		),
		'Population' => array(
			'id' => '690',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'canonical' => 'sevilla/carmona',
			'canonical_town' => 'carmona',
			'is_footer' => '1',
			'capital_population_id' => null,
			'latitude_town' => null,
			'longitude_town' => null
		),
		'Bono' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'PopulationZone' => array(),
		'activities' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			),
			(int) 28 => array(
				[maximum depth reached]
			),
			(int) 29 => array(
				[maximum depth reached]
			),
			(int) 30 => array(
				[maximum depth reached]
			),
			(int) 31 => array(
				[maximum depth reached]
			),
			(int) 32 => array(
				[maximum depth reached]
			),
			(int) 33 => array(
				[maximum depth reached]
			),
			(int) 34 => array(
				[maximum depth reached]
			),
			(int) 35 => array(
				[maximum depth reached]
			),
			(int) 36 => array(
				[maximum depth reached]
			),
			(int) 37 => array(
				[maximum depth reached]
			),
			(int) 38 => array(
				[maximum depth reached]
			),
			(int) 39 => array(
				[maximum depth reached]
			),
			(int) 40 => array(
				[maximum depth reached]
			),
			(int) 41 => array(
				[maximum depth reached]
			),
			(int) 42 => array(
				[maximum depth reached]
			),
			(int) 43 => array(
				[maximum depth reached]
			),
			(int) 44 => array(
				[maximum depth reached]
			),
			(int) 45 => array(
				[maximum depth reached]
			)
		),
		'ServiceHours' => '<div class="fis_card_schedule_day text_center">Horario no disponible</div>'
	),
	'establishmentInfoData' => '{"id":"2493","releases":[],"coupons":[],"budget":[],"offers":[]}',
	'gallery' => '[]',
	'user' => false,
	'near_recommend' => array(
		(int) 0 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Establishment' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			(int) 0 => array(
				[maximum depth reached]
			),
			'Offer' => array([maximum depth reached]),
			'Coupon' => array([maximum depth reached]),
			'Bono' => array([maximum depth reached]),
			'Newlaunch' => array([maximum depth reached]),
			'EstablishmentsBudgetType' => array([maximum depth reached]),
			'BudgetsUser' => array([maximum depth reached]),
			'EstablishmentsRequest' => array([maximum depth reached]),
			'EstablishmentsUser' => array([maximum depth reached]),
			'EstablishmentsCategory' => array([maximum depth reached]),
			'Comment' => array([maximum depth reached]),
			'Service' => array([maximum depth reached]),
			'Staff' => array([maximum depth reached]),
			'Timetable' => array([maximum depth reached]),
			'News' => array([maximum depth reached]),
			'Slide' => array([maximum depth reached]),
			'Rating' => array([maximum depth reached]),
			'UsersSubscription' => array([maximum depth reached]),
			'Feature' => array([maximum depth reached]),
			'Specialty' => array([maximum depth reached]),
			'Insurance' => array([maximum depth reached]),
			'Users' => array([maximum depth reached]),
			'PopulationZone' => array([maximum depth reached])
		)
	),
	'total_bonos' => (int) 7,
	'last_bonos' => array(
		(int) 0 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		)
	)
)
$validations_errors = null
$establishment = array(
	'Establishment' => array(
		'id' => '2493',
		'name' => 'NEÚFES CENTRO DE FISIOTERAPIA',
		'category_id' => '1',
		'establishment_type' => '1',
		'image' => null,
		'image_dir' => null,
		'web' => null,
		'short_description' => null,
		'description' => null,
		'fiscalnumber' => '',
		'address1' => 'C/ Bodeguilla 2A, local 2',
		'address2' => '',
		'email' => null,
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '955318287',
		'phone2' => null,
		'zipcode' => '41410',
		'town' => 'Carmona',
		'state' => 'Sevilla',
		'country' => 'España',
		'latitude' => '37.469707',
		'longitude' => '-5.645351',
		'slug' => 'neufes-centro-de-fisioterapia-c-bodeguilla-a-local',
		'canonical' => 'fisioterapia/carmona/neufes-centro-de-fisioterapia',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '210a3fd60b69c6221568841c7714746b',
		'hash_old' => '0d09e336d87c009db55c2227d34c6a90',
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => null,
		'plan_id' => '1',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => '0',
		'subscription_id' => '0',
		'population_id' => '690',
		'bank' => null,
		'bank_cert' => null,
		'bank_cert_dir' => null,
		'bank_cert_status' => null,
		'file_dni' => null,
		'file_dni_dir' => null,
		'writers' => null,
		'writers_dir' => null,
		'split_id' => null,
		'created' => '2016-07-07 13:16:16',
		'modified' => '2018-07-10 19:43:39',
		'sms' => null,
		'fulladdress' => 'C/ Bodeguilla 2A, local 2, Carmona ( 41410 ) , Sevilla',
		'link' => 'https://www.fisiosite.com/fisioterapia/carmona/neufes-centro-de-fisioterapia',
		'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
		'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
		'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//',
		'rating' => false,
		'is_open' => false
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3',
		'ParentCategory' => array(
			'id' => '31',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia-general',
			'description' => '',
			'parent_id' => '0',
			'created' => null,
			'modified' => null,
			'lft' => null,
			'rght' => null
		)
	),
	'Population' => array(
		'id' => '690',
		'town' => 'Carmona',
		'state' => 'Sevilla',
		'canonical' => 'sevilla/carmona',
		'canonical_town' => 'carmona',
		'is_footer' => '1',
		'capital_population_id' => null,
		'latitude_town' => null,
		'longitude_town' => null
	),
	'Bono' => array(),
	'EstablishmentsCategory' => array(),
	'Comment' => array(),
	'Service' => array(),
	'Staff' => array(),
	'Timetable' => array(),
	'Feature' => array(),
	'Specialty' => array(),
	'Insurance' => array(),
	'PopulationZone' => array(),
	'activities' => array(
		(int) 0 => array(
			'id' => '268',
			'name' => 'Migraña',
			'description' => '',
			'slug' => 'migrana',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'id' => '269',
			'name' => 'Radiculopatía',
			'description' => '',
			'slug' => 'radiculopatia',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'id' => '270',
			'name' => 'Vértigo',
			'description' => '',
			'slug' => 'vertigo',
			'featured' => null,
			'created' => '2017-05-22 16:08:04',
			'modified' => '2017-05-22 16:08:04',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'id' => '271',
			'name' => 'Artrosis',
			'description' => '',
			'slug' => 'artrosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:05',
			'modified' => '2017-05-22 16:08:05',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'id' => '272',
			'name' => 'Artritis',
			'description' => '',
			'slug' => 'artritis',
			'featured' => null,
			'created' => '2017-05-22 16:08:06',
			'modified' => '2017-05-22 16:08:06',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'id' => '273',
			'name' => 'Cervicalgia',
			'description' => '',
			'slug' => 'cervicalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:07',
			'modified' => '2017-05-22 16:08:07',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'id' => '274',
			'name' => 'Dolor de cuello',
			'description' => '',
			'slug' => 'dolor-de-cuello',
			'featured' => null,
			'created' => '2017-05-22 16:08:08',
			'modified' => '2017-05-22 16:08:08',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'id' => '275',
			'name' => 'Dorsalgia',
			'description' => '',
			'slug' => 'dorsalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:09',
			'modified' => '2017-05-22 16:08:09',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'id' => '276',
			'name' => 'Dolor de espalda',
			'description' => '',
			'slug' => 'dolor-de-espalda',
			'featured' => null,
			'created' => '2017-05-22 16:08:10',
			'modified' => '2017-05-22 16:08:10',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'id' => '277',
			'name' => 'Lumbalgia',
			'description' => '',
			'slug' => 'lumbalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:11',
			'modified' => '2017-05-22 16:08:11',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'id' => '278',
			'name' => 'Dolor lumbar',
			'description' => '',
			'slug' => 'dolor-lumbar',
			'featured' => null,
			'created' => '2017-05-22 16:08:12',
			'modified' => '2017-05-22 16:08:12',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'id' => '279',
			'name' => 'Diabetes mellitus',
			'description' => '',
			'slug' => 'diabetes-mellitus',
			'featured' => null,
			'created' => '2017-05-22 16:08:13',
			'modified' => '2017-05-22 16:08:13',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'id' => '282',
			'name' => 'Dolor crónico',
			'description' => '',
			'slug' => 'dolor-cronico',
			'featured' => null,
			'created' => '2017-05-22 16:08:14',
			'modified' => '2017-05-22 16:08:14',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'id' => '283',
			'name' => 'Sd del túnel carpiano',
			'description' => '',
			'slug' => 'sd-del-tunel-carpiano',
			'featured' => null,
			'created' => '2017-05-22 16:08:15',
			'modified' => '2017-05-22 16:08:15',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'id' => '284',
			'name' => 'Ciática',
			'description' => '',
			'slug' => 'ciatica',
			'featured' => null,
			'created' => '2017-05-22 16:08:16',
			'modified' => '2017-05-22 16:08:16',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'id' => '285',
			'name' => 'Bruxismo',
			'description' => '',
			'slug' => 'bruxismo',
			'featured' => null,
			'created' => '2017-05-22 16:08:17',
			'modified' => '2017-05-22 16:08:17',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'id' => '286',
			'name' => 'Mareos',
			'description' => '',
			'slug' => 'mareos',
			'featured' => null,
			'created' => '2017-05-22 16:08:18',
			'modified' => '2017-05-22 16:08:18',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'id' => '287',
			'name' => 'Dolor de cabeza',
			'description' => '',
			'slug' => 'dolor-de-cabeza',
			'featured' => null,
			'created' => '2017-05-22 16:08:19',
			'modified' => '2017-05-22 16:08:19',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'id' => '288',
			'name' => 'Cefalea',
			'description' => '',
			'slug' => 'cefalea',
			'featured' => null,
			'created' => '2017-05-22 16:08:20',
			'modified' => '2017-05-22 16:08:20',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'id' => '289',
			'name' => 'Fascitis plantar',
			'description' => '',
			'slug' => 'fascitis-plantar',
			'featured' => null,
			'created' => '2017-05-22 16:08:21',
			'modified' => '2017-05-22 16:08:21',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'id' => '290',
			'name' => 'Cefalea tensional',
			'description' => '',
			'slug' => 'cefalea-tensional',
			'featured' => null,
			'created' => '2017-05-22 16:08:23',
			'modified' => '2017-05-22 16:08:23',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'id' => '291',
			'name' => 'Esguince',
			'description' => '',
			'slug' => 'esguince',
			'featured' => null,
			'created' => '2017-05-22 16:08:24',
			'modified' => '2017-05-22 16:08:24',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'id' => '292',
			'name' => 'Esguince de tobillo',
			'description' => '',
			'slug' => 'esguince-de-tobillo',
			'featured' => null,
			'created' => '2017-05-22 16:08:25',
			'modified' => '2017-05-22 16:08:25',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'id' => '293',
			'name' => 'Desgarro muscular',
			'description' => '',
			'slug' => 'desgarro-muscular',
			'featured' => null,
			'created' => '2017-05-22 16:08:26',
			'modified' => '2017-05-22 16:08:26',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'id' => '294',
			'name' => 'Tendinitis',
			'description' => '',
			'slug' => 'tendinitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:27',
			'modified' => '2017-05-22 16:08:27',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'id' => '295',
			'name' => 'Tendinosis',
			'description' => '',
			'slug' => 'tendinosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:28',
			'modified' => '2017-05-22 16:08:28',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'id' => '296',
			'name' => 'Lesión del manguito rotador',
			'description' => '',
			'slug' => 'lesion-del-manguito-rotador',
			'featured' => null,
			'created' => '2017-05-22 16:08:30',
			'modified' => '2017-05-22 16:08:30',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'id' => '297',
			'name' => 'Epicondilitis',
			'description' => '',
			'slug' => 'epicondilitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:31',
			'modified' => '2017-05-22 16:08:31',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'id' => '298',
			'name' => 'Epitrocleitis',
			'description' => '',
			'slug' => 'epitrocleitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:32',
			'modified' => '2017-05-22 16:08:32',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'id' => '299',
			'name' => 'Periostitis',
			'description' => '',
			'slug' => 'periostitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:33',
			'modified' => '2017-05-22 16:08:33',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'id' => '300',
			'name' => 'Lesión meniscal',
			'description' => '',
			'slug' => 'lesion-meniscal',
			'featured' => null,
			'created' => '2017-05-22 16:08:34',
			'modified' => '2017-05-22 16:08:34',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'id' => '307',
			'name' => 'Espolón calcáneo',
			'description' => '',
			'slug' => 'espolon-calcaneo',
			'featured' => null,
			'created' => '2017-05-22 16:08:35',
			'modified' => '2017-05-22 16:08:35',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'id' => '308',
			'name' => 'Prótesis de rodilla',
			'description' => '',
			'slug' => 'protesis-de-rodilla',
			'featured' => null,
			'created' => '2017-05-22 16:08:36',
			'modified' => '2017-05-22 16:08:36',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'id' => '309',
			'name' => 'Prótesis de cadera',
			'description' => '',
			'slug' => 'protesis-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:37',
			'modified' => '2017-05-22 16:08:37',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'id' => '311',
			'name' => 'Fractura de cadera',
			'description' => '',
			'slug' => 'fractura-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:38',
			'modified' => '2017-05-22 16:08:38',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'id' => '312',
			'name' => 'Trastornos de equilibrio',
			'description' => '',
			'slug' => 'trastornos-de-equilibrio',
			'featured' => null,
			'created' => '2017-05-22 16:08:39',
			'modified' => '2017-05-22 16:08:39',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'id' => '313',
			'name' => 'Caídas',
			'description' => '',
			'slug' => 'caidas',
			'featured' => null,
			'created' => '2017-05-22 16:08:40',
			'modified' => '2017-05-22 16:08:40',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'id' => '323',
			'name' => 'Dolor pélvico',
			'description' => '',
			'slug' => 'dolor-pelvico',
			'featured' => null,
			'created' => '2017-05-22 16:08:41',
			'modified' => '2017-05-22 16:08:41',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'id' => '329',
			'name' => 'Fracturas',
			'description' => '',
			'slug' => 'fracturas',
			'featured' => null,
			'created' => '2017-05-22 16:08:42',
			'modified' => '2017-05-22 16:08:42',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'id' => '330',
			'name' => 'Lesión LCA (ligamento cruzado anterior)',
			'description' => '',
			'slug' => 'lesion-lca-ligamento-cruzado-anterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:43',
			'modified' => '2017-05-22 16:08:43',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'id' => '331',
			'name' => 'Lesión LCP (ligamento cruzado posterior)',
			'description' => '',
			'slug' => 'lesion-lcp-ligamento-cruzado-posterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:44',
			'modified' => '2017-05-22 16:08:44',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'id' => '332',
			'name' => 'Rotura del tendón de Aquiles',
			'description' => '',
			'slug' => 'rotura-del-tendon-de-aquiles',
			'featured' => null,
			'created' => '2017-05-22 16:08:45',
			'modified' => '2017-05-22 16:08:45',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'id' => '333',
			'name' => 'Luxación',
			'description' => '',
			'slug' => 'luxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:46',
			'modified' => '2017-05-22 16:08:46',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'id' => '334',
			'name' => 'Subluxación',
			'description' => '',
			'slug' => 'subluxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:47',
			'modified' => '2017-05-22 16:08:47',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'id' => '335',
			'name' => 'Condromalacia',
			'description' => '',
			'slug' => 'condromalacia',
			'featured' => null,
			'created' => '2017-05-22 16:08:48',
			'modified' => '2017-05-22 16:08:48',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'id' => '340',
			'name' => 'Linfedema Drenaje linfático',
			'description' => '',
			'slug' => 'linfedema-drenaje-linfatico',
			'featured' => null,
			'created' => '2017-05-22 16:08:49',
			'modified' => '2017-05-22 16:08:49',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		)
	),
	'ServiceHours' => '<div class="fis_card_schedule_day text_center">Horario no disponible</div>'
)
$establishmentInfoData = '{"id":"2493","releases":[],"coupons":[],"budget":[],"offers":[]}'
$gallery = '[]'
$user = false
$near_recommend = array(
	(int) 0 => array(
		'Establishment' => array(
			'id' => '11246',
			'name' => 'Gracia Maria',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Bernardo Enrique Cerezo',
			'address2' => '13',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '954191436',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.473713',
			'longitude' => '-5.643435',
			'slug' => null,
			'canonical' => 'fisioterapia/carmona/gracia-maria',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '81413032bbc2f1034085ec95d8d36e2f',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 12:27:00',
			'modified' => '2018-07-10 20:07:18',
			'sms' => null,
			'fulladdress' => 'Bernardo Enrique Cerezo, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/gracia-maria',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'FISIOTERAPIA'
		),
		(int) 0 => array(
			'distance' => '0.476451111415471'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	),
	(int) 1 => array(
		'Establishment' => array(
			'id' => '11408',
			'name' => 'Centro de Pilates Carmona ',
			'category_id' => '17',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'Calle Guadalete',
			'address2' => '30',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '637414203',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.472252',
			'longitude' => '-5.651840',
			'slug' => null,
			'canonical' => 'pilates/carmona/centro-de-pilates-carmona',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '8a1bb701bbf9676a0faa25078e02f4a1',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 13:19:00',
			'modified' => '2018-07-10 20:08:03',
			'sms' => null,
			'fulladdress' => 'Calle Guadalete, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/pilates/carmona/centro-de-pilates-carmona',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'PILATES'
		),
		(int) 0 => array(
			'distance' => '0.6387798968981186'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	),
	(int) 2 => array(
		'Establishment' => array(
			'id' => '11364',
			'name' => 'Instituto Médico de Carmona',
			'category_id' => '1',
			'establishment_type' => null,
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => null,
			'fiscalnumber' => null,
			'address1' => 'C/ SANTA ANA',
			'address2' => '31',
			'email' => '',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '619966040',
			'phone2' => '',
			'zipcode' => '41410',
			'town' => 'Carmona',
			'state' => 'Sevilla',
			'country' => 'España',
			'latitude' => '37.475224',
			'longitude' => '-5.642756',
			'slug' => null,
			'canonical' => 'fisioterapia/carmona/instituto-medico-de-carmona',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'ce1bd529fce750b8e9cf0039e25bf898',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => null,
			'plan_id' => null,
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '690',
			'bank' => null,
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-11-30 13:02:30',
			'modified' => '2018-07-10 20:07:51',
			'sms' => null,
			'fulladdress' => 'C/ SANTA ANA, Carmona ( 41410 ) , Sevilla',
			'link' => 'https://www.fisiosite.com/fisioterapia/carmona/instituto-medico-de-carmona',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Category' => array(
			'name' => 'FISIOTERAPIA'
		),
		(int) 0 => array(
			'distance' => '0.6547659285852868'
		),
		'Offer' => array(),
		'Coupon' => array(),
		'Bono' => array(),
		'Newlaunch' => array(),
		'EstablishmentsBudgetType' => array(),
		'BudgetsUser' => array(),
		'EstablishmentsRequest' => array(),
		'EstablishmentsUser' => array(),
		'EstablishmentsCategory' => array(),
		'Comment' => array(),
		'Service' => array(),
		'Staff' => array(),
		'Timetable' => array(),
		'News' => array(),
		'Slide' => array(),
		'Rating' => array(),
		'UsersSubscription' => array(),
		'Feature' => array(),
		'Specialty' => array(),
		'Insurance' => array(),
		'Users' => array(),
		'PopulationZone' => array()
	)
)
$total_bonos = (int) 7
$last_bonos = array(
	(int) 0 => array(
		'Bono' => array(
			'id' => '44',
			'establishment_id' => '12251',
			'name' => 'Bono 5 sesiones',
			'description' => '<p>Bono de 5 sesiones con un 10% de descuento.</p>',
			'num_sessions' => '5',
			'price' => '200',
			'price_old' => '225',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2019-02-28 02:02:00',
			'tag' => '',
			'image' => 'img_20190217_142642_605.jpg',
			'image_dir' => '44/33/51/15',
			'created' => '2019-02-17 17:06:53',
			'modified' => '2019-02-17 17:08:47'
		),
		'Establishment' => array(
			'id' => '12251',
			'name' => 'Fisiopraxis ',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => '<p>Centro de Servicios integrales de FISIOTERAPIA, ENTRENAMIENTO PERSONAL,&nbsp;ASESORAMIENTO NUTRICIONAL&nbsp;y PREPARACION FISICA.<br></p><p>-Tratamientos de Fisioterapia adaptados a la patología del paciente:</p><p></p><p>&nbsp; -Recuperación de lesiones</p><p>&nbsp; -Rehabilitación</p><p>&nbsp; -Terapia postural</p><p>&nbsp; -Readaptación del cuerpo</p><p>&nbsp; -Inducción Miofascial</p><p>&nbsp; -Terapia global</p><p>-En los Tratamientos referentes al Entrenamiento Personal y al Asesoramiento Nutricional, evaluamos en primera instancia el estado corporal de cada paciente.&nbsp;Realizamos una evaluación física (IMC, % de agua en el cuerpo, peso, masa grasa, masa muscular, grasa visceral y metabolismo basal saludable),con la que conseguimos&nbsp;los datos necesarios para hacer&nbsp;una estimación del consumo calórico en reposo y el necesario real&nbsp;adaptado a la vida de cada persona.En estos tratamientos, en la primera sesión,&nbsp;entregamos un plan de acción a&nbsp;4 semanas para conseguir los objetivos que nos requiera cada cliente.<br></p><p>-Nuestras recomendaciones siempre estarán enfocadas tanto en el ámbito de la recuperación corporal,&nbsp;preparación física&nbsp;y la nutrición saludable.</p>',
			'fiscalnumber' => '51073539s',
			'address1' => 'Trueba y Fernandez 16, 1D',
			'address2' => 'PROMOCION SEMANAL: VEN Y LLEVATE TU PRIMER ESTUDIO NUTRICIONAL DE FORMA GRATUITA.

Pide tu cita a cualquier hora del día cualquier día de la semana en el Tlf. 24H.(620152075).',
			'email' => 'Lucia.pascual@gmail.com',
			'fax' => null,
			'mobile' => '620152076',
			'mobile2' => null,
			'phone' => '620152076',
			'phone2' => '620152076',
			'zipcode' => '28016',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.454800',
			'longitude' => '-3.679500',
			'slug' => null,
			'canonical' => 'fisioterapia/madrid/fisiopraxis',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '6421757aee8fc8f44f16a93b2acfe8af',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5c5eed8e-4c38-4903-b7c0-ad520a3a8879',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => 'ES3502340001079015557146',
			'bank_cert' => '1360573960275006783.pdf',
			'bank_cert_dir' => '12251/79/88/01',
			'bank_cert_status' => null,
			'file_dni' => 'zip_dni.zip',
			'file_dni_dir' => '12251/54/87/23',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2019-02-09 16:19:06',
			'modified' => '2019-03-21 18:53:54',
			'sms' => null,
			'fulladdress' => 'Trueba y Fernandez 16, 1D, Madrid ( 28016 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia/madrid/fisiopraxis',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12251/79/88/01/1360573960275006783.pdf',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12251/54/87/23/zip_dni.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 1 => array(
		'Bono' => array(
			'id' => '38',
			'establishment_id' => '10174',
			'name' => 'Pack 5 sesiones de vapor (infantil)',
			'description' => '<p>

<!--StartFragment--><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><h4 class="av_iconlist_title iconlist_title  " itemprop="headline" style="display: block; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial; box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: 600; font-stretch: inherit; font-size: 18px; line-height: 1.1em; font-family: &quot;Terminal Dosis&quot;, HelveticaNeue, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; vertical-align: baseline; color: rgb(34, 34, 34); text-transform: uppercase; top: 4px; position: relative;">CALOR HÚMEDO (Vapor)</h4><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><div class="iconlist_content  " itemprop="text" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: 1.65em; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: rgb(141, 141, 141); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"><p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px rgb(225, 225, 225); font: inherit; vertical-align: baseline;">Chorro de vapor de agua de mar isotónica que actúa a nivel de las vías respiratorias altas y del oído hidratando y preparando la mucosa para los tratamientos posteriores. El vapor produce una agradable sensación de descongestión y tiene una gran acción mucolítica para ayudar a drenar la mucosidad, sobretodo en el caso de los niños.&nbsp;</p></div></p><p class="sceditor-nlf"><br></p>',
			'num_sessions' => '5',
			'price' => '81',
			'price_old' => '18',
			'status' => '0',
			'start' => null,
			'end' => '2018-11-30 02:00:00',
			'tag' => 'Pack F,Pack Vapores',
			'image' => 'nen_p.jpg',
			'image_dir' => '38/78/37/59',
			'created' => '2018-11-20 10:35:46',
			'modified' => '2018-11-20 10:35:46'
		),
		'Establishment' => array(
			'id' => '10174',
			'name' => 'BALNEARI RESPIRATORI METODE Dr. PROS',
			'category_id' => '6',
			'establishment_type' => '2',
			'image' => 'logo_br_m_dr.pros_nvcat.jpg',
			'image_dir' => '10174/86/81/02',
			'web' => 'http://balnearirespiratori.cat',
			'short_description' => 'En el centro tratamos todas las patologías de las vías respiratorias y del oído utilizando el agua de mar como herramienta terapéutica a través de vapores, nebulizaciones y duchas nasales, así como técnicas de fisioterapia para el drenaje de la mucosidad bronquial.',
			'description' => '<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2002 nació el Balneari Respiratori bajo la dirección del Dr. Miquel Pros, prestigioso médico naturista pionero en la introducción en España de las terapias procedentes de la escuela alemana de medicina naturista.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">El Dr. Pros afirma que la acumulación crónica de las mucosidades en el interior de las cavidades nasales las convierte en una zona altamente conflictiva, un foco infeccioso que puede llegar a generar más de 20 patologías respiratorias y del oído, además de afectar a otras partes de nuestro organismo, como el sistema digestivo y el sistema inmunológico. Es su&nbsp;Teoría de la Sinusitis Silenciosa.&nbsp;</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">Esta teoría lo llevó a sistematizar el uso del agua de mar para el tratamiento de las afecciones respiratorias y del oído en lo que hoy conocemos como Balneari Respiratori. A lo largo de estos 15 años y acompañado por la fisioterapeuta Núria Oliver, que actualmente dirige el centro, se ha demostrado la gran eficacia del método terapéutico del Dr. Pros, más de 6.000 pacientes han recibido los tratamientos con agua de mar.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2010 se realizó un estudio piloto con un grupo de niños de guardería de 0 a 6 años para constatar científicamente los beneficios de los tratamientos con agua de mar en niños, obteniendo unos resultados altamente satisfactorios, pues 9 de cada 10 niños y niñas mejoraron sus trastornos respiratorios respecto a su situación inicial.</p>
Alergias? Sinusitis? Oídos tapados? Dolor de garganta o de cabeza? Congestión nasal?

&nbsp;



<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Te podemos ayudar a disminuir y eliminar todos estos síntomas.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Ven y haremos una desensibilización de las mucosas respiratorias con agua de mar natural y INDIBA (hipertermia profunda). A través de nuestros tratamientos ayudamos a drenar la mucosidad estancada y disminuir la inflamación de las mucosas respiratorias.</p>

<p class="sceditor-nlf"><br></p>',
			'fiscalnumber' => '52593943G',
			'address1' => 'Carrer de Muntaner, 411',
			'address2' => '',
			'email' => 'info@balnearirespiratori.cat',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '932 11 07 95',
			'phone2' => '',
			'zipcode' => '08021',
			'town' => 'Barcelona',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.400227',
			'longitude' => '2.141209',
			'slug' => null,
			'canonical' => 'fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b15b72025c53132fa9f4d7177cf636d4',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '59d49439-e0a0-4f05-8bf9-75470a3a8836',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => 'https://www.facebook.com/balnearirespiratori/videos/vb.120248087989511/1142642909083352/?type=2&theater',
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4957',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 09:47:34',
			'modified' => '2019-09-16 13:01:21',
			'sms' => null,
			'fulladdress' => 'Carrer de Muntaner, 411, Barcelona ( 08021 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 2 => array(
		'Bono' => array(
			'id' => '32',
			'establishment_id' => '12044',
			'name' => '10 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '10',
			'price' => '450',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '32/14/58/99',
			'created' => '2018-11-09 21:17:41',
			'modified' => '2018-11-09 21:19:24'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Bono' => array(
			'id' => '29',
			'establishment_id' => '12044',
			'name' => '5 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '5',
			'price' => '237.5',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '29/68/63/77',
			'created' => '2018-11-09 21:15:55',
			'modified' => '2018-11-09 21:19:10'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	)
)
$meta_description = 'NEÚFES CENTRO DE FISIOTERAPIA en Fisiosite. FISIOTERAPIA. '
$t_avg = (int) 0
$clean_avg = (int) 3
$professionality_avg = (int) 3
$puntuality_avg = (int) 3
$quality_avg = (int) 3
$sum = array(
	'clean' => (int) 0,
	'professionality' => (int) 0,
	'puntuality' => (int) 0,
	'quality' => (int) 0,
	'total' => (int) 0
)
$divisors = array(
	'clean' => (int) 0,
	'professionality' => (int) 0,
	'puntuality' => (int) 0,
	'quality' => (int) 0,
	'total' => (int) 0
)
$chars = array(
	(int) 0 => 'clean',
	(int) 1 => 'professionality',
	(int) 2 => 'puntuality',
	(int) 3 => 'quality'
)
$notes = array(
	(int) 1 => 'A mejorar',
	(int) 2 => 'Suficiente',
	(int) 3 => 'Bien',
	(int) 4 => 'Notable',
	(int) 5 => 'Sobresaliente'
)
$note = 'Bien'
$msg = 'Sobresaliente'
$n = (int) 5
$src = '/assets/fisiosite/images/resultado-2.jpg'
include - APP/View/fisiosite/Establishments/show.ctp, line 562
View::_evaluate() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 971
View::_render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 933
View::render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 473
Controller::render() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 968
EstablishmentsController::show() - APP/Controller/EstablishmentsController.php, line 322
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 135

(default) 51 queries took 247 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url`, `Redirect`.`created`, `Redirect`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_redirects` AS `Redirect` WHERE `old_url` = 'fisioterapia/carmona/neufes-centro-de-fisioterapia' LIMIT 1	0	0	7
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`slug` = 'fisioterapia' LIMIT 1	1	1	1
3	SELECT `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` WHERE `Population`.`canonical` = 'carmona/neufes-centro-de-fisioterapia' LIMIT 1	0	0	11
4	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`hash` = '210a3fd60b69c6221568841c7714746b' LIMIT 1	1	1	1
5	SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified`, `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != '' ORDER BY `Bono`.`created` desc LIMIT 4	4	4	2
6	SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified`, `BonosService`.`id`, `BonosService`.`bono_id`, `BonosService`.`service_id` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` JOIN `bkvtdvlfisiosite`.`fisiosite_bonos_services` AS `BonosService` ON (`BonosService`.`bono_id` IN (44, 38, 32, 29) AND `BonosService`.`service_id` = `Service`.`id`)	4	4	1
7	SELECT COUNT(*) AS `count` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != ''	1	1	1
8	BEGIN	0	0	0
9	INSERT INTO `bkvtdvlfisiosite`.`fisiosite_events` (`object`, `object_id`, `user_id`, `params`, `ipaddress`, `request`, `modified`, `created`) VALUES ('page_view', '2493', NULL, 'a:7:{s:6:\"plugin\";N;s:10:\"controller\";s:14:\"establishments\";s:6:\"action\";s:4:\"show\";s:5:\"named\";a:0:{}s:4:\"pass\";a:1:{s:2:\"id\";s:4:\"2493\";}s:6:\"_Token\";a:2:{s:3:\"key\";s:128:\"2a53833e789ad06f6b9e2cd5fc71e786f3c6b210e2ee9cb3587bddf01635c5f1d8e26495c520fcc54ee7427d60da3117ed9db8abec462d40c710a14b62f23d8f\";s:14:\"unlockedFields\";a:0:{}}s:6:\"isAjax\";b:0;}', '18.97.14.89', 'fisioterapia/carmona/neufes-centro-de-fisioterapia', '2025-02-15 01:14:47', '2025-02-15 01:14:47')	1	1	1
10	COMMIT	0	0	0
11	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`id` = 2493 LIMIT 1	1	1	1
12	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght`, `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` = 2493 AND `Establishment`.`status` = 1 LIMIT 1	1	1	1
13	SELECT `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`slug`, `ParentCategory`.`description`, `ParentCategory`.`parent_id`, `ParentCategory`.`created`, `ParentCategory`.`modified`, `ParentCategory`.`lft`, `ParentCategory`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 31	1	1	1
14	SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` WHERE `Bono`.`establishment_id` = (2493)	0	0	1
15	SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` = (2493)	0	0	1
16	SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`status` IN ('', '0', '1') AND `Comment`.`object_id` = (2493) ORDER BY `created` DESC	0	0	1
17	SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` WHERE `Service`.`establishment_id` = (2493)	0	0	1
18	SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` WHERE `Staff`.`establishment_id` = (2493)	0	0	1
19	SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Establishment' AND `Timetable`.`object_id` = (2493)	0	0	1
20	SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` = 2493 AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)	0	0	1
21	SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` = 2493 AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)	0	0	1
22	SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` = 2493 AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)	0	0	1
23	SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` = 2493 AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)	0	0	3
24	SELECT AVG( Rating.value ) as average, COUNT(`Rating`.`id`) AS valoraciones FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` = '2493' GROUP BY `Rating`.`foreign_key`	0	0	5
25	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`id` = 1	1	1	1
26	SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `CategoriesSpecialty`.`id`, `CategoriesSpecialty`.`specialty_id`, `CategoriesSpecialty`.`category_id`, `CategoriesSpecialty`.`created`, `CategoriesSpecialty`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_categories_specialties` AS `CategoriesSpecialty` ON (`CategoriesSpecialty`.`category_id` = 1 AND `CategoriesSpecialty`.`specialty_id` = `Specialty`.`id`)	46	46	2
27	SELECT Establishment., Category.name, (6371 ACOS( SIN(RADIANS(latitude)) * SIN(RADIANS(37.469707)) + COS(RADIANS(longitude - -5.645351)) * COS(RADIANS(latitude)) * COS(RADIANS(37.469707)) ) ) AS distance, `Establishment`.`id` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_users` AS `User` ON (`Establishment`.`user_id` = `User`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` != 2493 GROUP BY distance HAVING distance < 20 ORDER BY `distance` ASC LIMIT 3	3	3	140
28	SELECT `Offer`.`id`, `Offer`.`establishment_id`, `Offer`.`title`, `Offer`.`image`, `Offer`.`image_dir`, `Offer`.`description`, `Offer`.`stock`, `Offer`.`requestlimit`, `Offer`.`old_price`, `Offer`.`price`, `Offer`.`type`, `Offer`.`start`, `Offer`.`end`, `Offer`.`status`, `Offer`.`tag`, `Offer`.`deleted`, `Offer`.`modified`, `Offer`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_offers` AS `Offer` WHERE `Offer`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
29	SELECT `Coupon`.`id`, `Coupon`.`establishment_id`, `Coupon`.`title`, `Coupon`.`image`, `Coupon`.`image_dir`, `Coupon`.`description`, `Coupon`.`stock`, `Coupon`.`requestlimit`, `Coupon`.`old_price`, `Coupon`.`price`, `Coupon`.`type`, `Coupon`.`start`, `Coupon`.`end`, `Coupon`.`status`, `Coupon`.`tag`, `Coupon`.`deleted`, `Coupon`.`modified`, `Coupon`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_coupons` AS `Coupon` WHERE `Coupon`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
30	SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` WHERE `Bono`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
31	SELECT `Newlaunch`.`id`, `Newlaunch`.`establishment_id`, `Newlaunch`.`name`, `Newlaunch`.`image`, `Newlaunch`.`image_dir`, `Newlaunch`.`description`, `Newlaunch`.`stock`, `Newlaunch`.`requestlimit`, `Newlaunch`.`price`, `Newlaunch`.`end`, `Newlaunch`.`status`, `Newlaunch`.`tag`, `Newlaunch`.`modified`, `Newlaunch`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_newlaunches` AS `Newlaunch` WHERE `Newlaunch`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
32	SELECT `EstablishmentsBudgetType`.`id`, `EstablishmentsBudgetType`.`budget_type_id`, `EstablishmentsBudgetType`.`establishment_id`, `EstablishmentsBudgetType`.`created`, `EstablishmentsBudgetType`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_budget_types` AS `EstablishmentsBudgetType` WHERE `EstablishmentsBudgetType`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
33	SELECT `BudgetsUser`.`id`, `BudgetsUser`.`budget_type_id`, `BudgetsUser`.`establishment_id`, `BudgetsUser`.`user_id`, `BudgetsUser`.`request`, `BudgetsUser`.`created`, `BudgetsUser`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_budgets_users` AS `BudgetsUser` WHERE `BudgetsUser`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
34	SELECT `EstablishmentsRequest`.`id`, `EstablishmentsRequest`.`establishment_id`, `EstablishmentsRequest`.`user_id`, `EstablishmentsRequest`.`email`, `EstablishmentsRequest`.`verified`, `EstablishmentsRequest`.`notes`, `EstablishmentsRequest`.`ipaddress`, `EstablishmentsRequest`.`created`, `EstablishmentsRequest`.`modified`, `EstablishmentsRequest`.`phone` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_requests` AS `EstablishmentsRequest` WHERE `EstablishmentsRequest`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
35	SELECT `EstablishmentsUser`.`id`, `EstablishmentsUser`.`establishment_id`, `EstablishmentsUser`.`user_id`, `EstablishmentsUser`.`name`, `EstablishmentsUser`.`surname`, `EstablishmentsUser`.`email`, `EstablishmentsUser`.`phone`, `EstablishmentsUser`.`phone2`, `EstablishmentsUser`.`birthday`, `EstablishmentsUser`.`nif`, `EstablishmentsUser`.`genre`, `EstablishmentsUser`.`address`, `EstablishmentsUser`.`town`, `EstablishmentsUser`.`state`, `EstablishmentsUser`.`zipcode`, `EstablishmentsUser`.`job`, `EstablishmentsUser`.`assurance`, `EstablishmentsUser`.`firm`, `EstablishmentsUser`.`firm_date`, `EstablishmentsUser`.`created`, `EstablishmentsUser`.`modified`, (CONCAT(`EstablishmentsUser`.`name`, " ", `EstablishmentsUser`.`surname`)) AS `EstablishmentsUser__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_users` AS `EstablishmentsUser` WHERE `EstablishmentsUser`.`establishment_id` IN (11246, 11408, 11364)	0	0	16
36	SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
37	SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`object` = 'establishment' AND `Comment`.`object_id` IN (11246, 11408, 11364) ORDER BY `created` DESC	0	0	1
38	SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` WHERE `Service`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
39	SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` WHERE `Staff`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
40	SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Establishment' AND `Timetable`.`object_id` IN (11246, 11408, 11364)	0	0	1
41	SELECT `News`.`id`, `News`.`user_id`, `News`.`establishment_id`, `News`.`title`, `News`.`description`, `News`.`canonical`, `News`.`image`, `News`.`image_dir`, `News`.`status`, `News`.`role`, `News`.`placement`, `News`.`created`, `News`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_news` AS `News` WHERE `News`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
42	SELECT `Slide`.`id`, `Slide`.`model`, `Slide`.`foreign_key`, `Slide`.`name`, `Slide`.`attachment`, `Slide`.`dir`, `Slide`.`type`, `Slide`.`size`, `Slide`.`active` FROM `bkvtdvlfisiosite`.`fisiosite_attachments` AS `Slide` WHERE `Slide`.`model` = 'Establishment' AND `Slide`.`foreign_key` IN (11246, 11408, 11364)	0	0	1
43	SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`foreign_key`, `Rating`.`model`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` IN (11246, 11408, 11364)	0	0	1
44	SELECT `UsersSubscription`.`id`, `UsersSubscription`.`user_id`, `UsersSubscription`.`subscription_id`, `UsersSubscription`.`establishment_id`, `UsersSubscription`.`permit`, `UsersSubscription`.`quantity` FROM `bkvtdvlfisiosite`.`fisiosite_users_subscriptions` AS `UsersSubscription` WHERE `UsersSubscription`.`establishment_id` IN (11246, 11408, 11364)	0	0	1
45	SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)	0	0	1
46	SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)	0	0	1
47	SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)	0	0	1
48	SELECT `Users`.`id`, `Users`.`name`, `Users`.`surname`, `Users`.`password`, `Users`.`password_token`, `Users`.`password_token_expires`, `Users`.`activation_token`, `Users`.`activation_token_expires`, `Users`.`activation_success`, `Users`.`phone`, `Users`.`email`, `Users`.`nif`, `Users`.`address`, `Users`.`tos`, `Users`.`active`, `Users`.`last_login`, `Users`.`last_action`, `Users`.`is_admin`, `Users`.`is_owner`, `Users`.`is_user`, `Users`.`is_staff`, `Users`.`role`, `Users`.`image`, `Users`.`image_dir`, `Users`.`provider`, `Users`.`provider_uid`, `Users`.`confirm_term`, `Users`.`created`, `Users`.`modified`, `Users`.`optin`, `Users`.`payment_gateway_id`, `Users`.`payment_profile_id`, `EstablishmentsUser`.`id`, `EstablishmentsUser`.`establishment_id`, `EstablishmentsUser`.`user_id`, `EstablishmentsUser`.`name`, `EstablishmentsUser`.`surname`, `EstablishmentsUser`.`email`, `EstablishmentsUser`.`phone`, `EstablishmentsUser`.`phone2`, `EstablishmentsUser`.`birthday`, `EstablishmentsUser`.`nif`, `EstablishmentsUser`.`genre`, `EstablishmentsUser`.`address`, `EstablishmentsUser`.`town`, `EstablishmentsUser`.`state`, `EstablishmentsUser`.`zipcode`, `EstablishmentsUser`.`job`, `EstablishmentsUser`.`assurance`, `EstablishmentsUser`.`firm`, `EstablishmentsUser`.`firm_date`, `EstablishmentsUser`.`created`, `EstablishmentsUser`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_users` AS `Users` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_users` AS `EstablishmentsUser` ON (`EstablishmentsUser`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsUser`.`user_id` = `Users`.`id`)	0	0	16
49	SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` IN (11246, 11408, 11364) AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)	0	0	1
50	SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/carmona/neufes-centro-de-fisioterapia') OR (CONCAT('/',url) = '/fisioterapia/carmona/neufes-centro-de-fisioterapia')) LIMIT 1	0	0	3
51	SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/carmona/neufes-centro-de-fisioterapia') OR (CONCAT('/',url) = '/fisioterapia/carmona/neufes-centro-de-fisioterapia')) LIMIT 1	0	0	4

(default) 51 queries took 247 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url`, `Redirect`.`created`, `Redirect`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_redirects` AS `Redirect` WHERE `old_url` = 'fisioterapia/carmona/neufes-centro-de-fisioterapia' LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`slug` = 'fisioterapia' LIMIT 1

SELECT `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` WHERE `Population`.`canonical` = 'carmona/neufes-centro-de-fisioterapia' LIMIT 1

SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`hash` = '210a3fd60b69c6221568841c7714746b' LIMIT 1

SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified`, `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != '' ORDER BY `Bono`.`created` desc LIMIT 4

SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified`, `BonosService`.`id`, `BonosService`.`bono_id`, `BonosService`.`service_id` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` JOIN `bkvtdvlfisiosite`.`fisiosite_bonos_services` AS `BonosService` ON (`BonosService`.`bono_id` IN (44, 38, 32, 29) AND `BonosService`.`service_id` = `Service`.`id`)

SELECT COUNT(*) AS `count` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != ''

BEGIN

INSERT INTO `bkvtdvlfisiosite`.`fisiosite_events` (`object`, `object_id`, `user_id`, `params`, `ipaddress`, `request`, `modified`, `created`) VALUES ('page_view', '2493', NULL, 'a:7:{s:6:\"plugin\";N;s:10:\"controller\";s:14:\"establishments\";s:6:\"action\";s:4:\"show\";s:5:\"named\";a:0:{}s:4:\"pass\";a:1:{s:2:\"id\";s:4:\"2493\";}s:6:\"_Token\";a:2:{s:3:\"key\";s:128:\"2a53833e789ad06f6b9e2cd5fc71e786f3c6b210e2ee9cb3587bddf01635c5f1d8e26495c520fcc54ee7427d60da3117ed9db8abec462d40c710a14b62f23d8f\";s:14:\"unlockedFields\";a:0:{}}s:6:\"isAjax\";b:0;}', '18.97.14.89', 'fisioterapia/carmona/neufes-centro-de-fisioterapia', '2025-02-15 01:14:47', '2025-02-15 01:14:47')

COMMIT

SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght`, `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` = 2493 AND `Establishment`.`status` = 1 LIMIT 1

SELECT `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`slug`, `ParentCategory`.`description`, `ParentCategory`.`parent_id`, `ParentCategory`.`created`, `ParentCategory`.`modified`, `ParentCategory`.`lft`, `ParentCategory`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 31

SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` = (2493)

SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`status` IN ('', '0', '1') AND `Comment`.`object_id` = (2493) ORDER BY `created` DESC

SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` WHERE `Staff`.`establishment_id` = (2493)

SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Establishment' AND `Timetable`.`object_id` = (2493)

SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` = 2493 AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)

SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` = 2493 AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)

SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` = 2493 AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)

SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` = 2493 AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)

SELECT AVG( Rating.value ) as average, COUNT(`Rating`.`id`) AS valoraciones FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` = '2493' GROUP BY `Rating`.`foreign_key`

SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `CategoriesSpecialty`.`id`, `CategoriesSpecialty`.`specialty_id`, `CategoriesSpecialty`.`category_id`, `CategoriesSpecialty`.`created`, `CategoriesSpecialty`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_categories_specialties` AS `CategoriesSpecialty` ON (`CategoriesSpecialty`.`category_id` = 1 AND `CategoriesSpecialty`.`specialty_id` = `Specialty`.`id`)

SELECT Establishment.*, Category.name, (6371 * ACOS( SIN(RADIANS(latitude)) * SIN(RADIANS(37.469707)) + COS(RADIANS(longitude - -5.645351)) * COS(RADIANS(latitude)) * COS(RADIANS(37.469707)) ) ) AS distance, `Establishment`.`id` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_users` AS `User` ON (`Establishment`.`user_id` = `User`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` != 2493 GROUP BY distance HAVING distance < 20 ORDER BY `distance` ASC LIMIT 3

140

SELECT `Offer`.`id`, `Offer`.`establishment_id`, `Offer`.`title`, `Offer`.`image`, `Offer`.`image_dir`, `Offer`.`description`, `Offer`.`stock`, `Offer`.`requestlimit`, `Offer`.`old_price`, `Offer`.`price`, `Offer`.`type`, `Offer`.`start`, `Offer`.`end`, `Offer`.`status`, `Offer`.`tag`, `Offer`.`deleted`, `Offer`.`modified`, `Offer`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_offers` AS `Offer` WHERE `Offer`.`establishment_id` IN (11246, 11408, 11364)

SELECT `Coupon`.`id`, `Coupon`.`establishment_id`, `Coupon`.`title`, `Coupon`.`image`, `Coupon`.`image_dir`, `Coupon`.`description`, `Coupon`.`stock`, `Coupon`.`requestlimit`, `Coupon`.`old_price`, `Coupon`.`price`, `Coupon`.`type`, `Coupon`.`start`, `Coupon`.`end`, `Coupon`.`status`, `Coupon`.`tag`, `Coupon`.`deleted`, `Coupon`.`modified`, `Coupon`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_coupons` AS `Coupon` WHERE `Coupon`.`establishment_id` IN (11246, 11408, 11364)

SELECT `Newlaunch`.`id`, `Newlaunch`.`establishment_id`, `Newlaunch`.`name`, `Newlaunch`.`image`, `Newlaunch`.`image_dir`, `Newlaunch`.`description`, `Newlaunch`.`stock`, `Newlaunch`.`requestlimit`, `Newlaunch`.`price`, `Newlaunch`.`end`, `Newlaunch`.`status`, `Newlaunch`.`tag`, `Newlaunch`.`modified`, `Newlaunch`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_newlaunches` AS `Newlaunch` WHERE `Newlaunch`.`establishment_id` IN (11246, 11408, 11364)

SELECT `EstablishmentsBudgetType`.`id`, `EstablishmentsBudgetType`.`budget_type_id`, `EstablishmentsBudgetType`.`establishment_id`, `EstablishmentsBudgetType`.`created`, `EstablishmentsBudgetType`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_budget_types` AS `EstablishmentsBudgetType` WHERE `EstablishmentsBudgetType`.`establishment_id` IN (11246, 11408, 11364)

SELECT `BudgetsUser`.`id`, `BudgetsUser`.`budget_type_id`, `BudgetsUser`.`establishment_id`, `BudgetsUser`.`user_id`, `BudgetsUser`.`request`, `BudgetsUser`.`created`, `BudgetsUser`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_budgets_users` AS `BudgetsUser` WHERE `BudgetsUser`.`establishment_id` IN (11246, 11408, 11364)

SELECT `EstablishmentsRequest`.`id`, `EstablishmentsRequest`.`establishment_id`, `EstablishmentsRequest`.`user_id`, `EstablishmentsRequest`.`email`, `EstablishmentsRequest`.`verified`, `EstablishmentsRequest`.`notes`, `EstablishmentsRequest`.`ipaddress`, `EstablishmentsRequest`.`created`, `EstablishmentsRequest`.`modified`, `EstablishmentsRequest`.`phone` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_requests` AS `EstablishmentsRequest` WHERE `EstablishmentsRequest`.`establishment_id` IN (11246, 11408, 11364)

SELECT `EstablishmentsUser`.`id`, `EstablishmentsUser`.`establishment_id`, `EstablishmentsUser`.`user_id`, `EstablishmentsUser`.`name`, `EstablishmentsUser`.`surname`, `EstablishmentsUser`.`email`, `EstablishmentsUser`.`phone`, `EstablishmentsUser`.`phone2`, `EstablishmentsUser`.`birthday`, `EstablishmentsUser`.`nif`, `EstablishmentsUser`.`genre`, `EstablishmentsUser`.`address`, `EstablishmentsUser`.`town`, `EstablishmentsUser`.`state`, `EstablishmentsUser`.`zipcode`, `EstablishmentsUser`.`job`, `EstablishmentsUser`.`assurance`, `EstablishmentsUser`.`firm`, `EstablishmentsUser`.`firm_date`, `EstablishmentsUser`.`created`, `EstablishmentsUser`.`modified`, (CONCAT(`EstablishmentsUser`.`name`, " ", `EstablishmentsUser`.`surname`)) AS `EstablishmentsUser__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_users` AS `EstablishmentsUser` WHERE `EstablishmentsUser`.`establishment_id` IN (11246, 11408, 11364)

SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`object` = 'establishment' AND `Comment`.`object_id` IN (11246, 11408, 11364) ORDER BY `created` DESC

SELECT `News`.`id`, `News`.`user_id`, `News`.`establishment_id`, `News`.`title`, `News`.`description`, `News`.`canonical`, `News`.`image`, `News`.`image_dir`, `News`.`status`, `News`.`role`, `News`.`placement`, `News`.`created`, `News`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_news` AS `News` WHERE `News`.`establishment_id` IN (11246, 11408, 11364)

SELECT `Slide`.`id`, `Slide`.`model`, `Slide`.`foreign_key`, `Slide`.`name`, `Slide`.`attachment`, `Slide`.`dir`, `Slide`.`type`, `Slide`.`size`, `Slide`.`active` FROM `bkvtdvlfisiosite`.`fisiosite_attachments` AS `Slide` WHERE `Slide`.`model` = 'Establishment' AND `Slide`.`foreign_key` IN (11246, 11408, 11364)

SELECT `Rating`.`id`, `Rating`.`user_id`, `Rating`.`foreign_key`, `Rating`.`model`, `Rating`.`value`, `Rating`.`created`, `Rating`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` IN (11246, 11408, 11364)

SELECT `UsersSubscription`.`id`, `UsersSubscription`.`user_id`, `UsersSubscription`.`subscription_id`, `UsersSubscription`.`establishment_id`, `UsersSubscription`.`permit`, `UsersSubscription`.`quantity` FROM `bkvtdvlfisiosite`.`fisiosite_users_subscriptions` AS `UsersSubscription` WHERE `UsersSubscription`.`establishment_id` IN (11246, 11408, 11364)

SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)

SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)

SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)

SELECT `Users`.`id`, `Users`.`name`, `Users`.`surname`, `Users`.`password`, `Users`.`password_token`, `Users`.`password_token_expires`, `Users`.`activation_token`, `Users`.`activation_token_expires`, `Users`.`activation_success`, `Users`.`phone`, `Users`.`email`, `Users`.`nif`, `Users`.`address`, `Users`.`tos`, `Users`.`active`, `Users`.`last_login`, `Users`.`last_action`, `Users`.`is_admin`, `Users`.`is_owner`, `Users`.`is_user`, `Users`.`is_staff`, `Users`.`role`, `Users`.`image`, `Users`.`image_dir`, `Users`.`provider`, `Users`.`provider_uid`, `Users`.`confirm_term`, `Users`.`created`, `Users`.`modified`, `Users`.`optin`, `Users`.`payment_gateway_id`, `Users`.`payment_profile_id`, `EstablishmentsUser`.`id`, `EstablishmentsUser`.`establishment_id`, `EstablishmentsUser`.`user_id`, `EstablishmentsUser`.`name`, `EstablishmentsUser`.`surname`, `EstablishmentsUser`.`email`, `EstablishmentsUser`.`phone`, `EstablishmentsUser`.`phone2`, `EstablishmentsUser`.`birthday`, `EstablishmentsUser`.`nif`, `EstablishmentsUser`.`genre`, `EstablishmentsUser`.`address`, `EstablishmentsUser`.`town`, `EstablishmentsUser`.`state`, `EstablishmentsUser`.`zipcode`, `EstablishmentsUser`.`job`, `EstablishmentsUser`.`assurance`, `EstablishmentsUser`.`firm`, `EstablishmentsUser`.`firm_date`, `EstablishmentsUser`.`created`, `EstablishmentsUser`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_users` AS `Users` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_users` AS `EstablishmentsUser` ON (`EstablishmentsUser`.`establishment_id` IN (11246, 11408, 11364) AND `EstablishmentsUser`.`user_id` = `Users`.`id`)

SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` IN (11246, 11408, 11364) AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)

SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/carmona/neufes-centro-de-fisioterapia') OR (CONCAT('/',url) = '/fisioterapia/carmona/neufes-centro-de-fisioterapia')) LIMIT 1

NEÚFES CENTRO DE FISIOTERAPIA

Nuestros Partners