Програмата на Локомотив за есенния полусезон във Втора лига

вкл. 22 Юни 2017.

vtoraliga Актуални резултати и цялата уточнена програма за втора лига вижте кликвайки ТУК.

Днес бе теглен жребия за програмата на есенния полусезон на 2017/2018 във Втора лига, вижте двубоите на Локомотив по-долу:

I кръг 23 юли 2017 20:00 (неделя) Лудогорец 1945 II (Разград) - Локомотив
II кръг 31 юли 2017 18:15 (понеделник) Локомотив - Ботев (Враца)
III кръг 05 август 2017 18:00 (събота) Оборище (Панагюрище) - Локомотив
IV кръг 12 август 2017 18:00 (събота) Локомотив - Монтана 1921 (Монтана)
V кръг 20 август 2017 18:00 (неделя) Марица 1921 (Пловдив) - Локомотив
VI кръг 26 август 2017 18:00 (събота) Струмска слава 1927 (Радомир) - Локомотив
VII кръг 09 септември 2017 17:00 (събота) Локомотив - Нефтохимик 1962 (Бургас) и 88 години Локомотив
VIII кръг 16 септември 2017 17:00 (събота) Черноморец (Балчик) - Локомотив
IX кръг 24 септември 2017 17:00 (неделя) Локомотив - Несебър (Несебър)
X кръг 02 октомври 2017 20:00 (понеделник) Поморие (Поморие) - Локомотив
XI кръг 14 октомври 2017 16:00 (събота) Локомотив - Литекс (Ловеч)
XII кръг 20 октомври 2017 15:45 (петък) Локомотив (Горна Оряховица) - Локомотив
XIII кръг 28 октомври 2017 14:45 (събота) Локомотив - Царско село 2015 (София)
XIV кръг 04 ноември 2017 15:30 (събота) Созопол (Созопол) - Локомотив
XV кръг 18 ноември 2017 14:30 (събота) Локомотив - Ботев (Гълъбово)

Контролната среща със Славия, част от лятната подготовка, няма да се състои. Търси се нов съперник за 03 юли 2017 г.

актуализирана 07 октомври 2017г.

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

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

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

8b58e515ac5d1e43b76013736d68dc4036c8dc74

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

c8c04d3d4c554c310d985f385fa9cc5e8d319c10

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

5c18a66c30ed1a4912b8be6a25c963ffa1f80453

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

41618c0f929023c6e96d7155f4e77e0db8966589

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

def5ce0204b8124cf1ca0284b127bbe1e25d7d72

link ⇒ https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/художествена-гимнастика/1169-4814-50-лв-дарени-от-турнира-„деца-помагат-на-деца“

10385b5c265320e1d73a2b373a53ce822a7c813f

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

fb3e1aeeab9e7af6a649d61a144229ba7daaf814

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

705d62a41e75608336a1da6009a8e274efd0a1a8

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

50e99e8d64e84cd90ebc0db1afc4c023a0bf85dc

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

787ee9f29a1f1f4c3d3540f0f1cf5cce5d31bf5b

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

9b5e684d0f03baefe6b0e254dc5a6b0436869312

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-спортни-срещи/2201-видео-локомотив-черноморец-9-7-u19

75e7a74e2e875ce4ce47094db46b01d1327c99f5

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

cc77424793610aa00bc727abac901bb089850976

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

f0945bf08a0a28145606c56a3b0436e436c38228

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

session.token ⇒ 40228424d10800bf4b228ef4ebdf9c64

comments-captcha-code ⇒ dydun

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

Application 0.062 seconds (+0.062); 3.86 MB (+3.215) - afterInitialise

Application 0.108 seconds (+0.046); 6.60 MB (+2.736) - afterRoute

Application 5.594 seconds (+5.487); 10.36 MB (+3.762) - afterDispatch

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

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

Application 5.618 seconds (+0.001); 10.85 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

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

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

Application 5.701 seconds (+0.079); 12.82 MB (+1.957) - afterRenderModule mod_menu (Main Menu)

Application 5.726 seconds (+0.025); 13.08 MB (+0.255) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 5.734 seconds (+0.008); 13.11 MB (+0.028) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Application 5.926 seconds (+0.190); 13.43 MB (+0.309) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 5.928 seconds (+0.002); 13.36 MB (-0.072) - beforeRenderModule mod_menu (Submenu)

