Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав

вкл. 05 Юли 2019.

evgeni ziumbulev

Актуалния състав на Локомотив, може да видите кликвайки тук.

Локомотив се раздели със защитника Евгени Зюмбулев, който пристигна в отбора през зимата, съобщи официалната страница на железничарите. "По взаимно съгласие се разделихме с Евгени Зюмбулев. Пожелаваме му успех в професионален и личен план, пише на страницата на клуба.

transferi2019 lokomotiv ziumbiulev

30-годишният футболист се завърна в Локомотив след като дойде от ЦСКА 1948, където дори беше и капитан. Отбраната на тима пък вече е подсилена с две нови попълнения със същия профил. Това са Неманя Иванов, който е от българското малцинство в Сърбия, и Саша Домич. Иванов има български паспорт и няма да заема квота за чужденец. Домич може да играе и като ляв бек, а е картотекиран с хърватския паспорт, който притежава и също няма да попада в групата на чужденците.

Изненадващо от Дунав си тръгна Владислав Романов. Той беше смятан за ново попълнение на тима, но в крайна сметка не се разбра за договор.

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

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

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

2cb63fdc9d9b1473e79bca184639ddcf577a4fbd

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

172111712d7b47e6447b63138110630feab39dd2

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

b2c393bd09fe1b13adb3146e64696eeff3238a44

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

87b33fa33c8625e8bab2d3241fcde9f2acd67db1

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

44cbc0ca55e835f0aa66d6fc2f770f2912bcee57

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

37ed63a30db01635f88f762de029f711a57cf388

link ⇒ https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2943-контрола-локомотив-монтана-03-04-2021-14-30

e4647ddf4fbd65121701e635edaa701e385929b4

link ⇒ https://lokomotiv.ntesrv.com/joomla16/за-нас/контакти

d89cfb1704ae75014e2effda597c07bd1b19cd65

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

b5d934896e209c4aa7850b2a6a48ca0b3b81dc26

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

79d5f07a8aa6aa10258e1f1a7ae090a389c88b9e

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

81d92c036eb475a3535791adcd90fc0b2f1a328e

link ⇒ https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1976-нов-зимен-локомoтивски-шал

ee831dc53c29da0a08718cb4604ba68596c39041

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

9658c39579d4b4db0f95caf8d1b0e8511f77e940

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

cfeff17cfd09a7011337a96bb0026eada7b4b2f4

link ⇒ https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1471-актуални-артикули-локомотив

e73bc10b1461a76666656ae4fdaee5b4b8b023e2

link ⇒ https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1011-ново

1ea16d8429e5be2b5ba973a5134448c1b9c02d88

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

6eb169a5e9035079880c614d37ed4055f37a205b

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

842fe14725c219b2356138ad1929de489c1a2f01

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

1426a95ad267549bbc79c4aaf6e8637d7301cefd

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

session.token ⇒ e40952d9cf1b13fd1d04b47bcb4973fe

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

Application 0.065 seconds (+0.065); 3.86 MB (+3.217) - afterInitialise

Application 0.118 seconds (+0.053); 6.60 MB (+2.737) - afterRoute

Application 0.372 seconds (+0.254); 10.36 MB (+3.759) - afterDispatch

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

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

Application 0.396 seconds (+0.001); 10.86 MB (-0.005) - beforeRenderModule mod_custom (LOGO)

Application 0.399 seconds (+0.003); 10.86 MB (+0.007) - afterRenderModule mod_custom (LOGO)

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

Application 0.481 seconds (+0.081); 12.82 MB (+1.957) - afterRenderModule mod_menu (Main Menu)

Application 0.509 seconds (+0.027); 13.08 MB (+0.256) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.515 seconds (+0.007); 13.10 MB (+0.027) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Application 0.606 seconds (+0.089); 13.39 MB (+0.267) - afterRenderModule mod_fj_related_plus (Подобни публикации)

Application 0.608 seconds (+0.002); 13.32 MB (-0.072) - beforeRenderModule mod_menu (Submenu)

Application 0.615 seconds (+0.007); 13.33 MB (+0.010) - afterRenderModule mod_menu (Submenu)

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

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

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

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

Application 0.619 seconds (+0.000); 13.33 MB (-0.002) - beforeRenderModule mod_custom (Refresh_all)

