Чудесен празник, Локомотив - Нефтохимик 2:0

вкл. 10 Септември 2017.

С чудесен празник, Локомотивците отбелязахме 88 години от началото на железничарската спортна магия. Поздравления за страхотната атмосфера създадена от всички! Двубоя с Нефтохимик премина под тръпката от празника, а момчетата в червено-черно са постараха да ни зарадват с добра игра и победа. Вижте видеaтa на sportal.bg по-долу и очаквайте утре в сайта ни галерия с много снимки.

ЛОКОМОТИВ: 24 Ивайло Яначков, 16 Васил Попов, 23 Емил Виячки, 3 Евгени Зюмбулев, 21 Виктор Райчев, 6 Владимир Семерджиев, 7 Александър Александров /81-Денис Стоилов/, 33 Евертон Джилио /86-Иво Иванов/, 9 Илия Димитров, 18 Николай Цветков /90+3- Марио Йорданов/, 20 Здравко Димитров /Резерви: 1 Цветомир Витков, 13 Кристиян Николов, 26 Красимир Милошев, 14 Иво Иванов, 4 Антонио Стойков, 11 Денис Стоилов, 19 Марио Йорданов/ Старши треньор – Младен Додич

НЕФТОХИМИК: 11 Димитър Николов /70-Християн Славов/, 89 Андрей Казалиев, 3 Димитър Дончев, 16 Цветан Чахов /78-Георги Жеков/, 23 Станислав Жеков, 19 Ясен Тузаков, 71 Живко Илиев, 21 Цветан Филипов, 11 Мартин Иванов /57-Халибрям Кърмаджъ/, 18 Кирил Личев, 91 Виктор Янев /Резерви: 96 Християн Славов, 7 Георги Жеков, 9 Дзаминг Люй, 10 Симеон Русев, 22 Халибрям Кърмаджъ, 20 Стоян Калев, 8 Даниел Стаматов/ Старши треньор – Николай Кръстев

1:0 Илия Димитров 42' 2:0 Илия Димитров 90+2'

Главен съдия: Димо Димов, асистенти Стефан Делчев, Атанас Делчев
Стадион: “Локомотив”, София

източник: http://www.fclokomotiv1929.com/

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

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

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

3418dfd32357b9f46d21d867e463e5e269e10076

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

b0d63332b02706de8d4133ea719a14bf73dfdf0b

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

a7479597fd72b8803079f3f74eb3a56f662f5512

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

a536b8cca5bf4811afe4cf8bbc7d86f89b52a4be

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

189051820df04a6e55ec97534effd40bd0c94cfd

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

02ff18d152c1d9f27c5a83d1824fe432420c8af7

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

d460c4dea14dc867b83920919c2d11cedfa0a31a

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

e078e44bcd343e6ffdbb1145677e450146b91266

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

0e64e189c63ac6d51c2a8b764337963e51eed7bd

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/1582-big5-николай-гигов-дал-над-400-хиляди-лева-на-бсп-заради-дълговете-на-„дума“

a0adcda7b0511fedb0b02ea83bc4a4eb62fab7be

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

f279b7e955fb4ac186ad1e98a5d4fac631408208

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

8ab41640b7955358d720806b29e04050839ad817

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

b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f

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

267c2edc4dfc3bb5d2c827285416eaadb7752788

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

368bd5b539db3a9c4e3eb56d338fbdc37ce88522

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2408-таланти-от-локо-сф-ни-напомниха-най-важното-е-да-бъдем-хора-снимки

85de86eca22347586e823a9055509b122691a0c2

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2394-набор-2008-и-2009-на-купа-софия,-2003-и-нова-победа

d94a96d6bfeeee880667853724c273610b99e403

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

e9efa77d6384ef2ebf808a4b904bd7cca91363c2

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

c27ac076a2d81e81cd9f68d4160349a217d16f21

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

8baeb4e692f8d3b1c0a2248af304bffc170d9574

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

253e738a99b2102c2890c707a299620a424cc98a

link ⇒ https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/698-респект