Application 5.934 seconds (+0.005); 13.37 MB (+0.010) - afterRenderModule mod_menu (Submenu)

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

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

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

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

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

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

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

Application 5.973 seconds (+0.033); 13.81 MB (+0.407) - afterRenderModule mod_joomleague_matches (Програма и резултати)

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

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

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

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

Application 6.017 seconds (+0.000); 16.49 MB (-0.035) - beforeRenderModule mod_custom (Добави статия)

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

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

Application 6.024 seconds (+0.005); 16.57 MB (+0.078) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

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

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

Application 6.221 seconds (+0.116); 17.33 MB (+0.259) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

Application 6.236 seconds (+0.014); 17.23 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

Application 6.254 seconds (+0.018); 17.26 MB (+0.025) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 6.287 seconds (+0.033); 17.59 MB (+0.331) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 6.288 seconds (+0.001); 17.63 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 6.295 seconds (+0.006); 17.65 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 6.331 seconds (+0.036); 17.80 MB (+0.151) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

Application 6.331 seconds (+0.001); 17.77 MB (-0.031) - beforeRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

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

Application 6.365 seconds (+0.004); 17.78 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 6.486 seconds (+0.120); 20.11 MB (+2.327) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 6.520 seconds (+0.035); 20.13 MB (+0.019) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '6b44dbd9b37c04eb2f49b9cc74622390'
DELETE FROM `jos_session` WHERE `time` < '1766407701'
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=1724 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 = 1724
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 = 1724 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 13:48:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 13:48:21') 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.1724') 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 <= '2025-12-22 13:48:21') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-22 13:48:21') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '1724' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 1724 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 1724
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 13:48:21') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-22 13:48:21') 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` < '1766407707'
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 = 1724
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 != 1724 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 "%,2017,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 13:48:21' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 13:48:21' ) 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=32 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=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
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 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 13:48:21' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 13:48:21' ) 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 13:48:21', 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 <= '2025-12-22 13:48:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 13:48:21') ORDER BY a.created DESC LIMIT 0, 1
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') ORDER BY c.date DESC LIMIT 0, 4
SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') GROUP BY o.id, o.title, o.link ORDER BY commentsCount DESC, c.date DESC LIMIT 0, 5
select name, value from jos_extrawatch_config
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.216.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.*%' limit 1
update jos_extrawatch_uri2title set count = count+1, timestamp = '1766411307' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига') limit 1
update jos_extrawatch_uri2title set title = 'Програмата на Локомотив за есенния полусезон във Втора лига ' where id = '2549839'
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', '1766411307', '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига', 'Програмата на Локомотив за есенния полусезон във Втора лига ')
select id from jos_extrawatch_uri where fk = '900214' and `timestamp` = '1766411307' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига' and `title` LIKE 'Програмата на Локомотив за есенния полусезон във Втора лига '
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'Itemid', '154', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'catid', '27', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'id', '1724', 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:26;s:19:\"session.timer.start\";i:1766411261;s:18:\"session.timer.last\";i:1766411299;s:17:\"session.timer.now\";i:1766411301;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:14:{s:40:\"8b58e515ac5d1e43b76013736d68dc4036c8dc74\";O:8:\"stdClass\":2:{s:4:\"link\";s:333:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/859-видео-иван-василев-ще-възродим-локомотив\";s:6:\"expiry\";i:1766411261;}s:40:\"c8c04d3d4c554c310d985f385fa9cc5e8d319c10\";O:8:\"stdClass\":2:{s:4:\"link\";s:258:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/876-антон-велков-от-победата-и-полусезона-съм-доволен,-от-играта-днес-не\";s:6:\"expiry\";i:1766411263;}s:40:\"5c18a66c30ed1a4912b8be6a25c963ffa1f80453\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1186-видео-радостта-на-децата-на-локомотив-сф-след-победата\";s:6:\"expiry\";i:1766411266;}s:40:\"41618c0f929023c6e96d7155f4e77e0db8966589\";O:8:\"stdClass\":2:{s:4:\"link\";s:353:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/обзор/2798-обзор-на-19-ия-кръг-във-втора-лига-2019-2020\";s:6:\"expiry\";i:1766411268;}s:40:\"def5ce0204b8124cf1ca0284b127bbe1e25d7d72\";O:8:\"stdClass\":2:{s:4:\"link\";s:222:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/художествена-гимнастика/1169-4814-50-лв-дарени-от-турнира-„деца-помагат-на-деца“\";s:6:\"expiry\";i:1766411273;}s:40:\"10385b5c265320e1d73a2b373a53ce822a7c813f\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/244-бюлетин-lokosf-info-бр-34\";s:6:\"expiry\";i:1766411275;}s:40:\"fb3e1aeeab9e7af6a649d61a144229ba7daaf814\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/228-бюлетин-lokosf-info-бр-33\";s:6:\"expiry\";i:1766411275;}s:40:\"705d62a41e75608336a1da6009a8e274efd0a1a8\";O:8:\"stdClass\":2:{s:4:\"link\";s:337:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1177-видео-готия-къп-набор-2003-екеро-локомотив-1-2\";s:6:\"expiry\";i:1766411276;}s:40:\"50e99e8d64e84cd90ebc0db1afc4c023a0bf85dc\";O:8:\"stdClass\":2:{s:4:\"link\";s:230:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/2133-младен-додич-това-беше-мач-за-мъже,-имаше-напрежение\";s:6:\"expiry\";i:1766411278;}s:40:\"787ee9f29a1f1f4c3d3540f0f1cf5cce5d31bf5b\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1180-видео-децата-на-локо-разказват-за-победата-над-тампере\";s:6:\"expiry\";i:1766411280;}s:40:\"9b5e684d0f03baefe6b0e254dc5a6b0436869312\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-спортни-срещи/2201-видео-локомотив-черноморец-9-7-u19\";s:6:\"expiry\";i:1766411282;}s:40:\"75e7a74e2e875ce4ce47094db46b01d1327c99f5\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/330-видео-нефтохимик-локомотив-0-2-28-кръг\";s:6:\"expiry\";i:1766411286;}s:40:\"cc77424793610aa00bc727abac901bb089850976\";O:8:\"stdClass\":2:{s:4:\"link\";s:191:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/184-нов-ред-и-порядки-в-школата-на-локомотив\";s:6:\"expiry\";i:1766411300;}s:40:\"f0945bf08a0a28145606c56a3b0436e436c38228\";O:8:\"stdClass\":2:{s:4:\"link\";s:254:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига\";s:6:\"expiry\";i:1766411307;}}s:13:\"session.token\";s:32:\"40228424d10800bf4b228ef4ebdf9c64\";}comments-captcha-code|s:5:\"dydun\";' , `time` = '1766411308' WHERE `session_id` = '6b44dbd9b37c04eb2f49b9cc74622390'

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

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

132 × SELECT id FROM jos_categories
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
9 × SELECT username FROM jos_users
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 ('12290395', 'view', 'article', 2
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1766411261;s:18:\"session.timer.last\";i:1766411299;s:17:\"session.timer.now\";i:1766411301;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:14:{s:40:\"8b58e515ac5d1e43b76013736d68dc4036c8dc74\";O:8:\"stdClass\":2:{s:4:\"link\";s:333:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/859-видео-иван-василев-ще-възродим-локомотив\";s:6:\"expiry\";i:1766411261;}s:40:\"c8c04d3d4c554c310d985f385fa9cc5e8d319c10\";O:8:\"stdClass\":2:{s:4:\"link\";s:258:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/876-антон-велков-от-победата-и-полусезона-съм-доволен,-от-играта-днес-не\";s:6:\"expiry\";i:1766411263;}s:40:\"5c18a66c30ed1a4912b8be6a25c963ffa1f80453\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1186-видео-радостта-на-децата-на-локомотив-сф-след-победата\";s:6:\"expiry\";i:1766411266;}s:40:\"41618c0f929023c6e96d7155f4e77e0db8966589\";O:8:\"stdClass\":2:{s:4:\"link\";s:353:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/обзор/2798-обзор-на-19-ия-кръг-във-втора-лига-2019-2020\";s:6:\"expiry\";i:1766411268;}s:40:\"def5ce0204b8124cf1ca0284b127bbe1e25d7d72\";O:8:\"stdClass\":2:{s:4:\"link\";s:222:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/художествена-гимнастика/1169-4814-50-лв-дарени-от-турнира-„деца-помагат-на-деца“\";s:6:\"expiry\";i:1766411273;}s:40:\"10385b5c265320e1d73a2b373a53ce822a7c813f\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/244-бюлетин-lokosf-info-бр-34\";s:6:\"expiry\";i:1766411275;}s:40:\"fb3e1aeeab9e7af6a649d61a144229ba7daaf814\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/печатен-бюлетин-lokosf-info/228-бюлетин-lokosf-info-бр-33\";s:6:\"expiry\";i:1766411275;}s:40:\"705d62a41e75608336a1da6009a8e274efd0a1a8\";O:8:\"stdClass\":2:{s:4:\"link\";s:337:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1177-видео-готия-къп-набор-2003-екеро-локомотив-1-2\";s:6:\"expiry\";i:1766411276;}s:40:\"50e99e8d64e84cd90ebc0db1afc4c023a0bf85dc\";O:8:\"stdClass\":2:{s:4:\"link\";s:230:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/2133-младен-додич-това-беше-мач-за-мъже,-имаше-напрежение\";s:6:\"expiry\";i:1766411278;}s:40:\"787ee9f29a1f1f4c3d3540f0f1cf5cce5d31bf5b\";O:8:\"stdClass\":2:{s:4:\"link\";s:359:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-отборите-в-дюш-на-локомотив-софия/1180-видео-децата-на-локо-разказват-за-победата-над-тампере\";s:6:\"expiry\";i:1766411280;}s:40:\"9b5e684d0f03baefe6b0e254dc5a6b0436869312\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-спортни-срещи/2201-видео-локомотив-черноморец-9-7-u19\";s:6:\"expiry\";i:1766411282;}s:40:\"75e7a74e2e875ce4ce47094db46b01d1327c99f5\";O:8:\"stdClass\":2:{s:4:\"link\";s:338:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/видео-записи-от-футболни-срещи-на-мъжкия-футболен-отбор-на-локомотив-софия/330-видео-нефтохимик-локомотив-0-2-28-кръг\";s:6:\"expiry\";i:1766411286;}s:40:\"cc77424793610aa00bc727abac901bb089850976\";O:8:\"stdClass\":2:{s:4:\"link\";s:191:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/184-нов-ред-и-порядки-в-школата-на-локомотив\";s:6:\"expiry\";i:1766411300;}s:40:\"f0945bf08a0a28145606c56a3b0436e436c38228\";O:8:\"stdClass\":2:{s:4:\"link\";s:254:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига\";s:6:\"expiry\";i:1766411307;}}s:13:\"session.token\";s:32:\"40228424d10800bf4b228ef4ebdf9c64\";}comments-captcha-code|s:5:\"dydun\";' , `time` = '1766411308'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'catid', '27', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'id', '1724', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12290395', '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 = '1766411307'
1 × update jos_extrawatch_uri2title set title = 'Програмата на Локомотив за есенния полусезон във Втора лига '
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766411307', '/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/1724-програмата-на-локомотив-за-есенния-полусезон-във-втора-лига', 'Програмата на Локомотив за есенния полусезон във Втора лига '

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

8b58e515ac5d1e43b76013736d68dc4036c8dc74

c8c04d3d4c554c310d985f385fa9cc5e8d319c10

5c18a66c30ed1a4912b8be6a25c963ffa1f80453

41618c0f929023c6e96d7155f4e77e0db8966589

def5ce0204b8124cf1ca0284b127bbe1e25d7d72

10385b5c265320e1d73a2b373a53ce822a7c813f

fb3e1aeeab9e7af6a649d61a144229ba7daaf814

705d62a41e75608336a1da6009a8e274efd0a1a8

50e99e8d64e84cd90ebc0db1afc4c023a0bf85dc

787ee9f29a1f1f4c3d3540f0f1cf5cce5d31bf5b

9b5e684d0f03baefe6b0e254dc5a6b0436869312

75e7a74e2e875ce4ce47094db46b01d1327c99f5

cc77424793610aa00bc727abac901bb089850976

f0945bf08a0a28145606c56a3b0436e436c38228

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

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

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

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

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

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

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