Application 0.620 seconds (+0.001); 13.33 MB (+0.005) - afterRenderModule mod_custom (Refresh_all)

Application 0.620 seconds (+0.001); 13.36 MB (+0.030) - beforeRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.651 seconds (+0.031); 13.77 MB (+0.407) - afterRenderModule mod_joomleague_matches (Програма и резултати)

Application 0.651 seconds (+0.000); 13.73 MB (-0.039) - beforeRenderModule mod_custom (razvitie)

Application 0.653 seconds (+0.001); 13.74 MB (+0.005) - afterRenderModule mod_custom (razvitie)

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

Application 0.698 seconds (+0.046); 16.48 MB (+2.740) - afterRenderModule mod_jnews (Абонамент за новини)

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

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

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

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

Application 0.787 seconds (+0.083); 17.04 MB (+0.516) - afterRenderModule mod_aidanews2 (НАЙ-НОВИ)

Application 0.788 seconds (+0.000); 17.02 MB (-0.026) - beforeRenderModule mod_aidanews2 (ИЗБРАНО)

Application 0.874 seconds (+0.086); 17.21 MB (+0.186) - afterRenderModule mod_aidanews2 (ИЗБРАНО)

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

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

Application 0.886 seconds (+0.011); 17.11 MB (+0.028) - afterRenderModule mod_whosonline (Кой е тук)

Application 0.898 seconds (+0.012); 17.14 MB (+0.025) - beforeRenderModule mod_articles_news (ВИДЕО)

Application 0.918 seconds (+0.020); 17.47 MB (+0.332) - afterRenderModule mod_articles_news (ВИДЕО)

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

Application 0.919 seconds (+0.001); 17.51 MB (+0.045) - beforeRenderModule mod_fbfanbox (FACEBOOK)

Application 0.924 seconds (+0.005); 17.53 MB (+0.022) - afterRenderModule mod_fbfanbox (FACEBOOK)

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

Application 0.947 seconds (+0.024); 17.68 MB (+0.152) - afterRenderModule mod_jcomments_latest (НОВИ КОМЕНТАРИ)

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

Application 1.081 seconds (+0.134); 17.70 MB (+0.050) - afterRenderModule mod_jcomments_most_commented (НАЙ-КОМЕНТИРАНИ)

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

Application 1.084 seconds (+0.003); 17.66 MB (+0.009) - beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.196 seconds (+0.112); 19.99 MB (+2.327) - afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Application 1.227 seconds (+0.031); 20.01 MB (+0.018) - afterRender

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

