A. Casco, Ferro General Pico - Ferro General Pico

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

5,897,000 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Player / Images )	1.3155
Total Execution Time	1.3167

CADENA URL

/fotos/jugador/A-Casco-805928

GET DATOS

$_GET['/fotos/jugador/A-Casco-805928']

POST DATOS

No hay datos POST existentes

CONSULTAS (80)

0.0008	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` = '805928'
0.0155	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 = 'A-Casco-805928' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0348	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 = 'A-Casco-805928' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0157	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 = 61892
0.0172	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 = 60280
0.0172	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 = 59657
0.0158	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 = 49952
0.0151	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 = 50798
0.0152	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 = 60160
0.0151	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 = 60198
0.0152	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 = 61076
0.0151	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 = 55626
0.0155	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 = 43555
0.0159	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 = 48466
0.0162	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 = 48479
0.0159	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 = 49304
0.0146	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 = '805928'
0.0152	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 = 805928 ORDER BY rp.year DESC
0.0150	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 = '805928' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24
0.0149	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 = '805928' and rp.type = 3
0.0151	SELECT e.* FROM `events2021` e WHERE e.player_id = 805928 AND league_id = 61892 ORDER BY e.date ASC
0.0152	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61892 AND rel.player_id=805928
0.0150	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 61892 AND action = 18
0.0148	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 61892 AND action = 19
0.0145	SELECT e.* FROM `events2021` e WHERE e.player_id = 805928 AND league_id = 60280 ORDER BY e.date ASC
0.0145	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60280 AND rel.player_id=805928
0.0145	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 60280 AND action = 18
0.0145	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 60280 AND action = 19
0.0145	SELECT e.* FROM `events2021` e WHERE e.player_id = 805928 AND league_id = 59657 ORDER BY e.date ASC
0.0146	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 59657 AND rel.player_id=805928
0.0145	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 59657 AND action = 18
0.0148	SELECT action,minute FROM events2021 WHERE player_id = 805928 AND league_id = 59657 AND action = 19
0.0150	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 49952 ORDER BY e.date ASC
0.0151	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49952 AND rel.player_id=805928
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 49952 AND action = 18
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 49952 AND action = 19
0.0148	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 50672 ORDER BY e.date ASC
0.0152	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50672 AND rel.player_id=805928
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50672 AND action = 18
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50672 AND action = 19
0.0145	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 50673 ORDER BY e.date ASC
0.0145	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50673 AND rel.player_id=805928
0.0145	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50673 AND action = 18
0.0148	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50673 AND action = 19
0.0148	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 50798 ORDER BY e.date ASC
0.0149	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50798 AND rel.player_id=805928
0.0153	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50798 AND action = 18
0.0151	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 50798 AND action = 19
0.0150	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 60160 ORDER BY e.date ASC
0.0147	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60160 AND rel.player_id=805928
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 60160 AND action = 18
0.0147	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 60160 AND action = 19
0.0151	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 60198 ORDER BY e.date ASC
0.0150	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60198 AND rel.player_id=805928
0.0150	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 60198 AND action = 18
0.0150	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 60198 AND action = 19
0.0152	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 61076 ORDER BY e.date ASC
0.0147	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61076 AND rel.player_id=805928
0.0146	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 61076 AND action = 18
0.0145	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 61076 AND action = 19
0.0146	SELECT e.* FROM `events2020` e WHERE e.player_id = 805928 AND league_id = 55626 ORDER BY e.date ASC
0.0149	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55626 AND rel.player_id=805928
0.0149	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 55626 AND action = 18
0.0151	SELECT action,minute FROM events2020 WHERE player_id = 805928 AND league_id = 55626 AND action = 19
0.0149	SELECT e.* FROM `events2019` e WHERE e.player_id = 805928 AND league_id = 43555 ORDER BY e.date ASC
0.0154	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43555 AND rel.player_id=805928
0.0150	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 43555 AND action = 18
0.0151	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 43555 AND action = 19
0.0150	SELECT e.* FROM `events2019` e WHERE e.player_id = 805928 AND league_id = 48466 ORDER BY e.date ASC
0.0150	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48466 AND rel.player_id=805928
0.0146	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 48466 AND action = 18
0.0146	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 48466 AND action = 19
0.0147	SELECT e.* FROM `events2019` e WHERE e.player_id = 805928 AND league_id = 48479 ORDER BY e.date ASC
0.0147	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48479 AND rel.player_id=805928
0.0145	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 48479 AND action = 18
0.0145	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 48479 AND action = 19
0.0145	SELECT e.* FROM `events2019` e WHERE e.player_id = 805928 AND league_id = 49304 ORDER BY e.date ASC
0.0146	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49304 AND rel.player_id=805928
0.0145	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 49304 AND action = 18
0.0145	SELECT action,minute FROM events2019 WHERE player_id = 805928 AND league_id = 49304 AND action = 19

Ferro General Pico

A. Casco2020/2021

Subir imagen de A. Casco


	¡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: