Локомотив - Спортист (Своге) 3:0

вкл. 31 Януари 2019.

lokomotiv 2017

Локомотив победи Спортист (Своге) с 3:0 в контролна среща. Първата част на двубоя завърши без попадения, а през второто полувреме "железничарите" вкараха три попадения.

Голмайстори бяха Вачев, Веселинов и Чаворски. В четвъртък футболистите на на Младен Додич заминават на лагер в град Сандански. Там първия двубой е срещу Кариана на 6 февруари, а след това срещу Септември в Симитли и накрая срещу Вихрен в Сандански.

Последната проверка преди подновяването на полусезона във Втора лига е в столицат срещу Локомотив (Горна Оряховица).

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

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

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

ba353a3b3eb4d78dc689633f6b5eeb0ad18ce6a9

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

ba2291bc7c289a2119494ea851336ff4fc2132f3

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/450-снимки-2014-2015-2-кръг-локомотив-литекс-2-0

7cacd236095a3a36a2529a59ffd7ca0c2e88a21a

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

b2d028fe94bb7e3a539b3599fb804546852ad303

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

00811603551eb1eaa5aefa9fa75571320b718e3b

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

14494a8673b868321ce0bcf726b6c78f5f913e73

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

de6ffb9680d1817338e1bd59cdacebe97411ef89

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

670b7c47b274e1ea1ddfffc911e1efc65d35bdf4

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

37cfda2fb1961b38f657f60c88e694b829f95b10

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

9d71d4f14ff65157e35e47839de8189d2f1aee0d

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

bb4d44ee1208cfde33303a188e3c16d237e86c2f

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

9f16ac7168f8a16ac77a9f536be293879f43bbed

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

b28f85a29bdeabe09967b87d6fe12cab34cb3fa4

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/446-на-живо-u21-локомотив-ботев-1-1

65a6cd2bd00ced230a1b26ff58af0a61cfb67746

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

67323adb16dec79e01900df4830df71ef77d74b8

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2734-на-живо-локомотив-цска-1948-12-00

443d1a1c481750fa1676af82eb942719f7262ff8

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

c36e188bb4ef4210632fdb8746b93373711c73a8

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

a5216814c58f33214b6bd5ba812c6ef37872d2a4

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

64c25abdee98ce28306bc554d01663ca37b5573d

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

56e78c24c1e7d730694e38698522f1b4beab78f8

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2844-локомотив-миньор-18-00

b0cf9d7efd763debd727bc7c492581ed21eb88f1

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

session.token ⇒ 4ea794338f1b618858e7ffabf2609566

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

Application 0.059 seconds (+0.059); 3.86 MB (+3.220) - afterInitialise

Application 0.112 seconds (+0.053); 6.60 MB (+2.736) - afterRoute

Application 0.330 seconds (+0.218); 10.41 MB (+3.815) - afterDispatch

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

Application 0.352 seconds (+0.007); 10.92 MB (+0.045) - afterRenderModule mod_search (Търси)

Application 0.353 seconds (+0.001); 10.91 MB (-0.005) - beforeRenderModule mod_custom (LOGO)

Application 0.357 seconds (+0.003); 10.92 MB (+0.007) - afterRenderModule mod_custom (LOGO)

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

Application 0.446 seconds (+0.087); 12.88 MB (+1.957) - afterRenderModule mod_menu (Main Menu)

Application 0.472 seconds (+0.026); 13.13 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.477 seconds (+0.005); 13.16 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Application 0.663 seconds (+0.185); 13.43 MB (+0.258) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.666 seconds (+0.003); 13.36 MB (-0.077) - beforeRenderModule mod_menu (Submenu)

Application 0.678 seconds (+0.012); 13.37 MB (+0.010) - afterRenderModule mod_menu (Submenu)

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

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

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

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

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

Application 0.685 seconds (+0.001); 13.37 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

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

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

Application 0.719 seconds (+0.000); 13.77 MB (-0.040) - beforeRenderModule mod_custom (razvitie)

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

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

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

