30.06.2013 г. - да си спомним Никола Котков

вкл. 26 Юни 2013.

kotkov small

Тази година на 30 юни се навършват 42 години от смъртта на двама от най-великите футболисти в историята на България - Георги Аспарухов (Гунди) и Никола Котков (Котето).

Денят се пада неделя, а от "Железни бригади" и RBP каним всички локомотивци, които имат възможност, да поднесат цветя на лобното им място на Витиня сутринта, а след това в 11:00 часа ще се срещнем пред метростанция "Хан Кубрат", откъдето ще тръгнем на мини шествие, за да поднесем цветя на паметника на Никола Котков в "Надежда", откъдето ще се насочим към Централни глобища, за да положим венец на гроба на двамата велики футболисти.

ПОКЛОН ПРЕД ВЕЧНАТА ИМ ПАМЕТ!

< Предишна

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

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

session.token ⇒ 1965b9a0fabd477f2c12e2277b3d47f3

com_mailto.links

9a44ef67a340270d21d1e00aef27c5917bf754e6

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/637-видео-2014-2015-27-кръг-локомотив-ботев-1-0

86ec6753e6753e78aca3012c21b5feb7c1579ed2

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/817-видео-2015-2016-5-кръг-спартак-подгомер-локомотив-2-3

709aee6c2f1977a4e8c5d47c18b2cbfe41e1b9d4

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1664-видео-локомотив-созопол-3-1-27-кръг-впл-2016-2017

078e48040c884bbb3bed36ddcd4ce6af6e77dd25

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

2c7b17d15a5f33ea48429f2798f458b4ca69f742

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1015-видео-локомотив-сокол-н-4-0-18-кръг-срг-2015-2016

d7335a5f7d6c9b676ed964d10a2dd9574cad1cc0

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

2adf3abe330564fd698a04c72905e3b30d5b2f96

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

60e38d3f0d2c26c427e603b41fae8e0c332514e8

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

4bc886e3100600dd29ef2bb7f0b6728b4287f042

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2476-видео-кариана-локомотив-0-2-24-кръг-впл-2018-2019

b1dd32dcbc96d97f27eff18ce4ac82a364eb8125

link ⇒ https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/1124-необходима-ни-е-помощ,-попълваме-екипа-на-lokosf-info

d2c1de570553d3eb0aba99a1866385bbab3ff123

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/874-видео-2015-2016-11-кръг-вихър-локомотив-0-2

f3713d8aac3601ad1a66fc0f3b33d6bf46c3a29f

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/957-видео-2015-2016-13-кръг-софия-спорт-локомотив-1-5

bee58e1f465349ceae256bfa315444bb2eda16aa

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

3b9501219048b76c141dc3a3fa5df473596bd604

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1561-видео-локомотив-поморие-3-0-20-кръг-впл-2016-2017

47d0cfcfef99c08496a466f61c7bd4ab01fec716

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1764-видео-лудогорец-2-локомотив-2-1-1-кръг-впл-2017-2018

e65d0cb6c23dfff1e04f3b08df71d1789e74ecd9

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2033-видео-монтана-локомотив-4-0-19-кръг-впл-2017-2018

d6bc7326b9e42225d097761efb0924cf8b0d37de

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

c98da7b77968688c8f113e66635f8231b4f66bc1

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1793-видео-оборище-локомотив-1-2-3-кръг-впл-2017-2018

d2dd96311f6383a1a41712ed139976a05199da3d

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

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

Application 0.050 seconds (+0.050); 3.87 MB (+3.225) - afterInitialise

Application 0.098 seconds (+0.048); 6.66 MB (+2.788) - afterRoute

Application 0.279 seconds (+0.182); 10.41 MB (+3.750) - afterDispatch

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

Application 0.300 seconds (+0.005); 10.91 MB (+0.044) - afterRenderModule mod_search (Търси)

