Labdarúgóink hibátlanul zárták az elmúlt hétvégét.
Megyei I. felnőtt, 12. forduló: HTE – Bocskai SE Vámospércs 5-0 (2-0)
Gól: Kerekes Bence (2), Borbély Milán, Oláh Norbert, Nagy Máté
HTE: Csorvási Tamás (Nagy Máté 84’) – Oláh Norbert, Szathmári Zsolt, Tóth Bertold (Kerekes Bence 70’), Hortó Attila (Szakács Dániel 75’), Nagy Máté, Misák Sándor (Tóth Tamás 64’), Kovács Milán (Bereczki Tamás 58’), Kerek Balázs, Borbély Milán, Linzenbold Zsolt (Pásztor Donát 70’). Edző: Igor Bogdanovic, Rákos Csaba.
Igor Bogdanovic: „A két héttel ezelőtti rossz eredmény után a Vámospércs elleni mérkőzésen a legfőbb cél a 3 pont begyűjtése volt. Igaz, a találkozó elején álmosan kezdtünk, de ahogy mentünk bele a meccsbe, a fiúk egyre jobban futballoztak, és így elég sima győzelmet sikerült szereznünk.”
Megyei I. U19: HTE – Bocskai SE Vámospércs 8-3 (4-0)
Gól: Bányász Alex (2), Barna Béla (2), Csirkés Imre, Varga Dávid, Bányász Krisztofer, Hajdu Ádám
HTE: Nagy Sándor (Debreczeni Dávid 67’) – Sajtos Zoltán (Benke Szabolcs 64’), Bányász Alex (Szanyi Dániel 67’), Oláh Sándor (Nagy Szabolcs 67’), Tompák Bence, Varga Dávid (Hajdu Ádám 67’), Tóth Norbert (Máthé Gergő 64’), Barna Béla (Bányász Krisztofer 46’), Papp Levente, Rákos Balázs, Csirkés Imre. Edző: Rákos Csaba, Igor Bogdanovic.
Rákos Csaba: „Az elmúlt két hét nem úgy sikerült, ahogy terveztük, így a mostani mérkőzésen a legfontosabb feladat az volt, hogy visszataláljunk a "helyes útra”, ami a mellékelt ábra szerint sikerült. A csapat gólerősen és sokszor szépen futballozva tartotta itthon a három pontot.”
Megyei U16: HTE – Nyíradony VVTK 6-2 (2-1)
Gól: Lakatos Attila (2), Kálmán Patrik, Kósa Tamás, Kolompár Sándor, Kovács Bendegúz
HTE: Pájerski József – Markos Nándor, Szekeres Ákos, Kálmán Patrik, Kósa Tamás, Jónizs Ábel, Lakatos Attila, Varga Ferenc (Pipó Levente 70’), Kolompár Sándor (Benke István 70’), Benke Szabolcs (Bereczki László 70’), Kovács Bendegúz. Edző: Kiss Antal.
Kiss Antal: „A ziccereink harmadát kihasználva, ismét magabiztos győzelmet arattunk! Gratulálok a csapat minden játékosának!”
Megyei U14: HTE – Nyíradony VVTK 10-0 (3-0)
Gól: Papp Kristóf (5), Molnár Gergő (2), Ősz-Varga Boldizsár, Csecsődi Imre, Sipos Kende
HTE: Szekeres Ádám – Kiss Áron, Sipos Kende, Csecsődi Imre, Tulipán Kristóf, Hagymási Dávid, Ősz-Varga Boldizsár, Molnár Gergő, Papp Kristóf, Bódi Kristóf. Csere: Éles Gábor, Milák Róbert, Zelenka Szabolcs, Uzonyi Balázs, Pipó Roland, Szolnoki Gergő. Edző: Sipos Elemér.
Sipos Elemér: „Egy szerényebb képességű csapat ellen arattunk nagy gólarányú győzelmet. Most is minden játékos maximálisan tört a sikerre!”
Oldalainkat 22 vendég és 0 tag böngészi
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
com_rsfirewall.geoip ⇒
link ⇒ http://hte.hajduboszormeny.hu/index.php?option=com_content&view=article&id=743:4-4-gyozelem-a-megyei-bajnoksagokban&catid=9&Itemid=385
Application 0.001 seconds (+0.001); 0.60 MB (+0.604) - afterLoad
Application 0.257 seconds (+0.256); 6.01 MB (+5.401) - afterInitialise
Application 0.288 seconds (+0.031); 8.36 MB (+2.352) - afterRoute
Application 0.507 seconds (+0.219); 12.25 MB (+3.895) - afterDispatch
Application 0.775 seconds (+0.267); 15.76 MB (+3.510) - beforeRenderModule mod_roknavmenu ()
Application 0.913 seconds (+0.138); 17.36 MB (+1.597) - afterRenderModule mod_roknavmenu ()
Application 0.932 seconds (+0.019); 17.27 MB (-0.087) - beforeRenderModule mod_spearheadfacebooklike (Tetszik)
Application 0.935 seconds (+0.003); 17.31 MB (+0.042) - afterRenderModule mod_spearheadfacebooklike (Tetszik)
Application 0.935 seconds (+0.000); 17.31 MB (-0.003) - beforeRenderModule mod_search (Keresés)
Application 0.938 seconds (+0.003); 17.33 MB (+0.023) - afterRenderModule mod_search (Keresés)
Application 0.938 seconds (+0.000); 17.33 MB (-0.007) - beforeRenderModule mod_articles_latest (Friss hírek)
Application 1.008 seconds (+0.070); 20.02 MB (+2.696) - afterRenderModule mod_articles_latest (Friss hírek)
Application 1.008 seconds (+0.000); 17.57 MB (-2.451) - beforeRenderModule mod_custom (Facebook)
Application 1.012 seconds (+0.004); 17.59 MB (+0.013) - afterRenderModule mod_custom (Facebook)
Application 1.012 seconds (+0.000); 17.58 MB (-0.002) - beforeRenderModule mod_articles_popular (Legnépszerűbb cikkek)
Application 1.042 seconds (+0.030); 18.65 MB (+1.062) - afterRenderModule mod_articles_popular (Legnépszerűbb cikkek)
Application 1.042 seconds (+0.000); 17.61 MB (-1.038) - beforeRenderModule mod_articles_popular (Legolvasottabb tartalom)
Application 1.084 seconds (+0.042); 19.76 MB (+2.151) - afterRenderModule mod_articles_popular (Legolvasottabb tartalom)
Application 1.084 seconds (+0.000); 17.61 MB (-2.143) - beforeRenderModule mod_whosonline (Users)
Application 1.091 seconds (+0.007); 17.65 MB (+0.033) - afterRenderModule mod_whosonline (Users)
Application 1.101 seconds (+0.010); 18.36 MB (+0.708) - afterRender
18.91 MB (19,833,648 Bytes)
SELECT `data`
FROM `vbx29_session`
WHERE `session_id` = 'd2bf02a5c8f432a27fe6b88c43b3e4d3'
SELECT `session_id`
FROM `vbx29_session`
WHERE `session_id` = 'd2bf02a5c8f432a27fe6b88c43b3e4d3'
LIMIT 0, 1
INSERT INTO `vbx29_session`
(`session_id`, `client_id`, `time`)
VALUES
('d2bf02a5c8f432a27fe6b88c43b3e4d3', 0, '1610778016')
SELECT extension_id AS id, element AS "option", params, enabled
FROM vbx29_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM vbx29_usergroups AS a
LEFT JOIN vbx29_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `vbx29_viewlevels`
SELECT folder AS type, element AS name, params
FROM vbx29_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 vbx29_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT `path`
FROM vbx29_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
SELECT `file`
FROM vbx29_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM vbx29_rsfirewall_configuration
SHOW FULL COLUMNS
FROM `vbx29_rsfirewall_logs`
SELECT template
FROM vbx29_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
SELECT template
FROM vbx29_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
SELECT extension, file, type
FROM vbx29_rokcommon_configs
ORDER BY priority
SHOW FULL COLUMNS
FROM `vbx29_extensions`
SELECT `extension_id`
FROM `vbx29_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
SELECT *
FROM vbx29_extensions
WHERE `extension_id` = '10014'
SELECT `extension_id`
FROM `vbx29_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
SELECT *
FROM vbx29_extensions
WHERE `extension_id` = '10014'
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 vbx29_menu AS m
LEFT JOIN vbx29_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT *
FROM vbx29_rsfirewall_hashes
WHERE (`type`='2.5.28' OR `type`='protect')
AND `flag`!='C'
SELECT *
FROM vbx29_rsfirewall_snapshots
WHERE `type`='protect'
SELECT `ip`,`reason`
FROM vbx29_rsfirewall_lists
WHERE (`ip`='18.204.42.98' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
SELECT `ip`,`reason`
FROM vbx29_rsfirewall_lists
WHERE (`ip`='18.204.42.98' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
SELECT *
FROM vbx29_rsfirewall_exceptions
WHERE `published`='1'
SELECT extension_id AS id, element AS "option", params, enabled
FROM vbx29_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM vbx29_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT a.rules
FROM vbx29_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM vbx29_assets AS a
LEFT JOIN vbx29_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 vbx29_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 vbx29_content AS a
LEFT JOIN vbx29_categories AS c
on c.id = a.catid
LEFT JOIN vbx29_users AS u
on u.id = a.created_by
LEFT JOIN vbx29_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vbx29_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vbx29_categories AS cat JOIN vbx29_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 = 743
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 06:20:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 06:20:16')
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 vbx29_categories as c
LEFT JOIN vbx29_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 vbx29_categories AS cat JOIN vbx29_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=9
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 b.rules
FROM vbx29_assets AS a
LEFT JOIN vbx29_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.743')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.language,
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 vbx29_content AS a
LEFT JOIN vbx29_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 9
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-01-16 06:20:16')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-01-16 06:20:16')
ORDER BY a.created DESC
UPDATE vbx29_content
SET hits = hits + 1
WHERE id = 743
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_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
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vbx29_modules AS m
LEFT JOIN vbx29_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vbx29_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 <= '2021-01-16 06:20:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-16 06:20:16')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 385 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT ts.template
FROM vbx29_template_styles AS ts
INNER JOIN vbx29_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 385
AND m.template_style_id != 0
SELECT template
FROM vbx29_template_styles
WHERE home = 1
AND client_id = 0
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM vbx29_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM vbx29_content AS a
LEFT JOIN vbx29_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vbx29_categories AS c
ON c.id = a.catid
LEFT JOIN vbx29_users AS ua
ON ua.id = a.created_by
LEFT JOIN vbx29_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vbx29_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vbx29_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vbx29_categories AS cat JOIN vbx29_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (9)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 06:20:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 06:20:16')
ORDER BY a.created DESC
LIMIT 0, 8
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM vbx29_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM vbx29_content AS a
LEFT JOIN vbx29_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vbx29_categories AS c
ON c.id = a.catid
LEFT JOIN vbx29_users AS ua
ON ua.id = a.created_by
LEFT JOIN vbx29_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vbx29_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vbx29_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vbx29_categories AS cat JOIN vbx29_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (9)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 06:20:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 06:20:16')
ORDER BY a.hits DESC
LIMIT 0, 5
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM vbx29_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM vbx29_content AS a
LEFT JOIN vbx29_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vbx29_categories AS c
ON c.id = a.catid
LEFT JOIN vbx29_users AS ua
ON ua.id = a.created_by
LEFT JOIN vbx29_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vbx29_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vbx29_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM vbx29_categories AS cat JOIN vbx29_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 06:20:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 06:20:16')
ORDER BY a.hits DESC
LIMIT 0, 10
SELECT guest, usertype, client_id
FROM vbx29_session
WHERE client_id = 0
SHOW FULL COLUMNS
FROM `vbx29_template_styles`
SELECT *
FROM vbx29_template_styles
WHERE `id` = '8'
UPDATE `vbx29_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610778016;s:18:\"session.timer.last\";i:1610778016;s:17:\"session.timer.now\";i:1610778016;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:1:{s:40:\"5643513a3865e8ca21b45b3d1ff52855b630539f\";O:8:\"stdClass\":2:{s:4:\"link\";s:134:\"http://hte.hajduboszormeny.hu/index.php?option=com_content&view=article&id=743:4-4-gyozelem-a-megyei-bajnoksagokban&catid=9&Itemid=385\";s:6:\"expiry\";i:1610778016;}}}'
, `time` = '1610778017'
WHERE `session_id` = 'd2bf02a5c8f432a27fe6b88c43b3e4d3'
6 × SELECT id, home, template, s.params
FROM vbx29_template_styles as s
LEFT JOIN vbx29_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM vbx29_extensions
3 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM vbx29_contact_details AS contact
2 × SELECT *
FROM vbx29_extensions
2 × SELECT template
FROM vbx29_template_styles as s
2 × SELECT `ip`,`reason`
FROM vbx29_rsfirewall_lists
2 × SELECT b.rules
FROM vbx29_assets AS a
LEFT JOIN vbx29_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT `extension_id`
FROM `vbx29_extensions`
1 × SELECT a.rules
FROM vbx29_assets AS a
1 × 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 vbx29_contact_details AS contact
1 × SELECT a.id, a.language,
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 vbx29_content AS a
LEFT JOIN vbx29_categories AS cc
ON cc.id = a.catid
1 × SELECT guest, usertype, client_id
FROM vbx29_session
1 × SELECT *
FROM vbx29_template_styles
1 × SELECT template
FROM vbx29_template_styles
1 × SELECT ts.template
FROM vbx29_template_styles AS ts
INNER JOIN vbx29_menu AS m
ON ts.id=m.template_style_id
1 × SELECT *
FROM vbx29_languages
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vbx29_modules AS m
LEFT JOIN vbx29_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vbx29_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM vbx29_categories as c
LEFT JOIN vbx29_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 vbx29_categories AS cat JOIN vbx29_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM vbx29_rsfirewall_snapshots
1 × SELECT folder AS type, element AS name, params
FROM vbx29_extensions
1 × SELECT `path`
FROM vbx29_rsfirewall_ignored
1 × SELECT id, rules
FROM `vbx29_viewlevels
1 × SELECT b.id
FROM vbx29_usergroups AS a
LEFT JOIN vbx29_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `vbx29_session`
1 × SELECT `file`
FROM vbx29_rsfirewall_hashes
1 × SELECT *
FROM vbx29_rsfirewall_configuratio
1 × SELECT `data`
FROM `vbx29_session`
1 × SELECT *
FROM vbx29_rsfirewall_hashes
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 vbx29_menu AS m
LEFT JOIN vbx29_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT extension, file, type
FROM vbx29_rokcommon_configs
1 × SELECT *
FROM vbx29_rsfirewall_exceptions
1 × SHOW FULL COLUMNS
FROM `vbx29_template_styles
1 × UPDATE `vbx29_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1610778016;s:18:\"session.timer.last\";i:1610778016;s:17:\"session.timer.now\";i:1610778016;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:1:{s:40:\"5643513a3865e8ca21b45b3d1ff52855b630539f\";O:8:\"stdClass\":2:{s:4:\"link\";s:134:\"http://hte.hajduboszormeny.hu/index.php?option=com_content&view=article&id=743:4-4-gyozelem-a-megyei-bajnoksagokban&catid=9&Itemid=385\";s:6:\"expiry\";i:1610778016;}}}' , `time` = '1610778017'
1 × UPDATE vbx29_content
SET hits = hits + 1
1 × SHOW FULL COLUMNS
FROM `vbx29_extensions
1 × SHOW FULL COLUMNS
FROM `vbx29_rsfirewall_logs
1 × INSERT INTO `vbx29_session` (`session_id`, `client_id`, `time`)
VALUES ('d2bf02a5c8f432a27fe6b88c43b3e4d3', 0, '1610778016'