Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)

вкл. 02 Юли 2013.

21 юни 2013 г. (петък)

Локомотив - Теута /Дурес, Албания/ (гр. Разлог)

(2:1)

26 юни 2013 г. (сряда)

Локомотив - Раковски (гр. Разлог)

(0:0)

27 юни 2013 г. (четвъртък)

Пирин Разлог - Локомотив (гр. Разлог)

(0:3)

29 юни 2013 г. (събота)

Локомотив - Черно море /Варна/ (гр. Разлог)

(2:0)

02 юли 2013 г. (вторник) 18:00 часа

Локомотив - Ягодина /Сърбия/ (гр. София, ст. Локомотив)
(0:1)

06 юни 2013 г. (събота)

Локомотив - Ботев /Гълъбово/ (гр. Самоков)

10 юли 2013 г. (сряда) ОФИЦИАЛНО ПРЕДСТАВЯНЕ

Локомотив - Сливнишки герой (гр. София, ст. Локомотив)

13 юли 2013 г. (събота)

Локомотив /Мездра/ или ЦСКА 1923 - Локомотив

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

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

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 ⇒ d6d892b6749541bc9bd438a050a98f20

com_mailto.links

28c5e34dc54287f3df6c99885b0043f4c72b852b

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

38c60038f6ee9e4ef174724a1245d8a7e34bffb5

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

61a5c1ff615757b12816f2ccd2393447cc841e96

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

9a9bae5a31babb9cd8818565deb76892e90d2c1f

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

3ac91bc33e4f1062fba60dce6887c498a7009d38

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

03e6ce526959c08f88e430ac6000c70a123ed752

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

9f18b9a2bcb6fa69408443ca1b35eb8336a0d3a9

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

9f04c3d0fd23f5d1161615532967821cde5b0af1

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

4f197d12a37a1816f16ae53f1649576e1b7185e8

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

78c15978e3cabbe4e44515fcb4166bf375ec4ff3

link ⇒ https://lokomotiv.ntesrv.com/joomla16/видео/пълен-запис/2532-пълен-запис-вт-локомотив-нн-комодор-6-5-финали-u19

1b5af4b14ce99ee92a9b75a6c6d9a3b61cb3da51

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

bb7dc75b17bf1cd586beae79b10c9f506a592423

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

29730f7d59366c62eb19f4dcb8c4f125a0c2014d

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

f52c6006d9eaa858af559b0ec5e43831aa997152

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

b5709e6b1897ba72e1fc82b956e464a1b2522efb

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

f5a4d6104438899531546d9ec8da1d1dd30f2ea5

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

9d8dc22cd9f8b4c399750d42a8e0d14c24ae1ed9

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

742b7b9df2979f1d1ae426ace18004b695bfe13e

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

d204fe37afddd6890551d7896392ad85920798f9

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

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

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

Application 0.107 seconds (+0.049); 6.63 MB (+2.764) - afterRoute

Application 0.280 seconds (+0.172); 10.48 MB (+3.849) - afterDispatch

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

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

Application 0.303 seconds (+0.001); 10.97 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.306 seconds (+0.003); 10.98 MB (+0.007) - afterRenderModule mod_custom (LOGO)

Application 0.307 seconds (+0.001); 10.98 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.404 seconds (+0.097); 12.94 MB (+1.957) - afterRenderModule mod_menu (Main Menu)

Application 0.434 seconds (+0.030); 13.20 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.439 seconds (+0.005); 13.22 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Application 0.505 seconds (+0.064); 13.50 MB (+0.264) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.507 seconds (+0.002); 13.42 MB (-0.083) - beforeRenderModule mod_menu (Submenu)

Application 0.513 seconds (+0.006); 13.43 MB (+0.010) - afterRenderModule mod_menu (Submenu)

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

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

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

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

Application 0.517 seconds (+0.000); 13.43 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.518 seconds (+0.001); 13.44 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