eb3c12f6be81836d3faf5e0a739b31d477f48a24

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

session.token ⇒ 8f329c32c3239c143d547fd92f6022f4

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

Application 0.060 seconds (+0.060); 3.87 MB (+3.223) - afterInitialise

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

Application 5.363 seconds (+5.257); 10.43 MB (+3.828) - afterDispatch

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

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

Application 5.385 seconds (+0.001); 10.93 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 5.388 seconds (+0.003); 10.94 MB (+0.008) - afterRenderModule mod_custom (LOGO)

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

Application 5.467 seconds (+0.078); 12.89 MB (+1.956) - afterRenderModule mod_menu (Main Menu)

Application 5.492 seconds (+0.025); 13.15 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

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

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

Application 5.681 seconds (+0.181); 13.46 MB (+0.266) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 5.685 seconds (+0.004); 13.40 MB (-0.062) - beforeRenderModule mod_menu (Submenu)

Application 5.692 seconds (+0.007); 13.41 MB (+0.010) - afterRenderModule mod_menu (Submenu)

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

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

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

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

Application 5.697 seconds (+0.000); 13.41 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 5.698 seconds (+0.001); 13.41 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

Application 5.699 seconds (+0.002); 13.44 MB (+0.030) - beforeRenderModule mod_joomleague_matches (Програма и резултати)

Application 5.730 seconds (+0.030); 13.85 MB (+0.409) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 5.730 seconds (+0.000); 13.81 MB (-0.039) - beforeRenderModule mod_custom (razvitie)

Application 5.731 seconds (+0.001); 13.82 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 5.772 seconds (+0.041); 16.57 MB (+2.740) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

Application 5.779 seconds (+0.006); 16.61 MB (+0.078) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 5.859 seconds (+0.081); 17.13 MB (+0.516) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

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

Application 5.947 seconds (+0.087); 17.37 MB (+0.267) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

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

