Кметът на Негован: "При Гигов локомотивските корени бяха отрязани"

вкл. 06 Ноември 2015.

Поредният гост в рубриката от интервюта за lokosf.info e кметът село Негован и президент на Сокол, 50 годишният Валентин Павлов.

- Г-н Павлов, в неделя приемате Локомотив в Негован. Каква е настройката за този мач?
- Този двубой се чака с огромен интерес. Село Негован е локомотивски район, както и съседните ни села. Не мисля, че ще има интрига в мача - по-важно е хората да са доволни, че виждат Локомотив на наша територия.

- Има ли амбиции и цели отбора през сезона?
- За конкретни цели не може да се говори. Идеята е да се развива футбола, в селото да се спортува масово и ние разчитаме на наши местни момчета. Много рядко разчитаме на чужди футболисти. Росен Йорданов, който вече е голмайстор на Локомотив, е наше момче и в неделя ще играе срещу брат си, който му е близнак. Имаме и още 2 двойки близнаци в отбора. Радвам се за Росен и следя изявите му във всеки мач на Локомотив.

- За разлика от повечето игрища на отборите от тази група, вашият терен се води като един от най-добрите в нея. Как успявате да го поддържате и да издържате отбора?
- Предимно на доброволни начела. А, относно терена, цялото село има заслуга за него - събират се пари от хората, които жевеят в Негован и благодарение на всички имаме един хубав стадион.

- Като следите мачовете на Локомотив не ви ли се струва абсурдно отборът да играе в тази група?
- Принципно е така, но аз гледам от положителната гледна точка. Сега се дава път на младите, което е бъдещето на Локомотив. При Гигов всички знаем как се работеше и локомотивските корени бяха отрязани. Тогава се взимаха много чужденци и хора, които не милееха за този клуб. Силно се надявам Локомотив да успее да премине бързо през "В" и "Б" група и да се завърне скоро в елита!

Сокол (Негован) е създаден през 1927 година, като футбол в селото продължава да има до 1990 година. От 2005 година клубът е възрден отново. Цветовете на екипите им са жълто-черни.

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

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

Коментари

0 #1 Pride 06-11-2015 19:27

Хубаво интервю : :-)

Цитиране

Обнови списъка с коментари
RSS на коментарите по тази тема

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

5bba1a66aa2ebfe6a105766b10c141abfe81c279

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

93dc1f3005384e8524bb0c75aa880a3710c2c386

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

385fb8a13d3ca6b82fc4b0be73bb692151aab715

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1739-хебър-локомотив-03-07-2017-18-00

cbfc9f534303127f94140586f20dabd3dc77062b

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

6911552bc400096f537a2dd4e7f2c9d1d5558513

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

237833e3fc05cf50b0c33ba656b61ea81d0434bf

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1359-резултати-дюш-29-31-10-2016

64708b64942b5c166ff225b56e67e6da61101503

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

9def783b3798b561460fa62afb8944cb68e52386

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

3dba39737c45f451dd8d496cb519815d8e2e64b3

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

91d5d59c8f799e44be4346169f06a17898af69fe

link ⇒ https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1580-резултати-дюш-18-20-03-2017

e164906e4e90c55dc9071f292504d0a08b9efff6

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

5a48b8f08d90d961b1c59c1f374d1ba7fd042806

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

cb57981e9943dc959f454b3bad635c81f7a71aae

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

9e4dc28c9311c64013923f53faba8a6fab551ec1

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

918a0a6edcd07444d2c93dba44e4d216757045db

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

d155eb53f8127514ff325d15a52f68031c06245f

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

d0feaac67aea52e5637da10f25a49153e721bd76

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

45229fffbecbb40e27a657c9b57326f43aff95f7

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

session.token ⇒ 03531cdee8c5748991af18ad5112fc36

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

Application 0.067 seconds (+0.067); 3.86 MB (+3.218) - afterInitialise

Application 0.124 seconds (+0.057); 6.60 MB (+2.736) - afterRoute

Application 0.316 seconds (+0.192); 10.50 MB (+3.900) - afterDispatch

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