SELECT `data` FROM `jos_session` WHERE `session_id` = 'd9e17056264a74493d8f774d6883c844'
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=2582 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 = 2582
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 = 2582 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-22 08:50:18') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:50:18') 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=15 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
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.2582') 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 = 15 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 08:50:18') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-22 08:50:18') ORDER BY a.created DESC
SELECT * FROM `jos_jcomments_objects` WHERE `object_id` = '2582' AND `object_group` = 'com_content' AND `lang` = 'bg-BG'
SELECT count(*) FROM jos_jcomments AS c WHERE c.object_id = 2582 AND c.object_group = 'com_content' AND c.published = 1
UPDATE jos_content SET hits = hits + 1 WHERE id = 2582
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 08:50:18') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-22 08:50:18') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 148 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 = 2582
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 != 2582 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 "%,трансфери 2019,%" OR 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 <= '2025-12-22 08:50:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:50:18' ) 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=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 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 08:50:18' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:50:18' ) 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 08:50:18', 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 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 <= '2025-12-22 08:50:18') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-22 08:50:18') 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 = '1766393419' where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав')
select id from jos_extrawatch_uri2title where (`uri` = '/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав') limit 1
update jos_extrawatch_uri2title set title = 'Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав' where id = '2538971'
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', '1766393419', '/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав', 'Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав')
select id from jos_extrawatch_uri where fk = '900214' and `timestamp` = '1766393419' and `uri` LIKE '/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав' and `title` LIKE 'Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав'
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'Itemid', '148', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'option', 'com_content', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'view', 'article', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'catid', '15', 2)
insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'id', '2582', 2)
select count(id) as count from jos_extrawatch_info where (` group` = '6' and name = '216.73.216.57' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '6' and name = '216.73.216.57' and date = '20444')
select count(id) as count from jos_extrawatch_info where (` group` = '4' and name = '4' and date = '20444')
update jos_extrawatch_info set value = value+1 where (` group` = '4' and name = '4' and date = '20444')
select ip, country from jos_extrawatch where (ip = '216.73.216.57' and country is not NULL) limit 1
SELECT country FROM jos_extrawatch_ip2c WHERE 3628718137 >= start AND 3628718137 <= end
update jos_extrawatch set country = 'us' where ip = '216.73.216.57'
select * from jos_extrawatch_goals
UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:18;s:19:\"session.timer.start\";i:1766393394;s:18:\"session.timer.last\";i:1766393417;s:17:\"session.timer.now\";i:1766393418;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:19:{s:40:\"2cb63fdc9d9b1473e79bca184639ddcf577a4fbd\";O:8:\"stdClass\":2:{s:4:\"link\";s:209:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/2627-гледайте-90-години-локомотив-филмът\";s:6:\"expiry\";i:1766393394;}s:40:\"172111712d7b47e6447b63138110630feab39dd2\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2753-локомотив-се-раздели-с-двама,-куп-треньори-отказаха\";s:6:\"expiry\";i:1766393397;}s:40:\"b2c393bd09fe1b13adb3146e64696eeff3238a44\";O:8:\"stdClass\":2:{s:4:\"link\";s:207:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2647-локомотив-be-strong-кетълбел-с-чудесно-представяне-на-сърбия-опън-4-2019\";s:6:\"expiry\";i:1766393398;}s:40:\"87b33fa33c8625e8bab2d3241fcde9f2acd67db1\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2878-6-седмичен-курс-за-начинаещи-18\";s:6:\"expiry\";i:1766393402;}s:40:\"44cbc0ca55e835f0aa66d6fc2f770f2912bcee57\";O:8:\"stdClass\":2:{s:4:\"link\";s:234:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/2586-програма-за-1-ви-кръг-на-втора-лига-по-дни-и-часове\";s:6:\"expiry\";i:1766393404;}s:40:\"37ed63a30db01635f88f762de029f711a57cf388\";O:8:\"stdClass\":2:{s:4:\"link\";s:186:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2943-контрола-локомотив-монтана-03-04-2021-14-30\";s:6:\"expiry\";i:1766393405;}s:40:\"e4647ddf4fbd65121701e635edaa701e385929b4\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/контакти\";s:6:\"expiry\";i:1766393406;}s:40:\"d89cfb1704ae75014e2effda597c07bd1b19cd65\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2632-ще-ни-липсваш\";s:6:\"expiry\";i:1766393408;}s:40:\"b5d934896e209c4aa7850b2a6a48ca0b3b81dc26\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2640-галерия-струмска-слава-локомотив-0-2\";s:6:\"expiry\";i:1766393410;}s:40:\"79d5f07a8aa6aa10258e1f1a7ae090a389c88b9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:133:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/2325-нова-фланелка-локо-софия-по-света\";s:6:\"expiry\";i:1766393413;}s:40:\"81d92c036eb475a3535791adcd90fc0b2f1a328e\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1976-нов-зимен-локомoтивски-шал\";s:6:\"expiry\";i:1766393413;}s:40:\"ee831dc53c29da0a08718cb4604ba68596c39041\";O:8:\"stdClass\":2:{s:4:\"link\";s:140:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1966-локо-артикули-в-предколедна-продажба\";s:6:\"expiry\";i:1766393413;}s:40:\"9658c39579d4b4db0f95caf8d1b0e8511f77e940\";O:8:\"stdClass\":2:{s:4:\"link\";s:136:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1560-вижте-новия-везан-локомотивски-шал\";s:6:\"expiry\";i:1766393413;}s:40:\"cfeff17cfd09a7011337a96bb0026eada7b4b2f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:124:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1471-актуални-артикули-локомотив\";s:6:\"expiry\";i:1766393413;}s:40:\"e73bc10b1461a76666656ae4fdaee5b4b8b023e2\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1011-ново\";s:6:\"expiry\";i:1766393413;}s:40:\"1ea16d8429e5be2b5ba973a5134448c1b9c02d88\";O:8:\"stdClass\":2:{s:4:\"link\";s:203:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/903-актуални-артикули-в-продажба,-малките-календарчета-също-вече-са-налични\";s:6:\"expiry\";i:1766393413;}s:40:\"6eb169a5e9035079880c614d37ed4055f37a205b\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2768-щастлива-и-успешна-2020-година\";s:6:\"expiry\";i:1766393414;}s:40:\"842fe14725c219b2356138ad1929de489c1a2f01\";O:8:\"stdClass\":2:{s:4:\"link\";s:177:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2561-няма-смисъл-да-живуркаме-във-втора-лига\";s:6:\"expiry\";i:1766393416;}s:40:\"1426a95ad267549bbc79c4aaf6e8637d7301cefd\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав\";s:6:\"expiry\";i:1766393418;}}s:13:\"session.token\";s:32:\"e40952d9cf1b13fd1d04b47bcb4973fe\";}' , `time` = '1766393419' WHERE `session_id` = 'd9e17056264a74493d8f774d6883c844'

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

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

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

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