Application 5.970 seconds (+0.014); 17.30 MB (+0.025) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 5.992 seconds (+0.022); 17.63 MB (+0.331) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 5.993 seconds (+0.001); 17.67 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 5.999 seconds (+0.006); 17.69 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 6.024 seconds (+0.025); 17.84 MB (+0.151) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 6.051 seconds (+0.027); 17.86 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 6.053 seconds (+0.002); 17.83 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 6.160 seconds (+0.106); 20.09 MB (+2.264) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 6.186 seconds (+0.026); 20.11 MB (+0.019) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = 'a32e0f09e9a92befb9c4b3658dc39a71'
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=1830 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 = 1830
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 = 1830 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 10:24:16') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:24:16') 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.1830') 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 <= '2025-12-22 10:24:16') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-22 10:24:16') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '1830' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 1830 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 1830
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-22 10:24:16') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-22 10:24:16') 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 = 1830
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 != 1830 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 "%,88 години,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,празник,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Нефтохимик,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Локомотив,%" OR a.catid in (2) ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 10:24:16' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:24:16' ) AND a.catid IN (8,12,15,26,27,13,14,28,49,50,55,51,21,22,47,17,18,29,30,52,53,23,24,25,34,35,36,37,38,39,40,41,42,43,46,31,54,32,45,44,33)
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=28 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT id, fav_team FROM jos_joomleague_project p WHERE fav_team != '' AND id IN (39)
SELECT m.*,m.id as match_id, t1.id team1_id, t2.id team2_id, DATE(m.match_date) AS match_date_notime, m.match_date AS match_date, NOW() AS currenttime, IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) AS totaltime, IF ( (match_date > UTC_TIMESTAMP() AND m.team1_result IS NULL) AND ((m.team1_result_split IS NULL) OR TRIM(REPLACE(m.team1_result_split, ';', '')) = ''),m.match_date, 'z' ) AS upcoming, IF ( (m.team1_result IS NOT NULL OR m.match_date < UTC_TIMESTAMP()),m.match_date, 0 ) AS alreadyplayed, IF ( ( ( DATE_ADD(m.match_date, INTERVAL IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) MINUTE ) > UTC_TIMESTAMP() ) AND (m.match_date < UTC_TIMESTAMP() ) AND (m.team1_result IS NULL) ),m.match_date, 'z' ) AS actplaying, IF ( ((m.team1_result IS NULL) AND (m.team1_result_split IS NOT NULL) AND TRIM(REPLACE(m.team1_result_split, ';', '') != '')),m.match_date,'z' ) AS live, DATE_SUB(m.match_date, INTERVAL '90' MINUTE) AS meetingtime, NOW() AS local_time, r.*, p.name AS pname, p.current_round, p.id AS project_id, p.timezone, p.game_parts, p.ordering, IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname, pg.name AS pg_name, pt1.division_id, pg.short_name AS pg_shortname FROM jos_joomleague_match m INNER JOIN jos_joomleague_round r ON m.round_id = r.id INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = m.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = m.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id INNER JOIN jos_joomleague_project p ON pt1.project_id = p.id LEFT JOIN jos_joomleague_match_referee AS mref ON m.id = mref.match_id LEFT JOIN jos_joomleague_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN jos_joomleague_person AS person ON person.id = pref.person_id AND person.published = 1 AND pref.published = 1 LEFT JOIN jos_joomleague_playground AS pg ON pg.id = m.playground_id WHERE ( (( (pt1.team_id IN (2) OR pt2.team_id IN (2)) AND (pt1.project_id = 39 OR pt2.project_id = 39) )) AND p.published = 1 AND m.published = 1 AND (m.match_date > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 3 MONTH)) AND (pt1.project_id IN (39) OR pt2.project_id IN (39)) ) GROUP BY m.id ORDER by match_date DESC LIMIT 1
SHOW FULL COLUMNS FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_lists` WHERE `published` = 1
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT id, rules FROM `jos_viewlevels`
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE cc.published = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 10:24:16' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:24:16' ) AND (cc.id = 8 OR cc.id = 9 OR cc.id = 12 OR cc.id = 13 OR cc.id = 16 OR cc.id = 17 OR cc.id = 19 OR cc.id = 23 OR cc.id = 31 OR cc.id = 56 OR cc.id = 10 OR cc.id = 11 OR cc.id = 67 OR cc.id = 15 OR cc.id = 26 OR cc.id = 27 OR cc.id = 48 OR cc.id = 14 OR cc.id = 28 OR cc.id = 51 OR cc.id = 55 OR cc.id = 59 OR cc.id = 21 OR cc.id = 22 OR cc.id = 47 OR cc.id = 61 OR cc.id = 18 OR cc.id = 29 OR cc.id = 30 OR cc.id = 52 OR cc.id = 53 OR cc.id = 64 OR cc.id = 65 OR cc.id = 69 OR cc.id = 70 OR cc.id = 71 OR cc.id = 72 OR cc.id = 24 OR cc.id = 37 OR cc.id = 38 OR cc.id = 39 OR cc.id = 40 OR cc.id = 41 OR cc.id = 42 OR cc.id = 43 OR cc.id = 46 OR cc.id = 32 OR cc.id = 33 OR cc.id = 44 OR cc.id = 45 OR cc.id = 54 OR cc.id = 57 OR cc.id = 62 OR cc.id = 63 OR cc.id = 66 OR cc.id = 73 OR cc.id = 74 OR cc.id = 49 OR cc.id = 50 OR cc.id = 58 OR cc.id = 60 OR cc.id = 68 OR cc.id = 25 OR cc.id = 34 OR cc.id = 35 OR cc.id = 36) AND a.access <= 1 AND cc.access <= 1 AND DATEDIFF('2025-12-22 10:24:16', a.created) < 30 AND a.state = 1 ORDER BY a.id DESC, a.modified ASC LIMIT 0, 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE a.id IN (12,2511,2506,2475,2470,2174,871,692,1109) AND a.access <= 1 AND cc.access <= 1 ORDER BY case a.id when '12' then '1' when '2511' then '2' when '2506' then '3' when '2475' then '4' when '2470' then '5' when '2174' then '6' when '871' then '7' when '692' then '8' when '1109' then '9' end
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=16 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT username FROM jos_users WHERE id = 849
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=23 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=54 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT username FROM jos_users WHERE id = 849
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=56 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT username FROM jos_users WHERE id = 849
SELECT guest, usertype, client_id FROM jos_session WHERE client_id = 0
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (49) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 10:24:16') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 10:24:16') ORDER BY a.created DESC LIMIT 0, 1
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') ORDER BY c.date DESC LIMIT 0, 4
SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') GROUP BY o.id, o.title, o.link ORDER BY commentsCount DESC, c.date DESC LIMIT 0, 5
select name, value from jos_extrawatch_config
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.216.57' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.216.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.*%' limit 1
update jos_extrawatch_uri2title set count = count+1, timestamp = '1766399062' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0') limit 1
update jos_extrawatch_uri2title set title = 'Чудесен празник, Локомотив - Нефтохимик 2:0' where id = '2550088'
select id, username from jos_extrawatch where ip = '216.73.216.57' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766399062', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0', 'Чудесен празник, Локомотив - Нефтохимик 2:0')
select id from jos_extrawatch_uri where fk = '900214' and `timestamp` = '1766399062' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0' and `title` LIKE 'Чудесен празник, Локомотив - Нефтохимик 2:0'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'Itemid', '153', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'catid', '26', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'id', '1830', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.57' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.57' and date = '20444')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20444')
select ip, country from jos_extrawatch where (ip = '216.73.216.57' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718137 >= start AND 3628718137 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.57'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:27;s:19:\"session.timer.start\";i:1766399004;s:18:\"session.timer.last\";i:1766399055;s:17:\"session.timer.now\";i:1766399056;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:22:{s:40:\"3418dfd32357b9f46d21d867e463e5e269e10076\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/360-денят-на-дербито\";s:6:\"expiry\";i:1766399005;}s:40:\"b0d63332b02706de8d4133ea719a14bf73dfdf0b\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/393-резултати-на-отборите-от-дюш-на-локомотив-23-24-май-2014-г\";s:6:\"expiry\";i:1766399008;}s:40:\"a7479597fd72b8803079f3f74eb3a56f662f5512\";O:8:\"stdClass\":2:{s:4:\"link\";s:239:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/390-резултати,-награждаване-и-галерия-на-турнира-никола-котков\";s:6:\"expiry\";i:1766399008;}s:40:\"a536b8cca5bf4811afe4cf8bbc7d86f89b52a4be\";O:8:\"stdClass\":2:{s:4:\"link\";s:225:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/389-жребий-за-набори-95-и-97-за-баражите-за-елитните-групи\";s:6:\"expiry\";i:1766399008;}s:40:\"189051820df04a6e55ec97534effd40bd0c94cfd\";O:8:\"stdClass\":2:{s:4:\"link\";s:233:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/388-резултати-и-галерия-от-срещите-на-турнира-никола-котков\";s:6:\"expiry\";i:1766399008;}s:40:\"02ff18d152c1d9f27c5a83d1824fe432420c8af7\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/387-турнирът-никола-котков-започва-утре\";s:6:\"expiry\";i:1766399008;}s:40:\"d460c4dea14dc867b83920919c2d11cedfa0a31a\";O:8:\"stdClass\":2:{s:4:\"link\";s:252:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/386-момчетата-от-набори-95-и-97-продължават-в-баражите-за-елитните-групи\";s:6:\"expiry\";i:1766399008;}s:40:\"e078e44bcd343e6ffdbb1145677e450146b91266\";O:8:\"stdClass\":2:{s:4:\"link\";s:232:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/351-резултати-на-отборите-от-дюш-на-локомотив-11-13-април-2014-г\";s:6:\"expiry\";i:1766399008;}s:40:\"0e64e189c63ac6d51c2a8b764337963e51eed7bd\";O:8:\"stdClass\":2:{s:4:\"link\";s:216:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/1582-big5-николай-гигов-дал-над-400-хиляди-лева-на-бсп-заради-дълговете-на-„дума“\";s:6:\"expiry\";i:1766399012;}s:40:\"a0adcda7b0511fedb0b02ea83bc4a4eb62fab7be\";O:8:\"stdClass\":2:{s:4:\"link\";s:223:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1665-видео-обзор-на-всички-мачове-от-27-мия-кръг-на-впл\";s:6:\"expiry\";i:1766399013;}s:40:\"f279b7e955fb4ac186ad1e98a5d4fac631408208\";O:8:\"stdClass\":2:{s:4:\"link\";s:205:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/321-програмата-на-локомотив-пролет-2014\";s:6:\"expiry\";i:1766399021;}s:40:\"8ab41640b7955358d720806b29e04050839ad817\";O:8:\"stdClass\":2:{s:4:\"link\";s:173:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/лека-атлетика/2974-сребърен-медал-за-лозан-димитров\";s:6:\"expiry\";i:1766399024;}s:40:\"b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2528-генерално-класиране-при-юношите-младша,-зона-софия\";s:6:\"expiry\";i:1766399026;}s:40:\"267c2edc4dfc3bb5d2c827285416eaadb7752788\";O:8:\"stdClass\":2:{s:4:\"link\";s:267:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2523-локомотив-софия-е-номер-едно-в-столичното-първенство-при-юношите-младша\";s:6:\"expiry\";i:1766399026;}s:40:\"368bd5b539db3a9c4e3eb56d338fbdc37ce88522\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2408-таланти-от-локо-сф-ни-напомниха-най-важното-е-да-бъдем-хора-снимки\";s:6:\"expiry\";i:1766399026;}s:40:\"85de86eca22347586e823a9055509b122691a0c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:214:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2394-набор-2008-и-2009-на-купа-софия,-2003-и-нова-победа\";s:6:\"expiry\";i:1766399026;}s:40:\"d94a96d6bfeeee880667853724c273610b99e403\";O:8:\"stdClass\":2:{s:4:\"link\";s:287:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2391-набор-2003-на-локомотив-продължава-с-отличното-представяне-в-предсезонните-контроли\";s:6:\"expiry\";i:1766399026;}s:40:\"e9efa77d6384ef2ebf808a4b904bd7cca91363c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2348-тим-от-серия-а-прати-официална-оферта-за\";s:6:\"expiry\";i:1766399026;}s:40:\"c27ac076a2d81e81cd9f68d4160349a217d16f21\";O:8:\"stdClass\":2:{s:4:\"link\";s:239:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/1758-достойно-предстваяне-на-децата-на-локомотив-на-готия-къп\";s:6:\"expiry\";i:1766399026;}s:40:\"8baeb4e692f8d3b1c0a2248af304bffc170d9574\";O:8:\"stdClass\":2:{s:4:\"link\";s:211:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/996-упътване-и-транспорт-до-игрище-чепинци-преди-мача-с-левски\";s:6:\"expiry\";i:1766399034;}s:40:\"253e738a99b2102c2890c707a299620a424cc98a\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/698-респект\";s:6:\"expiry\";i:1766399054;}s:40:\"eb3c12f6be81836d3faf5e0a739b31d477f48a24\";O:8:\"stdClass\":2:{s:4:\"link\";s:193:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0\";s:6:\"expiry\";i:1766399062;}}s:13:\"session.token\";s:32:\"8f329c32c3239c143d547fd92f6022f4\";s:19:\"com_mailto.formtime\";i:1766399023;}' , `time` = '1766399063' WHERE `session_id` = 'a32e0f09e9a92befb9c4b3658dc39a71'

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

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

132 × SELECT id FROM jos_categories
9 × SELECT username FROM jos_users
7 × 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 ('12282166', 'catid', '26', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'view', 'article', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'id', '1830', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', '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:27;s:19:\"session.timer.start\";i:1766399004;s:18:\"session.timer.last\";i:1766399055;s:17:\"session.timer.now\";i:1766399056;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:22:{s:40:\"3418dfd32357b9f46d21d867e463e5e269e10076\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/360-денят-на-дербито\";s:6:\"expiry\";i:1766399005;}s:40:\"b0d63332b02706de8d4133ea719a14bf73dfdf0b\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/393-резултати-на-отборите-от-дюш-на-локомотив-23-24-май-2014-г\";s:6:\"expiry\";i:1766399008;}s:40:\"a7479597fd72b8803079f3f74eb3a56f662f5512\";O:8:\"stdClass\":2:{s:4:\"link\";s:239:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/390-резултати,-награждаване-и-галерия-на-турнира-никола-котков\";s:6:\"expiry\";i:1766399008;}s:40:\"a536b8cca5bf4811afe4cf8bbc7d86f89b52a4be\";O:8:\"stdClass\":2:{s:4:\"link\";s:225:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/389-жребий-за-набори-95-и-97-за-баражите-за-елитните-групи\";s:6:\"expiry\";i:1766399008;}s:40:\"189051820df04a6e55ec97534effd40bd0c94cfd\";O:8:\"stdClass\":2:{s:4:\"link\";s:233:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/388-резултати-и-галерия-от-срещите-на-турнира-никола-котков\";s:6:\"expiry\";i:1766399008;}s:40:\"02ff18d152c1d9f27c5a83d1824fe432420c8af7\";O:8:\"stdClass\":2:{s:4:\"link\";s:197:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/387-турнирът-никола-котков-започва-утре\";s:6:\"expiry\";i:1766399008;}s:40:\"d460c4dea14dc867b83920919c2d11cedfa0a31a\";O:8:\"stdClass\":2:{s:4:\"link\";s:252:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/386-момчетата-от-набори-95-и-97-продължават-в-баражите-за-елитните-групи\";s:6:\"expiry\";i:1766399008;}s:40:\"e078e44bcd343e6ffdbb1145677e450146b91266\";O:8:\"stdClass\":2:{s:4:\"link\";s:232:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/351-резултати-на-отборите-от-дюш-на-локомотив-11-13-април-2014-г\";s:6:\"expiry\";i:1766399008;}s:40:\"0e64e189c63ac6d51c2a8b764337963e51eed7bd\";O:8:\"stdClass\":2:{s:4:\"link\";s:216:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/1582-big5-николай-гигов-дал-над-400-хиляди-лева-на-бсп-заради-дълговете-на-„дума“\";s:6:\"expiry\";i:1766399012;}s:40:\"a0adcda7b0511fedb0b02ea83bc4a4eb62fab7be\";O:8:\"stdClass\":2:{s:4:\"link\";s:223:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1665-видео-обзор-на-всички-мачове-от-27-мия-кръг-на-впл\";s:6:\"expiry\";i:1766399013;}s:40:\"f279b7e955fb4ac186ad1e98a5d4fac631408208\";O:8:\"stdClass\":2:{s:4:\"link\";s:205:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/321-програмата-на-локомотив-пролет-2014\";s:6:\"expiry\";i:1766399021;}s:40:\"8ab41640b7955358d720806b29e04050839ad817\";O:8:\"stdClass\":2:{s:4:\"link\";s:173:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/лека-атлетика/2974-сребърен-медал-за-лозан-димитров\";s:6:\"expiry\";i:1766399024;}s:40:\"b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f\";O:8:\"stdClass\":2:{s:4:\"link\";s:228:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2528-генерално-класиране-при-юношите-младша,-зона-софия\";s:6:\"expiry\";i:1766399026;}s:40:\"267c2edc4dfc3bb5d2c827285416eaadb7752788\";O:8:\"stdClass\":2:{s:4:\"link\";s:267:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2523-локомотив-софия-е-номер-едно-в-столичното-първенство-при-юношите-младша\";s:6:\"expiry\";i:1766399026;}s:40:\"368bd5b539db3a9c4e3eb56d338fbdc37ce88522\";O:8:\"stdClass\":2:{s:4:\"link\";s:255:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2408-таланти-от-локо-сф-ни-напомниха-най-важното-е-да-бъдем-хора-снимки\";s:6:\"expiry\";i:1766399026;}s:40:\"85de86eca22347586e823a9055509b122691a0c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:214:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2394-набор-2008-и-2009-на-купа-софия,-2003-и-нова-победа\";s:6:\"expiry\";i:1766399026;}s:40:\"d94a96d6bfeeee880667853724c273610b99e403\";O:8:\"stdClass\":2:{s:4:\"link\";s:287:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2391-набор-2003-на-локомотив-продължава-с-отличното-представяне-в-предсезонните-контроли\";s:6:\"expiry\";i:1766399026;}s:40:\"e9efa77d6384ef2ebf808a4b904bd7cca91363c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/2348-тим-от-серия-а-прати-официална-оферта-за\";s:6:\"expiry\";i:1766399026;}s:40:\"c27ac076a2d81e81cd9f68d4160349a217d16f21\";O:8:\"stdClass\":2:{s:4:\"link\";s:239:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/набор-2003/1758-достойно-предстваяне-на-децата-на-локомотив-на-готия-къп\";s:6:\"expiry\";i:1766399026;}s:40:\"8baeb4e692f8d3b1c0a2248af304bffc170d9574\";O:8:\"stdClass\":2:{s:4:\"link\";s:211:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/996-упътване-и-транспорт-до-игрище-чепинци-преди-мача-с-левски\";s:6:\"expiry\";i:1766399034;}s:40:\"253e738a99b2102c2890c707a299620a424cc98a\";O:8:\"stdClass\":2:{s:4:\"link\";s:95:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/698-респект\";s:6:\"expiry\";i:1766399054;}s:40:\"eb3c12f6be81836d3faf5e0a739b31d477f48a24\";O:8:\"stdClass\":2:{s:4:\"link\";s:193:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0\";s:6:\"expiry\";i:1766399062;}}s:13:\"session.token\";s:32:\"8f329c32c3239c143d547fd92f6022f4\";s:19:\"com_mailto.formtime\";i:1766399023;}' , `time` = '1766399063'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12282166', 'Itemid', '153', 2
1 × SHOW FULL COLUMNS FROM `jos_jnews_xonfig
1 × UPDATE jos_content SET hits = hits + 1
1 × update jos_extrawatch_uri2title set count = count+1, timestamp = '1766399062'
1 × update jos_extrawatch_uri2title set title = 'Чудесен празник, Локомотив - Нефтохимик 2:0'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766399062', '/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1830-чудесен-празник,-локомотив-нефтохимик-2-0', 'Чудесен празник, Локомотив - Нефтохимик 2:0'
1 × SHOW FULL COLUMNS FROM `jos_assets

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

3418dfd32357b9f46d21d867e463e5e269e10076

b0d63332b02706de8d4133ea719a14bf73dfdf0b

a7479597fd72b8803079f3f74eb3a56f662f5512

a536b8cca5bf4811afe4cf8bbc7d86f89b52a4be

189051820df04a6e55ec97534effd40bd0c94cfd

02ff18d152c1d9f27c5a83d1824fe432420c8af7

d460c4dea14dc867b83920919c2d11cedfa0a31a

e078e44bcd343e6ffdbb1145677e450146b91266

0e64e189c63ac6d51c2a8b764337963e51eed7bd

a0adcda7b0511fedb0b02ea83bc4a4eb62fab7be

f279b7e955fb4ac186ad1e98a5d4fac631408208

8ab41640b7955358d720806b29e04050839ad817

b5d0e70bfd8fa010af9f8ac9329f7f92c30f565f

267c2edc4dfc3bb5d2c827285416eaadb7752788

368bd5b539db3a9c4e3eb56d338fbdc37ce88522

85de86eca22347586e823a9055509b122691a0c2

d94a96d6bfeeee880667853724c273610b99e403

e9efa77d6384ef2ebf808a4b904bd7cca91363c2

c27ac076a2d81e81cd9f68d4160349a217d16f21

8baeb4e692f8d3b1c0a2248af304bffc170d9574

253e738a99b2102c2890c707a299620a424cc98a

eb3c12f6be81836d3faf5e0a739b31d477f48a24

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

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

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

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

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

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

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