Application 0.790 seconds (+0.003); 16.49 MB (-0.034) - beforeRenderModule mod_custom (Добави статия)

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

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

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

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

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

Application 1.010 seconds (+0.093); 17.33 MB (+0.267) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

Application 1.011 seconds (+0.001); 17.21 MB (-0.117) - afterRenderModule mod_jw_ts (Tabs & Sliders (by JoomlaWorks) sidebar-b)

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

Application 1.026 seconds (+0.015); 17.24 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

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

Application 1.083 seconds (+0.041); 17.62 MB (+0.355) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 1.085 seconds (+0.001); 17.66 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 1.094 seconds (+0.009); 17.68 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

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

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

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

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

Application 1.165 seconds (+0.003); 17.81 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.324 seconds (+0.159); 20.08 MB (+2.264) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.355 seconds (+0.031); 20.09 MB (+0.015) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '64a9f17e106272c78421f42712bc554b'
DELETE FROM `jos_session` WHERE `time` < '1772294899'
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=2373 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 = 2373
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 = 2373 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-28 17:08:19') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-28 17:08:19') 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.2373') 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-02-28 17:08:19') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-28 17:08:19') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '2373' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 2373 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 2373
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-02-28 17:08:19') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-28 17:08:19') 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'
DELETE FROM `jos_session` WHERE `time` < '1772294899'
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 = 2373
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 != 2373 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 "%,2019,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Спортист,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Требич,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-28 17:08:19' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-28 17:08:19' ) 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=15 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=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
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT id, fav_team FROM jos_joomleague_project p WHERE fav_team != '' AND id IN (39)
SELECT m.*,m.id as match_id, t1.id team1_id, t2.id team2_id, DATE(m.match_date) AS match_date_notime, m.match_date AS match_date, NOW() AS currenttime, IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) AS totaltime, IF ( (match_date > UTC_TIMESTAMP() AND m.team1_result IS NULL) AND ((m.team1_result_split IS NULL) OR TRIM(REPLACE(m.team1_result_split, ';', '')) = ''),m.match_date, 'z' ) AS upcoming, IF ( (m.team1_result IS NOT NULL OR m.match_date < UTC_TIMESTAMP()),m.match_date, 0 ) AS alreadyplayed, IF ( ( ( DATE_ADD(m.match_date, INTERVAL IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) MINUTE ) > UTC_TIMESTAMP() ) AND (m.match_date < UTC_TIMESTAMP() ) AND (m.team1_result IS NULL) ),m.match_date, 'z' ) AS actplaying, IF ( ((m.team1_result IS NULL) AND (m.team1_result_split IS NOT NULL) AND TRIM(REPLACE(m.team1_result_split, ';', '') != '')),m.match_date,'z' ) AS live, DATE_SUB(m.match_date, INTERVAL '90' MINUTE) AS meetingtime, NOW() AS local_time, r.*, p.name AS pname, p.current_round, p.id AS project_id, p.timezone, p.game_parts, p.ordering, IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname, pg.name AS pg_name, pt1.division_id, pg.short_name AS pg_shortname FROM jos_joomleague_match m INNER JOIN jos_joomleague_round r ON m.round_id = r.id INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = m.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = m.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id INNER JOIN jos_joomleague_project p ON pt1.project_id = p.id LEFT JOIN jos_joomleague_match_referee AS mref ON m.id = mref.match_id LEFT JOIN jos_joomleague_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN jos_joomleague_person AS person ON person.id = pref.person_id AND person.published = 1 AND pref.published = 1 LEFT JOIN jos_joomleague_playground AS pg ON pg.id = m.playground_id WHERE ( (( (pt1.team_id IN (2) OR pt2.team_id IN (2)) AND (pt1.project_id = 39 OR pt2.project_id = 39) )) AND p.published = 1 AND m.published = 1 AND (m.match_date > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 3 MONTH)) AND (pt1.project_id IN (39) OR pt2.project_id IN (39)) ) GROUP BY m.id ORDER by match_date DESC LIMIT 1
SHOW FULL COLUMNS FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_lists` WHERE `published` = 1
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT id, rules FROM `jos_viewlevels`
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE cc.published = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-28 17:08:19' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-28 17:08:19' ) AND (cc.id = 8 OR cc.id = 9 OR cc.id = 12 OR cc.id = 13 OR cc.id = 16 OR cc.id = 17 OR cc.id = 19 OR cc.id = 23 OR cc.id = 31 OR cc.id = 56 OR cc.id = 10 OR cc.id = 11 OR cc.id = 67 OR cc.id = 15 OR cc.id = 26 OR cc.id = 27 OR cc.id = 48 OR cc.id = 14 OR cc.id = 28 OR cc.id = 51 OR cc.id = 55 OR cc.id = 59 OR cc.id = 21 OR cc.id = 22 OR cc.id = 47 OR cc.id = 61 OR cc.id = 18 OR cc.id = 29 OR cc.id = 30 OR cc.id = 52 OR cc.id = 53 OR cc.id = 64 OR cc.id = 65 OR cc.id = 69 OR cc.id = 70 OR cc.id = 71 OR cc.id = 72 OR cc.id = 24 OR cc.id = 37 OR cc.id = 38 OR cc.id = 39 OR cc.id = 40 OR cc.id = 41 OR cc.id = 42 OR cc.id = 43 OR cc.id = 46 OR cc.id = 32 OR cc.id = 33 OR cc.id = 44 OR cc.id = 45 OR cc.id = 54 OR cc.id = 57 OR cc.id = 62 OR cc.id = 63 OR cc.id = 66 OR cc.id = 73 OR cc.id = 74 OR cc.id = 49 OR cc.id = 50 OR cc.id = 58 OR cc.id = 60 OR cc.id = 68 OR cc.id = 25 OR cc.id = 34 OR cc.id = 35 OR cc.id = 36) AND a.access <= 1 AND cc.access <= 1 AND DATEDIFF('2026-02-28 17:08:19', 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-02-28 17:08:19') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-28 17:08:19') ORDER BY a.created DESC LIMIT 0, 1
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=49 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') ORDER BY c.date DESC LIMIT 0, 4
SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') GROUP BY o.id, o.title, o.link ORDER BY commentsCount DESC, c.date DESC LIMIT 0, 5
select name, value from jos_extrawatch_config
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.21' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.21' 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 = '1772298500' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0') limit 1
update jos_extrawatch_uri2title set title = 'Локомотив - Спортист (Своге) 3:0' where id = '2549153'
select id, username from jos_extrawatch where ip = '216.73.216.21' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '839810', '1772298500', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0', 'Локомотив - Спортист (Своге) 3:0')
select id from jos_extrawatch_uri where fk = '839810' and `timestamp` = '1772298500' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0' and `title` LIKE 'Локомотив - Спортист (Своге) 3:0'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'Itemid', '153', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'catid', '26', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'id', '2373', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.21' and date = '20512')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.21' and date = '20512')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20512')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20512')
select ip, country from jos_extrawatch where (ip = '216.73.216.21' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718101 >= start AND 3628718101 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.21'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:21;s:19:\"session.timer.start\";i:1772298452;s:18:\"session.timer.last\";i:1772298497;s:17:\"session.timer.now\";i:1772298499;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:21:{s:40:\"ba353a3b3eb4d78dc689633f6b5eeb0ad18ce6a9\";O:8:\"stdClass\":2:{s:4:\"link\";s:172:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/789-на-живо-локомотив-софия-спорт\";s:6:\"expiry\";i:1772298453;}s:40:\"ba2291bc7c289a2119494ea851336ff4fc2132f3\";O:8:\"stdClass\":2:{s:4:\"link\";s:187:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/450-снимки-2014-2015-2-кръг-локомотив-литекс-2-0\";s:6:\"expiry\";i:1772298456;}s:40:\"7cacd236095a3a36a2529a59ffd7ca0c2e88a21a\";O:8:\"stdClass\":2:{s:4:\"link\";s:158:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/баскетбол/2949-политехника-надви-локомотив\";s:6:\"expiry\";i:1772298457;}s:40:\"b2d028fe94bb7e3a539b3599fb804546852ad303\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/539-иван-василев-бозата-пред-в-к-7-дни-спорт\";s:6:\"expiry\";i:1772298459;}s:40:\"00811603551eb1eaa5aefa9fa75571320b718e3b\";O:8:\"stdClass\":2:{s:4:\"link\";s:179:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1608-на-живо-локомотив-ботев-враца-17-00\";s:6:\"expiry\";i:1772298461;}s:40:\"14494a8673b868321ce0bcf726b6c78f5f913e73\";O:8:\"stdClass\":2:{s:4:\"link\";s:170:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1442-локомотив-победи-банско-с-2-0\";s:6:\"expiry\";i:1772298462;}s:40:\"de6ffb9680d1817338e1bd59cdacebe97411ef89\";O:8:\"stdClass\":2:{s:4:\"link\";s:159:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/1063-локомотив-царско-село,-витоша-левски\";s:6:\"expiry\";i:1772298464;}s:40:\"670b7c47b274e1ea1ddfffc911e1efc65d35bdf4\";O:8:\"stdClass\":2:{s:4:\"link\";s:179:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1735-на-живо-локомотив-ботев-враца-10-00\";s:6:\"expiry\";i:1772298466;}s:40:\"37cfda2fb1961b38f657f60c88e694b829f95b10\";O:8:\"stdClass\":2:{s:4:\"link\";s:180:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2920-видео-локомотив-спортист-своге-3-0\";s:6:\"expiry\";i:1772298467;}s:40:\"9d71d4f14ff65157e35e47839de8189d2f1aee0d\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/451-преди-дербито-с-левски\";s:6:\"expiry\";i:1772298469;}s:40:\"bb4d44ee1208cfde33303a188e3c16d237e86c2f\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1447-на-живо-локомотив-левски\";s:6:\"expiry\";i:1772298471;}s:40:\"9f16ac7168f8a16ac77a9f536be293879f43bbed\";O:8:\"stdClass\":2:{s:4:\"link\";s:161:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2669-локомотив-литекс-1-0-впл\";s:6:\"expiry\";i:1772298473;}s:40:\"b28f85a29bdeabe09967b87d6fe12cab34cb3fa4\";O:8:\"stdClass\":2:{s:4:\"link\";s:169:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/446-на-живо-u21-локомотив-ботев-1-1\";s:6:\"expiry\";i:1772298475;}s:40:\"65a6cd2bd00ced230a1b26ff58af0a61cfb67746\";O:8:\"stdClass\":2:{s:4:\"link\";s:156:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2728-локомотив-хебър-събота-14-30-ч\";s:6:\"expiry\";i:1772298477;}s:40:\"67323adb16dec79e01900df4830df71ef77d74b8\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2734-на-живо-локомотив-цска-1948-12-00\";s:6:\"expiry\";i:1772298479;}s:40:\"443d1a1c481750fa1676af82eb942719f7262ff8\";O:8:\"stdClass\":2:{s:4:\"link\";s:173:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1773-на-живо-локомотив-ботев-вр-18-30\";s:6:\"expiry\";i:1772298481;}s:40:\"c36e188bb4ef4210632fdb8746b93373711c73a8\";O:8:\"stdClass\":2:{s:4:\"link\";s:168:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1036-на-живо-локомотив-въстаник\";s:6:\"expiry\";i:1772298492;}s:40:\"a5216814c58f33214b6bd5ba812c6ef37872d2a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2888-всички-спортни-събития-отново-без-публика\";s:6:\"expiry\";i:1772298494;}s:40:\"64c25abdee98ce28306bc554d01663ca37b5573d\";O:8:\"stdClass\":2:{s:4:\"link\";s:175:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/574-локомотив-вече-и-на-теория-е-в-първата-шестица\";s:6:\"expiry\";i:1772298495;}s:40:\"56e78c24c1e7d730694e38698522f1b4beab78f8\";O:8:\"stdClass\":2:{s:4:\"link\";s:156:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2844-локомотив-миньор-18-00\";s:6:\"expiry\";i:1772298497;}s:40:\"b0cf9d7efd763debd727bc7c492581ed21eb88f1\";O:8:\"stdClass\":2:{s:4:\"link\";s:169:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0\";s:6:\"expiry\";i:1772298499;}}s:13:\"session.token\";s:32:\"4ea794338f1b618858e7ffabf2609566\";}' , `time` = '1772298500' WHERE `session_id` = '64a9f17e106272c78421f42712bc554b'

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 ('12642318', 'view', 'article', 2
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:21;s:19:\"session.timer.start\";i:1772298452;s:18:\"session.timer.last\";i:1772298497;s:17:\"session.timer.now\";i:1772298499;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:21:{s:40:\"ba353a3b3eb4d78dc689633f6b5eeb0ad18ce6a9\";O:8:\"stdClass\":2:{s:4:\"link\";s:172:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/789-на-живо-локомотив-софия-спорт\";s:6:\"expiry\";i:1772298453;}s:40:\"ba2291bc7c289a2119494ea851336ff4fc2132f3\";O:8:\"stdClass\":2:{s:4:\"link\";s:187:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/450-снимки-2014-2015-2-кръг-локомотив-литекс-2-0\";s:6:\"expiry\";i:1772298456;}s:40:\"7cacd236095a3a36a2529a59ffd7ca0c2e88a21a\";O:8:\"stdClass\":2:{s:4:\"link\";s:158:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/баскетбол/2949-политехника-надви-локомотив\";s:6:\"expiry\";i:1772298457;}s:40:\"b2d028fe94bb7e3a539b3599fb804546852ad303\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/539-иван-василев-бозата-пред-в-к-7-дни-спорт\";s:6:\"expiry\";i:1772298459;}s:40:\"00811603551eb1eaa5aefa9fa75571320b718e3b\";O:8:\"stdClass\":2:{s:4:\"link\";s:179:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1608-на-живо-локомотив-ботев-враца-17-00\";s:6:\"expiry\";i:1772298461;}s:40:\"14494a8673b868321ce0bcf726b6c78f5f913e73\";O:8:\"stdClass\":2:{s:4:\"link\";s:170:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1442-локомотив-победи-банско-с-2-0\";s:6:\"expiry\";i:1772298462;}s:40:\"de6ffb9680d1817338e1bd59cdacebe97411ef89\";O:8:\"stdClass\":2:{s:4:\"link\";s:159:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/1063-локомотив-царско-село,-витоша-левски\";s:6:\"expiry\";i:1772298464;}s:40:\"670b7c47b274e1ea1ddfffc911e1efc65d35bdf4\";O:8:\"stdClass\":2:{s:4:\"link\";s:179:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1735-на-живо-локомотив-ботев-враца-10-00\";s:6:\"expiry\";i:1772298466;}s:40:\"37cfda2fb1961b38f657f60c88e694b829f95b10\";O:8:\"stdClass\":2:{s:4:\"link\";s:180:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2920-видео-локомотив-спортист-своге-3-0\";s:6:\"expiry\";i:1772298467;}s:40:\"9d71d4f14ff65157e35e47839de8189d2f1aee0d\";O:8:\"stdClass\":2:{s:4:\"link\";s:145:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/451-преди-дербито-с-левски\";s:6:\"expiry\";i:1772298469;}s:40:\"bb4d44ee1208cfde33303a188e3c16d237e86c2f\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1447-на-живо-локомотив-левски\";s:6:\"expiry\";i:1772298471;}s:40:\"9f16ac7168f8a16ac77a9f536be293879f43bbed\";O:8:\"stdClass\":2:{s:4:\"link\";s:161:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2669-локомотив-литекс-1-0-впл\";s:6:\"expiry\";i:1772298473;}s:40:\"b28f85a29bdeabe09967b87d6fe12cab34cb3fa4\";O:8:\"stdClass\":2:{s:4:\"link\";s:169:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/446-на-живо-u21-локомотив-ботев-1-1\";s:6:\"expiry\";i:1772298475;}s:40:\"65a6cd2bd00ced230a1b26ff58af0a61cfb67746\";O:8:\"stdClass\":2:{s:4:\"link\";s:156:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2728-локомотив-хебър-събота-14-30-ч\";s:6:\"expiry\";i:1772298477;}s:40:\"67323adb16dec79e01900df4830df71ef77d74b8\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2734-на-живо-локомотив-цска-1948-12-00\";s:6:\"expiry\";i:1772298479;}s:40:\"443d1a1c481750fa1676af82eb942719f7262ff8\";O:8:\"stdClass\":2:{s:4:\"link\";s:173:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1773-на-живо-локомотив-ботев-вр-18-30\";s:6:\"expiry\";i:1772298481;}s:40:\"c36e188bb4ef4210632fdb8746b93373711c73a8\";O:8:\"stdClass\":2:{s:4:\"link\";s:168:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1036-на-живо-локомотив-въстаник\";s:6:\"expiry\";i:1772298492;}s:40:\"a5216814c58f33214b6bd5ba812c6ef37872d2a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2888-всички-спортни-събития-отново-без-публика\";s:6:\"expiry\";i:1772298494;}s:40:\"64c25abdee98ce28306bc554d01663ca37b5573d\";O:8:\"stdClass\":2:{s:4:\"link\";s:175:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/574-локомотив-вече-и-на-теория-е-в-първата-шестица\";s:6:\"expiry\";i:1772298495;}s:40:\"56e78c24c1e7d730694e38698522f1b4beab78f8\";O:8:\"stdClass\":2:{s:4:\"link\";s:156:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2844-локомотив-миньор-18-00\";s:6:\"expiry\";i:1772298497;}s:40:\"b0cf9d7efd763debd727bc7c492581ed21eb88f1\";O:8:\"stdClass\":2:{s:4:\"link\";s:169:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0\";s:6:\"expiry\";i:1772298499;}}s:13:\"session.token\";s:32:\"4ea794338f1b618858e7ffabf2609566\";}' , `time` = '1772298500'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'catid', '26', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'id', '2373', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12642318', '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 = '1772298500'
1 × update jos_extrawatch_uri2title set title = 'Локомотив - Спортист (Своге) 3:0'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '839810', '1772298500', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2373-локомотив-спортист-своге-3-0', 'Локомотив - Спортист (Своге) 3:0'

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

ba353a3b3eb4d78dc689633f6b5eeb0ad18ce6a9

ba2291bc7c289a2119494ea851336ff4fc2132f3

7cacd236095a3a36a2529a59ffd7ca0c2e88a21a

b2d028fe94bb7e3a539b3599fb804546852ad303

00811603551eb1eaa5aefa9fa75571320b718e3b

14494a8673b868321ce0bcf726b6c78f5f913e73

de6ffb9680d1817338e1bd59cdacebe97411ef89

670b7c47b274e1ea1ddfffc911e1efc65d35bdf4

37cfda2fb1961b38f657f60c88e694b829f95b10

9d71d4f14ff65157e35e47839de8189d2f1aee0d

bb4d44ee1208cfde33303a188e3c16d237e86c2f

9f16ac7168f8a16ac77a9f536be293879f43bbed

b28f85a29bdeabe09967b87d6fe12cab34cb3fa4

65a6cd2bd00ced230a1b26ff58af0a61cfb67746

67323adb16dec79e01900df4830df71ef77d74b8

443d1a1c481750fa1676af82eb942719f7262ff8

c36e188bb4ef4210632fdb8746b93373711c73a8

a5216814c58f33214b6bd5ba812c6ef37872d2a4

64c25abdee98ce28306bc554d01663ca37b5573d

56e78c24c1e7d730694e38698522f1b4beab78f8

b0cf9d7efd763debd727bc7c492581ed21eb88f1

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

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

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

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

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

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

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