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

Centro Fisioterapia Serrano

FISIOTERAPIA, FISIOTERAPIA EN LA ACTIVIDAD FISICA Y DEPORTE, FISIOTERAPIA GERIÁTRICA, OSTEOPATIA, PILATES, FISIOTERAPIA UROGINECOLÓGICA, FISIOTERAPIA TRAUMATOLOGICA
Madrid, Madrid  
- / 5
Opiniones (0)
-
PEDIR CITA
Información

Nuestra clínica tiene como objetivo proporcionar a los pacientes técnicas de tratamiento basadas en la evidencia científica con el fin de realizar una fisioterapia de calidad. Ayudamos a los pacientes con lesiones músculo-esqueléticas a disminuir el dolor y a trabajar en la etiología del problema, con el fin de que la lesión interfiera lo menos posible en su calidad de vida. Para ello utilizamos técnicas basadas en el ejercicio terapéutico y terapia manual, todo ello desde un paradigma biopsicosocial. 

Por otra parte, nuestro centro está especializado en la mujer. El departamento médico es experto en nutrición, sexología y anti-envejecimiento, por tanto muchos de los tratamientos de fisioterapia están enfocados en la mujer. Realizamos tratamientos de drenaje linfático + ejercicio terapéutico con el fin de complementar dietas pautadas, así como preparación del suelo pélvico durante y después de los embarazos. Los ejercicios del suelo pélvico protegen la cavidad pélvica de futuras complicaciones como puede ser la incontinencia urinaria. 

Profesionales que prestan servicio
Sandra Esteban Nº Colegiado: -
Experiencia -
Formación Fisioterapeuta

Cristina Perez Nº Colegiado: -
Experiencia -
Formación Fisioterapeuta y Osteópata

Pablo Garcia Nº Colegiado: -
Experiencia -
Formación Fisioterapeuta

ruben iturrarte Nº Colegiado: 11456
Experiencia clinica el escorial
Formación fisioterapeuta

Vanessa Luna Rodirguez Nº Colegiado: 12157
Experiencia -
Formación Fisioterapeuta y Osteopata

Servicios
Fisioterapia 35€

Tratamiento de fisioterapia general, drenaje linfático y suelo pélvico.


Tratamiento drenaje linfático40€

El drenaje linfático manual es una técnica de fisioterapia que consiste en suaves deslizamientos aplicados sobre determinadas zonas y siguiendo un orden específico, con el fin de conducir la linfa a la zona idónea.


Fisioterapia Suelo pélvico50€

La fisioterapia uroginecológica es una especialidad enfocada en el tratamiento de las disfunciones del suelo pélvico


Fisioterapia respiratoria35€

Fisioterapia respiratoria


Fisioterapia y Osteopatía50€

Sesión de fisioterapia y osteopatía completa


Fisioterapia45€

sesion de 50 minutos


fisioterapia pediatrica60€

fisioterapia para bebes


fisioterapia deportiva25€

fisioterapia deportiva


Fisioterapia Pediátrica30€

Tratamiento de fisioterapia para recién nacidos. Cólicos lactante, bronquiolitis y muchas más patologías


EPICONDILITIS45€

tratamiento lesión codo de tenista


fisioterapia rugby50€

sadasd


Este establecimiento aún no tiene valoración ¡Puedes ser el primero en valorar!
Limpieza
Profesional
Puntualidad
Calidad / Precio

Inicia sesión

Reserva tu cita
Elige el día para tu cita
Horario
LunesDe 9:00 a 14:00, 17:00 a 19:00
MartesDe 9:00 a 18:00, 20:00 a 21:00
MiercolesDe 9:00 a 18:00
JuevesDe 9:00 a 18:00
ViernesDe 9:00 a 18:00
SábadoCerrado
DomingoCerrado
Centro Fisioterapia Serrano Madrid, Madrid
Notice (8): Undefined variable: News [APP/View/Elements/Fisiosite/commons/news_slide.ctp, line 11]
Neuromodulación en vejiga hiperactiva Ver noticia

La cita será cargada al metodo de pago seleccionado.

Confirmar el pago con tarjeta

