Програма на Втора професионална лига от 6-ти до 9-ти кръг

вкл. 02 Септември 2016.

Програмата на Втора лига ("Б" група) по дни и часове

Септември

VІ кръг 17.00 часа

15.09 /четвъртък/	Лудогорец 2	-	Локомотив	18.00
16.09 /петък/	ЦСКА –София 2	-	Оборище Пан
17.09 /събота/	Етър ВТ	-	Поморие
	Ботев Вр	-	Септември Сф
	Ботев Гълъбово	-	Спартак Пл
	Витоша Бистрица	-	Левски Карлово
	Царско село 2015	-	Несебър
	Созопол	-	Банско	18.00

20.09 /вторник/	Купа „България” 1/16 финали
21.09 /сряда/	Купа „България” 1/16 финали
22.09 /четв./	Купа „България” 1/16 финали

VІІ кръг 17.00 часа

25.09 /неделя/	Поморие	-	Ботев Вр
	Банско	-	Царско село 2015
	Левски Карлово	-	Созопол
	Оборище Пан	-	Витоша Бистрица
	Септември Сф	-	Ботев Гълъбово
	Несебър	-	Лудогорец 2
26.09 /понеделник/	Локомотив	-	Етър ВТ	17.00	Диема спорт 2
	Спартак Пл	-	ЦСКА –София 2

Октомври

VІІІ кръг 17.00 часа

30.09 /петък/	Лудогорец 2	-	Етър ВТ
01.10 /събота/	Ботев Вр	-	Локомотив
	Ботев Гълъбово	-	Поморие
	Витоша Бистрица	-	Спартак Пл
	Несебър	-	Банско
	Созопол	-	Оборище Пан	18.00
02.10 /неделя/	ЦСКА –София 2	-	Септември Сф	14.30	Диема спорт 2
	Царско село 2015	-	Левски Карлово

ІХ кръг 16.00 часа

15.10 /събота/	Банско	-	Лудогорец 2
	Левски Карлово	-	Несебър
	Оборище Пан	-	Царско село 2015
	Спартак Пл	-	Созопол
	Локомотив	-	Ботев Гълъбово
16.10 /неделя/	Поморие	-	ЦСКА –София 2
	Септември Сф	-	Витоша Бистрица
17.10 /понед./	Етър ВТ	-	Ботев Вр	16.00	Диема спорт 2

БФС си запазва правото на промени в програмата

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

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

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 ⇒ 51bde0493a8a0e7be43dd3226a04ce8e

com_mailto.links

f0e745f987e4f08c57fec06973b7dd0f62913b22

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/663-мачът-на-сезона-или-века-23-05-2015-18-00-ч-,-ст-локомотив

8ecba49d0ee0e11c4acb332733755dd5c8a5c039

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

d48b4d9222fe9f8f403367ebbe03a62d2d9877f3

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

5c9b8503a77dabe7bb4b11f68aaefeaccf1234c3

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/501-локомотив-ботев-19-10-2014-13-30-часа,-ст-локомотив

4ba5d5071097a1831c8926f56af10e711c5c85d1

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

44b067dc7939adb908c3ac499faa7a7a756644b6

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

bc2ba2a7604d1fa7f2d7f3ad0d869b286175dd40

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

6988e99150183414913d4011f891688ee9875157

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

39bbd62474e095eb4fbcc995c60478df98d90e93

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

4af27e34d7ddfdca32036a8d8648334c8bccb9ee

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

2fa8ac73f8cd4fc2aa83ffdc2e8fff5f9412a60e

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

0925332610a45bfe1250b599e4653b403c26242e

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/333-локомотив-сф-берое-26-03-2013-г-ст-локомотив-15-30-ч

165f949dc2775f74ac170176b31c31185863f3be

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

84cbd6d6bfd77412200fc761c2762e279e012b01

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/652-локомотив-берое-11-05-2015-17-30-ч-,-ст-локомотив

7ba387c01c0c7d2265628abd678a15f4905e1980

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1020-резултати-и-класиране-в-дюш-локомотив-14-17-април-2016-г

703ed009b1d0706a87b42e3fcecdf3737109f3a1

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

7218339eff2edc755aa69ef47258f96d04b06f8f

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1081-децата-на-локомотив-завършиха-четвърти-на-турнира-котков-и-михайлов“

5077f0038d4254eb61d9290f6a944d56f22aaa79

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

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

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

Application 0.117 seconds (+0.054); 6.60 MB (+2.735) - afterRoute