Application 0.340 seconds (+0.008); 11.00 MB (+0.043) - afterRenderModule mod_search (Търси)

Application 0.342 seconds (+0.002); 10.99 MB (-0.006) - beforeRenderModule mod_custom (LOGO)

Application 0.347 seconds (+0.005); 11.00 MB (+0.009) - afterRenderModule mod_custom (LOGO)

Application 0.350 seconds (+0.003); 11.00 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)

Application 0.436 seconds (+0.086); 12.96 MB (+1.958) - afterRenderModule mod_menu (Main Menu)

Application 0.462 seconds (+0.026); 13.22 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.467 seconds (+0.005); 13.25 MB (+0.029) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.471 seconds (+0.004); 13.26 MB (+0.017) - beforeRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.557 seconds (+0.087); 13.64 MB (+0.381) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.559 seconds (+0.002); 13.53 MB (-0.111) - beforeRenderModule mod_menu (Submenu)

Application 0.566 seconds (+0.007); 13.54 MB (+0.010) - afterRenderModule mod_menu (Submenu)

Application 0.566 seconds (+0.000); 13.54 MB (-0.007) - beforeRenderModule mod_custom (ВХОД_html)

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

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

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

Application 0.571 seconds (+0.000); 13.55 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.571 seconds (+0.001); 13.55 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

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

Application 0.602 seconds (+0.030); 13.99 MB (+0.407) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.602 seconds (+0.000); 13.95 MB (-0.039) - beforeRenderModule mod_custom (razvitie)

Application 0.603 seconds (+0.001); 13.95 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 0.643 seconds (+0.040); 16.70 MB (+2.742) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

Application 0.649 seconds (+0.005); 16.75 MB (+0.076) - beforeRenderModule mod_aidanews2 (НАЙ-НОВИ)

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

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

Application 0.819 seconds (+0.082); 17.36 MB (+0.124) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

Application 0.833 seconds (+0.014); 17.33 MB (+0.090) - afterRenderModule mod_whosonline (Кой е тук)

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

