№ |
Team
|
Wins | DRAW | Lost | GD | Goals score | Goals conceded | Points |
---|---|---|---|---|---|---|---|---|
1 | BM TRIANA | 5 | 2 | 0 | 46 | 217 | 171 | 12 |
2 | BM CIUDAD DE ALGECIRAS | 6 | 0 | 1 | 14 | 205 | 191 | 12 |
3 | COLEGIO MARAVILLAS BENALMADENA | 4 | 1 | 2 | 15 | 208 | 193 | 9 |
4 | CIUDAD DE PALMA DEL RIO O2 | 3 | 2 | 1 | 8 | 159 | 151 | 8 |
5 | BM NAZARENO | 3 | 0 | 4 | 14 | 211 | 197 | 6 |
6 | BM MIJAS | 2 | 1 | 2 | 5 | 158 | 153 | 5 |
7 | BM GADES ASISA | 2 | 0 | 4 | -17 | 137 | 154 | 4 |
8 | SANIX BM SAN FERNANDO | 2 | 0 | 5 | -29 | 171 | 200 | 4 |
9 | BM SAN JOSE | 2 | 0 | 4 | -32 | 152 | 184 | 4 |
10 | HISPANOSERVIS ARS PALMA DEL RIO | 0 | 0 | 6 | -24 | 150 | 174 | 0 |
¡¡¡ HAZ CLIC EN EL EQUIPO PARA VER SUS RESULTADOS !!!
|
Dura aunque previsible derrota la sufrida por el primer equipo ante uno de los grandes favoritos al título.
El equipo que viajó a tierras manchegas con tan solo 12 jugadores no pudo aguantar el empuje local que durante todo el encuentro fue... Derrota por la mínima en un trepidante partido ante uno de los máximos candidatos al título en un Ciudad de Algeciras con mucho ambiente y que pudo disfrutar con dos equipos entregados a hacer un buen balonmano.La primera parte fue de dominio... Derrota por la mínima en tierras madrileñas ante un buen Safa, pero con las mismas sensaciones que las anteriores…Viaje largo y poco descanso… para afrontar un partido de nivel como el que requiere cualquier envite en esta categoría.Y una vez más,...
EL PRIMER EQUIPO MASCULINO VUELVE A CAER FRENTE ALARCOS CIUDAD REAL
EMOCIONANTE PARTIDO QUE SE DECANTA 35 A 36 PARA CAJASUR CORDOBA BM
DERROTA AJUSTADA EN LA VISITA A SAFA MADRID
|
|
Application 0.000 seconds (+0.000); 0.35 MB (+0.354) - afterLoad
Application 0.039 seconds (+0.039); 1.52 MB (+1.167) - afterInitialise
Application 0.059 seconds (+0.021); 3.05 MB (+1.530) - afterRoute
Application 0.077 seconds (+0.017); 3.46 MB (+0.409) - afterDispatch
Application 0.091 seconds (+0.014); 3.59 MB (+0.131) - beforeRenderModule mod_custom (Enlaces a pie de pagina)
Application 0.099 seconds (+0.009); 3.78 MB (+0.189) - afterRenderModule mod_custom (Enlaces a pie de pagina)
Application 0.099 seconds (+0.000); 3.78 MB (-0.001) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.100 seconds (+0.000); 3.78 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.100 seconds (+0.000); 3.78 MB (+0.002) - beforeRenderModule mod_custom (Publicidad titular left)
Application 0.100 seconds (+0.000); 3.79 MB (+0.002) - afterRenderModule mod_custom (Publicidad titular left)
Application 0.100 seconds (+0.000); 3.78 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners FASE FINAL)
Application 0.105 seconds (+0.005); 3.79 MB (+0.007) - afterRenderModule mod_jlbanners (mod_jlbanners FASE FINAL)
Application 0.105 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners HALCON FASE FINAL)
Application 0.107 seconds (+0.002); 3.79 MB (+0.002) - afterRenderModule mod_jlbanners (mod_jlbanners HALCON FASE FINAL)
Application 0.107 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left grande circo)
Application 0.112 seconds (+0.005); 3.79 MB (+0.002) - afterRenderModule mod_jlbanners (mod_jlbanners left grande circo)
Application 0.112 seconds (+0.000); 3.79 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left grande)
Application 0.116 seconds (+0.005); 3.81 MB (+0.019) - afterRenderModule mod_jlbanners (mod_jlbanners left grande)
Application 0.116 seconds (+0.000); 3.82 MB (+0.004) - beforeRenderModule mod_jlbanners (mod_jlbanners left pequeños)
Application 0.121 seconds (+0.004); 3.83 MB (+0.010) - afterRenderModule mod_jlbanners (mod_jlbanners left pequeños)
Application 0.121 seconds (+0.000); 3.83 MB (+0.005) - beforeRenderModule mod_js_table (Clasificación Senior)
Application 0.308 seconds (+0.187); 3.94 MB (+0.104) - afterRenderModule mod_js_table (Clasificación Senior)
Application 0.308 seconds (+0.000); 3.92 MB (-0.020) - beforeRenderModule mod_custom (Contenedor noticias Senior Masculino)
Application 0.311 seconds (+0.002); 3.96 MB (+0.041) - beforeRenderModule mod_featcats (Senior Masculino Featured categories)
Application 0.417 seconds (+0.107); 4.16 MB (+0.203) - afterRenderModule mod_featcats (Senior Masculino Featured categories)
Application 0.420 seconds (+0.003); 4.05 MB (-0.112) - afterRenderModule mod_custom (Contenedor noticias Senior Masculino)
Application 0.420 seconds (+0.000); 4.07 MB (+0.026) - beforeRenderModule mod_custom (Contenedor Partido Senior Masculino)
Application 0.423 seconds (+0.003); 4.09 MB (+0.020) - beforeRenderModule mod_js_next_matches (Proximos Partidos Senior Masculino)
Application 0.428 seconds (+0.005); 4.10 MB (+0.004) - afterRenderModule mod_js_next_matches (Proximos Partidos Senior Masculino)
Application 0.428 seconds (+0.000); 4.07 MB (-0.026) - afterRenderModule mod_custom (Contenedor Partido Senior Masculino)
Application 0.428 seconds (+0.000); 4.07 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 1 (copiar))
Application 0.432 seconds (+0.004); 4.06 MB (-0.010) - afterRenderModule mod_jlbanners (Publi central 1 (copiar))
Application 0.432 seconds (+0.000); 4.07 MB (+0.003) - beforeRenderModule mod_jlbanners (Publi central 1)
Application 0.435 seconds (+0.003); 4.07 MB (+0.007) - afterRenderModule mod_jlbanners (Publi central 1)
Application 0.435 seconds (+0.000); 4.07 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 2 234x130)
Application 0.436 seconds (+0.002); 4.07 MB (-0.002) - afterRenderModule mod_jlbanners (Publi central 2 234x130)
Application 0.436 seconds (+0.000); 4.07 MB (-0.000) - beforeRenderModule mod_jlbanners (Publi central 2 footer)
Application 0.438 seconds (+0.002); 4.07 MB (+0.002) - afterRenderModule mod_jlbanners (Publi central 2 footer)
Application 0.438 seconds (+0.000); 4.07 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 3)
Application 0.441 seconds (+0.003); 4.08 MB (+0.007) - afterRenderModule mod_jlbanners (Publi central 3)
Application 0.441 seconds (+0.000); 4.08 MB (-0.001) - beforeRenderModule mod_jlbanners (Publi central 1 footer )
Application 0.444 seconds (+0.004); 4.09 MB (+0.008) - afterRenderModule mod_jlbanners (Publi central 1 footer )
Application 0.445 seconds (+0.000); 4.09 MB (+0.002) - beforeRenderModule mod_custom (FOTO EQUIPO SENIOR MASCULINO)
Application 0.445 seconds (+0.001); 4.09 MB (+0.002) - afterRenderModule mod_custom (FOTO EQUIPO SENIOR MASCULINO)
Application 0.445 seconds (+0.000); 4.09 MB (-0.002) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.445 seconds (+0.000); 4.09 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.446 seconds (+0.000); 4.09 MB (+0.002) - beforeRenderModule mod_search (Buscar)
Application 0.447 seconds (+0.002); 4.10 MB (+0.009) - afterRenderModule mod_search (Buscar)
Application 0.462 seconds (+0.015); 4.16 MB (+0.056) - afterRender
4.24 MB (4,443,568 Bytes)
SELECT `data`
FROM `ohd02_session`
WHERE `session_id` = '8757bad439594e66909c204c15226d0a'
DELETE
FROM `ohd02_session`
WHERE `time` < '1711627765'
SELECT `session_id`
FROM `ohd02_session`
WHERE `session_id` = '8757bad439594e66909c204c15226d0a'
LIMIT 0, 1
INSERT INTO `ohd02_session`
(`session_id`, `client_id`, `time`)
VALUES
('8757bad439594e66909c204c15226d0a', 0, '1711628665')
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;
INSERT INTO ohd02_vvisit_counter (time, visits, bots)
VALUES (1711629000, 1, 1)
ON DUPLICATE KEY UPDATE visits=visits+1, bots=bots+1;
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 = 1
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 12:24:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 12:24:26')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 500 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 12:24:26' >= `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 12:24:26' >= `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 12:24:26' >= `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 12:24:26' >= `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 = 182
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 = 171
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 193
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 6
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 12:24:26' >= `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 = 82
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 = 141
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 14
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 68
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 142
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 105
SELECT *
FROM ohd02_bl_seasons
WHERE s_id = 31
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 = 31
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 = 31
SELECT bonus_point
FROM ohd02_bl_season_teams
WHERE team_id = 124
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 124
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 124
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 124
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 124
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 124
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND 124 = 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 = 31
AND m.published = 1
AND 124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (m.team2_id = 124
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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (m.team2_id = 124
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 = 31
AND m.published = 1
AND (124 = 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 = 31
AND m.published = 1
AND (124 = 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=124
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 = 130
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 130
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 130
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 130
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 130
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 130
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND 130 = 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 = 31
AND m.published = 1
AND 130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (m.team2_id = 130
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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (m.team2_id = 130
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 = 31
AND m.published = 1
AND (130 = 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 = 31
AND m.published = 1
AND (130 = 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=130
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 = 166
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 166
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 166
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 166
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 166
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 166
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND 166 = 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 = 31
AND m.published = 1
AND 166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (m.team2_id = 166
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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (m.team2_id = 166
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 = 31
AND m.published = 1
AND (166 = 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 = 31
AND m.published = 1
AND (166 = 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=166
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 = 182
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 182
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 182
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 182
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 182
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 182
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND 182 = 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 = 31
AND m.published = 1
AND 182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (m.team2_id = 182
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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (m.team2_id = 182
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 = 31
AND m.published = 1
AND (182 = 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 = 31
AND m.published = 1
AND (182 = 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=182
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 = 183
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 183
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 183
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 183
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 183
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 183
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND 183 = 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 = 31
AND m.published = 1
AND 183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (m.team2_id = 183
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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (m.team2_id = 183
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 = 31
AND m.published = 1
AND (183 = 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 = 31
AND m.published = 1
AND (183 = 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=183
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 = 185
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 185
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 185
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 185
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 185
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 185
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND 185 = 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 = 31
AND m.published = 1
AND 185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (m.team2_id = 185
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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (m.team2_id = 185
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 = 31
AND m.published = 1
AND (185 = 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 = 31
AND m.published = 1
AND (185 = 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=185
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 = 186
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 186
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 186
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 186
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 186
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 186
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND 186 = 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 = 31
AND m.published = 1
AND 186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (m.team2_id = 186
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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (m.team2_id = 186
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 = 31
AND m.published = 1
AND (186 = 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 = 31
AND m.published = 1
AND (186 = 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=186
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 = 187
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 187
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 187
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 187
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 187
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 187
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND 187 = 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 = 31
AND m.published = 1
AND 187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (m.team2_id = 187
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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (m.team2_id = 187
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 = 31
AND m.published = 1
AND (187 = 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 = 31
AND m.published = 1
AND (187 = 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=187
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 = 188
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 188
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 188
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 188
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 188
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 188
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND 188 = 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 = 31
AND m.published = 1
AND 188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (m.team2_id = 188
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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (m.team2_id = 188
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 = 31
AND m.published = 1
AND (188 = 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 = 31
AND m.published = 1
AND (188 = 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=188
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 = 189
AND season_id=31
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 189
LIMIT 1
SELECT t_emblem
FROM ohd02_bl_teams
WHERE id = 189
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 = 31
AND g.id = gr.g_id
AND gr.t_id = st.team_id
AND st.season_id = 31
AND st.team_id = 189
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team1_id = 189
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 = 31
AND m.published = 1
AND md.is_playoff = 0
AND m.is_extra = 0
AND m.m_played = 1
AND m.team2_id = 189
SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
WHERE m.m_id = md.id
AND md.s_id = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND 189 = 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 = 31
AND m.published = 1
AND 189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (m.team2_id = 189
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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (m.team2_id = 189
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 = 31
AND m.published = 1
AND (189 = 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 = 31
AND m.published = 1
AND (189 = 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=189
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 = 31
AND opt_name='equalpts_chk'
SELECT *
FROM ohd02_bl_ranksort
WHERE seasonid=31
ORDER BY ordering
SELECT *
FROM ohd02_bl_seasons
WHERE s_id = 31
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='Senior 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=87
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 = 87
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 12:24:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 12:24:26')
ORDER BY a.created DESC
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='Proximos Partidos Senior 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=24
AND m.team1_id = t1.id
AND m.team2_id = t2.id
AND m.m_date >= '2024-03-28'
AND m.m_played = 0
ORDER BY m.m_date,m.m_time,md.id
LIMIT 4
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 12:24:26' >= `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 12:24:26' >= `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 = 35
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 180
SELECT *
FROM ohd02_banners
WHERE '2024-03-28 12:24:26' >= `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 12:24:26' >= `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 12:24:26' >= `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 12:24:26' >= `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 = 192
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 187
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 150
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 175
UPDATE `ohd02_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711628665;s:18:\"session.timer.last\";i:1711628665;s:17:\"session.timer.now\";i:1711628665;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` = '1711628666'
WHERE `session_id` = '8757bad439594e66909c204c15226d0a'
120 × SELECT COUNT(*)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
20 × SELECT gr.g_id
FROM ohd02_bl_season_teams as st, ohd02_bl_grteams as gr, ohd02_bl_groups as g
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
11 × SELECT *
FROM ohd02_banners
10 × SELECT SUM(bonus2)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
10 × SELECT SUM(bonus1)
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
10 × SELECT SUM(score1) as rc,SUM(score2) as sc
FROM ohd02_bl_matchday as md, ohd02_bl_match as m
10 × SELECT cfg_value
FROM ohd02_bl_config
10 × SELECT t_emblem
FROM ohd02_bl_teams
10 × SELECT bonus_point
FROM ohd02_bl_season_teams
10 × SELECT SUM(score1) as sc,SUM(score2) as rc
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 config
FROM ohd02_fua_config
2 × SELECT *
FROM ohd02_bl_seasons
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 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.rules
FROM ohd02_assets AS a
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=185
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=189
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=188
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=186
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=187
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=182
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=183
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=166
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=130
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=124
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 ('8757bad439594e66909c204c15226d0a', 0, '1711628665'
1 × INSERT INTO ohd02_vvisit_counter (time, visits, bots)
VALUES (1711629000, 1, 1)
ON DUPLICATE KEY UPDATE 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:1711628665;s:18:\"session.timer.last\";i:1711628665;s:17:\"session.timer.now\";i:1711628665;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` = '1711628666'