Application 0.227 seconds (+0.110); 10.43 MB (+3.828) - afterDispatch

Application 0.247 seconds (+0.021); 10.89 MB (+0.458) - beforeRenderModule mod_search (Търси)

Application 0.253 seconds (+0.006); 10.93 MB (+0.044) - afterRenderModule mod_search (Търси)

Application 0.256 seconds (+0.003); 10.93 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.259 seconds (+0.003); 10.93 MB (+0.008) - afterRenderModule mod_custom (LOGO)

Application 0.260 seconds (+0.001); 10.94 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.340 seconds (+0.080); 12.89 MB (+1.958) - afterRenderModule mod_menu (Main Menu)

Application 0.365 seconds (+0.024); 13.15 MB (+0.255) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.369 seconds (+0.005); 13.18 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.371 seconds (+0.002); 13.19 MB (+0.017) - beforeRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.692 seconds (+0.321); 13.57 MB (+0.377) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.696 seconds (+0.004); 13.46 MB (-0.105) - beforeRenderModule mod_menu (Submenu)

Application 0.702 seconds (+0.005); 13.47 MB (+0.010) - afterRenderModule mod_menu (Submenu)

Application 0.702 seconds (+0.000); 13.47 MB (-0.006) - beforeRenderModule mod_custom (ВХОД_html)

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

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

Application 0.706 seconds (+0.003); 13.48 MB (+0.008) - afterRenderModule mod_custom (Събития)

Application 0.706 seconds (+0.000); 13.48 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.707 seconds (+0.001); 13.48 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

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

Application 0.740 seconds (+0.033); 13.92 MB (+0.408) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.740 seconds (+0.000); 13.88 MB (-0.038) - beforeRenderModule mod_custom (razvitie)

Application 0.741 seconds (+0.001); 13.89 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 0.787 seconds (+0.046); 16.63 MB (+2.741) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

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

Application 0.872 seconds (+0.080); 17.20 MB (+0.517) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.873 seconds (+0.000); 17.17 MB (-0.025) - beforeRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.951 seconds (+0.078); 17.44 MB (+0.267) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

Application 0.962 seconds (+0.011); 17.34 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

Application 0.973 seconds (+0.011); 17.37 MB (+0.025) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 0.997 seconds (+0.024); 17.70 MB (+0.331) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.998 seconds (+0.001); 17.74 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 1.003 seconds (+0.005); 17.76 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

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

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

