България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора

вкл. 18 Април 2019.

buulgaria 2003 U16 2019 valentin nikolov kapitan

Юношеският национален тим по футбол до 16 г. затвърди възходящата линия в представянето си, след като спечели четиристранния приятелски турнир под егидата на УЕФА, който се проведе през последната седмица в Сливен.

В решителния мач за първото място днес възпитаниците на Марчо Дафчев надделяха над коравия тим на Северна Ирландия след 1:1 в редовното време и 5:4 при изпълнението на дузпи. Така, след успехите в предишните два мача срещу Уелс (3:1) и Люксембург (2:0), тимът на България стана недостижим на върха в класирането. Капитан на тима ни бе локомотивецът Валентин Николов, който получи покана за проби от английския Фулъм (вижте повече тук)

България U16:

Мартин Петков (Лудогорец)

Радостин Георгиев (Берое)

Мартин Аврамов (ЦСКА-София)

Калоян Костов (Септември София)

Иван Йоанис Атанатос (Славия)

Анастас Пемперски (Лудогорец)

Александър Бучков (ЦСКА-София)

Лазар Боянов (Брук Хаус Колеж, Англия)

Николай Калинов (Левски)

Антон Бакалов (Национал)

Даниел Начев (Левски)

Пламен Цончев (Ботев Пловдив)

Мартин Хайдаров (Левски)

Станислав Дюлгеров (Твенте, Холандия)

Панайот Пасков (Септември София)

Димитър Иванов (Левски)

Мартин Смоленски (ЦСКА-София)

Валентин Николов (Локомотив София)

Мартин Сораков (Славия)

Симеон Александров (Септември София)

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

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

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

de1a8135b6fb7c740ff0f765b05d19a70987496d

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

d67eb4d3ae692c62f0c2f05d0d0c01b39b75d5ee

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

459502f4fbbbe9eb9f33ca66ef09d2d1a5a12865

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

d751cea8bab0a3e4e688d6e0a7da241389b176d4

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

555c52e2d12de0e80786c06400643a7923124efa

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

18097c5808721ba18a75a92d9cbe31cb6f3be8d9

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

f7d66e3f355344b4a36ceb4c5bc86cf2f9b77bc8

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/794-стартира-ремонтът-на-помощното-игрище-на-стадион-локомотив

dab525297e880a0e119f0000c97e86879b5be04a

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

3669d5395f30f005bdfc37c2cdfcacf7148bd8a4

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

91de0aec9862fc5e368bd00ba388f68c22f5e0c5

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/137-бюлетин-lokosf-info-бр-9

6f3b18794b9f9046c13f202f21290578a0dde5d9

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/136-бюлетин-lokosf-info-бр-8

839e61eedd91725caeafb6204ebd016e388a36f4

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/143-бюлетин-lokosf-info-бр-15

84d698b8975600c0724a9e8034bdca913699ba86

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/142-бюлетин-lokosf-info-бр-14

226e90880c0768d5b422f251f9a80f641269eb5c

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2737-видео-локомотив-цска-1948-2-3-18-кръг-впл-2019-2020

1685a9711ce29b735e3f22a7e82050330477d7f9

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

6d53c2b178c9eff000db4f0bbe1a19cc45fae83d

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/2918-видео-цска-софия-локомотив-3-1

26a7f1224458913db8dc9ea8858b298c1408784f

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

7014340dec6759fbf8b764b99e0c6f77d4ab13ad

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

110cd92b56aa7e182d251b67199cd2a0dd21cb77

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

session.token ⇒ aa1b9525737e018a74924d0742ab386e

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

Application 0.053 seconds (+0.053); 3.87 MB (+3.220) - afterInitialise

Application 0.099 seconds (+0.045); 6.60 MB (+2.736) - afterRoute

Application 0.275 seconds (+0.176); 10.37 MB (+3.769) - afterDispatch

Application 0.290 seconds (+0.015); 10.83 MB (+0.458) - beforeRenderModule mod_search (Търси)

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

Application 0.296 seconds (+0.001); 10.87 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.299 seconds (+0.003); 10.88 MB (+0.009) - afterRenderModule mod_custom (LOGO)

Application 0.301 seconds (+0.001); 10.88 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.391 seconds (+0.090); 12.83 MB (+1.957) - afterRenderModule mod_menu (Main Menu)

Application 0.416 seconds (+0.026); 13.09 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.421 seconds (+0.005); 13.12 MB (+0.028) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Application 0.677 seconds (+0.254); 13.41 MB (+0.276) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.680 seconds (+0.003); 13.33 MB (-0.084) - beforeRenderModule mod_menu (Submenu)

Application 0.688 seconds (+0.008); 13.34 MB (+0.010) - afterRenderModule mod_menu (Submenu)

