FELIZ NAVIDAD Y PROSPERO AÑO NUEVO - BALONMANO CIUDAD DE ALGECIRAS
Noticias BM Ciudad de Algeciras
Desde el Club Balonmano Ciudad de Algeciras os deseamos una Feliz Navidad y Prospero Año Nuevo junto a vuestros seres queridos.
#bmciudad...
PRIMERA JORNADA DE BALONMANO CALLE EL CORTE INGLES
Noticias BM Ciudad de Algeciras
El sábado 16 de diciembre vivimos la 1ª Jornada de Balonmano Calle El Corte Inglés. Una apasionante jornada que reunió ...
EL PRIMER EQUIPO MASCULINO VUELVE A CAER FRENTE ALARCOS CIUDAD REAL
Senior Masculino Noticias
Dura aunque previsible derrota la sufrida por el primer equipo ante uno de los grandes favoritos al título.
El equipo que viajó a...
EMOCIONANTE PARTIDO QUE SE DECANTA 35 A 36 PARA CAJASUR CORDOBA BM
Senior Masculino Noticias
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 mu...
DERROTA AJUSTADA EN LA VISITA A SAFA MADRID
Senior Masculino Noticias
Derrota por la mínima en tierras madrileñas ante un buen Safa, pero con las mismas sensaciones que las anteriores…
Viaje larg...
UN ENCUENTRO COMPLICADO EN EL QUE EL CIUDAD DE ALGECIRAS SE QUEDO CERCA DE LOS PUNTOS
Senior Masculino Noticias
Derrota en una de las canchas más complicadas de la categoría pero con la sensación que hoy era un día propicio para...
EL UBAGO ALGECIRAS NO PUDO CON UN SOBRESALIENTE BAHIA DE ALMERIA
Juvenil Masculino Noticias
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 facet...
I JORNADA DE BALONMANO CALLE BAHIA PLAZA
Noticias BM Ciudad de Algeciras
Este próximo sábado día 28 de Octubre tendrá lugar en Bahía Plaza la I Jornada de Balonmano Calle en horario d...
EL DYPRE ALGECIRAS SE TRAE A CASA LOS DOS PUNTOS DE TIERRAS MALAGUEÑAS
Senior Femenino Noticias
El 1er equipo femenino se desplazó hasta Málaga para disputar su segundo partido liguero, correspondiente a la 4ª jornada. Las...
VICTORIA PARA NUESTRO SENIOR MASCULINO EN SU DESPLAZAMIENTO A CORDOBA
Senior Masculino Noticias
Victoria a domicilio muy trabajada por el primer equipo ante los cordobeses de La Salle, que contaban sus partidos en casa por victorias. Adem& ...
VOLVEMOS CON VICTORIA BM CIUDAD DE ALGECIRAS 35-23 POZUELO DE CALATRAVA
Senior Masculino Noticias
Victoria del primer equipo tras dos derrotas consecutivas que nos permite coger impulso de cara a unos próximos partidos muy exigentes.
E...
SEGUNDA DERROTA DE NUESTRO SENIOR MASCULINO TRAS UN PARTIDO MUY PELEADO FRENTE A BALONMANO MARAVILLAS
Senior Masculino Noticias
PRIMERA DERROTA DEL BM CIUDAD DE ALGECIRAS 26-29 ANTE BM MELILLA
Senior Masculino Noticias
EL BM CIUDAD DE ALGECIRAS TRABAJO SU VICTORIA EN LEGANES
Senior Masculino Noticias
Dos puntos complicadísimos los conseguidos ayer en Leganés, en una cancha donde el equipo supo sufrir y aguantar el empuje de un co...
II TORNEO DIPUTACIÓN DE CADIZ - XIX MEMORIAL PEPE PINEDA
NOTICIAS BM CIUDAD DE ALGECIRAS
Revivimos nuestro II Torneo Diputación de Cádiz con el XIX Memorial Pepe Pineda en el Pabellón Juan Carlos Mateo.
L...
Application 0.000 seconds (+0.000); 0.36 MB (+0.356) - afterLoad
Application 0.025 seconds (+0.025); 1.52 MB (+1.167) - afterInitialise
Application 0.040 seconds (+0.016); 3.10 MB (+1.575) - afterRoute
Application 0.053 seconds (+0.012); 3.32 MB (+0.221) - afterDispatch
Application 0.060 seconds (+0.007); 3.43 MB (+0.114) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.066 seconds (+0.006); 3.62 MB (+0.189) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores)
Application 0.066 seconds (+0.000); 3.62 MB (-0.001) - beforeRenderModule mod_custom (proximo partido 2019)
Application 0.066 seconds (+0.000); 3.62 MB (+0.002) - afterRenderModule mod_custom (proximo partido 2019)
Application 0.066 seconds (+0.000); 3.62 MB (-0.001) - beforeRenderModule mod_custom (calendario CONTENEDOR)
Application 0.068 seconds (+0.002); 3.65 MB (+0.027) - beforeRenderModule mod_jevents_cal (Calendario )
Application 0.089 seconds (+0.020); 3.90 MB (+0.250) - afterRenderModule mod_jevents_cal (Calendario )
Application 0.090 seconds (+0.001); 3.86 MB (-0.034) - afterRenderModule mod_custom (calendario CONTENEDOR)
Application 0.090 seconds (+0.000); 3.88 MB (+0.011) - beforeRenderModule mod_custom (MODULOS SECCIONES )
Application 0.090 seconds (+0.000); 3.88 MB (+0.002) - afterRenderModule mod_custom (MODULOS SECCIONES )
Application 0.090 seconds (+0.000); 3.88 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left portada arriba)
Application 0.094 seconds (+0.004); 3.89 MB (+0.013) - afterRenderModule mod_jlbanners (mod_jlbanners left portada arriba)
Application 0.094 seconds (+0.000); 3.89 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners left portada)
Application 0.099 seconds (+0.005); 3.90 MB (+0.008) - afterRenderModule mod_jlbanners (mod_jlbanners left portada)
Application 0.099 seconds (+0.000); 3.90 MB (+0.002) - beforeRenderModule mod_vvisit_counter (Visitas)
Application 0.101 seconds (+0.002); 3.92 MB (+0.024) - afterRenderModule mod_vvisit_counter (Visitas)
Application 0.101 seconds (+0.000); 3.92 MB (-0.007) - beforeRenderModule mod_custom (PORTADA PRUEBA NOTICIAS 90 dias)
Application 0.101 seconds (+0.000); 3.92 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA NOTICIAS 90 dias)
Application 0.101 seconds (+0.000); 3.93 MB (+0.007) - beforeRenderModule mod_filterednews (PORTADA PRUEBA filteres)
Application 0.104 seconds (+0.003); 3.97 MB (+0.048) - afterRenderModule mod_filterednews (PORTADA PRUEBA filteres)
Application 0.104 seconds (+0.000); 3.96 MB (-0.013) - beforeRenderModule mod_jlbanners (mod_jlbanners right pequeños)
Application 0.110 seconds (+0.006); 3.98 MB (+0.021) - afterRenderModule mod_jlbanners (mod_jlbanners right pequeños)
Application 0.110 seconds (+0.000); 3.98 MB (-0.001) - beforeRenderModule mod_fbfanbox (PORTADA PRUEBA facebook)
Application 0.110 seconds (+0.000); 4.07 MB (+0.086) - afterRenderModule mod_fbfanbox (PORTADA PRUEBA facebook)
Application 0.110 seconds (+0.000); 4.07 MB (+0.006) - beforeRenderModule mod_jlbanners (mod_jlbanners right FASE FINAL HALCON)
Application 0.114 seconds (+0.004); 4.06 MB (-0.011) - afterRenderModule mod_jlbanners (mod_jlbanners right FASE FINAL HALCON)
Application 0.114 seconds (+0.000); 4.06 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners right grande circo)
Application 0.118 seconds (+0.004); 4.07 MB (+0.009) - afterRenderModule mod_jlbanners (mod_jlbanners right grande circo)
Application 0.119 seconds (+0.000); 4.07 MB (-0.000) - beforeRenderModule mod_jlbanners (mod_jlbanners right grande arriba)
Application 0.125 seconds (+0.006); 4.10 MB (+0.024) - afterRenderModule mod_jlbanners (mod_jlbanners right grande arriba)
Application 0.125 seconds (+0.000); 4.09 MB (-0.001) - beforeRenderModule mod_custom (PORTADA TODO EN UNO)
Application 0.125 seconds (+0.000); 4.10 MB (+0.002) - afterRenderModule mod_custom (PORTADA TODO EN UNO)
Application 0.125 seconds (+0.000); 4.10 MB (-0.002) - beforeRenderModule mod_custom (video youtube)
Application 0.125 seconds (+0.000); 4.10 MB (+0.002) - afterRenderModule mod_custom (video youtube)
Application 0.125 seconds (+0.000); 4.11 MB (+0.011) - beforeRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.126 seconds (+0.000); 4.11 MB (+0.002) - afterRenderModule mod_custom (PORTADA PRUEBA Patrocinadores superior)
Application 0.126 seconds (+0.000); 4.11 MB (-0.001) - beforeRenderModule mod_search (Buscar)
Application 0.127 seconds (+0.001); 4.13 MB (+0.017) - afterRenderModule mod_search (Buscar)
Application 0.135 seconds (+0.009); 4.41 MB (+0.283) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.140 seconds (+0.005); 4.40 MB (-0.005) - afterRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.142 seconds (+0.002); 4.45 MB (+0.042) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.148 seconds (+0.006); 4.45 MB (+0.005) - afterRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.150 seconds (+0.002); 4.45 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA PRIMERO)
Application 0.155 seconds (+0.004); 4.45 MB (+0.005) - afterRenderModule mod_jlbanners (PORTADA PRUEBA PRIMERO)
Application 0.156 seconds (+0.001); 4.46 MB (+0.003) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA SEGUNDO)
Application 0.159 seconds (+0.004); 4.46 MB (+0.001) - afterRenderModule mod_jlbanners (PORTADA PRUEBA SEGUNDO)
Application 0.161 seconds (+0.001); 4.46 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA TERCERO)
Application 0.165 seconds (+0.005); 4.47 MB (+0.014) - afterRenderModule mod_jlbanners (PORTADA PRUEBA TERCERO)
Application 0.167 seconds (+0.001); 4.47 MB (+0.002) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA CUARTO)
Application 0.171 seconds (+0.005); 4.47 MB (+0.002) - afterRenderModule mod_jlbanners (PORTADA PRUEBA CUARTO)
Application 0.173 seconds (+0.001); 4.47 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.177 seconds (+0.004); 4.48 MB (+0.005) - afterRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.180 seconds (+0.003); 4.48 MB (+0.003) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA PRIMERO)
Application 0.186 seconds (+0.006); 4.49 MB (+0.005) - afterRenderModule mod_jlbanners (PORTADA PRUEBA PRIMERO)
Application 0.187 seconds (+0.001); 4.48 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA SEGUNDO)
Application 0.191 seconds (+0.004); 4.49 MB (+0.002) - afterRenderModule mod_jlbanners (PORTADA PRUEBA SEGUNDO)
Application 0.192 seconds (+0.002); 4.48 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA TERCERO)
Application 0.198 seconds (+0.006); 4.50 MB (+0.014) - afterRenderModule mod_jlbanners (PORTADA PRUEBA TERCERO)
Application 0.200 seconds (+0.001); 4.50 MB (-0.002) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA CUARTO)
Application 0.204 seconds (+0.004); 4.50 MB (+0.002) - afterRenderModule mod_jlbanners (PORTADA PRUEBA CUARTO)
Application 0.206 seconds (+0.002); 4.50 MB (-0.001) - beforeRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.210 seconds (+0.004); 4.51 MB (+0.010) - afterRenderModule mod_jlbanners (PORTADA PRUEBA QUINTO)
Application 0.509 seconds (+0.299); 4.30 MB (-0.212) - afterRender
4.32 MB (4,529,792 Bytes)
SELECT `data`
FROM `ohd02_session`
WHERE `session_id` = '9a58e2d8de9e5906620e87f612bd4a88'
DELETE
FROM `ohd02_session`
WHERE `time` < '1711727235'
SELECT `session_id`
FROM `ohd02_session`
WHERE `session_id` = '9a58e2d8de9e5906620e87f612bd4a88'
LIMIT 0, 1
INSERT INTO `ohd02_session`
(`session_id`, `client_id`, `time`)
VALUES
('9a58e2d8de9e5906620e87f612bd4a88', 0, '1711728135')
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=1711728900;
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 extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
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 *
FROM ohd02_jcomments_settings
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.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
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=131
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 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-29 16:02:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 16:02:15')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 928 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='Calendario' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
WHERE `type` = 'component'
AND `element` = 'com_jevents'
SHOW FULL COLUMNS
FROM `ohd02_jev_users`
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_jevents')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
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 (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_jevents'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
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 c.id
FROM ohd02_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.extension = 'com_jevents'
SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM ohd02_jevents_repetition as rpt
LEFT JOIN ohd02_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN ohd02_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN ohd02_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN ohd02_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN
ohd02_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN
ohd02_categories AS catmapcat
ON catmap.catid = catmapcat.id
WHERE 1
AND rpt.endrepeat >= '2024-03-01 00:00:00'
AND rpt.startrepeat <= '2024-03-31 23:59:59'
AND ev.state=1
AND catmapcat.access IN (1,1)
AND catmap.catid IN(-1,100,101,114,115,116,117,128)
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.rp_id
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 (198)
ORDER BY a.sticky DESC,RAND()
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 (197)
ORDER BY a.sticky DESC,RAND()
LIMIT 4
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 159
SELECT SUM(visits) AS visits
FROM ohd02_vvisit_counter
WHERE '1=1'
AND time > 1711666800
SHOW FULL COLUMNS
FROM `ohd02_content`
SELECT *
FROM ohd02_content
WHERE `id` = '1115'
SELECT a.*, cc.title AS catname,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
FROM ohd02_content AS a
INNER JOIN ohd02_categories AS cc
ON cc.id = a.catid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
AND DATEDIFF('2024-03-29 16:02:15', a.created) < 90
AND a.id!=1115
AND a.access IN (1,1)
AND (cc.id=131)
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 15
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 36
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 142
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 105
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 68
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 14
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 173
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 16
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 82
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 141
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 9
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 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 = 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 = 191
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 193
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA QUINTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA QUINTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 = 186
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 177
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA SEXTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA PRIMERO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 4
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 130
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 189
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA SEGUNDO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA TERCERO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 4
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 = 192
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 175
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA CUARTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA QUINTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 = 186
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 177
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA SEXTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA PRIMERO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 4
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 189
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 130
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA SEGUNDO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA TERCERO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 4
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_banners
SET impmade = (impmade + 1)
WHERE id = 175
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA CUARTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA QUINTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT *
FROM ohd02_banners
WHERE '2024-03-29 16:02:15' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM ohd02_content AS a
LEFT JOIN ohd02_categories AS c
on c.id = a.catid
LEFT JOIN ohd02_users AS u
on u.id = a.created_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 <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 1115
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15')
AND (a.state = 1 OR a.state =2)
SELECT *
FROM ohd02_jlbanners_reference
WHERE (`reference_table`='categories'
AND `reference_field`='id'
AND `reference_id`='131')
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 = 186
UPDATE ohd02_banners
SET impmade = (impmade + 1)
WHERE id = 177
SELECT *
FROM ohd02_modules
WHERE client_id = 0
AND access IN (1,1)
AND ( title='PORTADA PRUEBA SEXTO' )
AND published = 1
ORDER BY ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'FELIZ NAVIDAD Y PROSPERO AÑO NUEVO - BALONMANO CIUDAD DE ALGECIRAS' OR a.alias = 'FELIZ NAVIDAD Y PROSPERO AÑO NUEVO - BALONMANO CIUDAD DE ALGECIRAS' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT config
FROM ohd02_fua_config
WHERE id='fua'
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'PRIMERA JORNADA DE BALONMANO CALLE EL CORTE INGLES' OR a.alias = 'PRIMERA JORNADA DE BALONMANO CALLE EL CORTE INGLES' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'EL PRIMER EQUIPO MASCULINO VUELVE A CAER FRENTE ALARCOS CIUDAD REAL' OR a.alias = 'EL PRIMER EQUIPO MASCULINO VUELVE A CAER FRENTE ALARCOS CIUDAD REAL' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.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 a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'EMOCIONANTE PARTIDO QUE SE DECANTA 35 A 36 PARA CAJASUR CORDOBA BM' OR a.alias = 'EMOCIONANTE PARTIDO QUE SE DECANTA 35 A 36 PARA CAJASUR CORDOBA BM' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'DERROTA AJUSTADA EN LA VISITA A SAFA MADRID' OR a.alias = 'DERROTA AJUSTADA EN LA VISITA A SAFA MADRID' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'UN ENCUENTRO COMPLICADO EN EL QUE EL CIUDAD DE ALGECIRAS SE QUEDO CERCA DE LOS PUNTOS' OR a.alias = 'UN ENCUENTRO COMPLICADO EN EL QUE EL CIUDAD DE ALGECIRAS SE QUEDO CERCA DE LOS PUNTOS' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'EL UBAGO ALGECIRAS NO PUDO CON UN SOBRESALIENTE BAHIA DE ALMERIA' OR a.alias = 'EL UBAGO ALGECIRAS NO PUDO CON UN SOBRESALIENTE BAHIA DE ALMERIA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.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 a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'I JORNADA DE BALONMANO CALLE BAHIA PLAZA' OR a.alias = 'I JORNADA DE BALONMANO CALLE BAHIA PLAZA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'EL DYPRE ALGECIRAS SE TRAE A CASA LOS DOS PUNTOS DE TIERRAS MALAGUEÑAS' OR a.alias = 'EL DYPRE ALGECIRAS SE TRAE A CASA LOS DOS PUNTOS DE TIERRAS MALAGUEÑAS' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.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=192
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 a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'VICTORIA PARA NUESTRO SENIOR MASCULINO EN SU DESPLAZAMIENTO A CORDOBA' OR a.alias = 'VICTORIA PARA NUESTRO SENIOR MASCULINO EN SU DESPLAZAMIENTO A CORDOBA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'VOLVEMOS CON VICTORIA BM CIUDAD DE ALGECIRAS 35-23 POZUELO DE CALATRAVA' OR a.alias = 'VOLVEMOS CON VICTORIA BM CIUDAD DE ALGECIRAS 35-23 POZUELO DE CALATRAVA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'SEGUNDA DERROTA DE NUESTRO SENIOR MASCULINO TRAS UN PARTIDO MUY PELEADO FRENTE A BALONMANO MARAVILLAS' OR a.alias = 'SEGUNDA DERROTA DE NUESTRO SENIOR MASCULINO TRAS UN PARTIDO MUY PELEADO FRENTE A BALONMANO MARAVILLAS' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'PRIMERA DERROTA DEL BM CIUDAD DE ALGECIRAS 26-29 ANTE BM MELILLA' OR a.alias = 'PRIMERA DERROTA DEL BM CIUDAD DE ALGECIRAS 26-29 ANTE BM MELILLA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'EL BM CIUDAD DE ALGECIRAS TRABAJO SU VICTORIA EN LEGANES' OR a.alias = 'EL BM CIUDAD DE ALGECIRAS TRABAJO SU VICTORIA EN LEGANES' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
WHERE a.access IN (1,1)
AND ( a.title = 'II TORNEO DIPUTACIÓN DE CADIZ - XIX MEMORIAL PEPE PINEDA' OR a.alias = 'II TORNEO DIPUTACIÓN DE CADIZ - XIX MEMORIAL PEPE PINEDA' )
AND a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 16:02:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 16:02:15' )
ORDER BY a.ordering
LIMIT 1
UPDATE `ohd02_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711728135;s:18:\"session.timer.last\";i:1711728135;s:17:\"session.timer.now\";i:1711728135;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` = '1711728136'
WHERE `session_id` = '9a58e2d8de9e5906620e87f612bd4a88'
19 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM ohd02_contact_details AS contact
18 × 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
18 × SELECT *
FROM ohd02_jlbanners_reference
18 × SELECT *
FROM ohd02_banners
16 × SELECT *
FROM ohd02_modules
15 × SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`modified`, a.`modified_by`, a.`checked_out`, a.`checked_out_time`, a.`publish_up`, a.`publish_down`, a.`images`, a.`urls`, a.`attribs`, a.`version`, a.`parentid`, a.`ordering`, a.`metakey`, a.`metadesc`, a.`access`, a.`hits`, a.`metadata`, a.`featured`, a.`language`, a.`xreference`, a.`introtext`, a.`fulltext`,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug, c.title as category, c.alias as category_alias
FROM ohd02_content as a
LEFT JOIN ohd02_categories as c
ON c.id = a.catid
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ohd02_extensions
4 × 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
3 × SELECT config
FROM ohd02_fua_config
2 × 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 c.id
FROM ohd02_categories AS c
1 × SELECT a.*, cc.title AS catname,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
FROM ohd02_content AS a
INNER JOIN ohd02_categories AS cc
ON cc.id = a.catid
1 × SELECT *
FROM ohd02_content
1 × SELECT SUM(visits) AS visits
FROM ohd02_vvisit_counter
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 id, rules
FROM `ohd02_viewlevels
1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM ohd02_jevents_repetition as rpt
LEFT JOIN ohd02_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN ohd02_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN ohd02_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN ohd02_jevents_rrule as rr
ON rr.eventid = rpt.eventid
LEFT JOIN ohd02_jevents_catmap as catmap
ON catmap.evid = rpt.eventid
LEFT JOIN ohd02_categories AS catmapcat
ON catmap.catid = catmapcat.id
1 × SELECT folder AS type, element AS name, params
FROM ohd02_extensions
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 (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 time
FROM ohd02_vvisit_counter USE INDEX(time)
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 `session_id`
FROM `ohd02_session`
1 × SELECT a.rules
FROM ohd02_assets AS a
1 × SELECT *
FROM ohd02_jcomments_setting
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 `data`
FROM `ohd02_session`
41 × UPDATE ohd02_banners
SET impmade = (impmade + 1)
1 × DELETE
FROM `ohd02_session`
1 × INSERT INTO `ohd02_session` (`session_id`, `client_id`, `time`)
VALUES ('9a58e2d8de9e5906620e87f612bd4a88', 0, '1711728135'
1 × UPDATE ohd02_vvisit_counter
SET visits=visits+1, bots=bots+1
1 × SHOW COLUMNS
FROM ohd02_conten
1 × SHOW FULL COLUMNS
FROM `ohd02_jev_users
1 × SHOW FULL COLUMNS
FROM `ohd02_content
1 × UPDATE `ohd02_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711728135;s:18:\"session.timer.last\";i:1711728135;s:17:\"session.timer.now\";i:1711728135;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` = '1711728136'