2 × update jos_extrawatch_info set value = value+1
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'catid', '15', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'view', 'article', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'id', '2582', 2
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'option', 'com_content', 2
1 × update jos_extrawatch set country = 'us'
1 × UPDATE `jos_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:18;s:19:\"session.timer.start\";i:1766393394;s:18:\"session.timer.last\";i:1766393417;s:17:\"session.timer.now\";i:1766393418;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:19:{s:40:\"2cb63fdc9d9b1473e79bca184639ddcf577a4fbd\";O:8:\"stdClass\":2:{s:4:\"link\";s:209:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/2627-гледайте-90-години-локомотив-филмът\";s:6:\"expiry\";i:1766393394;}s:40:\"172111712d7b47e6447b63138110630feab39dd2\";O:8:\"stdClass\":2:{s:4:\"link\";s:199:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2753-локомотив-се-раздели-с-двама,-куп-треньори-отказаха\";s:6:\"expiry\";i:1766393397;}s:40:\"b2c393bd09fe1b13adb3146e64696eeff3238a44\";O:8:\"stdClass\":2:{s:4:\"link\";s:207:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2647-локомотив-be-strong-кетълбел-с-чудесно-представяне-на-сърбия-опън-4-2019\";s:6:\"expiry\";i:1766393398;}s:40:\"87b33fa33c8625e8bab2d3241fcde9f2acd67db1\";O:8:\"stdClass\":2:{s:4:\"link\";s:141:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2878-6-седмичен-курс-за-начинаещи-18\";s:6:\"expiry\";i:1766393402;}s:40:\"44cbc0ca55e835f0aa66d6fc2f770f2912bcee57\";O:8:\"stdClass\":2:{s:4:\"link\";s:234:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/програма-а-отбор-сезон-2013-2014/2586-програма-за-1-ви-кръг-на-втора-лига-по-дни-и-часове\";s:6:\"expiry\";i:1766393404;}s:40:\"37ed63a30db01635f88f762de029f711a57cf388\";O:8:\"stdClass\":2:{s:4:\"link\";s:186:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2943-контрола-локомотив-монтана-03-04-2021-14-30\";s:6:\"expiry\";i:1766393405;}s:40:\"e4647ddf4fbd65121701e635edaa701e385929b4\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/контакти\";s:6:\"expiry\";i:1766393406;}s:40:\"d89cfb1704ae75014e2effda597c07bd1b19cd65\";O:8:\"stdClass\":2:{s:4:\"link\";s:111:\"https://lokomotiv.ntesrv.com/joomla16/спорт-в-локомотив-софия/2632-ще-ни-липсваш\";s:6:\"expiry\";i:1766393408;}s:40:\"b5d934896e209c4aa7850b2a6a48ca0b3b81dc26\";O:8:\"stdClass\":2:{s:4:\"link\";s:184:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/двубои-а-отбор/2640-галерия-струмска-слава-локомотив-0-2\";s:6:\"expiry\";i:1766393410;}s:40:\"79d5f07a8aa6aa10258e1f1a7ae090a389c88b9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:133:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/2325-нова-фланелка-локо-софия-по-света\";s:6:\"expiry\";i:1766393413;}s:40:\"81d92c036eb475a3535791adcd90fc0b2f1a328e\";O:8:\"stdClass\":2:{s:4:\"link\";s:120:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1976-нов-зимен-локомoтивски-шал\";s:6:\"expiry\";i:1766393413;}s:40:\"ee831dc53c29da0a08718cb4604ba68596c39041\";O:8:\"stdClass\":2:{s:4:\"link\";s:140:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1966-локо-артикули-в-предколедна-продажба\";s:6:\"expiry\";i:1766393413;}s:40:\"9658c39579d4b4db0f95caf8d1b0e8511f77e940\";O:8:\"stdClass\":2:{s:4:\"link\";s:136:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1560-вижте-новия-везан-локомотивски-шал\";s:6:\"expiry\";i:1766393413;}s:40:\"cfeff17cfd09a7011337a96bb0026eada7b4b2f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:124:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1471-актуални-артикули-локомотив\";s:6:\"expiry\";i:1766393413;}s:40:\"e73bc10b1461a76666656ae4fdaee5b4b8b023e2\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/1011-ново\";s:6:\"expiry\";i:1766393413;}s:40:\"1ea16d8429e5be2b5ba973a5134448c1b9c02d88\";O:8:\"stdClass\":2:{s:4:\"link\";s:203:\"https://lokomotiv.ntesrv.com/joomla16/за-нас/артикули/903-актуални-артикули-в-продажба,-малките-календарчета-също-вече-са-налични\";s:6:\"expiry\";i:1766393413;}s:40:\"6eb169a5e9035079880c614d37ed4055f37a205b\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/исторически-факти-за-всичко-свързано-с-локомотив-софия/локомотивци/2768-щастлива-и-успешна-2020-година\";s:6:\"expiry\";i:1766393414;}s:40:\"842fe14725c219b2356138ad1929de489c1a2f01\";O:8:\"stdClass\":2:{s:4:\"link\";s:177:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2561-няма-смисъл-да-живуркаме-във-втора-лига\";s:6:\"expiry\";i:1766393416;}s:40:\"1426a95ad267549bbc79c4aaf6e8637d7301cefd\";O:8:\"stdClass\":2:{s:4:\"link\";s:220:\"https://lokomotiv.ntesrv.com/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав\";s:6:\"expiry\";i:1766393418;}}s:13:\"session.token\";s:32:\"e40952d9cf1b13fd1d04b47bcb4973fe\";}' , `time` = '1766393419'
1 × insert into jos_extrawatch_uri_post (`uriid`, `key`, `value`, `type`) values ('12280400', 'Itemid', '148', 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 = '1766393419'
1 × update jos_extrawatch_uri2title set title = 'Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав'
1 × insert into jos_extrawatch_uri (id, fk, timestamp, uri, title) values ('', '900214', '1766393419', '/joomla16/а-отбор-на-локомотив-софия/новини/2582-трансфери-2019-разделихме-се-със-зюмбюлев,-романов-напусна-дунав', 'Трансфери 2019: Разделихме се със Зюмбюлев, Романов напусна Дунав'
1 × SHOW FULL COLUMNS FROM `jos_assets

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

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

