93 години от рождението на Георги Берков

вкл. 28 Октомври 2019.

1964 2 e

На 27 октомври през 1926 г. се ражда една футболна легенда на Локомотив - Георги Берков "БЕЛИЯ ОРЕЛ". Като футболист и треньор той катери върховете на Българския футбол . Два пъти бронзов медалист 1952 и 1954 и носител на купата на НРБ 1953 г. като футболист на Локомотив! Като треньор през 1961 и 1963 става европейски железничарски шампион с отбора, а през 1964 г. прави Локомотив шампион на България. През 1982 печели купата на НРБ тогава (КСА).

На национално ниво - Олимпийски вицешампион на игрите в Мексико .

< Предишна Следваща >

Добавете коментар

JComments

НОВИ КОМЕНТАРИ

parva kopka na stadiona 1968

Прочетете още...

Стойнето се бил разсърдил на тази публикация и затова Локомотив нямало вече да домакинства там.

Прочетете още...

Ако някое капутче посмее само да си помисли да драска по платната, после щеще ходи да пикае през 5 ...

Прочетете още...

Хем сме най-красиви, хем сме най-добри :-)

Прочетете още...

Конзола за дебъг на Joomla!

__default

session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

user

password_clear ⇒

groups ⇒

gid ⇒ 1

com_mailto.links

ed29d0f61789d458100893cb8a2f99a011c78437

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/програма-дюш-сезон-2013-2014/1626-програма-на-двубоите-за-отборите-в-дюш-21-22-април-2017

a8493e7542d1251165410cd78faf9ab65bab21f5

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2914-контролна-среща-локомотив-рилски-спортист-3-0

e2e8b9ad13d087bff912cc5b0c96e4a23112d5a5

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2913-второ-равенство-в-контролите-за-локомотив

aef9947aebbe999b411a70c1703ee1de5fdd149c

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2912-приятелска-среща-септември-симитли-локомотив-го-14-30-ч

4f6a8d612fc5b31b205352c99e63ef009ed3bab5

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2908-приятелска-среща-локомотив-локомотив-го-14-00-ч

9d109406d36ffc2023dffcc41e0e82f68b3772c0

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2903-приятелска-среща-локомотив-сливнишки-герой-14-30-ч

110334afc787154e222718a70736cf7e4929f1ef

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2896-созопол-локомотив-12-00

f31c7ec0a686079a4c7a8ea85bdc6f9ab33c3caf

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2892-локомотив-септември-см-14-45

b3340478ea54f655dcc51651cc142ed7e326857a

link ⇒ https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2529-гледайте-локомотив-нн-на-държавното-по-водна-топка-за-u19

73b7fbe80fa5097d14cf2b7ad5cedf458a16f6cb

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2732-срамно-изказване-на-иван-василев

b8415493a9eb3279caa1983496e32ca5e2bbcc9e

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2585-ботев-пловдив-локомотив-0-0-контролна-среща

b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2528-генерално-класиране-при-юношите-младша,-зона-софия

7b9382354977963cb375cbf3ea9026e97c56c40e

link ⇒ https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2887-стойка-кръстева-спечели-титла-от-турнира-балкан

5b524494e323e0476abc7bee9a536d8de5eb9c17

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1967-иван-деянов-на-80

96baa8f5577bde065edbd4190e149b6e96277160

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1926-ивайло-георгиев-на-75-най-много-във-футбола-научих-от-буч-и-берков

e29dcbf77c13fb74ea20aa47fbf3580f4a982a05

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1922-почина-стефан-милев-роко

bb3921b9824c5492fa6be007844318c09a531648

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1879-скръбна-вест-почина-борис-илиев

ec1e5de0dc925d47d910a3d8bda420fc30fb287b

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1875-11-години-без-начко-михайлов-–-човека-от-улица-“съзнание”

45cb6194c232eb1211dd2fdabb205475a3d205e0

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1756-никола-спасов-за-втора-лига-и-локомотив

80bddaef8b740f071492eb56df33bceb953f2814

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1749-човешки-апел-за-помощ-легенда-на-локо-сф-се-нуждае-от-подкрепа

ca093695a1d213f45e1829e3e33cca3a148b4c80

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/родени-1997-дюш/684-скандално-съдийство-опорочи-1-4-финал-срещу-спартак

c26011876703f50e52bf2d9c6891e37e0aca886a

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2837-абонаментна-карта-за-сезон-2020-2021

92644283e281858954a0244333e43c9ba3bbf2fb

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2679-1500-деца-спортуват-в-обединени-спортни-клубове-„локомотив“