Application 0.302 seconds (+0.002); 10.91 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.305 seconds (+0.003); 10.92 MB (+0.009) - afterRenderModule mod_custom (LOGO)

Application 0.306 seconds (+0.001); 10.92 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.378 seconds (+0.071); 12.87 MB (+1.958) - afterRenderModule mod_menu (Main Menu)

Application 0.401 seconds (+0.023); 13.13 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.406 seconds (+0.004); 13.16 MB (+0.030) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.407 seconds (+0.002); 13.17 MB (+0.015) - beforeRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.489 seconds (+0.082); 13.45 MB (+0.274) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.492 seconds (+0.003); 13.36 MB (-0.091) - beforeRenderModule mod_menu (Submenu)

Application 0.511 seconds (+0.019); 13.37 MB (+0.016) - afterRenderModule mod_menu (Submenu)

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

Application 0.512 seconds (+0.001); 13.37 MB (+0.005) - afterRenderModule mod_custom (ВХОД_html)

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

Application 0.516 seconds (+0.004); 13.38 MB (+0.007) - afterRenderModule mod_custom (Събития)

Application 0.516 seconds (+0.000); 13.37 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.517 seconds (+0.001); 13.38 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

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

Application 0.553 seconds (+0.035); 13.82 MB (+0.407) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.554 seconds (+0.000); 13.78 MB (-0.038) - beforeRenderModule mod_custom (razvitie)

Application 0.555 seconds (+0.001); 13.78 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 0.612 seconds (+0.057); 16.53 MB (+2.740) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

Application 0.618 seconds (+0.005); 16.58 MB (+0.077) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.714 seconds (+0.096); 17.09 MB (+0.517) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.714 seconds (+0.000); 17.07 MB (-0.026) - beforeRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.789 seconds (+0.075); 17.19 MB (+0.124) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.789 seconds (+0.000); 17.07 MB (-0.117) - afterRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) sidebar-b)

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

Application 0.797 seconds (+0.008); 17.10 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