Application 0.518 seconds (+0.000); 13.47 MB (+0.031) - beforeRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.547 seconds (+0.028); 13.88 MB (+0.407) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.547 seconds (+0.000); 13.84 MB (-0.039) - beforeRenderModule mod_custom (razvitie)

Application 0.548 seconds (+0.001); 13.84 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 0.593 seconds (+0.045); 16.59 MB (+2.739) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

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

Application 0.685 seconds (+0.087); 17.15 MB (+0.516) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

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

Application 0.780 seconds (+0.094); 17.38 MB (+0.259) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

Application 0.805 seconds (+0.024); 17.29 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

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

Application 0.846 seconds (+0.023); 17.65 MB (+0.332) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.846 seconds (+0.001); 17.69 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 0.852 seconds (+0.006); 17.71 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 0.884 seconds (+0.031); 17.86 MB (+0.152) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 0.919 seconds (+0.035); 17.88 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 0.922 seconds (+0.003); 17.84 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.028 seconds (+0.106); 20.11 MB (+2.265) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.061 seconds (+0.034); 20.13 MB (+0.022) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '132da9a687a3b10a6238184987f0569c'
DELETE FROM `jos_session` WHERE `time` < '1787399259'
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=33 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT alias, catid FROM jos_content WHERE id = 33
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 = 33 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-22 12:47:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 12:47:39') 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=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
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.33') 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 = 26 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-08-22 12:47:39') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-22 12:47:39') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '33' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 33 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 33
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-08-22 12:47:39') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-22 12:47:39') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 153 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_acepolls'
SELECT a.metakey, a.catid, a.created_by, a.created_by_alias, cc.title as category_title, u.name as author FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_users AS u ON u.id = a.created_by WHERE a.id = 33
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 != 33 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 "%,лято 2013,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-22 12:47:39' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 12:47:39' ) 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=49 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT 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 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-08-22 12:47:39' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 12:47:39' ) 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-08-22 12:47:39', 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-08-22 12:47:39') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 12:47:39') 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.217.173' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.217.173' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.217.*%' 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 = '1787402860' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013') limit 1
update jos_extrawatch_uri2title set title = 'Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)' where id = '2549452'
select id, username from jos_extrawatch where ip = '216.73.217.173' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '1043294', '1787402860', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013', 'Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)')
select id from jos_extrawatch_uri where fk = '1043294' and `timestamp` = '1787402860' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013' and `title` LIKE 'Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'Itemid', '153', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'catid', '26', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'id', '33', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.217.173' and date = '20687')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.217.173' and date = '20687')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20687')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20687')
select ip, country from jos_extrawatch where (ip = '216.73.217.173' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718509 >= start AND 3628718509 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.217.173'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:58;s:19:\"session.timer.start\";i:1787402798;s:18:\"session.timer.last\";i:1787402859;s:17:\"session.timer.now\";i:1787402859;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";s:1:\"1\";}s:13:\"session.token\";s:32:\"d6d892b6749541bc9bd438a050a98f20\";s:19:\"com_mailto.formtime\";i:1787402859;s:16:\"com_mailto.links\";a:19:{s:40:\"28c5e34dc54287f3df6c99885b0043f4c72b852b\";O:8:\"stdClass\":2:{s:4:\"link\";s:246:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/655-важно-официалните-цени-на-билетите-за-феновете-на-локомотив-в-разград\";s:6:\"expiry\";i:1787402809;}s:40:\"38c60038f6ee9e4ef174724a1245d8a7e34bffb5\";O:8:\"stdClass\":2:{s:4:\"link\";s:280:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/759-честит-юбилей-на-най-добрият-треньор-в-българия-димитър-васев\";s:6:\"expiry\";i:1787402811;}s:40:\"61a5c1ff615757b12816f2ccd2393447cc841e96\";O:8:\"stdClass\":2:{s:4:\"link\";s:230:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/661-николайчо-гигов-кога-сте-виждали-феновете-на-локомотив-да-помагат-на-отбора\";s:6:\"expiry\";i:1787402815;}s:40:\"9a9bae5a31babb9cd8818565deb76892e90d2c1f\";O:8:\"stdClass\":2:{s:4:\"link\";s:254:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1408-страхотно-три-финала-за-българските-боксьорки-на-европейското\";s:6:\"expiry\";i:1787402816;}s:40:\"3ac91bc33e4f1062fba60dce6887c498a7009d38\";O:8:\"stdClass\":2:{s:4:\"link\";s:229:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/992-фк-локомотив-поздрави-славчо-пеев\";s:6:\"expiry\";i:1787402824;}s:40:\"03e6ce526959c08f88e430ac6000c70a123ed752\";O:8:\"stdClass\":2:{s:4:\"link\";s:211:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1152-снимки-локо-сф-и-сливнишки-герой-с-реми-в-здрав-мач\";s:6:\"expiry\";i:1787402826;}s:40:\"9f18b9a2bcb6fa69408443ca1b35eb8336a0d3a9\";O:8:\"stdClass\":2:{s:4:\"link\";s:226:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2485-иван-василев-очаква-концепция-за-да-прехвърли-акциите-на-феновете\";s:6:\"expiry\";i:1787402831;}s:40:\"9f04c3d0fd23f5d1161615532967821cde5b0af1\";O:8:\"stdClass\":2:{s:4:\"link\";s:244:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/волейболен-клуб-локомотив-софия/2862-волейбол-u13-се-класираха-на-републиканско-първенство\";s:6:\"expiry\";i:1787402836;}s:40:\"4f197d12a37a1816f16ae53f1649576e1b7185e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:251:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/783-девет-години-от-смъртта-на-незабравимия-начко\";s:6:\"expiry\";i:1787402837;}s:40:\"78c15978e3cabbe4e44515fcb4166bf375ec4ff3\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/видео/пълен-запис/2532-пълен-запис-вт-локомотив-нн-комодор-6-5-финали-u19\";s:6:\"expiry\";i:1787402839;}s:40:\"1b5af4b14ce99ee92a9b75a6c6d9a3b61cb3da51\";O:8:\"stdClass\":2:{s:4:\"link\";s:189:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/3001-видео-лудогорец-2-локомотив-1-4\";s:6:\"expiry\";i:1787402840;}s:40:\"bb7dc75b17bf1cd586beae79b10c9f506a592423\";O:8:\"stdClass\":2:{s:4:\"link\";s:242:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2449-боксьорите-с-чудесно-представяне-на-мемориал-емил-жечев\";s:6:\"expiry\";i:1787402841;}s:40:\"29730f7d59366c62eb19f4dcb8c4f125a0c2014d\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1461-европейски-шампионки-наградиха-сираци-на-боксов-турнир\";s:6:\"expiry\";i:1787402845;}s:40:\"f52c6006d9eaa858af559b0ec5e43831aa997152\";O:8:\"stdClass\":2:{s:4:\"link\";s:233:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1699-благотворителен-боксов-турнир-деца-помагат-на-деца\";s:6:\"expiry\";i:1787402846;}s:40:\"b5709e6b1897ba72e1fc82b956e464a1b2522efb\";O:8:\"stdClass\":2:{s:4:\"link\";s:236:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2727-мъжкият-отбор-стартира-защитата-на-три-поредни-титли\";s:6:\"expiry\";i:1787402848;}s:40:\"f5a4d6104438899531546d9ec8da1d1dd30f2ea5\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2729-на-живо-локомотив-хебър-събота-14-30-ч\";s:6:\"expiry\";i:1787402849;}s:40:\"9d8dc22cd9f8b4c399750d42a8e0d14c24ae1ed9\";O:8:\"stdClass\":2:{s:4:\"link\";s:213:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/карате/2323-снимки-карате-клуб-локомотив-на-турнира-ронин-в-зала-триадица\";s:6:\"expiry\";i:1787402857;}s:40:\"742b7b9df2979f1d1ae426ace18004b695bfe13e\";O:8:\"stdClass\":2:{s:4:\"link\";s:194:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1315-следихме-на-живо-ботев-враца-локомотив-0-0\";s:6:\"expiry\";i:1787402858;}s:40:\"d204fe37afddd6890551d7896392ad85920798f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013\";s:6:\"expiry\";i:1787402860;}}}' , `time` = '1787402860' WHERE `session_id` = '132da9a687a3b10a6238184987f0569c'

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

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

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

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

2 × update jos_extrawatch_info set value = value+1
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'catid', '26', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'view', 'article', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'id', '33', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:58;s:19:\"session.timer.start\";i:1787402798;s:18:\"session.timer.last\";i:1787402859;s:17:\"session.timer.now\";i:1787402859;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";s:1:\"1\";}s:13:\"session.token\";s:32:\"d6d892b6749541bc9bd438a050a98f20\";s:19:\"com_mailto.formtime\";i:1787402859;s:16:\"com_mailto.links\";a:19:{s:40:\"28c5e34dc54287f3df6c99885b0043f4c72b852b\";O:8:\"stdClass\":2:{s:4:\"link\";s:246:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/655-важно-официалните-цени-на-билетите-за-феновете-на-локомотив-в-разград\";s:6:\"expiry\";i:1787402809;}s:40:\"38c60038f6ee9e4ef174724a1245d8a7e34bffb5\";O:8:\"stdClass\":2:{s:4:\"link\";s:280:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/759-честит-юбилей-на-най-добрият-треньор-в-българия-димитър-васев\";s:6:\"expiry\";i:1787402811;}s:40:\"61a5c1ff615757b12816f2ccd2393447cc841e96\";O:8:\"stdClass\":2:{s:4:\"link\";s:230:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/661-николайчо-гигов-кога-сте-виждали-феновете-на-локомотив-да-помагат-на-отбора\";s:6:\"expiry\";i:1787402815;}s:40:\"9a9bae5a31babb9cd8818565deb76892e90d2c1f\";O:8:\"stdClass\":2:{s:4:\"link\";s:254:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1408-страхотно-три-финала-за-българските-боксьорки-на-европейското\";s:6:\"expiry\";i:1787402816;}s:40:\"3ac91bc33e4f1062fba60dce6887c498a7009d38\";O:8:\"stdClass\":2:{s:4:\"link\";s:229:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/992-фк-локомотив-поздрави-славчо-пеев\";s:6:\"expiry\";i:1787402824;}s:40:\"03e6ce526959c08f88e430ac6000c70a123ed752\";O:8:\"stdClass\":2:{s:4:\"link\";s:211:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1152-снимки-локо-сф-и-сливнишки-герой-с-реми-в-здрав-мач\";s:6:\"expiry\";i:1787402826;}s:40:\"9f18b9a2bcb6fa69408443ca1b35eb8336a0d3a9\";O:8:\"stdClass\":2:{s:4:\"link\";s:226:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2485-иван-василев-очаква-концепция-за-да-прехвърли-акциите-на-феновете\";s:6:\"expiry\";i:1787402831;}s:40:\"9f04c3d0fd23f5d1161615532967821cde5b0af1\";O:8:\"stdClass\":2:{s:4:\"link\";s:244:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/волейболен-клуб-локомотив-софия/2862-волейбол-u13-се-класираха-на-републиканско-първенство\";s:6:\"expiry\";i:1787402836;}s:40:\"4f197d12a37a1816f16ae53f1649576e1b7185e8\";O:8:\"stdClass\":2:{s:4:\"link\";s:251:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/783-девет-години-от-смъртта-на-незабравимия-начко\";s:6:\"expiry\";i:1787402837;}s:40:\"78c15978e3cabbe4e44515fcb4166bf375ec4ff3\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/видео/пълен-запис/2532-пълен-запис-вт-локомотив-нн-комодор-6-5-финали-u19\";s:6:\"expiry\";i:1787402839;}s:40:\"1b5af4b14ce99ee92a9b75a6c6d9a3b61cb3da51\";O:8:\"stdClass\":2:{s:4:\"link\";s:189:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/3001-видео-лудогорец-2-локомотив-1-4\";s:6:\"expiry\";i:1787402840;}s:40:\"bb7dc75b17bf1cd586beae79b10c9f506a592423\";O:8:\"stdClass\":2:{s:4:\"link\";s:242:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/2449-боксьорите-с-чудесно-представяне-на-мемориал-емил-жечев\";s:6:\"expiry\";i:1787402841;}s:40:\"29730f7d59366c62eb19f4dcb8c4f125a0c2014d\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1461-европейски-шампионки-наградиха-сираци-на-боксов-турнир\";s:6:\"expiry\";i:1787402845;}s:40:\"f52c6006d9eaa858af559b0ec5e43831aa997152\";O:8:\"stdClass\":2:{s:4:\"link\";s:233:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/боксов-клуб-локомотив-софия/1699-благотворителен-боксов-турнир-деца-помагат-на-деца\";s:6:\"expiry\";i:1787402846;}s:40:\"b5709e6b1897ba72e1fc82b956e464a1b2522efb\";O:8:\"stdClass\":2:{s:4:\"link\";s:236:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2727-мъжкият-отбор-стартира-защитата-на-три-поредни-титли\";s:6:\"expiry\";i:1787402848;}s:40:\"f5a4d6104438899531546d9ec8da1d1dd30f2ea5\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2729-на-живо-локомотив-хебър-събота-14-30-ч\";s:6:\"expiry\";i:1787402849;}s:40:\"9d8dc22cd9f8b4c399750d42a8e0d14c24ae1ed9\";O:8:\"stdClass\":2:{s:4:\"link\";s:213:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/карате/2323-снимки-карате-клуб-локомотив-на-турнира-ронин-в-зала-триадица\";s:6:\"expiry\";i:1787402857;}s:40:\"742b7b9df2979f1d1ae426ace18004b695bfe13e\";O:8:\"stdClass\":2:{s:4:\"link\";s:194:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1315-следихме-на-живо-ботев-враца-локомотив-0-0\";s:6:\"expiry\";i:1787402858;}s:40:\"d204fe37afddd6890551d7896392ad85920798f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013\";s:6:\"expiry\";i:1787402860;}}}' , `time` = '1787402860'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14168301', 'Itemid', '153', 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 = '1787402860'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '1043294', '1787402860', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/33-програма-и-резултати-в-контролните-срещи-лято-2013-2-юли-2013', 'Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)'
1 × update jos_extrawatch_uri2title set title = 'Програма и резултати в контролните срещи - лято 2013 (2 юли 2013)'
1 × DELETE FROM `jos_session`

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

28c5e34dc54287f3df6c99885b0043f4c72b852b

38c60038f6ee9e4ef174724a1245d8a7e34bffb5

61a5c1ff615757b12816f2ccd2393447cc841e96

9a9bae5a31babb9cd8818565deb76892e90d2c1f

3ac91bc33e4f1062fba60dce6887c498a7009d38

03e6ce526959c08f88e430ac6000c70a123ed752

9f18b9a2bcb6fa69408443ca1b35eb8336a0d3a9

9f04c3d0fd23f5d1161615532967821cde5b0af1

4f197d12a37a1816f16ae53f1649576e1b7185e8

78c15978e3cabbe4e44515fcb4166bf375ec4ff3

1b5af4b14ce99ee92a9b75a6c6d9a3b61cb3da51

bb7dc75b17bf1cd586beae79b10c9f506a592423

29730f7d59366c62eb19f4dcb8c4f125a0c2014d

f52c6006d9eaa858af559b0ec5e43831aa997152

b5709e6b1897ba72e1fc82b956e464a1b2522efb

f5a4d6104438899531546d9ec8da1d1dd30f2ea5

9d8dc22cd9f8b4c399750d42a8e0d14c24ae1ed9

742b7b9df2979f1d1ae426ace18004b695bfe13e

d204fe37afddd6890551d7896392ad85920798f9

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

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

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

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

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

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

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