Application 1.068 seconds (+0.032); 17.93 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 1.071 seconds (+0.003); 17.90 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.176 seconds (+0.105); 20.16 MB (+2.265) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.206 seconds (+0.030); 20.19 MB (+0.030) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '6b358cb74c37a14675abb8af26d55383'
DELETE FROM `jos_session` WHERE `time` < '1781390655'
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=1238 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 = 1238
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 = 1238 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-13 23:44:15') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-13 23:44:15') AND (a.state = 1 OR a.state =2)
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM 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=27 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.1238') 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 = 27 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-06-13 23:44:15') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-13 23:44:15') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '1238' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 1238 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 1238
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-06-13 23:44:15') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-13 23:44:15') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 154 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` < '1781390655'
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 = 1238
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 != 1238 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 "%,Втора професионална лига. от 6 кръг,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,9 кръг,%" 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-06-13 23:44:15' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-13 23:44:15' ) 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=28 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=15 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=26 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-06-13 23:44:15' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-13 23:44:15' ) 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-06-13 23:44:15', 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 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 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-06-13 23:44:15') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-13 23:44:15') 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.109' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.109' 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 = '1781394256' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг') limit 1
update jos_extrawatch_uri2title set title = 'Програма на Втора професионална лига от 6-ти до 9-ти кръг' where id = '2549722'
select id, username from jos_extrawatch where ip = '216.73.216.109' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '947300', '1781394256', '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг', 'Програма на Втора професионална лига от 6-ти до 9-ти кръг')
select id from jos_extrawatch_uri where fk = '947300' and `timestamp` = '1781394256' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг' and `title` LIKE 'Програма на Втора професионална лига от 6-ти до 9-ти кръг'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'Itemid', '154', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'catid', '27', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'id', '1238', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.109' and date = '20618')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.109' and date = '20618')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20618')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20618')
select ip, country from jos_extrawatch where (ip = '216.73.216.109' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718189 >= start AND 3628718189 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.109'
select * from jos_extrawatch_goals
SELECT alias FROM jos_content WHERE id=1205
UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1781394220;s:18:\"session.timer.last\";i:1781394254;s:17:\"session.timer.now\";i:1781394255;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:19:\"com_mailto.formtime\";i:1781394251;s:13:\"session.token\";s:32:\"51bde0493a8a0e7be43dd3226a04ce8e\";s:16:\"com_mailto.links\";a:18:{s:40:\"f0e745f987e4f08c57fec06973b7dd0f62913b22\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/663-мачът-на-сезона-или-века-23-05-2015-18-00-ч-,-ст-локомотив\";s:6:\"expiry\";i:1781394221;}s:40:\"8ecba49d0ee0e11c4acb332733755dd5c8a5c039\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/38-да-отпразнуваме-заедно-рожденият-ден-на-начко\";s:6:\"expiry\";i:1781394224;}s:40:\"d48b4d9222fe9f8f403367ebbe03a62d2d9877f3\";O:8:\"stdClass\":2:{s:4:\"link\";s:246:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1647-дани-пеев-за-да-се-върнем-в-първа-лига-трябват-повече-финанси\";s:6:\"expiry\";i:1781394226;}s:40:\"5c9b8503a77dabe7bb4b11f68aaefeaccf1234c3\";O:8:\"stdClass\":2:{s:4:\"link\";s:198:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/501-локомотив-ботев-19-10-2014-13-30-часа,-ст-локомотив\";s:6:\"expiry\";i:1781394227;}s:40:\"4ba5d5071097a1831c8926f56af10e711c5c85d1\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/607-бк-спечели-6-титли-при-девойките,-иванова-завоюва-сребърен-медал\";s:6:\"expiry\";i:1781394229;}s:40:\"44b067dc7939adb908c3ac499faa7a7a756644b6\";O:8:\"stdClass\":2:{s:4:\"link\";s:322:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/704-в-памет-на-начко-михайлов\";s:6:\"expiry\";i:1781394232;}s:40:\"bc2ba2a7604d1fa7f2d7f3ad0d869b286175dd40\";O:8:\"stdClass\":2:{s:4:\"link\";s:303:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/527-локомотив-никола-нанов-за-втори-пореден-път-е-носител-на-купата-на-българия-по-водна-топка\";s:6:\"expiry\";i:1781394234;}s:40:\"6988e99150183414913d4011f891688ee9875157\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/190-бюлетин-lokosf-info-бр-27-уеб-издание\";s:6:\"expiry\";i:1781394235;}s:40:\"39bbd62474e095eb4fbcc995c60478df98d90e93\";O:8:\"stdClass\":2:{s:4:\"link\";s:243:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/627-железни-юнаци-прекършиха-цска,-пред-локомотив-остана-само-лудогорец\";s:6:\"expiry\";i:1781394237;}s:40:\"4af27e34d7ddfdca32036a8d8648334c8bccb9ee\";O:8:\"stdClass\":2:{s:4:\"link\";s:299:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/40-история-на-водната-топка-в-локомотив-софия/825-локомотив-нн-за-първи-път-с-женски-отбор\";s:6:\"expiry\";i:1781394240;}s:40:\"2fa8ac73f8cd4fc2aa83ffdc2e8fff5f9412a60e\";O:8:\"stdClass\":2:{s:4:\"link\";s:308:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2657-галерия-издигнаха-тенис-балона,-сменят-дограмата-на-новата-баскетболна-зала\";s:6:\"expiry\";i:1781394242;}s:40:\"0925332610a45bfe1250b599e4653b403c26242e\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/333-локомотив-сф-берое-26-03-2013-г-ст-локомотив-15-30-ч\";s:6:\"expiry\";i:1781394244;}s:40:\"165f949dc2775f74ac170176b31c31185863f3be\";O:8:\"stdClass\":2:{s:4:\"link\";s:268:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2960-богати-клубове-не-искат-делят-искат-да-са-още-по-богати\";s:6:\"expiry\";i:1781394245;}s:40:\"84cbd6d6bfd77412200fc761c2762e279e012b01\";O:8:\"stdClass\":2:{s:4:\"link\";s:193:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/652-локомотив-берое-11-05-2015-17-30-ч-,-ст-локомотив\";s:6:\"expiry\";i:1781394247;}s:40:\"7ba387c01c0c7d2265628abd678a15f4905e1980\";O:8:\"stdClass\":2:{s:4:\"link\";s:226:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1020-резултати-и-класиране-в-дюш-локомотив-14-17-април-2016-г\";s:6:\"expiry\";i:1781394249;}s:40:\"703ed009b1d0706a87b42e3fcecdf3737109f3a1\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/611-евролицензи,-медийни-атаки-и-възхвали,-европриходи\";s:6:\"expiry\";i:1781394253;}s:40:\"7218339eff2edc755aa69ef47258f96d04b06f8f\";O:8:\"stdClass\":2:{s:4:\"link\";s:260:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1081-децата-на-локомотив-завършиха-четвърти-на-турнира-котков-и-михайлов“\";s:6:\"expiry\";i:1781394254;}s:40:\"5077f0038d4254eb61d9290f6a944d56f22aaa79\";O:8:\"stdClass\":2:{s:4:\"link\";s:245:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг\";s:6:\"expiry\";i:1781394255;}}}' , `time` = '1781394256' WHERE `session_id` = '6b358cb74c37a14675abb8af26d55383'

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

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

132 × SELECT id FROM jos_categories
9 × SELECT username FROM jos_users
9 × 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 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 guest, usertype, client_id FROM jos_session
1 × SELECT id, rules FROM `jos_viewlevels
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 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 id, username from jos_extrawatch
1 × select * from jos_extrawatch_goal
1 × SELECT alias FROM jos_content
1 × SELECT country FROM jos_extrawatch_ip2c
1 × select ip, country from jos_extrawatch
1 × select id from jos_extrawatch_uri2title
1 × select id from jos_extrawatch_uri
1 × select name, value from jos_extrawatch_confi
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 * 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 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 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_jcomments_setting
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 alias, catid FROM jos_content
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 * FROM `jos_jcomments_objects`
1 × SELECT id, fav_team FROM jos_joomleague_project p
1 × SELECT `data` FROM `jos_session`
1 × SELECT * FROM `jos_jnews_xonfig
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 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 count(*) FROM jos_jcomments AS c
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_jnews_lists`

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

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 ('13824298', 'view', 'article', 2
1 × UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1781394220;s:18:\"session.timer.last\";i:1781394254;s:17:\"session.timer.now\";i:1781394255;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:19:\"com_mailto.formtime\";i:1781394251;s:13:\"session.token\";s:32:\"51bde0493a8a0e7be43dd3226a04ce8e\";s:16:\"com_mailto.links\";a:18:{s:40:\"f0e745f987e4f08c57fec06973b7dd0f62913b22\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/663-мачът-на-сезона-или-века-23-05-2015-18-00-ч-,-ст-локомотив\";s:6:\"expiry\";i:1781394221;}s:40:\"8ecba49d0ee0e11c4acb332733755dd5c8a5c039\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/38-да-отпразнуваме-заедно-рожденият-ден-на-начко\";s:6:\"expiry\";i:1781394224;}s:40:\"d48b4d9222fe9f8f403367ebbe03a62d2d9877f3\";O:8:\"stdClass\":2:{s:4:\"link\";s:246:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1647-дани-пеев-за-да-се-върнем-в-първа-лига-трябват-повече-финанси\";s:6:\"expiry\";i:1781394226;}s:40:\"5c9b8503a77dabe7bb4b11f68aaefeaccf1234c3\";O:8:\"stdClass\":2:{s:4:\"link\";s:198:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/501-локомотив-ботев-19-10-2014-13-30-часа,-ст-локомотив\";s:6:\"expiry\";i:1781394227;}s:40:\"4ba5d5071097a1831c8926f56af10e711c5c85d1\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/607-бк-спечели-6-титли-при-девойките,-иванова-завоюва-сребърен-медал\";s:6:\"expiry\";i:1781394229;}s:40:\"44b067dc7939adb908c3ac499faa7a7a756644b6\";O:8:\"stdClass\":2:{s:4:\"link\";s:322:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/исторически-факти-за-футбола-в-локомотив/футболисти-на-локомотив-софия/704-в-памет-на-начко-михайлов\";s:6:\"expiry\";i:1781394232;}s:40:\"bc2ba2a7604d1fa7f2d7f3ad0d869b286175dd40\";O:8:\"stdClass\":2:{s:4:\"link\";s:303:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/527-локомотив-никола-нанов-за-втори-пореден-път-е-носител-на-купата-на-българия-по-водна-топка\";s:6:\"expiry\";i:1781394234;}s:40:\"6988e99150183414913d4011f891688ee9875157\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/190-бюлетин-lokosf-info-бр-27-уеб-издание\";s:6:\"expiry\";i:1781394235;}s:40:\"39bbd62474e095eb4fbcc995c60478df98d90e93\";O:8:\"stdClass\":2:{s:4:\"link\";s:243:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/627-железни-юнаци-прекършиха-цска,-пред-локомотив-остана-само-лудогорец\";s:6:\"expiry\";i:1781394237;}s:40:\"4af27e34d7ddfdca32036a8d8648334c8bccb9ee\";O:8:\"stdClass\":2:{s:4:\"link\";s:299:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/40-история-на-водната-топка-в-локомотив-софия/825-локомотив-нн-за-първи-път-с-женски-отбор\";s:6:\"expiry\";i:1781394240;}s:40:\"2fa8ac73f8cd4fc2aa83ffdc2e8fff5f9412a60e\";O:8:\"stdClass\":2:{s:4:\"link\";s:308:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2657-галерия-издигнаха-тенис-балона,-сменят-дограмата-на-новата-баскетболна-зала\";s:6:\"expiry\";i:1781394242;}s:40:\"0925332610a45bfe1250b599e4653b403c26242e\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/333-локомотив-сф-берое-26-03-2013-г-ст-локомотив-15-30-ч\";s:6:\"expiry\";i:1781394244;}s:40:\"165f949dc2775f74ac170176b31c31185863f3be\";O:8:\"stdClass\":2:{s:4:\"link\";s:268:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2960-богати-клубове-не-искат-делят-искат-да-са-още-по-богати\";s:6:\"expiry\";i:1781394245;}s:40:\"84cbd6d6bfd77412200fc761c2762e279e012b01\";O:8:\"stdClass\":2:{s:4:\"link\";s:193:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/652-локомотив-берое-11-05-2015-17-30-ч-,-ст-локомотив\";s:6:\"expiry\";i:1781394247;}s:40:\"7ba387c01c0c7d2265628abd678a15f4905e1980\";O:8:\"stdClass\":2:{s:4:\"link\";s:226:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1020-резултати-и-класиране-в-дюш-локомотив-14-17-април-2016-г\";s:6:\"expiry\";i:1781394249;}s:40:\"703ed009b1d0706a87b42e3fcecdf3737109f3a1\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/611-евролицензи,-медийни-атаки-и-възхвали,-европриходи\";s:6:\"expiry\";i:1781394253;}s:40:\"7218339eff2edc755aa69ef47258f96d04b06f8f\";O:8:\"stdClass\":2:{s:4:\"link\";s:260:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1081-децата-на-локомотив-завършиха-четвърти-на-турнира-котков-и-михайлов“\";s:6:\"expiry\";i:1781394254;}s:40:\"5077f0038d4254eb61d9290f6a944d56f22aaa79\";O:8:\"stdClass\":2:{s:4:\"link\";s:245:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг\";s:6:\"expiry\";i:1781394255;}}}' , `time` = '1781394256'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'catid', '27', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'id', '1238', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('13824298', 'Itemid', '154', 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 = '1781394256'
1 × update jos_extrawatch_uri2title set title = 'Програма на Втора професионална лига от 6-ти до 9-ти кръг'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '947300', '1781394256', '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1238-програма-на-втора-професионална-лига-от-6-ти-до-9-ти-кръг', 'Програма на Втора професионална лига от 6-ти до 9-ти кръг'

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

f0e745f987e4f08c57fec06973b7dd0f62913b22

8ecba49d0ee0e11c4acb332733755dd5c8a5c039

d48b4d9222fe9f8f403367ebbe03a62d2d9877f3

5c9b8503a77dabe7bb4b11f68aaefeaccf1234c3

4ba5d5071097a1831c8926f56af10e711c5c85d1

44b067dc7939adb908c3ac499faa7a7a756644b6

bc2ba2a7604d1fa7f2d7f3ad0d869b286175dd40

6988e99150183414913d4011f891688ee9875157

39bbd62474e095eb4fbcc995c60478df98d90e93

4af27e34d7ddfdca32036a8d8648334c8bccb9ee

2fa8ac73f8cd4fc2aa83ffdc2e8fff5f9412a60e

0925332610a45bfe1250b599e4653b403c26242e

165f949dc2775f74ac170176b31c31185863f3be

84cbd6d6bfd77412200fc761c2762e279e012b01

7ba387c01c0c7d2265628abd678a15f4905e1980

703ed009b1d0706a87b42e3fcecdf3737109f3a1

7218339eff2edc755aa69ef47258f96d04b06f8f

5077f0038d4254eb61d9290f6a944d56f22aaa79

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

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

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

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

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

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

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