Application 0.688 seconds (+0.000); 13.33 MB (-0.007) - beforeRenderModule mod_custom (ВХОД_html)

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

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

Application 0.692 seconds (+0.003); 13.34 MB (+0.007) - afterRenderModule mod_custom (Събития)

Application 0.692 seconds (+0.000); 13.34 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.693 seconds (+0.001); 13.34 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

Application 0.693 seconds (+0.000); 13.37 MB (+0.030) - beforeRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.722 seconds (+0.029); 13.78 MB (+0.408) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.724 seconds (+0.002); 13.74 MB (-0.039) - beforeRenderModule mod_custom (razvitie)

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

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

Application 0.770 seconds (+0.045); 16.50 MB (+2.740) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

Application 0.776 seconds (+0.004); 16.54 MB (+0.078) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.853 seconds (+0.077); 17.06 MB (+0.517) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

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

Application 0.932 seconds (+0.078); 17.28 MB (+0.251) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

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

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

Application 0.981 seconds (+0.026); 17.57 MB (+0.355) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.982 seconds (+0.001); 17.61 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 0.989 seconds (+0.007); 17.63 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 1.015 seconds (+0.027); 17.78 MB (+0.152) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 1.045 seconds (+0.030); 17.80 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 1.048 seconds (+0.003); 17.76 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.160 seconds (+0.112); 20.09 MB (+2.327) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.189 seconds (+0.028); 20.11 MB (+0.021) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = 'a813e97429543f0e2774994dd43e4e75'
DELETE FROM `jos_session` WHERE `time` < '1766395301'
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=2468 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 = 2468
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 = 2468 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 10:21:41') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:21:41') 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=18 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.2468') 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 = 18 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 10:21:41') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-22 10:21:41') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '2468' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 2468 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 2468
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 10:21:41') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-22 10:21:41') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 147 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` < '1766395301'
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 = 2468
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 != 2468 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 "%,U16,%" 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 <= '2025-12-22 10:21:41' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:21:41' ) 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=33 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=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 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 10:21:41' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:21:41' ) 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 10:21:41', 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 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 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 10:21:41') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:21:41') ORDER BY a.created DESC LIMIT 0, 1
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=49 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 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 = '1766398902' where (`uri` = '/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора') limit 1
update jos_extrawatch_uri2title set title = 'България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора' where id = '2538740'
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', '1766398902', '/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора', 'България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора')
select id from jos_extrawatch_uri where fk = '900214' and `timestamp` = '1766398902' and `uri` LIKE '/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора' and `title` LIKE 'България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'Itemid', '147', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'catid', '18', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'id', '2468', 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:19;s:19:\"session.timer.start\";i:1766398867;s:18:\"session.timer.last\";i:1766398900;s:17:\"session.timer.now\";i:1766398901;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:19:{s:40:\"de1a8135b6fb7c740ff0f765b05d19a70987496d\";O:8:\"stdClass\":2:{s:4:\"link\";s:234:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/2706-младен-додич-искам-момчетата-да-играят-без-напрежение\";s:6:\"expiry\";i:1766398867;}s:40:\"d67eb4d3ae692c62f0c2f05d0d0c01b39b75d5ee\";O:8:\"stdClass\":2:{s:4:\"link\";s:212:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2875-боксов-клуб-локомотив-е-отборен-шампион\";s:6:\"expiry\";i:1766398872;}s:40:\"459502f4fbbbe9eb9f33ca66ef09d2d1a5a12865\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/777-представяне-на-отбор-за-новия-полусезон-есен-2015\";s:6:\"expiry\";i:1766398873;}s:40:\"d751cea8bab0a3e4e688d6e0a7da241389b176d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:343:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2291-видео-локомотив-арда-0-3-7-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398875;}s:40:\"555c52e2d12de0e80786c06400643a7923124efa\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2458-видео-локомотив-ботев-г-1-0-23-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398878;}s:40:\"18097c5808721ba18a75a92d9cbe31cb6f3be8d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:264:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/1041-децата-на-локомотив-ще-участват-на-най-големия-юношески-турнир-в-света\";s:6:\"expiry\";i:1766398879;}s:40:\"f7d66e3f355344b4a36ceb4c5bc86cf2f9b77bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/видео/794-стартира-ремонтът-на-помощното-игрище-на-стадион-локомотив\";s:6:\"expiry\";i:1766398880;}s:40:\"dab525297e880a0e119f0000c97e86879b5be04a\";O:8:\"stdClass\":2:{s:4:\"link\";s:221:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/977-упътване-и-транспорт-до-стадион-ботунец-преди-мача-с-кремиковци\";s:6:\"expiry\";i:1766398884;}s:40:\"3669d5395f30f005bdfc37c2cdfcacf7148bd8a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:205:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/2860-първи-международен-турнир-в-памет-на-георги-тонков\";s:6:\"expiry\";i:1766398886;}s:40:\"91de0aec9862fc5e368bd00ba388f68c22f5e0c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/137-бюлетин-lokosf-info-бр-9\";s:6:\"expiry\";i:1766398887;}s:40:\"6f3b18794b9f9046c13f202f21290578a0dde5d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/136-бюлетин-lokosf-info-бр-8\";s:6:\"expiry\";i:1766398887;}s:40:\"839e61eedd91725caeafb6204ebd016e388a36f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/143-бюлетин-lokosf-info-бр-15\";s:6:\"expiry\";i:1766398889;}s:40:\"84d698b8975600c0724a9e8034bdca913699ba86\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/142-бюлетин-lokosf-info-бр-14\";s:6:\"expiry\";i:1766398889;}s:40:\"226e90880c0768d5b422f251f9a80f641269eb5c\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2737-видео-локомотив-цска-1948-2-3-18-кръг-впл-2019-2020\";s:6:\"expiry\";i:1766398891;}s:40:\"1685a9711ce29b735e3f22a7e82050330477d7f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:185:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/43-локо-сф-надви-звездите-на-българия-в-мача-в-памет-на-начко\";s:6:\"expiry\";i:1766398892;}s:40:\"6d53c2b178c9eff000db4f0bbe1a19cc45fae83d\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"https://lokomotiv.ntesrv.com/joomla16/видео/2918-видео-цска-софия-локомотив-3-1\";s:6:\"expiry\";i:1766398894;}s:40:\"26a7f1224458913db8dc9ea8858b298c1408784f\";O:8:\"stdClass\":2:{s:4:\"link\";s:348:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2488-видео-литекс-локомотив-0-0-26-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398897;}s:40:\"7014340dec6759fbf8b764b99e0c6f77d4ab13ad\";O:8:\"stdClass\":2:{s:4:\"link\";s:214:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/2413-благой-иванов-багата-спечели-първата-си-битка-в-ufc-видео\";s:6:\"expiry\";i:1766398898;}s:40:\"110cd92b56aa7e182d251b67199cd2a0dd21cb77\";O:8:\"stdClass\":2:{s:4:\"link\";s:267:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора\";s:6:\"expiry\";i:1766398901;}}s:13:\"session.token\";s:32:\"aa1b9525737e018a74924d0742ab386e\";}' , `time` = '1766398902' WHERE `session_id` = 'a813e97429543f0e2774994dd43e4e75'

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

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

132 × SELECT id FROM jos_categories
9 × SELECT username FROM jos_users
8 × 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 × DELETE FROM `jos_session`
2 × update jos_extrawatch_info set value = value+1
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'view', 'article', 2
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:19;s:19:\"session.timer.start\";i:1766398867;s:18:\"session.timer.last\";i:1766398900;s:17:\"session.timer.now\";i:1766398901;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:19:{s:40:\"de1a8135b6fb7c740ff0f765b05d19a70987496d\";O:8:\"stdClass\":2:{s:4:\"link\";s:234:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/2706-младен-додич-искам-момчетата-да-играят-без-напрежение\";s:6:\"expiry\";i:1766398867;}s:40:\"d67eb4d3ae692c62f0c2f05d0d0c01b39b75d5ee\";O:8:\"stdClass\":2:{s:4:\"link\";s:212:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2875-боксов-клуб-локомотив-е-отборен-шампион\";s:6:\"expiry\";i:1766398872;}s:40:\"459502f4fbbbe9eb9f33ca66ef09d2d1a5a12865\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/777-представяне-на-отбор-за-новия-полусезон-есен-2015\";s:6:\"expiry\";i:1766398873;}s:40:\"d751cea8bab0a3e4e688d6e0a7da241389b176d4\";O:8:\"stdClass\":2:{s:4:\"link\";s:343:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2291-видео-локомотив-арда-0-3-7-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398875;}s:40:\"555c52e2d12de0e80786c06400643a7923124efa\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2458-видео-локомотив-ботев-г-1-0-23-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398878;}s:40:\"18097c5808721ba18a75a92d9cbe31cb6f3be8d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:264:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/1041-децата-на-локомотив-ще-участват-на-най-големия-юношески-турнир-в-света\";s:6:\"expiry\";i:1766398879;}s:40:\"f7d66e3f355344b4a36ceb4c5bc86cf2f9b77bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/видео/794-стартира-ремонтът-на-помощното-игрище-на-стадион-локомотив\";s:6:\"expiry\";i:1766398880;}s:40:\"dab525297e880a0e119f0000c97e86879b5be04a\";O:8:\"stdClass\":2:{s:4:\"link\";s:221:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/977-упътване-и-транспорт-до-стадион-ботунец-преди-мача-с-кремиковци\";s:6:\"expiry\";i:1766398884;}s:40:\"3669d5395f30f005bdfc37c2cdfcacf7148bd8a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:205:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/2860-първи-международен-турнир-в-памет-на-георги-тонков\";s:6:\"expiry\";i:1766398886;}s:40:\"91de0aec9862fc5e368bd00ba388f68c22f5e0c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/137-бюлетин-lokosf-info-бр-9\";s:6:\"expiry\";i:1766398887;}s:40:\"6f3b18794b9f9046c13f202f21290578a0dde5d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/136-бюлетин-lokosf-info-бр-8\";s:6:\"expiry\";i:1766398887;}s:40:\"839e61eedd91725caeafb6204ebd016e388a36f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/143-бюлетин-lokosf-info-бр-15\";s:6:\"expiry\";i:1766398889;}s:40:\"84d698b8975600c0724a9e8034bdca913699ba86\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/142-бюлетин-lokosf-info-бр-14\";s:6:\"expiry\";i:1766398889;}s:40:\"226e90880c0768d5b422f251f9a80f641269eb5c\";O:8:\"stdClass\":2:{s:4:\"link\";s:349:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2737-видео-локомотив-цска-1948-2-3-18-кръг-впл-2019-2020\";s:6:\"expiry\";i:1766398891;}s:40:\"1685a9711ce29b735e3f22a7e82050330477d7f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:185:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/43-локо-сф-надви-звездите-на-българия-в-мача-в-памет-на-начко\";s:6:\"expiry\";i:1766398892;}s:40:\"6d53c2b178c9eff000db4f0bbe1a19cc45fae83d\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"https://lokomotiv.ntesrv.com/joomla16/видео/2918-видео-цска-софия-локомотив-3-1\";s:6:\"expiry\";i:1766398894;}s:40:\"26a7f1224458913db8dc9ea8858b298c1408784f\";O:8:\"stdClass\":2:{s:4:\"link\";s:348:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/2488-видео-литекс-локомотив-0-0-26-кръг-впл-2018-2019\";s:6:\"expiry\";i:1766398897;}s:40:\"7014340dec6759fbf8b764b99e0c6f77d4ab13ad\";O:8:\"stdClass\":2:{s:4:\"link\";s:214:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/2413-благой-иванов-багата-спечели-първата-си-битка-в-ufc-видео\";s:6:\"expiry\";i:1766398898;}s:40:\"110cd92b56aa7e182d251b67199cd2a0dd21cb77\";O:8:\"stdClass\":2:{s:4:\"link\";s:267:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора\";s:6:\"expiry\";i:1766398901;}}s:13:\"session.token\";s:32:\"aa1b9525737e018a74924d0742ab386e\";}' , `time` = '1766398902'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'catid', '18', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'id', '2468', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12281944', 'Itemid', '147', 2
1 × UPDATE jos_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `jos_assets
1 × SHOW FULL COLUMNS FROM `jos_jnews_xonfig
1 × update jos_extrawatch_uri2title set count = count+1, timestamp = '1766398902'
1 × update jos_extrawatch_uri2title set title = 'България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766398902', '/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/2468-българия-u16-спечели-турнира-на-уефа,-валентин-николов-бе-капитан-на-отбора', 'България U16 спечели турнира на УЕФА, Валентин Николов бе капитан на отбора'

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

de1a8135b6fb7c740ff0f765b05d19a70987496d

d67eb4d3ae692c62f0c2f05d0d0c01b39b75d5ee

459502f4fbbbe9eb9f33ca66ef09d2d1a5a12865

d751cea8bab0a3e4e688d6e0a7da241389b176d4

555c52e2d12de0e80786c06400643a7923124efa

18097c5808721ba18a75a92d9cbe31cb6f3be8d9

f7d66e3f355344b4a36ceb4c5bc86cf2f9b77bc8

dab525297e880a0e119f0000c97e86879b5be04a

3669d5395f30f005bdfc37c2cdfcacf7148bd8a4

91de0aec9862fc5e368bd00ba388f68c22f5e0c5

6f3b18794b9f9046c13f202f21290578a0dde5d9

839e61eedd91725caeafb6204ebd016e388a36f4

84d698b8975600c0724a9e8034bdca913699ba86

226e90880c0768d5b422f251f9a80f641269eb5c

1685a9711ce29b735e3f22a7e82050330477d7f9

6d53c2b178c9eff000db4f0bbe1a19cc45fae83d

26a7f1224458913db8dc9ea8858b298c1408784f

7014340dec6759fbf8b764b99e0c6f77d4ab13ad

110cd92b56aa7e182d251b67199cd2a0dd21cb77

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

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

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

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

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

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

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