ВИДЕО

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

Сесия

__default

user

com_mailto.links

2cb63fdc9d9b1473e79bca184639ddcf577a4fbd

172111712d7b47e6447b63138110630feab39dd2

b2c393bd09fe1b13adb3146e64696eeff3238a44

87b33fa33c8625e8bab2d3241fcde9f2acd67db1

44cbc0ca55e835f0aa66d6fc2f770f2912bcee57

37ed63a30db01635f88f762de029f711a57cf388

e4647ddf4fbd65121701e635edaa701e385929b4

d89cfb1704ae75014e2effda597c07bd1b19cd65

b5d934896e209c4aa7850b2a6a48ca0b3b81dc26

79d5f07a8aa6aa10258e1f1a7ae090a389c88b9e

81d92c036eb475a3535791adcd90fc0b2f1a328e

ee831dc53c29da0a08718cb4604ba68596c39041

9658c39579d4b4db0f95caf8d1b0e8511f77e940

cfeff17cfd09a7011337a96bb0026eada7b4b2f4

e73bc10b1461a76666656ae4fdaee5b4b8b023e2

1ea16d8429e5be2b5ba973a5134448c1b9c02d88

6eb169a5e9035079880c614d37ed4055f37a205b

842fe14725c219b2356138ad1929de489c1a2f01

1426a95ad267549bbc79c4aaf6e8637d7301cefd

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

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

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

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

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

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

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