Application 0.880 seconds (+0.029); 17.69 MB (+0.331) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.881 seconds (+0.001); 17.73 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 0.890 seconds (+0.009); 17.75 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 0.926 seconds (+0.035); 17.88 MB (+0.136) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 0.965 seconds (+0.039); 17.90 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 0.968 seconds (+0.003); 17.86 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.091 seconds (+0.123); 20.13 MB (+2.265) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.127 seconds (+0.036); 20.15 MB (+0.021) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = '38c0dbbafb1b70d40f59fd205316c122'
DELETE FROM `jos_session` WHERE `time` < '1787390727'
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=830 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 = 830
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 = 830 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-22 10:25:27') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 10:25:27') 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=61 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.830') 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 = 61 AND a.state = 1 AND a.access = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-22 10:25:27') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-22 10:25:27') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '830' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 830 AND c.object_group = 'com_content' AND c.published = 1
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner FROM jos_jcomments AS c LEFT JOIN jos_jcomments_votes AS v ON c.id = v.commentid AND v.userid = 0 AND v.ip = '216.73.217.173' WHERE c.object_id = 830 AND c.object_group = 'com_content' AND c.published = 1 ORDER BY c.date DESC LIMIT 0, 10
UPDATE jos_content SET hits = hits + 1 WHERE id = 830
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-22 10:25:27') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-22 10:25:27') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 314 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` < '1787390727'
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 = 830
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 != 830 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 "%,кмет,%" 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-08-22 10:25:27' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 10:25:27' ) 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=22 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=12 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=28 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT 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=14 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=25 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT id, fav_team FROM jos_joomleague_project p WHERE fav_team != '' AND id IN (39)
SELECT m.*,m.id as match_id, t1.id team1_id, t2.id team2_id, DATE(m.match_date) AS match_date_notime, m.match_date AS match_date, NOW() AS currenttime, IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) AS totaltime, IF ( (match_date > UTC_TIMESTAMP() AND m.team1_result IS NULL) AND ((m.team1_result_split IS NULL) OR TRIM(REPLACE(m.team1_result_split, ';', '')) = ''),m.match_date, 'z' ) AS upcoming, IF ( (m.team1_result IS NOT NULL OR m.match_date < UTC_TIMESTAMP()),m.match_date, 0 ) AS alreadyplayed, IF ( ( ( DATE_ADD(m.match_date, INTERVAL IF ( m.match_result_type > 0, (p.game_regular_time+(p.game_parts * p.halftime)-p.halftime) + p.add_time, p.game_regular_time+(p.game_parts * p.halftime)-p.halftime ) MINUTE ) > UTC_TIMESTAMP() ) AND (m.match_date < UTC_TIMESTAMP() ) AND (m.team1_result IS NULL) ),m.match_date, 'z' ) AS actplaying, IF ( ((m.team1_result IS NULL) AND (m.team1_result_split IS NOT NULL) AND TRIM(REPLACE(m.team1_result_split, ';', '') != '')),m.match_date,'z' ) AS live, DATE_SUB(m.match_date, INTERVAL '90' MINUTE) AS meetingtime, NOW() AS local_time, r.*, p.name AS pname, p.current_round, p.id AS project_id, p.timezone, p.game_parts, p.ordering, IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname, pg.name AS pg_name, pt1.division_id, pg.short_name AS pg_shortname FROM jos_joomleague_match m INNER JOIN jos_joomleague_round r ON m.round_id = r.id INNER JOIN jos_joomleague_project_team pt1 ON pt1.id = m.projectteam1_id INNER JOIN jos_joomleague_team t1 ON t1.id = pt1.team_id INNER JOIN jos_joomleague_project_team pt2 ON pt2.id = m.projectteam2_id INNER JOIN jos_joomleague_team t2 ON t2.id = pt2.team_id INNER JOIN jos_joomleague_project p ON pt1.project_id = p.id LEFT JOIN jos_joomleague_match_referee AS mref ON m.id = mref.match_id LEFT JOIN jos_joomleague_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN jos_joomleague_person AS person ON person.id = pref.person_id AND person.published = 1 AND pref.published = 1 LEFT JOIN jos_joomleague_playground AS pg ON pg.id = m.playground_id WHERE ( (( (pt1.team_id IN (2) OR pt2.team_id IN (2)) AND (pt1.project_id = 39 OR pt2.project_id = 39) )) AND p.published = 1 AND m.published = 1 AND (m.match_date > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 3 MONTH)) AND (pt1.project_id IN (39) OR pt2.project_id IN (39)) ) GROUP BY m.id ORDER by match_date DESC LIMIT 1
SHOW FULL COLUMNS FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_xonfig`
SELECT * FROM `jos_jnews_lists` WHERE `published` = 1
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 8
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 9
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 12
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 13
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 16
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 17
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 19
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 23
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 31
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 56
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 10
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 11
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 67
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 15
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 26
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 27
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 48
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 14
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 28
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 51
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 55
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 59
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 21
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 22
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 47
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 61
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 18
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 29
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 30
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 52
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 53
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 64
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 65
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 69
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 70
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 71
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 72
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 24
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 37
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 38
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 39
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 40
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 41
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 42
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 43
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 46
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 32
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 33
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 44
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 45
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 54
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 57
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 62
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 63
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 66
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 73
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 74
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 49
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 50
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 58
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 60
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 68
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 25
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 34
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 35
SELECT id FROM jos_categories WHERE extension = "com_content" AND parent_id = 36
SELECT id, rules FROM `jos_viewlevels`
SELECT a.*,r.rating_count,r.rating_sum,cc.params AS catparams,cc.title AS cattle,cc.alias AS category_alias FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_content_rating AS r ON r.content_id = a.id WHERE cc.published = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-22 10:25:27' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 10:25:27' ) AND (cc.id = 8 OR cc.id = 9 OR cc.id = 12 OR cc.id = 13 OR cc.id = 16 OR cc.id = 17 OR cc.id = 19 OR cc.id = 23 OR cc.id = 31 OR cc.id = 56 OR cc.id = 10 OR cc.id = 11 OR cc.id = 67 OR cc.id = 15 OR cc.id = 26 OR cc.id = 27 OR cc.id = 48 OR cc.id = 14 OR cc.id = 28 OR cc.id = 51 OR cc.id = 55 OR cc.id = 59 OR cc.id = 21 OR cc.id = 22 OR cc.id = 47 OR cc.id = 61 OR cc.id = 18 OR cc.id = 29 OR cc.id = 30 OR cc.id = 52 OR cc.id = 53 OR cc.id = 64 OR cc.id = 65 OR cc.id = 69 OR cc.id = 70 OR cc.id = 71 OR cc.id = 72 OR cc.id = 24 OR cc.id = 37 OR cc.id = 38 OR cc.id = 39 OR cc.id = 40 OR cc.id = 41 OR cc.id = 42 OR cc.id = 43 OR cc.id = 46 OR cc.id = 32 OR cc.id = 33 OR cc.id = 44 OR cc.id = 45 OR cc.id = 54 OR cc.id = 57 OR cc.id = 62 OR cc.id = 63 OR cc.id = 66 OR cc.id = 73 OR cc.id = 74 OR cc.id = 49 OR cc.id = 50 OR cc.id = 58 OR cc.id = 60 OR cc.id = 68 OR cc.id = 25 OR cc.id = 34 OR cc.id = 35 OR cc.id = 36) AND a.access <= 1 AND cc.access <= 1 AND DATEDIFF('2026-08-22 10:25:27', 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 username FROM jos_users WHERE id = 849
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 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=36 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 guest, usertype, client_id FROM jos_session WHERE client_id = 0
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (49) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-22 10:25:27') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-22 10:25:27') ORDER BY a.created DESC LIMIT 0, 1
SELECT id FROM jos_assets WHERE parent_id = 0
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') ORDER BY c.date DESC LIMIT 0, 4
SELECT o.id, o.title, o.link, COUNT(c.id) AS commentsCount, MAX(c.date) AS commentdate FROM jos_jcomments_objects AS o JOIN jos_jcomments AS c ON c.object_id = o.object_id AND c.object_group = o.object_group AND c.lang = o.lang WHERE c.published = 1 AND c.deleted = 0 AND o.link <> '' AND o.access IN (1,0) AND c.object_group in ('com_content','com_jcomments') GROUP BY o.id, o.title, o.link ORDER BY commentsCount DESC, c.date DESC LIMIT 0, 5
select name, value from jos_extrawatch_config
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.217.173' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip = '216.73.217.173' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.217.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.73.*%' limit 1
select count(ip) as count from jos_extrawatch_blocked where ip like '216.*%' limit 1
update jos_extrawatch_uri2title set count = count+1, timestamp = '1787394328' where (`uri` = '/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани') limit 1
update jos_extrawatch_uri2title set title = 'Кметът на Негован: "При Гигов локомотивските корени бяха отрязани"' where id = '2549527'
select id, username from jos_extrawatch where ip = '216.73.217.173' limit 1
insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '1043294', '1787394328', '/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани', 'Кметът на Негован: \"При Гигов локомотивските корени бяха отрязани\"')
select id from jos_extrawatch_uri where fk = '1043294' and `timestamp` = '1787394328' and `uri` LIKE '/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани' and `title` LIKE 'Кметът на Негован: \"При Гигов локомотивските корени бяха отрязани\"'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'Itemid', '314', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'catid', '61', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'id', '830', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.217.173' and date = '20687')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.217.173' and date = '20687')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20687')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20687')
select ip, country from jos_extrawatch where (ip = '216.73.217.173' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718509 >= start AND 3628718509 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.217.173'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1787394294;s:18:\"session.timer.last\";i:1787394327;s:17:\"session.timer.now\";i:1787394327;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:18:{s:40:\"5bba1a66aa2ebfe6a105766b10c141abfe81c279\";O:8:\"stdClass\":2:{s:4:\"link\";s:204:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1282-влакче-на-радостта-за-червено-черните\";s:6:\"expiry\";i:1787394294;}s:40:\"93dc1f3005384e8524bb0c75aa880a3710c2c386\";O:8:\"stdClass\":2:{s:4:\"link\";s:201:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2167-вальо-николов-локомотив-ще-продължи-да-се-бори-видео\";s:6:\"expiry\";i:1787394297;}s:40:\"385fb8a13d3ca6b82fc4b0be73bb692151aab715\";O:8:\"stdClass\":2:{s:4:\"link\";s:165:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1739-хебър-локомотив-03-07-2017-18-00\";s:6:\"expiry\";i:1787394300;}s:40:\"cbfc9f534303127f94140586f20dabd3dc77062b\";O:8:\"stdClass\":2:{s:4:\"link\";s:215:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1815-мокра-селска-поръчка-със-съдии-ли-ще-спира-локомотив\";s:6:\"expiry\";i:1787394301;}s:40:\"6911552bc400096f537a2dd4e7f2c9d1d5558513\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1385-резултати-дюш-11-14-11-2016\";s:6:\"expiry\";i:1787394304;}s:40:\"237833e3fc05cf50b0c33ba656b61ea81d0434bf\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1359-резултати-дюш-29-31-10-2016\";s:6:\"expiry\";i:1787394306;}s:40:\"64708b64942b5c166ff225b56e67e6da61101503\";O:8:\"stdClass\":2:{s:4:\"link\";s:242:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2216-галерия-почетохме-великия-никола-котков\";s:6:\"expiry\";i:1787394309;}s:40:\"9def783b3798b561460fa62afb8944cb68e52386\";O:8:\"stdClass\":2:{s:4:\"link\";s:206:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-с-фенове-на-локомотив-софия/733-автобусът-на-касев-надраскан-и-със-счупено-стъкло\";s:6:\"expiry\";i:1787394312;}s:40:\"3dba39737c45f451dd8d496cb519815d8e2e64b3\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2421-николови-пред-камерата-на-“витоша-нюз”\";s:6:\"expiry\";i:1787394314;}s:40:\"91d5d59c8f799e44be4346169f06a17898af69fe\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1580-резултати-дюш-18-20-03-2017\";s:6:\"expiry\";i:1787394315;}s:40:\"e164906e4e90c55dc9071f292504d0a08b9efff6\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/1511-кайо-караджинов-гигов-съсипа-локомотив-в-к-шоу\";s:6:\"expiry\";i:1787394316;}s:40:\"5a48b8f08d90d961b1c59c1f374d1ba7fd042806\";O:8:\"stdClass\":2:{s:4:\"link\";s:200:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2128-железни-горди-юнаци-царско-село-локомотив-1-2\";s:6:\"expiry\";i:1787394318;}s:40:\"cb57981e9943dc959f454b3bad635c81f7a71aae\";O:8:\"stdClass\":2:{s:4:\"link\";s:191:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1368-предавахме-на-живо-созопол-локомотив-0-0\";s:6:\"expiry\";i:1787394319;}s:40:\"9e4dc28c9311c64013923f53faba8a6fab551ec1\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/372-алекс-василев-стана-европейски-шампион-по-самбо\";s:6:\"expiry\";i:1787394322;}s:40:\"918a0a6edcd07444d2c93dba44e4d216757045db\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2347-иконата-никола-котков\";s:6:\"expiry\";i:1787394323;}s:40:\"d155eb53f8127514ff325d15a52f68031c06245f\";O:8:\"stdClass\":2:{s:4:\"link\";s:229:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2320-бфвт-обяви-състезателния-календар-за-новия-сезон\";s:6:\"expiry\";i:1787394324;}s:40:\"d0feaac67aea52e5637da10f25a49153e721bd76\";O:8:\"stdClass\":2:{s:4:\"link\";s:209:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/художествена-гимнастика/2443-момичетата-от-скхг-локомотив-през-март-2019\";s:6:\"expiry\";i:1787394326;}s:40:\"45229fffbecbb40e27a657c9b57326f43aff95f7\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани\";s:6:\"expiry\";i:1787394327;}}s:13:\"session.token\";s:32:\"03531cdee8c5748991af18ad5112fc36\";s:19:\"com_mailto.formtime\";i:1787394327;}' , `time` = '1787394328' WHERE `session_id` = '38c0dbbafb1b70d40f59fd205316c122'

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

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

132 × SELECT id FROM jos_categories
10 × 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 * FROM jos_languages
1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM jos_contact_details AS contact
1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT * FROM jos_jcomments_setting
1 × SELECT folder AS type, element AS name, params FROM jos_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT alias, catid FROM jos_content
1 × SELECT a.id, a.language, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid
1 × SELECT * FROM `jos_jcomments_objects`
1 × SELECT 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 count(*) FROM jos_jcomments AS c
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted , case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner FROM jos_jcomments AS c LEFT JOIN jos_jcomments_votes AS v ON c.id = v.commentid AND v.userid = 0 AND v.ip = '216.73.217.173'
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 ('14156460', 'view', 'article', 2
1 × UPDATE `jos_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1787394294;s:18:\"session.timer.last\";i:1787394327;s:17:\"session.timer.now\";i:1787394327;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:18:{s:40:\"5bba1a66aa2ebfe6a105766b10c141abfe81c279\";O:8:\"stdClass\":2:{s:4:\"link\";s:204:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-записи-от-футболни-срещи-на-локомотив/1282-влакче-на-радостта-за-червено-черните\";s:6:\"expiry\";i:1787394294;}s:40:\"93dc1f3005384e8524bb0c75aa880a3710c2c386\";O:8:\"stdClass\":2:{s:4:\"link\";s:201:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2167-вальо-николов-локомотив-ще-продължи-да-се-бори-видео\";s:6:\"expiry\";i:1787394297;}s:40:\"385fb8a13d3ca6b82fc4b0be73bb692151aab715\";O:8:\"stdClass\":2:{s:4:\"link\";s:165:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1739-хебър-локомотив-03-07-2017-18-00\";s:6:\"expiry\";i:1787394300;}s:40:\"cbfc9f534303127f94140586f20dabd3dc77062b\";O:8:\"stdClass\":2:{s:4:\"link\";s:215:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1815-мокра-селска-поръчка-със-съдии-ли-ще-спира-локомотив\";s:6:\"expiry\";i:1787394301;}s:40:\"6911552bc400096f537a2dd4e7f2c9d1d5558513\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1385-резултати-дюш-11-14-11-2016\";s:6:\"expiry\";i:1787394304;}s:40:\"237833e3fc05cf50b0c33ba656b61ea81d0434bf\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1359-резултати-дюш-29-31-10-2016\";s:6:\"expiry\";i:1787394306;}s:40:\"64708b64942b5c166ff225b56e67e6da61101503\";O:8:\"stdClass\":2:{s:4:\"link\";s:242:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2216-галерия-почетохме-великия-никола-котков\";s:6:\"expiry\";i:1787394309;}s:40:\"9def783b3798b561460fa62afb8944cb68e52386\";O:8:\"stdClass\":2:{s:4:\"link\";s:206:\"https://lokomotiv.ntesrv.com/joomla16/видео/видео-с-фенове-на-локомотив-софия/733-автобусът-на-касев-надраскан-и-със-счупено-стъкло\";s:6:\"expiry\";i:1787394312;}s:40:\"3dba39737c45f451dd8d496cb519815d8e2e64b3\";O:8:\"stdClass\":2:{s:4:\"link\";s:241:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2421-николови-пред-камерата-на-“витоша-нюз”\";s:6:\"expiry\";i:1787394314;}s:40:\"91d5d59c8f799e44be4346169f06a17898af69fe\";O:8:\"stdClass\":2:{s:4:\"link\";s:171:\"https://lokomotiv.ntesrv.com/joomla16/детско-юношеска-школа-на-локомотив-софия/новини/1580-резултати-дюш-18-20-03-2017\";s:6:\"expiry\";i:1787394315;}s:40:\"e164906e4e90c55dc9071f292504d0a08b9efff6\";O:8:\"stdClass\":2:{s:4:\"link\";s:167:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/избрано/1511-кайо-караджинов-гигов-съсипа-локомотив-в-к-шоу\";s:6:\"expiry\";i:1787394316;}s:40:\"5a48b8f08d90d961b1c59c1f374d1ba7fd042806\";O:8:\"stdClass\":2:{s:4:\"link\";s:200:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2128-железни-горди-юнаци-царско-село-локомотив-1-2\";s:6:\"expiry\";i:1787394318;}s:40:\"cb57981e9943dc959f454b3bad635c81f7a71aae\";O:8:\"stdClass\":2:{s:4:\"link\";s:191:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/1368-предавахме-на-живо-созопол-локомотив-0-0\";s:6:\"expiry\";i:1787394319;}s:40:\"9e4dc28c9311c64013923f53faba8a6fab551ec1\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/джудо-и-самбо/372-алекс-василев-стана-европейски-шампион-по-самбо\";s:6:\"expiry\";i:1787394322;}s:40:\"918a0a6edcd07444d2c93dba44e4d216757045db\";O:8:\"stdClass\":2:{s:4:\"link\";s:208:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2347-иконата-никола-котков\";s:6:\"expiry\";i:1787394323;}s:40:\"d155eb53f8127514ff325d15a52f68031c06245f\";O:8:\"stdClass\":2:{s:4:\"link\";s:229:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/клуб-локомотив-никола-нанов/2320-бфвт-обяви-състезателния-календар-за-новия-сезон\";s:6:\"expiry\";i:1787394324;}s:40:\"d0feaac67aea52e5637da10f25a49153e721bd76\";O:8:\"stdClass\":2:{s:4:\"link\";s:209:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/художествена-гимнастика/2443-момичетата-от-скхг-локомотив-през-март-2019\";s:6:\"expiry\";i:1787394326;}s:40:\"45229fffbecbb40e27a657c9b57326f43aff95f7\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани\";s:6:\"expiry\";i:1787394327;}}s:13:\"session.token\";s:32:\"03531cdee8c5748991af18ad5112fc36\";s:19:\"com_mailto.formtime\";i:1787394327;}' , `time` = '1787394328'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'catid', '61', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'id', '830', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('14156460', 'Itemid', '314', 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 = '1787394328'
1 × update jos_extrawatch_uri2title set title = 'Кметът на Негован: "При Гигов локомотивските корени бяха отрязани"'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '1043294', '1787394328', '/joomla16/медиен-обзор/интервю/830-кметът-на-негован-при-гигов-локомотивските-корени-бяха-отрязани', 'Кметът на Негован: \"При Гигов локомотивските корени бяха отрязани\"'

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

Коментари

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

5bba1a66aa2ebfe6a105766b10c141abfe81c279

93dc1f3005384e8524bb0c75aa880a3710c2c386

385fb8a13d3ca6b82fc4b0be73bb692151aab715

cbfc9f534303127f94140586f20dabd3dc77062b

6911552bc400096f537a2dd4e7f2c9d1d5558513

237833e3fc05cf50b0c33ba656b61ea81d0434bf

64708b64942b5c166ff225b56e67e6da61101503

9def783b3798b561460fa62afb8944cb68e52386

3dba39737c45f451dd8d496cb519815d8e2e64b3

91d5d59c8f799e44be4346169f06a17898af69fe

e164906e4e90c55dc9071f292504d0a08b9efff6

5a48b8f08d90d961b1c59c1f374d1ba7fd042806

cb57981e9943dc959f454b3bad635c81f7a71aae

9e4dc28c9311c64013923f53faba8a6fab551ec1

918a0a6edcd07444d2c93dba44e4d216757045db

d155eb53f8127514ff325d15a52f68031c06245f

d0feaac67aea52e5637da10f25a49153e721bd76

45229fffbecbb40e27a657c9b57326f43aff95f7

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

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

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

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

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

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

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