020d3a7d89a08a83ba153f823ca0a835bcc73eec

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков

session.token ⇒ a984085fd24fdbda1ec55af6701a880b

Application 0.000 seconds (+0.000); 0.65 MB (+0.645) - afterLoad

Application 0.066 seconds (+0.066); 3.87 MB (+3.228) - afterInitialise

Application 0.129 seconds (+0.063); 6.61 MB (+2.736) - afterRoute

Application 0.357 seconds (+0.228); 10.35 MB (+3.744) - afterDispatch

Application 0.374 seconds (+0.016); 10.81 MB (+0.458) - beforeRenderModule mod_search (Търси)

Application 0.382 seconds (+0.009); 10.85 MB (+0.044) - afterRenderModule mod_search (Търси)

Application 0.384 seconds (+0.002); 10.85 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.388 seconds (+0.004); 10.86 MB (+0.009) - afterRenderModule mod_custom (LOGO)

Application 0.390 seconds (+0.002); 10.86 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.500 seconds (+0.110); 12.82 MB (+1.958) - afterRenderModule mod_menu (Main Menu)

Application 0.541 seconds (+0.041); 13.07 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.549 seconds (+0.008); 13.10 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.551 seconds (+0.003); 13.12 MB (+0.017) - beforeRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.650 seconds (+0.099); 13.41 MB (+0.292) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.652 seconds (+0.002); 13.33 MB (-0.078) - beforeRenderModule mod_menu (Submenu)

Application 0.674 seconds (+0.022); 13.35 MB (+0.016) - afterRenderModule mod_menu (Submenu)

Application 0.674 seconds (+0.000); 13.34 MB (-0.008) - beforeRenderModule mod_custom (ВХОД_html)

Application 0.676 seconds (+0.002); 13.34 MB (+0.005) - afterRenderModule mod_custom (ВХОД_html)

Application 0.676 seconds (+0.000); 13.34 MB (-0.002) - beforeRenderModule mod_custom (Събития)

Application 0.682 seconds (+0.005); 13.35 MB (+0.007) - afterRenderModule mod_custom (Събития)

Application 0.682 seconds (+0.000); 13.35 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.683 seconds (+0.001); 13.35 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

Application 0.684 seconds (+0.001); 13.38 MB (+0.030) - beforeRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.718 seconds (+0.034); 13.79 MB (+0.406) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.718 seconds (+0.000); 13.75 MB (-0.038) - beforeRenderModule mod_custom (razvitie)

Application 0.719 seconds (+0.001); 13.75 MB (+0.005) - afterRenderModule mod_custom (razvitie)

Application 0.719 seconds (+0.000); 13.76 MB (+0.007) - beforeRenderModule mod_jnews (Абонамент за новини)

Application 0.771 seconds (+0.052); 16.50 MB (+2.739) - afterRenderModule mod_jnews (Абонамент за новини)

Application 0.771 seconds (+0.000); 16.47 MB (-0.034) - beforeRenderModule mod_custom (Добави статия)

Application 0.772 seconds (+0.001); 16.47 MB (+0.005) - afterRenderModule mod_custom (Добави статия)

Application 0.772 seconds (+0.000); 16.47 MB (-0.002) - beforeRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) sidebar-b)

Application 0.778 seconds (+0.006); 16.55 MB (+0.078) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.883 seconds (+0.106); 17.06 MB (+0.516) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.884 seconds (+0.001); 17.04 MB (-0.025) - beforeRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.973 seconds (+0.089); 17.28 MB (+0.242) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.973 seconds (+0.000); 17.16 MB (-0.116) - afterRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) sidebar-b)

Application 0.973 seconds (+0.000); 17.16 MB (-0.005) - beforeRenderModule mod_whosonline (Кой е тук)

Application 0.986 seconds (+0.012); 17.19 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

Application 1.004 seconds (+0.019); 17.21 MB (+0.025) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 1.032 seconds (+0.028); 17.54 MB (+0.331) - afterRenderModule mod_articles_news (ВИДЕО)

Application 1.032 seconds (+0.000); 17.54 MB (-0.006) - beforeRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) bottom-b)

Application 1.033 seconds (+0.001); 17.58 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 1.041 seconds (+0.008); 17.61 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

Application 1.041 seconds (+0.000); 17.60 MB (-0.001) - beforeRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

Application 1.074 seconds (+0.033); 17.76 MB (+0.152) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

Application 1.074 seconds (+0.000); 17.72 MB (-0.031) - beforeRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

Application 1.113 seconds (+0.040); 17.77 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

Application 1.114 seconds (+0.000); 17.73 MB (-0.046) - afterRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) bottom-b)