Application 0.810 seconds (+0.013); 17.13 MB (+0.029) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 0.829 seconds (+0.019); 17.46 MB (+0.332) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.830 seconds (+0.001); 17.50 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 0.835 seconds (+0.005); 17.52 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 0.863 seconds (+0.028); 17.67 MB (+0.152) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 0.892 seconds (+0.029); 17.69 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 0.895 seconds (+0.003); 17.65 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.032 seconds (+0.137); 19.98 MB (+2.327) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.065 seconds (+0.033); 20.00 MB (+0.023) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '194b1a1530b3f1bbe2499f415b5c1225'
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=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 alias, catid FROM jos_content WHERE id = 28
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 = 28 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-24 17:50:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-24 17:50:20') 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=25 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.28') 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 = 25 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 <= '2026-02-24 17:50:20') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-24 17:50:20') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '28' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 28 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 28
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 <= '2026-02-24 17:50:20') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-24 17:50:20') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 167 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'
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 = 28
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 != 28 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 CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Локомотивци,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-24 17:50:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-24 17:50:20' ) 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=22 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 <= '2026-02-24 17:50:20' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-24 17:50:20' ) 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('2026-02-24 17:50:20', 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 username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
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=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 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=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
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=36 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 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 <= '2026-02-24 17:50:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-24 17:50:20') 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.180' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.180' 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 = '1771955421' where (`uri` = '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков') limit 1
update jos_extrawatch_uri2title set title = '30.06.2013 г. - да си спомним Никола Котков' where id = '2596041'
select id, username from jos_extrawatch where ip = '216.73.216.180' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '909106', '1771955421', '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков', '30.06.2013 г. - да си спомним Никола Котков')
select id from jos_extrawatch_uri where fk = '909106' and `timestamp` = '1771955421' and `uri` LIKE '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков' and `title` LIKE '30.06.2013 г. - да си спомним Никола Котков'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'Itemid', '167', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'catid', '25', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'id', '28', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.180' and date = '20508')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.180' and date = '20508')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20508')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20508')
select ip, country from jos_extrawatch where (ip = '216.73.216.180' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718260 >= start AND 3628718260 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.180'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1771955373;s:18:\"session.timer.last\";i:1771955418;s:17:\"session.timer.now\";i:1771955420;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:13:\"session.token\";s:32:\"1965b9a0fabd477f2c12e2277b3d47f3\";s:16:\"com_mailto.links\";a:19:{s:40:\"9a44ef67a340270d21d1e00aef27c5917bf754e6\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/637-видео-2014-2015-27-кръг-локомотив-ботев-1-0\";s:6:\"expiry\";i:1771955376;}s:40:\"86ec6753e6753e78aca3012c21b5feb7c1579ed2\";O:8:\"stdClass\":2:{s:4:\"link\";s:358:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/817-видео-2015-2016-5-кръг-спартак-подгомер-локомотив-2-3\";s:6:\"expiry\";i:1771955378;}s:40:\"709aee6c2f1977a4e8c5d47c18b2cbfe41e1b9d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1664-видео-локомотив-созопол-3-1-27-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955382;}s:40:\"078e48040c884bbb3bed36ddcd4ce6af6e77dd25\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1376-видео-созопол-локомотив-0-0-12-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955384;}s:40:\"2c7b17d15a5f33ea48429f2798f458b4ca69f742\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1015-видео-локомотив-сокол-н-4-0-18-кръг-срг-2015-2016\";s:6:\"expiry\";i:1771955387;}s:40:\"d7335a5f7d6c9b676ed964d10a2dd9574cad1cc0\";O:8:\"stdClass\":2:{s:4:\"link\";s:348:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1653-видео-витоша-локомотив-0-2-26-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955389;}s:40:\"2adf3abe330564fd698a04c72905e3b30d5b2f96\";O:8:\"stdClass\":2:{s:4:\"link\";s:396:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/860-видео-красен-кралев-подкрепяме-проекта-за-възраждането-на-дюш-на-локомотив\";s:6:\"expiry\";i:1771955391;}s:40:\"60e38d3f0d2c26c427e603b41fae8e0c332514e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:248:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/925-локомотив-ботев-ихтиман-ще-се-играе-на-11-февруари-14-00-ч-в-с-к-царско-село\";s:6:\"expiry\";i:1771955393;}s:40:\"4bc886e3100600dd29ef2bb7f0b6728b4287f042\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2476-видео-кариана-локомотив-0-2-24-кръг-впл-2018-2019\";s:6:\"expiry\";i:1771955396;}s:40:\"b1dd32dcbc96d97f27eff18ce4ac82a364eb8125\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/1124-необходима-ни-е-помощ,-попълваме-екипа-на-lokosf-info\";s:6:\"expiry\";i:1771955398;}s:40:\"d2c1de570553d3eb0aba99a1866385bbab3ff123\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/874-видео-2015-2016-11-кръг-вихър-локомотив-0-2\";s:6:\"expiry\";i:1771955401;}s:40:\"f3713d8aac3601ad1a66fc0f3b33d6bf46c3a29f\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/957-видео-2015-2016-13-кръг-софия-спорт-локомотив-1-5\";s:6:\"expiry\";i:1771955403;}s:40:\"bee58e1f465349ceae256bfa315444bb2eda16aa\";O:8:\"stdClass\":2:{s:4:\"link\";s:395:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/643-видео-и-интервю-георги-пеев-бележи-за-амкар-при-победа-над-динамо\";s:6:\"expiry\";i:1771955406;}s:40:\"3b9501219048b76c141dc3a3fa5df473596bd604\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1561-видео-локомотив-поморие-3-0-20-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955407;}s:40:\"47d0cfcfef99c08496a466f61c7bd4ab01fec716\";O:8:\"stdClass\":2:{s:4:\"link\";s:355:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1764-видео-лудогорец-2-локомотив-2-1-1-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955409;}s:40:\"e65d0cb6c23dfff1e04f3b08df71d1789e74ecd9\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2033-видео-монтана-локомотив-4-0-19-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955414;}s:40:\"d6bc7326b9e42225d097761efb0924cf8b0d37de\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/864-цветан-генков-с-гол-при-победа-на-денизлиспор\";s:6:\"expiry\";i:1771955416;}s:40:\"c98da7b77968688c8f113e66635f8231b4f66bc1\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1793-видео-оборище-локомотив-1-2-3-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955418;}s:40:\"d2dd96311f6383a1a41712ed139976a05199da3d\";O:8:\"stdClass\":2:{s:4:\"link\";s:339:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков\";s:6:\"expiry\";i:1771955420;}}}' , `time` = '1771955421' WHERE `session_id` = '194b1a1530b3f1bbe2499f415b5c1225'

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

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

132 × SELECT id FROM jos_categories
9 × SELECT username FROM jos_users
6 × 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 ('12600499', 'catid', '25', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'view', 'article', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'id', '28', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', '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:32;s:19:\"session.timer.start\";i:1771955373;s:18:\"session.timer.last\";i:1771955418;s:17:\"session.timer.now\";i:1771955420;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:13:\"session.token\";s:32:\"1965b9a0fabd477f2c12e2277b3d47f3\";s:16:\"com_mailto.links\";a:19:{s:40:\"9a44ef67a340270d21d1e00aef27c5917bf754e6\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/637-видео-2014-2015-27-кръг-локомотив-ботев-1-0\";s:6:\"expiry\";i:1771955376;}s:40:\"86ec6753e6753e78aca3012c21b5feb7c1579ed2\";O:8:\"stdClass\":2:{s:4:\"link\";s:358:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/817-видео-2015-2016-5-кръг-спартак-подгомер-локомотив-2-3\";s:6:\"expiry\";i:1771955378;}s:40:\"709aee6c2f1977a4e8c5d47c18b2cbfe41e1b9d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1664-видео-локомотив-созопол-3-1-27-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955382;}s:40:\"078e48040c884bbb3bed36ddcd4ce6af6e77dd25\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1376-видео-созопол-локомотив-0-0-12-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955384;}s:40:\"2c7b17d15a5f33ea48429f2798f458b4ca69f742\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1015-видео-локомотив-сокол-н-4-0-18-кръг-срг-2015-2016\";s:6:\"expiry\";i:1771955387;}s:40:\"d7335a5f7d6c9b676ed964d10a2dd9574cad1cc0\";O:8:\"stdClass\":2:{s:4:\"link\";s:348:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1653-видео-витоша-локомотив-0-2-26-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955389;}s:40:\"2adf3abe330564fd698a04c72905e3b30d5b2f96\";O:8:\"stdClass\":2:{s:4:\"link\";s:396:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/860-видео-красен-кралев-подкрепяме-проекта-за-възраждането-на-дюш-на-локомотив\";s:6:\"expiry\";i:1771955391;}s:40:\"60e38d3f0d2c26c427e603b41fae8e0c332514e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:248:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/925-локомотив-ботев-ихтиман-ще-се-играе-на-11-февруари-14-00-ч-в-с-к-царско-село\";s:6:\"expiry\";i:1771955393;}s:40:\"4bc886e3100600dd29ef2bb7f0b6728b4287f042\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2476-видео-кариана-локомотив-0-2-24-кръг-впл-2018-2019\";s:6:\"expiry\";i:1771955396;}s:40:\"b1dd32dcbc96d97f27eff18ce4ac82a364eb8125\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/1124-необходима-ни-е-помощ,-попълваме-екипа-на-lokosf-info\";s:6:\"expiry\";i:1771955398;}s:40:\"d2c1de570553d3eb0aba99a1866385bbab3ff123\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/874-видео-2015-2016-11-кръг-вихър-локомотив-0-2\";s:6:\"expiry\";i:1771955401;}s:40:\"f3713d8aac3601ad1a66fc0f3b33d6bf46c3a29f\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/957-видео-2015-2016-13-кръг-софия-спорт-локомотив-1-5\";s:6:\"expiry\";i:1771955403;}s:40:\"bee58e1f465349ceae256bfa315444bb2eda16aa\";O:8:\"stdClass\":2:{s:4:\"link\";s:395:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/643-видео-и-интервю-георги-пеев-бележи-за-амкар-при-победа-над-динамо\";s:6:\"expiry\";i:1771955406;}s:40:\"3b9501219048b76c141dc3a3fa5df473596bd604\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1561-видео-локомотив-поморие-3-0-20-кръг-впл-2016-2017\";s:6:\"expiry\";i:1771955407;}s:40:\"47d0cfcfef99c08496a466f61c7bd4ab01fec716\";O:8:\"stdClass\":2:{s:4:\"link\";s:355:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1764-видео-лудогорец-2-локомотив-2-1-1-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955409;}s:40:\"e65d0cb6c23dfff1e04f3b08df71d1789e74ecd9\";O:8:\"stdClass\":2:{s:4:\"link\";s:350:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2033-видео-монтана-локомотив-4-0-19-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955414;}s:40:\"d6bc7326b9e42225d097761efb0924cf8b0d37de\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/864-цветан-генков-с-гол-при-победа-на-денизлиспор\";s:6:\"expiry\";i:1771955416;}s:40:\"c98da7b77968688c8f113e66635f8231b4f66bc1\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/1793-видео-оборище-локомотив-1-2-3-кръг-впл-2017-2018\";s:6:\"expiry\";i:1771955418;}s:40:\"d2dd96311f6383a1a41712ed139976a05199da3d\";O:8:\"stdClass\":2:{s:4:\"link\";s:339:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков\";s:6:\"expiry\";i:1771955420;}}}' , `time` = '1771955421'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12600499', 'Itemid', '167', 2
1 × SHOW FULL COLUMNS FROM `jos_jnews_xonfig
1 × UPDATE jos_content SET hits = hits + 1
1 × update jos_extrawatch_uri2title set count = count+1, timestamp = '1771955421'
1 × update jos_extrawatch_uri2title set title = '30.06.2013 г. - да си спомним Никола Котков'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '909106', '1771955421', '/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/28-30-06-2013-г-да-си-спомним-никола-котков', '30.06.2013 г. - да си спомним Никола Котков'
1 × SHOW FULL COLUMNS FROM `jos_assets

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

9a44ef67a340270d21d1e00aef27c5917bf754e6

86ec6753e6753e78aca3012c21b5feb7c1579ed2

709aee6c2f1977a4e8c5d47c18b2cbfe41e1b9d4

078e48040c884bbb3bed36ddcd4ce6af6e77dd25

2c7b17d15a5f33ea48429f2798f458b4ca69f742

d7335a5f7d6c9b676ed964d10a2dd9574cad1cc0

2adf3abe330564fd698a04c72905e3b30d5b2f96

60e38d3f0d2c26c427e603b41fae8e0c332514e8

4bc886e3100600dd29ef2bb7f0b6728b4287f042

b1dd32dcbc96d97f27eff18ce4ac82a364eb8125

d2c1de570553d3eb0aba99a1866385bbab3ff123

f3713d8aac3601ad1a66fc0f3b33d6bf46c3a29f

bee58e1f465349ceae256bfa315444bb2eda16aa

3b9501219048b76c141dc3a3fa5df473596bd604

47d0cfcfef99c08496a466f61c7bd4ab01fec716

e65d0cb6c23dfff1e04f3b08df71d1789e74ecd9

d6bc7326b9e42225d097761efb0924cf8b0d37de

c98da7b77968688c8f113e66635f8231b4f66bc1

d2dd96311f6383a1a41712ed139976a05199da3d

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

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

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

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

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

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

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