№ |
Team
|
Wins | DRAW | Lost | GD | Goals score | Goals conceded | Points |
---|---|---|---|---|---|---|---|---|
1 | BM MONTEQUINTO | 5 | 0 | 0 | 46 | 147 | 101 | 10 |
2 | CAJASUR CÓRDOBA DE BALONMANO | 4 | 0 | 1 | 21 | 134 | 113 | 8 |
3 | INNOVAMED LA SALLE | 2 | 0 | 3 | -7 | 117 | 124 | 4 |
4 | BM CIUDAD DE ALGECIRAS JM | 2 | 0 | 3 | -12 | 118 | 130 | 4 |
5 | BM LOS DOLMENES | 2 | 0 | 3 | -13 | 123 | 136 | 4 |
6 | HINOJOSA ESTR. ARS PALMA DEL RIO | 0 | 0 | 5 | -35 | 115 | 150 | 0 |
¡¡¡ HAZ CLIC EN EL EQUIPO PARA VER SUS RESULTADOS !!!
|
El Ubago perdió 34-18 en un partido ante un rival mas rodado, mas trabajado y que en todo momento supero a los nuestros en todas las facetas del juego, como bien podemos observar en el marcador, los nuestros lo intentaban y una y otra vez chocaban... El Ubago Algeciras consigue una victoria de oficio en su debut de la División de Honor juvenil masculina.
El Ubago venció 34-28 en un partido que no fue de los mejores, pero que tirando de casta y coraje sacó los dos puntos, un partido intenso de los... Victoria del UBAGO Algeciras en la vuelta de los cuarto de final del Campeonato Andaluz (30-28) ante Bahía de Almería, que no nos vale para entrar en la final 4.
Partido disputado el sábado 18 de marzo a las 13:00 horas, en el Pabellón Ciudad de...
EL UBAGO ALGECIRAS NO PUDO CON UN SOBRESALIENTE BAHIA DE ALMERIA
NUESTRO JUVENIL MASCULINO UBAGO ALGECIRAS COMIENZA CON BUEN PIE LA TEMPORADA
VICTORIA DEL UBAGO ALGECIRAS EN LOS CUARTOS DE FINAL QUE NO NOS SIRVE PARA CONSEGUIR LA PLAZA AL TOP 4 ANDALUZ
|
|
Application 0.000 seconds (+0.000); 0.35 MB (+0.354) - afterLoad
Application 0.024 seconds (+0.024); 1.52 MB (+1.167) - afterInitialise
Application 0.038 seconds (+0.015); 3.05 MB (+1.530) - afterRoute
Application 0.049 seconds (+0.011); 3.46 MB (+0.409) - afterDispatch
Application 0.057 seconds (+0.008); 3.59 MB (+0.130) - beforeRenderModule mod_custom (Enlaces a pie de pagina)
Application 0.063 seconds (+0.006); 3.78 MB (+0.189) - afterRenderModule mod_custom (Enlaces a pie de pagina)
Application 0.063 seconds (+0.000); 3.78 MB (-0.001) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.063 seconds (+0.000); 3.78 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.063 seconds (+0.000); 3.78 MB (+0.002) - beforeRenderModule mod_custom (Publicidad titular left)
Application 0.064 seconds (+0.000); 3.78 MB (+0.002) - afterRenderModule mod_custom (Publicidad titular left)
Application 0.064 seconds (+0.000); 3.78 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners FASE FINAL)
Application 0.066 seconds (+0.003); 3.79 MB (+0.007) - afterRenderModule mod_jlbanners (mod_jlbanners FASE FINAL)
Application 0.066 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners HALCON FASE FINAL)
Application 0.068 seconds (+0.001); 3.79 MB (+0.002) - afterRenderModule mod_jlbanners (mod_jlbanners HALCON FASE FINAL)
Application 0.068 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left grande circo)
Application 0.071 seconds (+0.003); 3.79 MB (+0.002) - afterRenderModule mod_jlbanners (mod_jlbanners left grande circo)
Application 0.071 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left grande)
Application 0.074 seconds (+0.004); 3.81 MB (+0.019) - afterRenderModule mod_jlbanners (mod_jlbanners left grande)
Application 0.074 seconds (+0.000); 3.81 MB (+0.003) - beforeRenderModule mod_jlbanners (mod_jlbanners left pequeños)
Application 0.078 seconds (+0.004); 3.82 MB (+0.010) - afterRenderModule mod_jlbanners (mod_jlbanners left pequeños)
Application 0.078 seconds (+0.000); 3.83 MB (+0.006) - beforeRenderModule mod_js_table (Clasificación Juvenil Masculina)
Application 0.179 seconds (+0.101); 3.89 MB (+0.063) - afterRenderModule mod_js_table (Clasificación Juvenil Masculina)
Application 0.179 seconds (+0.000); 3.88 MB (-0.015) - beforeRenderModule mod_custom (Contenedor Juvenil Masculino)
Application 0.181 seconds (+0.002); 3.92 MB (+0.041) - beforeRenderModule mod_featcats (Juvenil Masculino Featured categories )
Application 0.239 seconds (+0.057); 4.10 MB (+0.184) - afterRenderModule mod_featcats (Juvenil Masculino Featured categories )
Application 0.240 seconds (+0.001); 3.99 MB (-0.119) - afterRenderModule mod_custom (Contenedor Juvenil Masculino)
Application 0.240 seconds (+0.000); 4.00 MB (+0.014) - beforeRenderModule mod_custom (Contenedor Partido Juvenil Masculino)
Application 0.242 seconds (+0.002); 4.02 MB (+0.020) - beforeRenderModule mod_js_next_matches (Proximos Partidos Juvenil Masculino)
Application 0.246 seconds (+0.003); 4.03 MB (+0.006) - afterRenderModule mod_js_next_matches (Proximos Partidos Juvenil Masculino)
Application 0.246 seconds (+0.000); 4.00 MB (-0.026) - afterRenderModule mod_custom (Contenedor Partido Juvenil Masculino)
Application 0.246 seconds (+0.000); 4.00 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 1 (copiar))
Application 0.248 seconds (+0.003); 3.99 MB (-0.010) - afterRenderModule mod_jlbanners (Publi central 1 (copiar))
Application 0.248 seconds (+0.000); 3.99 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 1)
Application 0.250 seconds (+0.002); 3.99 MB (+0.007) - afterRenderModule mod_jlbanners (Publi central 1)
Application 0.250 seconds (+0.000); 4.00 MB (+0.003) - beforeRenderModule mod_jlbanners (Publi central 2 234x130)
Application 0.252 seconds (+0.001); 4.00 MB (-0.002) - afterRenderModule mod_jlbanners (Publi central 2 234x130)
Application 0.252 seconds (+0.000); 4.00 MB (-0.000) - beforeRenderModule mod_jlbanners (Publi central 2 footer)
Application 0.253 seconds (+0.001); 4.00 MB (+0.002) - afterRenderModule mod_jlbanners (Publi central 2 footer)
Application 0.253 seconds (+0.000); 4.00 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 3)
Application 0.255 seconds (+0.002); 4.00 MB (+0.007) - afterRenderModule mod_jlbanners (Publi central 3)
Application 0.255 seconds (+0.000); 4.00 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 1 footer )
Application 0.258 seconds (+0.003); 4.01 MB (+0.008) - afterRenderModule mod_jlbanners (Publi central 1 footer )
Application 0.258 seconds (+0.000); 4.01 MB (-0.002) - beforeRenderModule mod_custom (FOTO EQUIPO JUVENIL MASCULINO)
Application 0.258 seconds (+0.000); 4.01 MB (+0.002) - afterRenderModule mod_custom (FOTO EQUIPO JUVENIL MASCULINO)
Application 0.258 seconds (+0.000); 4.01 MB (-0.002) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.259 seconds (+0.000); 4.01 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.259 seconds (+0.000); 4.01 MB (+0.002) - beforeRenderModule mod_search (Buscar)
Application 0.260 seconds (+0.001); 4.02 MB (+0.009) - afterRenderModule mod_search (Buscar)
Application 0.269 seconds (+0.009); 4.13 MB (+0.103) - afterRender
4.13 MB (4,329,336 Bytes)
SELECT `data`
FROM `ohd02_session`
WHERE `session_id` = '800e272399e7ca72acbc282d00271f53'
DELETE
FROM `ohd02_session`
WHERE `time` < '1711657281'
SELECT `session_id`
FROM `ohd02_session`
WHERE `session_id` = '800e272399e7ca72acbc282d00271f53'
LIMIT 0, 1
INSERT INTO `ohd02_session`
(`session_id`, `client_id`, `time`)
VALUES
('800e272399e7ca72acbc282d00271f53', 0, '1711658181')
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM ohd02_usergroups AS a
LEFT JOIN ohd02_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `ohd02_viewlevels`
SELECT folder AS type, element AS name, params
FROM ohd02_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT config
FROM ohd02_fua_config
WHERE id='fua'
LIMIT 1
SELECT config
FROM ohd02_fua_config
WHERE id='fua'
LIMIT 1
SELECT time
FROM ohd02_vvisit_counter USE INDEX(time)
ORDER BY time DESC
LIMIT 1;
UPDATE ohd02_vvisit_counter
SET visits=visits+1, bots=bots+1
WHERE time=1711658700;
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ohd02_menu AS m
LEFT JOIN ohd02_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT *
FROM ohd02_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM ohd02_template_styles as s
LEFT JOIN ohd02_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SHOW COLUMNS
FROM ohd02_content
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_phocagallery'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ohd02_phocagallery_categories AS c
WHERE c.id = 4
LIMIT 0, 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ohd02_modules AS m
LEFT JOIN ohd02_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ohd02_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-03-28 20:36:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 20:36:21')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 501 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (185)
ORDER BY a.sticky DESC,RAND()
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (186)
ORDER BY a.sticky DESC,RAND()
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (187)
ORDER BY a.sticky DESC,RAND()
LIMIT 2
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (154)
ORDER BY a.sticky DESC,RAND()
LIMIT 6
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 183
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 171
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 191
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 144
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 179
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 193
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (15)
ORDER BY a.sticky DESC,RAND()
LIMIT 14
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 142
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 82
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 105
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 141
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 68
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 16
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 173
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 14
SELECT *
FROM ohd02_bl_seasons
WHERE s_id = 33
SELECT s.s_id as id, CONCAT(t.name,' ',s.s_name) as name
FROM ohd02_bl_tournament as t, ohd02_bl_seasons as s
WHERE s.s_id = 33
AND s.t_id = t.id
ORDER BY t.name, s.s_name
SELECT t.id,bonus_point,t.t_yteam,t.t_name,t.t_emblem
FROM ohd02_bl_season_teams as st, ohd02_bl_teams as t
WHERE t.id = st.team_id
AND st.season_id = 33
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 138
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 138
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 138
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 138
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 138
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 138
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 138 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 138 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 138
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 138
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (138 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=138
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 142
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 142
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 142
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 142
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 142
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 142
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 142 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 142 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 142
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 142
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (142 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=142
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 196
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 196
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 196
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 196
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 196
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 196
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 196 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 196 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 196
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 196
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (196 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=196
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 197
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 197
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 197
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 197
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 197
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 197
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 197 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 197 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 197
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 197
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (197 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=197
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 198
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 198
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 198
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 198
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 198
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 198
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 198 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 198 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 198
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 198
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (198 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=198
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 201
AND season_id=33
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 201
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 201
SELECT cfg_value
FROM ohd02_bl_config
WHERE cfg_name = 'yteam_color'
SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
WHERE g.s_id = 33
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 33
AND st.team_id = 201
LIMIT 1
SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 201
SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 201
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id
AND m.score1 > m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id
AND m.score1 < m.score2)
AND m.is_extra = 0
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 201 = m.team1_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND 201 = m.team2_id
AND md.is_playoff = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id
AND m.score1 > m.score2)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team1_id
AND m.score1 < m.score2)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 201
AND m.score2 > m.score1)
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND m.is_extra = 0
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team2_id
AND m.score2 < m.score1)
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (m.team2_id = 201
AND m.score2 > m.score1)
AND m.is_extra = 0
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team2_id)
AND m.score1 = m.score2
AND m.m_played = 1
AND md.is_playoff = 0
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 33
AND m.published = 1
AND (201 = m.team2_id
AND m.score2 < m.score1)
AND m.is_extra = 0
AND md.is_playoff = 0
AND m.m_played = 1
SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=201
WHERE ef.published=1
AND ef.type = '1'
AND ef.e_table_view = '1'
ORDER BY ef.ordering
SELECT opt_value
FROM ohd02_bl_season_option
WHERE s_id = 33
AND opt_name='equalpts_chk'
SELECT *
FROM ohd02_bl_ranksort
WHERE seasonid=33
ORDER BY ordering
SELECT *
FROM ohd02_bl_seasons
WHERE s_id = 33
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='Juvenil Masculino Featured categories' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ohd02_categories as c
LEFT JOIN ohd02_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ohd02_categories AS cat JOIN ohd02_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=88
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT a.rules
FROM ohd02_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM ohd02_assets AS a
LEFT JOIN ohd02_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM ohd02_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ohd02_content AS a
LEFT JOIN ohd02_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ohd02_categories AS c
ON c.id = a.catid
LEFT JOIN ohd02_users AS ua
ON ua.id = a.created_by
LEFT JOIN ohd02_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ohd02_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ohd02_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ohd02_categories AS cat JOIN ohd02_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 88
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 20:36:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 20:36:21')
ORDER BY a.created DESC
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='Proximos Partidos Juvenil Masculino' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT m.id,m.m_date,m.m_time,md.m_name,md.id as mdid, t1.t_name as home, t2.t_name as away, score1,score2,m.is_extra,t1.id as hm_id,t2.id as aw_id,t1.t_emblem as emb1, t2.t_emblem as emb2
FROM ohd02_bl_matchday as md, ohd02_bl_match as m, ohd02_bl_teams as t1, ohd02_bl_teams as t2
WHERE m.m_id = md.id
AND m.published = 1
AND md.s_id=2
AND m.team1_id = t1.id
AND m.team2_id = t2.id
AND m.m_date >= '2024-03-28'
AND m.m_played = 0
AND (t1.id=11 OR t2.id=11)
ORDER BY m.m_date,m.m_time,md.id
LIMIT 4
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (178)
ORDER BY a.sticky DESC,RAND()
LIMIT 1
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 130
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (165)
ORDER BY a.sticky DESC,RAND()
LIMIT 2
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 180
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 35
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (182)
ORDER BY a.sticky DESC,RAND()
LIMIT 2
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (167)
ORDER BY a.sticky DESC,RAND()
LIMIT 10
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (168)
ORDER BY a.sticky DESC,RAND()
LIMIT 2
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 177
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 186
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 20:36:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (188)
ORDER BY a.sticky DESC,RAND()
LIMIT 10
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 175
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 192
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 150
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 187
UPDATE `ohd02_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711658181;s:18:\"session.timer.last\";i:1711658181;s:17:\"session.timer.now\";i:1711658181;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1711658182'
WHERE `session_id` = '800e272399e7ca72acbc282d00271f53'
72 × SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
12 × SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
11 × SELECT *
FROM ohd02_banners
11 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions
FROM ohd02_banners as a
6 × SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
6 × SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
6 × SELECT SUM(score1) as sc,SUM(score2) as rc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
6 × SELECT cfg_value
FROM ohd02_bl_config
6 × SELECT bonus_point
FROM ohd02_bl_season_teams
6 × SELECT t_emblem
FROM ohd02_bl_teams
6 × SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
2 × SELECT *
FROM ohd02_modules
2 × SELECT *
FROM ohd02_bl_seasons
2 × SELECT config
FROM ohd02_fua_config
1 × SELECT opt_value
FROM ohd02_bl_season_option
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=201
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=198
1 × SELECT *
FROM ohd02_bl_ranksort
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=197
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=196
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ohd02_categories as c
LEFT JOIN ohd02_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ohd02_categories AS cat JOIN ohd02_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=142
1 × SELECT a.rules
FROM ohd02_assets AS a
1 × SELECT b.rules
FROM ohd02_assets AS a
LEFT JOIN ohd02_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM ohd02_contact_details AS contact
1 × SELECT `data`
FROM `ohd02_session`
1 × SELECT ev.fvalue as fvalue
FROM ohd02_bl_extra_filds as ef
LEFT JOIN ohd02_bl_extra_values as ev
ON ef.id=ev.f_id
AND ev.uid=138
1 × SELECT `session_id`
FROM `ohd02_session`
1 × SELECT t.id,bonus_point,t.t_yteam,t.t_name,t.t_emblem
FROM ohd02_bl_season_teams as st, ohd02_bl_teams as t
1 × SELECT s.s_id as id, CONCAT(t.name,' ',s.s_name) as name
FROM ohd02_bl_tournament as t, ohd02_bl_seasons as s
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ohd02_modules AS m
LEFT JOIN ohd02_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ohd02_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ohd02_phocagallery_categories AS c
1 × SELECT id, home, template, s.params
FROM ohd02_template_styles as s
LEFT JOIN ohd02_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM ohd02_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ohd02_menu AS m
LEFT JOIN ohd02_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT time
FROM ohd02_vvisit_counter USE INDEX(time)
1 × SELECT folder AS type, element AS name, params
FROM ohd02_extensions
1 × SELECT id, rules
FROM `ohd02_viewlevels
1 × SELECT b.id
FROM ohd02_usergroups AS a
LEFT JOIN ohd02_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id,m.m_date,m.m_time,md.m_name,md.id as mdid, t1.t_name as home, t2.t_name as away, score1,score2,m.is_extra,t1.id as hm_id,t2.id as aw_id,t1.t_emblem as emb1, t2.t_emblem as emb2
FROM ohd02_bl_matchday as md, ohd02_bl_match as m, ohd02_bl_teams as t1, ohd02_bl_teams as t2
23 × UPDATE ohd02_banners
SET impmade = (impmade + 1)
1 × DELETE
FROM `ohd02_session`
1 × INSERT INTO `ohd02_session` (`session_id`, `client_id`, `time`)
VALUES ('800e272399e7ca72acbc282d00271f53', 0, '1711658181'
1 × UPDATE ohd02_vvisit_counter
SET visits=visits+1, bots=bots+1
1 × SHOW COLUMNS
FROM ohd02_conten
1 × UPDATE `ohd02_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711658181;s:18:\"session.timer.last\";i:1711658181;s:17:\"session.timer.now\";i:1711658181;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1711658182'