Clínicas de fisioterapia en Orotava (La)

No se encontraron clínicas

Ver filtros Ver mapa
Elige municipio
¿Dónde quieres tu cita?
¿Tipo de especialidad?
Por precio
No se encontraron establecimientos con los filtros utilizados
(default) 8 queries took 28 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/orotava-la' LIMIT 10011
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_town` = 'orotava-la' LIMIT 1111
4SELECT `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`.`parent_id` > 013131
5SELECT `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) LIMIT 1112
6SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE `url` = '/fisioterapia/orotava-la' LIMIT 1112
7SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/orotava-la') OR (CONCAT('/',url) = '/fisioterapia/orotava-la')) LIMIT 1006
8SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/orotava-la') OR (CONCAT('/',url) = '/fisioterapia/orotava-la')) LIMIT 1004