Application 1.118 seconds (+0.004); 17.74 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.247 seconds (+0.129); 20.06 MB (+2.327) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.287 seconds (+0.040); 20.08 MB (+0.019) - afterRender

214 записани заявки

SELECT `data` FROM `jos_session` WHERE `session_id` = '8173d6572a0b3136b4a81ee270b17e01'
SELECT folder AS type, element AS name, params FROM jos_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 jos_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
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 jos_menu AS m LEFT JOIN jos_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 jos_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=2670 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 alias, catid FROM jos_content WHERE id = 2670
SELECT * FROM jos_jcomments_settings
SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_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 * FROM jos_languages WHERE published=1 ORDER BY ordering ASC
SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_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 extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 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 jos_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 jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_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 = 2670 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 08:54:52') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:54:52') 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 jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=56 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
SHOW FULL COLUMNS FROM `jos_assets`
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.2670') 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 jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid WHERE a.catid = 56 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 <= '2025-12-22 08:54:52') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-22 08:54:52') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '2670' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 2670 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 2670
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_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 <= '2025-12-22 08:54:52') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-22 08:54:52') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 265 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_acepolls'
DELETE FROM `jos_session` WHERE `time` < '1766390093'
SELECT a.metakey, a.catid, a.created_by, a.created_by_alias, cc.title as category_title, u.name as author FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.id = 2670
SELECT a.id, a.title, a.introtext, a.publish_up as date, a.catid, cc.access AS cat_access, a.created_by, a.created_by_alias, u.name AS author, cc.published AS cat_state, 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, cc.title as category_title, a.introtext as introtext_raw, a.fulltext, a.metakey, "0" as match_count, "" as match_list FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.id != 2670 AND a.state = 1 AND a.access IN (1,1) AND cc.access IN (1,1) AND cc.published = 1 AND ( CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Георги Берков,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,шампион,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Олимпиада,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 08:54:52' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:54:52' ) AND a.catid IN (8,12,15,26,27,13,14,28,49,50,55,51,21,22,47,17,18,29,30,52,53,23,24,25,34,35,36,37,38,39,40,41,42,43,46,31,54,32,45,44,33)
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=54 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.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=28 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.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=44 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 id FROM jos_assets WHERE parent_id = 0
SELECT id, fav_team FROM jos_joomleague_project p WHERE fav_team != '' AND id IN (39)
SELECT m.*,m.id as match_id, t1.id team1_id, t2.id team2_id, DATE(m.match_date) AS match_date_notime, m.match_date AS match_date, NOW() AS currenttime, IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) AS totaltime, IF ( (match_date > UTC_TIMESTAMP() AND m.team1_result IS NULL) AND ((m.team1_result_split IS NULL) OR TRIM(REPLACE(m.team1_result_split, ';', '')) = ''),m.match_date, 'z' ) AS upcoming, IF ( (m.team1_result IS NOT NULL OR m.match_date < UTC_TIMESTAMP()),m.match_date, 0 ) AS alreadyplayed, IF ( ( ( DATE_ADD(m.match_date, INTERVAL IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) MINUTE ) > UTC_TIMESTAMP() ) AND (m.match_date < UTC_TIMESTAMP() ) AND (m.team1_result IS NULL) ),m.match_date, 'z' ) AS actplaying, IF ( ((m.team1_result IS NULL) AND (m.team1_result_split IS NOT NULL) AND TRIM(REPLACE(m.team1_result_split, ';', '') != '')),m.match_date,'z' ) AS live, DATE_SUB(m.match_date, INTERVAL '90' MINUTE) AS meetingtime, NOW() AS local_time, r.*, p.name AS pname, p.current_round, p.id AS project_id, p.timezone, p.game_parts, p.ordering, IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname, pg.name AS pg_name, pt1.division_id, pg.short_name AS pg_shortname FROM jos_joomleague_match m INNER JOIN jos_joomleague_round r ON m.round_id = r.id INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = m.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = m.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id INNER JOIN jos_joomleague_project p ON pt1.project_id = p.id LEFT JOIN jos_joomleague_match_referee AS mref ON m.id = mref.match_id LEFT JOIN jos_joomleague_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN jos_joomleague_person AS person ON person.id = pref.person_id AND person.published = 1 AND pref.published = 1 LEFT JOIN jos_joomleague_playground AS pg ON pg.id = m.playground_id WHERE ( (( (pt1.team_id IN (2) OR pt2.team_id IN (2)) AND (pt1.project_id = 39 OR pt2.project_id = 39) )) AND p.published = 1 AND m.published = 1 AND (m.match_date > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 3 MONTH)) AND (pt1.project_id IN (39) OR pt2.project_id IN (39)) ) GROUP BY m.id ORDER by match_date DESC LIMIT 1
SHOW FULL COLUMNS FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_lists` WHERE `published` = 1
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT id, rules FROM `jos_viewlevels`
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE cc.published = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 08:54:52' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:54:52' ) AND (cc.id = 8 OR cc.id = 9 OR cc.id = 12 OR cc.id = 13 OR cc.id = 16 OR cc.id = 17 OR cc.id = 19 OR cc.id = 23 OR cc.id = 31 OR cc.id = 56 OR cc.id = 10 OR cc.id = 11 OR cc.id = 67 OR cc.id = 15 OR cc.id = 26 OR cc.id = 27 OR cc.id = 48 OR cc.id = 14 OR cc.id = 28 OR cc.id = 51 OR cc.id = 55 OR cc.id = 59 OR cc.id = 21 OR cc.id = 22 OR cc.id = 47 OR cc.id = 61 OR cc.id = 18 OR cc.id = 29 OR cc.id = 30 OR cc.id = 52 OR cc.id = 53 OR cc.id = 64 OR cc.id = 65 OR cc.id = 69 OR cc.id = 70 OR cc.id = 71 OR cc.id = 72 OR cc.id = 24 OR cc.id = 37 OR cc.id = 38 OR cc.id = 39 OR cc.id = 40 OR cc.id = 41 OR cc.id = 42 OR cc.id = 43 OR cc.id = 46 OR cc.id = 32 OR cc.id = 33 OR cc.id = 44 OR cc.id = 45 OR cc.id = 54 OR cc.id = 57 OR cc.id = 62 OR cc.id = 63 OR cc.id = 66 OR cc.id = 73 OR cc.id = 74 OR cc.id = 49 OR cc.id = 50 OR cc.id = 58 OR cc.id = 60 OR cc.id = 68 OR cc.id = 25 OR cc.id = 34 OR cc.id = 35 OR cc.id = 36) AND a.access <= 1 AND cc.access <= 1 AND DATEDIFF('2025-12-22 08:54:52', a.created) < 30 AND a.state = 1 ORDER BY a.id DESC, a.modified ASC LIMIT 0, 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE a.id IN (12,2511,2506,2475,2470,2174,871,692,1109) AND a.access <= 1 AND cc.access <= 1 ORDER BY case a.id when '12' then '1' when '2511' then '2' when '2506' then '3' when '2475' then '4' when '2470' then '5' when '2174' then '6' when '871' then '7' when '692' then '8' when '1109' then '9' end
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=16 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 username FROM jos_users WHERE id = 849
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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=23 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 username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT guest, usertype, client_id FROM jos_session WHERE client_id = 0
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,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 jos_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 jos_content AS a LEFT JOIN jos_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_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 (49) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 08:54:52') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:54:52') ORDER BY a.created DESC LIMIT 0, 1
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') ORDER BY c.date DESC LIMIT 0, 4
SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') GROUP BY o.id, o.title, o.link ORDER BY commentsCount DESC, c.date DESC LIMIT 0, 5
select name, value from jos_extrawatch_config
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.216.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.*%' limit 1
update jos_extrawatch_uri2title set count = count+1, timestamp = '1766393693' where (`uri` = '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков') limit 1
update jos_extrawatch_uri2title set title = '93 години от рождението на Георги Берков' where id = '2539180'
select id, username from jos_extrawatch where ip = '216.73.216.57' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766393693', '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков', '93 години от рождението на Георги Берков')
select id from jos_extrawatch_uri where fk = '900214' and `timestamp` = '1766393693' and `uri` LIKE '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков' and `title` LIKE '93 години от рождението на Георги Берков'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'Itemid', '265', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'catid', '56', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'id', '2670', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.57' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.57' and date = '20444')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20444')
select ip, country from jos_extrawatch where (ip = '216.73.216.57' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718137 >= start AND 3628718137 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.57'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1766393668;s:18:\"session.timer.last\";i:1766393691;s:17:\"session.timer.now\";i:1766393692;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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:3:\"gid\";s:1:\"1\";}s:16:\"com_mailto.links\";a:24:{s:40:\"ed29d0f61789d458100893cb8a2f99a011c78437\";O:8:\"stdClass\":2:{s:4:\"link\";s:256:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/програма-дюш-сезон-2013-2014/1626-програма-на-двубоите-за-отборите-в-дюш-21-22-април-2017\";s:6:\"expiry\";i:1766393674;}s:40:\"a8493e7542d1251165410cd78faf9ab65bab21f5\";O:8:\"stdClass\":2:{s:4:\"link\";s:201:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2914-контролна-среща-локомотив-рилски-спортист-3-0\";s:6:\"expiry\";i:1766393677;}s:40:\"e2e8b9ad13d087bff912cc5b0c96e4a23112d5a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:196:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2913-второ-равенство-в-контролите-за-локомотив\";s:6:\"expiry\";i:1766393677;}s:40:\"aef9947aebbe999b411a70c1703ee1de5fdd149c\";O:8:\"stdClass\":2:{s:4:\"link\";s:217:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2912-приятелска-среща-септември-симитли-локомотив-го-14-30-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"4f6a8d612fc5b31b205352c99e63ef009ed3bab5\";O:8:\"stdClass\":2:{s:4:\"link\";s:202:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2908-приятелска-среща-локомотив-локомотив-го-14-00-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"9d109406d36ffc2023dffcc41e0e82f68b3772c0\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2903-приятелска-среща-локомотив-сливнишки-герой-14-30-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"110334afc787154e222718a70736cf7e4929f1ef\";O:8:\"stdClass\":2:{s:4:\"link\";s:158:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2896-созопол-локомотив-12-00\";s:6:\"expiry\";i:1766393677;}s:40:\"f31c7ec0a686079a4c7a8ea85bdc6f9ab33c3caf\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2892-локомотив-септември-см-14-45\";s:6:\"expiry\";i:1766393677;}s:40:\"b3340478ea54f655dcc51651cc142ed7e326857a\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2529-гледайте-локомотив-нн-на-държавното-по-водна-топка-за-u19\";s:6:\"expiry\";i:1766393678;}s:40:\"73b7fbe80fa5097d14cf2b7ad5cedf458a16f6cb\";O:8:\"stdClass\":2:{s:4:\"link\";s:165:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2732-срамно-изказване-на-иван-василев\";s:6:\"expiry\";i:1766393680;}s:40:\"b8415493a9eb3279caa1983496e32ca5e2bbcc9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2585-ботев-пловдив-локомотив-0-0-контролна-среща\";s:6:\"expiry\";i:1766393681;}s:40:\"b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2528-генерално-класиране-при-юношите-младша,-зона-софия\";s:6:\"expiry\";i:1766393683;}s:40:\"7b9382354977963cb375cbf3ea9026e97c56c40e\";O:8:\"stdClass\":2:{s:4:\"link\";s:227:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2887-стойка-кръстева-спечели-титла-от-турнира-балкан\";s:6:\"expiry\";i:1766393684;}s:40:\"5b524494e323e0476abc7bee9a536d8de5eb9c17\";O:8:\"stdClass\":2:{s:4:\"link\";s:306:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1967-иван-деянов-на-80\";s:6:\"expiry\";i:1766393686;}s:40:\"96baa8f5577bde065edbd4190e149b6e96277160\";O:8:\"stdClass\":2:{s:4:\"link\";s:395:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1926-ивайло-георгиев-на-75-най-много-във-футбола-научих-от-буч-и-берков\";s:6:\"expiry\";i:1766393686;}s:40:\"e29dcbf77c13fb74ea20aa47fbf3580f4a982a05\";O:8:\"stdClass\":2:{s:4:\"link\";s:322:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1922-почина-стефан-милев-роко\";s:6:\"expiry\";i:1766393686;}s:40:\"bb3921b9824c5492fa6be007844318c09a531648\";O:8:\"stdClass\":2:{s:4:\"link\";s:335:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1879-скръбна-вест-почина-борис-илиев\";s:6:\"expiry\";i:1766393686;}s:40:\"ec1e5de0dc925d47d910a3d8bda420fc30fb287b\";O:8:\"stdClass\":2:{s:4:\"link\";s:383:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1875-11-години-без-начко-михайлов-–-човека-от-улица-“съзнание”\";s:6:\"expiry\";i:1766393686;}s:40:\"45cb6194c232eb1211dd2fdabb205475a3d205e0\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1756-никола-спасов-за-втора-лига-и-локомотив\";s:6:\"expiry\";i:1766393686;}s:40:\"80bddaef8b740f071492eb56df33bceb953f2814\";O:8:\"stdClass\":2:{s:4:\"link\";s:390:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1749-човешки-апел-за-помощ-легенда-на-локо-сф-се-нуждае-от-подкрепа\";s:6:\"expiry\";i:1766393686;}s:40:\"ca093695a1d213f45e1829e3e33cca3a148b4c80\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/родени-1997-дюш/684-скандално-съдийство-опорочи-1-4-финал-срещу-спартак\";s:6:\"expiry\";i:1766393687;}s:40:\"c26011876703f50e52bf2d9c6891e37e0aca886a\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2837-абонаментна-карта-за-сезон-2020-2021\";s:6:\"expiry\";i:1766393689;}s:40:\"92644283e281858954a0244333e43c9ba3bbf2fb\";O:8:\"stdClass\":2:{s:4:\"link\";s:277:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2679-1500-деца-спортуват-в-обединени-спортни-клубове-„локомотив“\";s:6:\"expiry\";i:1766393691;}s:40:\"020d3a7d89a08a83ba153f823ca0a835bcc73eec\";O:8:\"stdClass\":2:{s:4:\"link\";s:240:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков\";s:6:\"expiry\";i:1766393693;}}s:13:\"session.token\";s:32:\"a984085fd24fdbda1ec55af6701a880b\";}' , `time` = '1766393693' WHERE `session_id` = '8173d6572a0b3136b4a81ee270b17e01'

55 записани типове заявки, сортирани по описание

ИЗБРАНИ таблици:

132 × SELECT id FROM jos_categories
9 × SELECT username FROM jos_users
7 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_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 jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
5 × select count(ip) as count from jos_extrawatch_blocked
4 × SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions
3 × SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
3 × SELECT id FROM jos_assets
2 × select count(id) as count from jos_extrawatch_info
2 × SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id
1 × SELECT id, rules FROM `jos_viewlevels
1 × SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang
1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,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 jos_contact_details AS contact
1 × SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang
1 × SELECT guest, usertype, client_id FROM jos_session
1 × select id from jos_extrawatch_uri2title
1 × SELECT country FROM jos_extrawatch_ip2c
1 × select * from jos_extrawatch_goal
1 × select ip, country from jos_extrawatch
1 × select id from jos_extrawatch_uri
1 × SELECT * FROM `jos_jnews_lists`
1 × select id, username from jos_extrawatch
1 × select name, value from jos_extrawatch_confi
1 × SELECT id, fav_team FROM jos_joomleague_project p
1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM jos_languages
1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT * FROM jos_jcomments_setting
1 × SELECT alias, catid FROM jos_content
1 × SELECT folder AS type, element AS name, params FROM jos_extensions
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 jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
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 jos_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 jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid
1 × SELECT a.id, a.title, a.introtext, a.publish_up as date, a.catid, cc.access AS cat_access, a.created_by, a.created_by_alias, u.name AS author, cc.published AS cat_state, 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, cc.title as category_title, a.introtext as introtext_raw, a.fulltext, a.metakey, "0" as match_count, "" as match_list FROM jos_content AS a LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by
1 × SELECT `data` FROM `jos_session`
1 × SELECT m.*,m.id as match_id, t1.id team1_id, t2.id team2_id, DATE(m.match_date) AS match_date_notime, m.match_date AS match_date, NOW() AS currenttime, IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) AS totaltime, IF ( (match_date > UTC_TIMESTAMP() AND m.team1_result IS NULL) AND ((m.team1_result_split IS NULL) OR TRIM(REPLACE(m.team1_result_split, ';', '')) = ''),m.match_date, 'z' ) AS upcoming, IF ( (m.team1_result IS NOT NULL OR m.match_date < UTC_TIMESTAMP()),m.match_date, 0 ) AS alreadyplayed, IF ( ( ( DATE_ADD(m.match_date, INTERVAL IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) MINUTE ) > UTC_TIMESTAMP() ) AND (m.match_date < UTC_TIMESTAMP() ) AND (m.team1_result IS NULL) ),m.match_date, 'z' ) AS actplaying, IF ( ((m.team1_result IS NULL) AND (m.team1_result_split IS NOT NULL) AND TRIM(REPLACE(m.team1_result_split, ';', '') != '')),m.match_date,'z' ) AS live, DATE_SUB(m.match_date, INTERVAL '90' MINUTE) AS meetingtime, NOW() AS local_time, r.*, p.name AS pname, p.current_round, p.id AS project_id, p.timezone, p.game_parts, p.ordering, IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname, pg.name AS pg_name, pt1.division_id, pg.short_name AS pg_shortname FROM jos_joomleague_match m INNER JOIN jos_joomleague_round r ON m.round_id = r.id INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = m.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = m.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id INNER JOIN jos_joomleague_project p ON pt1.project_id = p.id LEFT JOIN jos_joomleague_match_referee AS mref ON m.id = mref.match_id LEFT JOIN jos_joomleague_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN jos_joomleague_person AS person ON person.id = pref.person_id AND person.published = 1 AND pref.published = 1 LEFT JOIN jos_joomleague_playground AS pg ON pg.id = m.playground_id
1 × SELECT a.metakey, a.catid, a.created_by, a.created_by_alias, cc.title as category_title, u.name as author FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT * FROM `jos_jcomments_objects`
1 × SELECT count(*) FROM jos_jcomments AS c
1 × SELECT * FROM `jos_jnews_xonfig

ДРУГИ таблици:

2 × update jos_extrawatch_info set value = value+1
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'catid', '56', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'view', 'article', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'id', '2670', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:13;s:19:\"session.timer.start\";i:1766393668;s:18:\"session.timer.last\";i:1766393691;s:17:\"session.timer.now\";i:1766393692;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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:3:\"gid\";s:1:\"1\";}s:16:\"com_mailto.links\";a:24:{s:40:\"ed29d0f61789d458100893cb8a2f99a011c78437\";O:8:\"stdClass\":2:{s:4:\"link\";s:256:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/програма-дюш-сезон-2013-2014/1626-програма-на-двубоите-за-отборите-в-дюш-21-22-април-2017\";s:6:\"expiry\";i:1766393674;}s:40:\"a8493e7542d1251165410cd78faf9ab65bab21f5\";O:8:\"stdClass\":2:{s:4:\"link\";s:201:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2914-контролна-среща-локомотив-рилски-спортист-3-0\";s:6:\"expiry\";i:1766393677;}s:40:\"e2e8b9ad13d087bff912cc5b0c96e4a23112d5a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:196:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2913-второ-равенство-в-контролите-за-локомотив\";s:6:\"expiry\";i:1766393677;}s:40:\"aef9947aebbe999b411a70c1703ee1de5fdd149c\";O:8:\"stdClass\":2:{s:4:\"link\";s:217:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2912-приятелска-среща-септември-симитли-локомотив-го-14-30-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"4f6a8d612fc5b31b205352c99e63ef009ed3bab5\";O:8:\"stdClass\":2:{s:4:\"link\";s:202:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2908-приятелска-среща-локомотив-локомотив-го-14-00-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"9d109406d36ffc2023dffcc41e0e82f68b3772c0\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2903-приятелска-среща-локомотив-сливнишки-герой-14-30-ч\";s:6:\"expiry\";i:1766393677;}s:40:\"110334afc787154e222718a70736cf7e4929f1ef\";O:8:\"stdClass\":2:{s:4:\"link\";s:158:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2896-созопол-локомотив-12-00\";s:6:\"expiry\";i:1766393677;}s:40:\"f31c7ec0a686079a4c7a8ea85bdc6f9ab33c3caf\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2892-локомотив-септември-см-14-45\";s:6:\"expiry\";i:1766393677;}s:40:\"b3340478ea54f655dcc51651cc142ed7e326857a\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2529-гледайте-локомотив-нн-на-държавното-по-водна-топка-за-u19\";s:6:\"expiry\";i:1766393678;}s:40:\"73b7fbe80fa5097d14cf2b7ad5cedf458a16f6cb\";O:8:\"stdClass\":2:{s:4:\"link\";s:165:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2732-срамно-изказване-на-иван-василев\";s:6:\"expiry\";i:1766393680;}s:40:\"b8415493a9eb3279caa1983496e32ca5e2bbcc9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2585-ботев-пловдив-локомотив-0-0-контролна-среща\";s:6:\"expiry\";i:1766393681;}s:40:\"b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2528-генерално-класиране-при-юношите-младша,-зона-софия\";s:6:\"expiry\";i:1766393683;}s:40:\"7b9382354977963cb375cbf3ea9026e97c56c40e\";O:8:\"stdClass\":2:{s:4:\"link\";s:227:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2887-стойка-кръстева-спечели-титла-от-турнира-балкан\";s:6:\"expiry\";i:1766393684;}s:40:\"5b524494e323e0476abc7bee9a536d8de5eb9c17\";O:8:\"stdClass\":2:{s:4:\"link\";s:306:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1967-иван-деянов-на-80\";s:6:\"expiry\";i:1766393686;}s:40:\"96baa8f5577bde065edbd4190e149b6e96277160\";O:8:\"stdClass\":2:{s:4:\"link\";s:395:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1926-ивайло-георгиев-на-75-най-много-във-футбола-научих-от-буч-и-берков\";s:6:\"expiry\";i:1766393686;}s:40:\"e29dcbf77c13fb74ea20aa47fbf3580f4a982a05\";O:8:\"stdClass\":2:{s:4:\"link\";s:322:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1922-почина-стефан-милев-роко\";s:6:\"expiry\";i:1766393686;}s:40:\"bb3921b9824c5492fa6be007844318c09a531648\";O:8:\"stdClass\":2:{s:4:\"link\";s:335:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1879-скръбна-вест-почина-борис-илиев\";s:6:\"expiry\";i:1766393686;}s:40:\"ec1e5de0dc925d47d910a3d8bda420fc30fb287b\";O:8:\"stdClass\":2:{s:4:\"link\";s:383:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1875-11-години-без-начко-михайлов-–-човека-от-улица-“съзнание”\";s:6:\"expiry\";i:1766393686;}s:40:\"45cb6194c232eb1211dd2fdabb205475a3d205e0\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1756-никола-спасов-за-втора-лига-и-локомотив\";s:6:\"expiry\";i:1766393686;}s:40:\"80bddaef8b740f071492eb56df33bceb953f2814\";O:8:\"stdClass\":2:{s:4:\"link\";s:390:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/1749-човешки-апел-за-помощ-легенда-на-локо-сф-се-нуждае-от-подкрепа\";s:6:\"expiry\";i:1766393686;}s:40:\"ca093695a1d213f45e1829e3e33cca3a148b4c80\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/родени-1997-дюш/684-скандално-съдийство-опорочи-1-4-финал-срещу-спартак\";s:6:\"expiry\";i:1766393687;}s:40:\"c26011876703f50e52bf2d9c6891e37e0aca886a\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2837-абонаментна-карта-за-сезон-2020-2021\";s:6:\"expiry\";i:1766393689;}s:40:\"92644283e281858954a0244333e43c9ba3bbf2fb\";O:8:\"stdClass\":2:{s:4:\"link\";s:277:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2679-1500-деца-спортуват-в-обединени-спортни-клубове-„локомотив“\";s:6:\"expiry\";i:1766393691;}s:40:\"020d3a7d89a08a83ba153f823ca0a835bcc73eec\";O:8:\"stdClass\":2:{s:4:\"link\";s:240:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков\";s:6:\"expiry\";i:1766393693;}}s:13:\"session.token\";s:32:\"a984085fd24fdbda1ec55af6701a880b\";}' , `time` = '1766393693'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280789', 'Itemid', '265', 2
1 × DELETE FROM `jos_session`
1 × UPDATE jos_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `jos_jnews_xonfig
1 × update jos_extrawatch_uri2title set count = count+1, timestamp = '1766393693'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766393693', '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2670-93-години-от-рождението-на-георги-берков', '93 години от рождението на Георги Берков'
1 × update jos_extrawatch_uri2title set title = '93 години от рождението на Георги Берков'
1 × SHOW FULL COLUMNS FROM `jos_assets

Добавете коментар

Подобни публикации

ВИДЕО

Конзола за дебъг на Joomla!

Сесия

__default

user

com_mailto.links

ed29d0f61789d458100893cb8a2f99a011c78437

a8493e7542d1251165410cd78faf9ab65bab21f5

e2e8b9ad13d087bff912cc5b0c96e4a23112d5a5

aef9947aebbe999b411a70c1703ee1de5fdd149c

4f6a8d612fc5b31b205352c99e63ef009ed3bab5

9d109406d36ffc2023dffcc41e0e82f68b3772c0

110334afc787154e222718a70736cf7e4929f1ef

f31c7ec0a686079a4c7a8ea85bdc6f9ab33c3caf

b3340478ea54f655dcc51651cc142ed7e326857a

73b7fbe80fa5097d14cf2b7ad5cedf458a16f6cb

b8415493a9eb3279caa1983496e32ca5e2bbcc9e

b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f

7b9382354977963cb375cbf3ea9026e97c56c40e

5b524494e323e0476abc7bee9a536d8de5eb9c17

96baa8f5577bde065edbd4190e149b6e96277160

e29dcbf77c13fb74ea20aa47fbf3580f4a982a05

bb3921b9824c5492fa6be007844318c09a531648

ec1e5de0dc925d47d910a3d8bda420fc30fb287b

45cb6194c232eb1211dd2fdabb205475a3d205e0

80bddaef8b740f071492eb56df33bceb953f2814

ca093695a1d213f45e1829e3e33cca3a148b4c80

c26011876703f50e52bf2d9c6891e37e0aca886a

92644283e281858954a0244333e43c9ba3bbf2fb

020d3a7d89a08a83ba153f823ca0a835bcc73eec

Информация за профила

Използвана памет

Заявки към базата данни

214 записани заявки

55 записани типове заявки, сортирани по описание

ИЗБРАНИ таблици:

ДРУГИ таблици: