D. Zamora, Real Cartagena - Real Cartagena

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,829,976 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Player / Images )	0.1994
Total Execution Time	0.2006

CADENA URL

/fotos/jugador/D-Zamora-386740

GET DATOS

$_GET['/fotos/jugador/D-Zamora-386740']

POST DATOS

No hay datos POST existentes

CONSULTAS (79)

0.0003	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` = '386740'
0.0024	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 = 'D-Zamora-386740' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0074	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 = 'D-Zamora-386740' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0024	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 = 66308
0.0024	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 = 60997
0.0023	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 = 63326
0.0023	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 = 55386
0.0023	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 = 60100
0.0023	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 = 48673
0.0024	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 = 48784
0.0024	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 = 42552
0.0024	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 = 46940
0.0024	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 = 42555
0.0025	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 = 38746
0.0024	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 = 41242
0.0018	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 = '386740'
0.0021	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 = 386740 ORDER BY rp.year DESC
0.0019	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 = '386740' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24
0.0019	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 = '386740' and rp.type = 3
0.0019	SELECT e.* FROM `events2022` e WHERE e.player_id = 386740 AND league_id = 66308 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66308 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2022 WHERE player_id = 386740 AND league_id = 66308 AND action = 18
0.0018	SELECT action,minute FROM events2022 WHERE player_id = 386740 AND league_id = 66308 AND action = 19
0.0018	SELECT e.* FROM `events2022` e WHERE e.player_id = 386740 AND league_id = 66316 ORDER BY e.date ASC
0.0025	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66316 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2022 WHERE player_id = 386740 AND league_id = 66316 AND action = 18
0.0018	SELECT action,minute FROM events2022 WHERE player_id = 386740 AND league_id = 66316 AND action = 19
0.0019	SELECT e.* FROM `events2021` e WHERE e.player_id = 386740 AND league_id = 60997 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60997 AND rel.player_id=386740
0.0024	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 60997 AND action = 18
0.0023	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 60997 AND action = 19
0.0019	SELECT e.* FROM `events2021` e WHERE e.player_id = 386740 AND league_id = 63326 ORDER BY e.date ASC
0.0030	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 63326 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 63326 AND action = 18
0.0018	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 63326 AND action = 19
0.0019	SELECT e.* FROM `events2021` e WHERE e.player_id = 386740 AND league_id = 61682 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61682 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 61682 AND action = 18
0.0019	SELECT action,minute FROM events2021 WHERE player_id = 386740 AND league_id = 61682 AND action = 19
0.0020	SELECT e.* FROM `events2020` e WHERE e.player_id = 386740 AND league_id = 55386 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 55386 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2020 WHERE player_id = 386740 AND league_id = 55386 AND action = 18
0.0019	SELECT action,minute FROM events2020 WHERE player_id = 386740 AND league_id = 55386 AND action = 19
0.0020	SELECT e.* FROM `events2020` e WHERE e.player_id = 386740 AND league_id = 60100 ORDER BY e.date ASC
0.0028	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60100 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2020 WHERE player_id = 386740 AND league_id = 60100 AND action = 18
0.0019	SELECT action,minute FROM events2020 WHERE player_id = 386740 AND league_id = 60100 AND action = 19
0.0020	SELECT e.* FROM `events2019` e WHERE e.player_id = 386740 AND league_id = 48673 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48673 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 48673 AND action = 18
0.0019	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 48673 AND action = 19
0.0019	SELECT e.* FROM `events2019` e WHERE e.player_id = 386740 AND league_id = 43475 ORDER BY e.date ASC
0.0024	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43475 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 43475 AND action = 18
0.0017	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 43475 AND action = 19
0.0018	SELECT e.* FROM `events2019` e WHERE e.player_id = 386740 AND league_id = 48784 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48784 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 48784 AND action = 18
0.0018	SELECT action,minute FROM events2019 WHERE player_id = 386740 AND league_id = 48784 AND action = 19
0.0018	SELECT e.* FROM `events2018` e WHERE e.player_id = 386740 AND league_id = 42552 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42552 AND rel.player_id=386740
0.0019	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 42552 AND action = 18
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 42552 AND action = 19
0.0019	SELECT e.* FROM `events2018` e WHERE e.player_id = 386740 AND league_id = 46940 ORDER BY e.date ASC
0.0020	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 46940 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 46940 AND action = 18
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 46940 AND action = 19
0.0019	SELECT e.* FROM `events2018` e WHERE e.player_id = 386740 AND league_id = 42555 ORDER BY e.date ASC
0.0021	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42555 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 42555 AND action = 18
0.0018	SELECT action,minute FROM events2018 WHERE player_id = 386740 AND league_id = 42555 AND action = 19
0.0019	SELECT e.* FROM `events2017` e WHERE e.player_id = 386740 AND league_id = 38746 ORDER BY e.date ASC
0.0019	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38746 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2017 WHERE player_id = 386740 AND league_id = 38746 AND action = 18
0.0018	SELECT action,minute FROM events2017 WHERE player_id = 386740 AND league_id = 38746 AND action = 19
0.0018	SELECT e.* FROM `events2017` e WHERE e.player_id = 386740 AND league_id = 41242 ORDER BY e.date ASC
0.0020	SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41242 AND rel.player_id=386740
0.0018	SELECT action,minute FROM events2017 WHERE player_id = 386740 AND league_id = 41242 AND action = 18
0.0018	SELECT action,minute FROM events2017 WHERE player_id = 386740 AND league_id = 41242 AND action = 19

Real Cartagena

D. Zamora2021/2022

Subir imagen de D. Zamora


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