(default) 61 queries took 190 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url`, `Redirect`.`created`, `Redirect`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_redirects` AS `Redirect` WHERE `old_url` = 'fisioterapia/madrid/centro-fisioterapia-serrano' LIMIT 1008
2SELECT `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 1111
3SELECT `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` = 'madrid/centro-fisioterapia-serrano' LIMIT 1006
4SELECT `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` = 'fd9d4ae034586935452ae0b6ca9f78cf' LIMIT 1111
5SELECT `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 4441
6SELECT `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`) 441
7SELECT 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` != ''111
8BEGIN000
9INSERT INTO `bkvtdvlfisiosite`.`fisiosite_events` (`object`, `object_id`, `user_id`, `params`, `ipaddress`, `request`, `modified`, `created`) VALUES ('page_view', '8499', 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:\"8499\";}s:6:\"_Token\";a:2:{s:3:\"key\";s:128:\"72361ddbf4122108a26dbb5e41ad1bd66747339d5454901a98006eac0aa08de047c4c651cfe310c628f91c0940095eae51a89647ef8f54a446cbc84bfae4ee23\";s:14:\"unlockedFields\";a:0:{}}s:6:\"isAjax\";b:0;}', '18.97.14.89', 'fisioterapia/madrid/centro-fisioterapia-serrano', '2025-03-21 21:01:12', '2025-03-21 21:01:12')111
10COMMIT000
11SELECT `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` = 8499 LIMIT 1111
12SELECT `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` = 8499 AND `Establishment`.`status` = 1 LIMIT 1112
13SELECT `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` = 31110
14SELECT `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` = (8499)001
15SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` = (8499)661
16SELECT `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` = (8499) ORDER BY `created` DESC001
17SELECT `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` = (8499)11112
18SELECT `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` = 'Service' AND `Timetable`.`object_id` IN (23, 129, 130, 134, 141, 145, 380, 383, 452, 455, 477)62621
19SELECT `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`, `ServicesStaff`.`id`, `ServicesStaff`.`service_id`, `ServicesStaff`.`staff_id`, `ServicesStaff`.`created`, `ServicesStaff`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` JOIN `bkvtdvlfisiosite`.`fisiosite_services_staffs` AS `ServicesStaff` ON (`ServicesStaff`.`service_id` IN (23, 129, 130, 134, 141, 145, 380, 383, 452, 455, 477) AND `ServicesStaff`.`staff_id` = `Staff`.`id`) 46461
20SELECT `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` = (8499)551
21SELECT `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` = (8499)771
22SELECT `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`.`status` = '1' AND `News`.`establishment_id` = (8499)111
23SELECT `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` = (8499)221
24SELECT `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` = 8499 AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`) 221
25SELECT `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` = 8499 AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`) 991
26SELECT `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` = 8499 AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`) 331
27SELECT `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` = 8499 AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`) 001
28SELECT `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` = 4 LIMIT 1111
29SELECT `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` = 8 LIMIT 1110
30SELECT `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` = 14 LIMIT 1110
31SELECT `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` = 17 LIMIT 1110
32SELECT `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` = 18 LIMIT 1110
33SELECT `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` = 20 LIMIT 1110
34SELECT AVG( Rating.value ) as average, COUNT(`Rating`.`id`) AS valoraciones FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` = '8499' GROUP BY `Rating`.`foreign_key`111
35SELECT `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` = 1111
36SELECT `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`) 46461
37SELECT Establishment.*, Category.name, (6371 * ACOS( SIN(RADIANS(latitude)) * SIN(RADIANS(40.454441)) + COS(RADIANS(longitude - -3.678469)) * COS(RADIANS(latitude)) * COS(RADIANS(40.454441)) ) ) 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` != 8499 GROUP BY distance HAVING distance < 20 ORDER BY `distance` ASC LIMIT 33394
38SELECT `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 (12251, 7872, 8000)001
39SELECT `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 (12251, 7872, 8000)001
40SELECT `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 (12251, 7872, 8000)111
41SELECT `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 (12251, 7872, 8000)001
42SELECT `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 (12251, 7872, 8000)001
43SELECT `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 (12251, 7872, 8000)001
44SELECT `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 (12251, 7872, 8000)001
45SELECT `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 (12251, 7872, 8000)7714
46SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` IN (12251, 7872, 8000)441
47SELECT `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 (12251, 7872, 8000) ORDER BY `created` DESC001
48SELECT `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 (12251, 7872, 8000)441
49SELECT `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 (12251, 7872, 8000)221
50SELECT `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 (12251, 7872, 8000)771
51SELECT `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 (12251, 7872, 8000)001
52SELECT `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 (12251, 7872, 8000)111
53SELECT `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 (12251, 7872, 8000)001
54SELECT `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 (12251, 7872, 8000)001
55SELECT `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 (12251, 7872, 8000) AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`) 001
56SELECT `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 (12251, 7872, 8000) AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`) 43431
57SELECT `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 (12251, 7872, 8000) AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`) 001
58SELECT `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 (12251, 7872, 8000) AND `EstablishmentsUser`.`user_id` = `Users`.`id`) 3313
59SELECT `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 (12251, 7872, 8000) AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`) 111
60SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/madrid/centro-fisioterapia-serrano') OR (CONCAT('/',url) = '/fisioterapia/madrid/centro-fisioterapia-serrano')) LIMIT 1004
61SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/madrid/centro-fisioterapia-serrano') OR (CONCAT('/',url) = '/fisioterapia/madrid/centro-fisioterapia-serrano')) LIMIT 1003