Castillo, CD Pozoblanco - CD Pozoblanco

Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

USO DE MEMORIA

6,188,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Player / Images )	0.8847
Total Execution Time	0.8861

CADENA URL

/fotos/jugador/Castillo-109982

GET DATOS

$_GET['/fotos/jugador/Castillo-109982']

POST DATOS

No hay datos POST existentes

CONSULTAS (70)

0.0005	SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '109982'
0.0112	SELECT p.,rp.,dt.,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM* `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'Castillo-109982' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0241	SELECT p.,rp.,dt.,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM* `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'Castillo-109982' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0111	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 58589
0.0111	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 50270
0.0112	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 33352
0.0112	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 15443
0.0113	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 2552
0.0112	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1943
0.0114	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1399
0.0114	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1113
0.0105	SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '109982'
0.0108	SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 109982 ORDER BY rp.year DESC
0.0107	SELECT p.title,p.totalcomments,p.downloads,p.views,p.id,p.author_id FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '109982' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24
0.0106	SELECT COUNT(DISTINCT(p.id)) as total FROM `pictures` p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '109982' and rp.type = 3
0.0106	SELECT e.* FROM `events2023` e WHERE e.player_id = 109982 AND league_id = 67320 ORDER BY e.date ASC
0.0122	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 67320 AND rel.player_id=109982
0.0106	SELECT action,minute FROM events2023 WHERE player_id = 109982 AND league_id = 67320 AND action = 18
0.0106	SELECT action,minute FROM events2023 WHERE player_id = 109982 AND league_id = 67320 AND action = 19
0.0107	SELECT e.* FROM `events2021` e WHERE e.player_id = 109982 AND league_id = 58589 ORDER BY e.date ASC
0.0132	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58589 AND rel.player_id=109982
0.0109	SELECT action,minute FROM events2021 WHERE player_id = 109982 AND league_id = 58589 AND action = 18
0.0110	SELECT action,minute FROM events2021 WHERE player_id = 109982 AND league_id = 58589 AND action = 19
0.0106	SELECT e.* FROM `events2020` e WHERE e.player_id = 109982 AND league_id = 50270 ORDER BY e.date ASC
0.0121	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50270 AND rel.player_id=109982
0.0105	SELECT action,minute FROM events2020 WHERE player_id = 109982 AND league_id = 50270 AND action = 18
0.0106	SELECT action,minute FROM events2020 WHERE player_id = 109982 AND league_id = 50270 AND action = 19
0.0107	SELECT e.* FROM `events2019` e WHERE e.player_id = 109982 AND league_id = 44390 ORDER BY e.date ASC
0.0128	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44390 AND rel.player_id=109982
0.0109	SELECT action,minute FROM events2019 WHERE player_id = 109982 AND league_id = 44390 AND action = 18
0.0109	SELECT action,minute FROM events2019 WHERE player_id = 109982 AND league_id = 44390 AND action = 19
0.0109	SELECT e.* FROM `events2018` e WHERE e.player_id = 109982 AND league_id = 39026 ORDER BY e.date ASC
0.0125	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39026 AND rel.player_id=109982
0.0111	SELECT action,minute FROM events2018 WHERE player_id = 109982 AND league_id = 39026 AND action = 18
0.0111	SELECT action,minute FROM events2018 WHERE player_id = 109982 AND league_id = 39026 AND action = 19
0.0108	SELECT e.* FROM `events2017` e WHERE e.player_id = 109982 AND league_id = 33352 ORDER BY e.date ASC
0.0118	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33352 AND rel.player_id=109982
0.0108	SELECT action,minute FROM events2017 WHERE player_id = 109982 AND league_id = 33352 AND action = 18
0.0108	SELECT action,minute FROM events2017 WHERE player_id = 109982 AND league_id = 33352 AND action = 19
0.0107	SELECT e.* FROM `events2016` e WHERE e.player_id = 109982 AND league_id = 15443 ORDER BY e.date ASC
0.0120	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15443 AND rel.player_id=109982
0.0108	SELECT action,minute FROM events2016 WHERE player_id = 109982 AND league_id = 15443 AND action = 18
0.0107	SELECT action,minute FROM events2016 WHERE player_id = 109982 AND league_id = 15443 AND action = 19
0.0120	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15443 AND rel.player_id=109982
0.0107	SELECT action,minute FROM events2016 WHERE player_id = 109982 AND league_id = 15443 AND action = 18
0.0109	SELECT action,minute FROM events2016 WHERE player_id = 109982 AND league_id = 15443 AND action = 19
0.0107	SELECT e.* FROM `events2015` e WHERE e.player_id = 109982 AND league_id = 3912 ORDER BY e.date ASC
0.0118	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3912 AND rel.player_id=109982
0.0107	SELECT action,minute FROM events2015 WHERE player_id = 109982 AND league_id = 3912 AND action = 18
0.0108	SELECT action,minute FROM events2015 WHERE player_id = 109982 AND league_id = 3912 AND action = 19
0.0110	SELECT e.* FROM `events2014` e WHERE e.player_id = 109982 AND league_id = 2552 ORDER BY e.date ASC
0.0166	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2552 AND rel.player_id=109982
0.0121	SELECT action,minute FROM events2014 WHERE player_id = 109982 AND league_id = 2552 AND action = 18
0.0112	SELECT action,minute FROM events2014 WHERE player_id = 109982 AND league_id = 2552 AND action = 19
0.0109	SELECT e.* FROM `events2013` e WHERE e.player_id = 109982 AND league_id = 1943 ORDER BY e.date ASC
0.0123	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1943 AND rel.player_id=109982
0.0109	SELECT action,minute FROM events2013 WHERE player_id = 109982 AND league_id = 1943 AND action = 18
0.0107	SELECT action,minute FROM events2013 WHERE player_id = 109982 AND league_id = 1943 AND action = 19
0.0110	SELECT e.* FROM `events2012` e WHERE e.player_id = 109982 AND league_id = 1399 ORDER BY e.date ASC
0.0130	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1399 AND rel.player_id=109982
0.0112	SELECT action,minute FROM events2012 WHERE player_id = 109982 AND league_id = 1399 AND action = 18
0.0110	SELECT action,minute FROM events2012 WHERE player_id = 109982 AND league_id = 1399 AND action = 19
0.0114	SELECT e.* FROM `events2011` e WHERE e.player_id = 109982 AND league_id = 1113 ORDER BY e.date ASC
0.0117	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1113 AND rel.player_id=109982
0.0112	SELECT action,minute FROM events2011 WHERE player_id = 109982 AND league_id = 1113 AND action = 18
0.0116	SELECT action,minute FROM events2011 WHERE player_id = 109982 AND league_id = 1113 AND action = 19
0.0110	SELECT e.* FROM `events2011` e WHERE e.player_id = 109982 AND league_id = 1276 ORDER BY e.date ASC
0.0110	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1276 AND rel.player_id=109982
0.0106	SELECT action,minute FROM events2011 WHERE player_id = 109982 AND league_id = 1276 AND action = 18
0.0106	SELECT action,minute FROM events2011 WHERE player_id = 109982 AND league_id = 1276 AND action = 19

CD Pozoblanco

Castillo2022/2023

Subir imagen de Castillo


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra: