WELCOME!

Xiangqi in English.com is all about having fun with Xiangqi (aka Chinese Chess, 象棋, Elephant Chess) in English. Note: Xiangqi is the OFFICIAL term recommended by the Chinese Xiangqi Association, the World Xiangqi Federation, and the Asian Xiangqi Federation.

Content is added very frequently, and there were over 2600 pages (as of June 2020) before the site moved. The Webmaster's mission is to share the basic and finer points of the game. And, Xqinenglish is entirely free!

Chinese Chess or Xiangqi is an ancient game that is deeply embedded in Chinese culture. Millions have played the game across Asia for the past few centuries. It is fast-paced, exciting, easy to learn, and intriguing. Xiangqi is also an indispensable part of the daily lives of many Chinese. There are well over one hundred idioms in Chinese that have their roots in Xiangqi.xqinenglish welcome page pic

Yet, outside of China or Chinese communities around the world, Xiangqi is relatively unknown. It is also alien to those unfamiliar with the Chinese language and would seem daunting. Perhaps the language barrier is the biggest reason.

The Webmaster sees no reason why the language barrier should deter those interested in the game and Chinese culture from experiencing Xiangqi, learning about the culture of the Chinese, and, most importantly, having fun. This website was created in 2011 to promote the intriguing game of Chinese chess to those who are interested but not familiar with the Chinese language.

Over the years, the Webmaster has added a Facebook Fanpage, a Youtube channel with over 3000 videos (as of Jan 2023), and a Twitter Account (search for "xqinenglish"), or simply click on the buttons on the top right hand side of the page.

The official xqinenglish.com accounts on the following social media are as follows or click on the buttons on the top right corner:
Facebook: https://www.facebook.com/xiangqiinenglish
Twitter: https://twitter.com/xqinenglish
Tiktok: https://www.tiktok.com/@xqinenglish  


Uploads are posted on Facebook and Youtube at least five days per week. Announcements can be seen on the Facebook Fanpage. Links to the various social media can be found on the menu. The following video is a short video introducing the site and how to navigate it. There are also introductory clips to the various social media associated with xqinenglish.

 

 

Xiangqi is an important part of Chinese culture.

After ten years of being the most prominent site on Xiangqi on the internet, the author has decided to re-do the entire site, so that mistakes can be corrected and that the organization of the site would be even more user- friendly. Some of the pages would also be merged so that the visitor would not be lost in the maze of content, which has been made easier with Content Management Systems like Joomla (which is used for this website).

The changes would also reflect the changes and advances of Xiangqi over the past decade. New sections would be added with more focus on culture, history, Xiangqi education for kids et cetera. Many of the articles or videos are still in the process of creation as the entire site is reconstructed.

For visitors new to the site, please go to the "Announcements" section on the menu bar to see what has been uploaded.

One of the biggest issues impeding the spread of Xiangqi to the non-Chinese peoples is the lack of literature, especially in English. Over the years, the Webmaster has written many English books on Xiangqi. Perhaps the most important book would be the world's first-ever Lexicon of Xiangqi that would help tear down the language! Great care and effort has also been put into translating the ancient manuals into English so that they would be preserved for posterity. The 'hidden' cultural and historical implications behind the ancient manuals have also been explained so that the non-Chinese would be able to appreciate the culture of Xiangqi, which would be an integral part of the culture of the Chinese itself. There is also an introduction to early books (though some may be still under construction) that can be found under the Publications button in the menu.

Finally, the Webmaster has decided to address some of the most frequently asked questions in Xiangqi. He has done some research and written some articles (although a few are still in the works). These articles can be found under the relevant sections.

Comparing Xiangqi (Chinese Chess) and International Chess      

Orthodox Opening Systems in Xiangqi (Chinese Chess)  

Unorthodox Opening Systems in Xiangqi (Chinese Chess)  

Analyzing the situation correctly in Xiangqi (Chinese Chess) 

Origins of Xiangqi (Chinese Chess) 10: Red & Black, Royal Rule etc. explained

 

All constructive comments are always welcomed. To contact the Webmaster, please write to xqinenglish@gmail.com.
Note:The email admin@xqinenglish.com is no longer available.

Recommendation: For visitors using a handphone, it would be better to view the site using a horizontal screen. There are many comments in the boards.

If you itch to play the game, you may visit the following link or simply go to

www.xiangqi.com (highly recommended)!

Note: Since the site started in 2011, there have been many new sites, blogs, Youtube Channels et cetera that have sprouted on the internet. Some contain very good content while the Webmaster will refrain from passing judgement on other such blogs or sites. Many sites have also seemed to use material from xqinenglish.com . The Webmaster only wishes to receive the acknowledgement he duly derserves if material from this site has been used.

DISCLAIMER for Affiliate Links: This website contains affiliate links, which means that if you click on one of the product links, xqinenglish.com will receive a small commission. 

Play Xiangqi

A simple app to play Xiangqi on this site!

Developed by Code Monkey King.

6MBMemory Usage539msRequest Duration
Joomla! Version4.2.9
PHP Version8.0.30
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.6-MariaDB
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:2 [ "start" => "30" "lang" => "en" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3R...
$_COOKIE
array:1 [ "cc789d06d5a146cad9b5c4fc8f8ebda1" => "e541699e24d9330613532c5240bd2ed7" ]
$_SERVER
array:50 [ "USER" => "Joomla" "HOME" => "/var/packages/Joomla/home" "SCRIPT_NAME" => "/index.p...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1749272974 "last" => 1749272974...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (540.45KB) (2.28ms)
  • afterInitialise (1.55MB) (34.81ms)
  • afterRoute (182.02KB) (5.56ms)
  • beforeRenderComponent com_content (187.63KB) (5.06ms)
  • Before Access::preloadComponents (all components) (67.46KB) (3.85ms)
  • After Access::preloadComponents (all components) (99.83KB) (1.91ms)
  • Before Access::preloadPermissions (com_content) (61.52KB) (62μs)
  • After Access::preloadPermissions (com_content) (909.02KB) (13.11ms)
  • Before Access::getAssetRules (id:293 name:com_content.article.96) (66.8KB) (196μs)
  • After Access::getAssetRules (id:293 name:com_content.article.96) (9.3KB) (273μs)
  • afterRenderComponent com_content (759.72KB) (162ms)
  • Before Access::getAssetRules (id:8 name:com_content) (11.1KB) (2.22ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.48KB) (90μs)
  • afterDispatch (15.15KB) (1.75ms)
  • beforeRenderRawModule mod_menu (Main Menu) (74.91KB) (5.78ms)
  • afterRenderRawModule mod_menu (Main Menu) (285.95KB) (10.14ms)
  • beforeRenderRawModule mod_menu (Main Menu) (736B) (79μs)
  • afterRenderRawModule mod_menu (Main Menu) (75.58KB) (3.43ms)
  • beforeRenderRawModule mod_menu (Others) (672B) (71μs)
  • afterRenderRawModule mod_menu (Others) (123.29KB) (6.13ms)
  • beforeRenderRawModule mod_articles_latest (Latest Additions) (704B) (108μs)
  • afterRenderRawModule mod_articles_latest (Latest Additions) (101.72KB) (207ms)
  • beforeRenderRawModule mod_custom (Adsense 02) (448B) (80μs)
  • afterRenderRawModule mod_custom (Adsense 02) (3.63KB) (1.3ms)
  • beforeRenderRawModule mod_finder (Search) (1008B) (61μs)
  • afterRenderRawModule mod_finder (Search) (68.67KB) (8.6ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.04KB) (215μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.7KB) (1.59ms)
  • beforeRenderRawModule mod_custom (Play Xiangqi) (592B) (136μs)
  • afterRenderRawModule mod_custom (Play Xiangqi) (976B) (615μs)
  • beforeRenderRawModule mod_footer (Footer) (624B) (82μs)
  • afterRenderRawModule mod_footer (Footer) (4.75KB) (1.34ms)
  • beforeRenderRawModule mod_social_slider (Social Media Links Top Right) (25.42KB) (117μs)
  • afterRenderRawModule mod_social_slider (Social Media Links Top Right) (32.45KB) (2.29ms)
  • Before Access::getAssetRules (id:16 name:com_menus) (30.13KB) (486μs)
  • After Access::getAssetRules (id:16 name:com_menus) (6.48KB) (65μs)
  • beforeRenderModule mod_footer (Footer) (4.27KB) (150μs)
  • afterRenderModule mod_footer (Footer) (2.84KB) (590μs)
  • beforeRenderModule mod_social_slider (Social Media Links Top Right) (24.37KB) (127μs)
  • afterRenderModule mod_social_slider (Social Media Links Top Right) (2.84KB) (224μs)
  • beforeRenderModule mod_custom (Play Xiangqi) (24.53KB) (150μs)
  • afterRenderModule mod_custom (Play Xiangqi) (3.15KB) (569μs)
  • beforeRenderModule mod_articles_latest (Latest Additions) (288B) (154μs)
  • afterRenderModule mod_articles_latest (Latest Additions) (9.96KB) (201μs)
  • beforeRenderModule mod_custom (Adsense 02) (616B) (39μs)
  • afterRenderModule mod_custom (Adsense 02) (2.38KB) (195μs)
  • beforeRenderModule mod_finder (Search) (88B) (41μs)
  • afterRenderModule mod_finder (Search) (2.68KB) (172μs)
  • beforeRenderModule mod_menu (Main Menu) (1.4KB) (238μs)
  • afterRenderModule mod_menu (Main Menu) (4.93KB) (183μs)
  • beforeRenderModule mod_menu (Main Menu) (360B) (44μs)
  • afterRenderModule mod_menu (Main Menu) (2.93KB) (173μs)
  • beforeRenderModule mod_menu (Others) (616B) (61μs)
  • afterRenderModule mod_menu (Others) (3.93KB) (191μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (272B) (99μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.45KB) (180μs)
  • afterRender (429.26KB) (41.61ms)
  • 1 x afterRenderRawModule mod_articles_latest (Latest Additions) (101.72KB) (38.37%)
    206.61ms
    1 x afterRenderComponent com_content (759.72KB) (30.16%)
    162.40ms
    1 x afterRender (429.26KB) (7.73%)
    41.61ms
    1 x afterInitialise (1.55MB) (6.46%)
    34.81ms
    1 x After Access::preloadPermissions (com_content) (909.02KB) (2.43%)
    13.11ms
    1 x afterRenderRawModule mod_menu (Main Menu) (285.95KB) (1.88%)
    10.14ms
    1 x afterRenderRawModule mod_finder (Search) (68.67KB) (1.6%)
    8.60ms
    1 x afterRenderRawModule mod_menu (Others) (123.29KB) (1.14%)
    6.13ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (74.91KB) (1.07%)
    5.78ms
    1 x afterRoute (182.02KB) (1.03%)
    5.56ms
    1 x beforeRenderComponent com_content (187.63KB) (0.94%)
    5.06ms
    1 x Before Access::preloadComponents (all components) (67.46KB) (0.72%)
    3.85ms
    1 x afterRenderRawModule mod_menu (Main Menu) (75.58KB) (0.64%)
    3.43ms
    1 x afterRenderRawModule mod_social_slider (Social Media Links Top Right) (32.45KB) (0.42%)
    2.29ms
    1 x afterLoad (540.45KB) (0.42%)
    2.28ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (11.1KB) (0.41%)
    2.22ms
    1 x After Access::preloadComponents (all components) (99.83KB) (0.36%)
    1.91ms
    1 x afterDispatch (15.15KB) (0.33%)
    1.75ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.7KB) (0.29%)
    1.59ms
    1 x afterRenderRawModule mod_footer (Footer) (4.75KB) (0.25%)
    1.34ms
    1 x afterRenderRawModule mod_custom (Adsense 02) (3.63KB) (0.24%)
    1.30ms
    1 x afterRenderRawModule mod_custom (Play Xiangqi) (976B) (0.11%)
    615μs
    1 x afterRenderModule mod_footer (Footer) (2.84KB) (0.11%)
    590μs
    1 x afterRenderModule mod_custom (Play Xiangqi) (3.15KB) (0.11%)
    569μs
    1 x Before Access::getAssetRules (id:16 name:com_menus) (30.13KB) (0.09%)
    486μs
    1 x After Access::getAssetRules (id:293 name:com_content.article.96) (9.3KB) (0.05%)
    273μs
    1 x beforeRenderModule mod_menu (Main Menu) (1.4KB) (0.04%)
    238μs
    1 x afterRenderModule mod_social_slider (Social Media Links Top Right) (2.84KB) (0.04%)
    224μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.04KB) (0.04%)
    215μs
    1 x afterRenderModule mod_articles_latest (Latest Additions) (9.96KB) (0.04%)
    201μs
    1 x Before Access::getAssetRules (id:293 name:com_content.article.96) (66.8KB) (0.04%)
    196μs
    1 x afterRenderModule mod_custom (Adsense 02) (2.38KB) (0.04%)
    195μs
    1 x afterRenderModule mod_menu (Others) (3.93KB) (0.04%)
    191μs
    1 x afterRenderModule mod_menu (Main Menu) (4.93KB) (0.03%)
    183μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.45KB) (0.03%)
    180μs
    1 x afterRenderModule mod_menu (Main Menu) (2.93KB) (0.03%)
    173μs
    1 x afterRenderModule mod_finder (Search) (2.68KB) (0.03%)
    172μs
    1 x beforeRenderModule mod_articles_latest (Latest Additions) (288B) (0.03%)
    154μs
    1 x beforeRenderModule mod_footer (Footer) (4.27KB) (0.03%)
    150μs
    1 x beforeRenderModule mod_custom (Play Xiangqi) (24.53KB) (0.03%)
    150μs
    1 x beforeRenderRawModule mod_custom (Play Xiangqi) (592B) (0.03%)
    136μs
    1 x beforeRenderModule mod_social_slider (Social Media Links Top Right) (24.37KB) (0.02%)
    127μs
    1 x beforeRenderRawModule mod_social_slider (Social Media Links Top Right) (25.42KB) (0.02%)
    117μs
    1 x beforeRenderRawModule mod_articles_latest (Latest Additions) (704B) (0.02%)
    108μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (272B) (0.02%)
    99μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.48KB) (0.02%)
    90μs
    1 x beforeRenderRawModule mod_footer (Footer) (624B) (0.02%)
    82μs
    1 x beforeRenderRawModule mod_custom (Adsense 02) (448B) (0.01%)
    80μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (736B) (0.01%)
    79μs
    1 x beforeRenderRawModule mod_menu (Others) (672B) (0.01%)
    71μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (6.48KB) (0.01%)
    65μs
    1 x Before Access::preloadPermissions (com_content) (61.52KB) (0.01%)
    62μs
    1 x beforeRenderRawModule mod_finder (Search) (1008B) (0.01%)
    61μs
    1 x beforeRenderModule mod_menu (Others) (616B) (0.01%)
    61μs
    1 x beforeRenderModule mod_menu (Main Menu) (360B) (0.01%)
    44μs
    1 x beforeRenderModule mod_finder (Search) (88B) (0.01%)
    41μs
    1 x beforeRenderModule mod_custom (Adsense 02) (616B) (0.01%)
    39μs
38 statements were executed, 2 of which were duplicates, 36 unique359ms534.77KB
  • SELECT @@SESSION.sql_mode;133μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `nkn0q_session` WHERE `session_id` = ?324μs17.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `nkn0q_session` WHERE `session_id` = :session_id LIMIT 1331μs1.64KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `nkn0q_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id289μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `nkn0q_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1722μs4.69KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `nkn0q_viewlevels`266μs1.16KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `nkn0q_usergroups` AS `a` LEFT JOIN `nkn0q_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest464μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `nkn0q_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.38ms11.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • SELECT * FROM `nkn0q_languages` WHERE `published` = 1 ORDER BY `ordering` ASC427μs3.69KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `nkn0q_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1463μs1.55KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `nkn0q_menu` AS `m` LEFT JOIN `nkn0q_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.2ms65.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `nkn0q_template_styles` AS `s` LEFT JOIN `nkn0q_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` = 1849μs1.22KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `nkn0q_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38)1.04ms9.62KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `nkn0q_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 09.29ms161.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `nkn0q_content`2.09ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE `nkn0q_content` SET `hits` = (`hits` + 1) WHERE `id` = '96'120ms48B/libraries/src/Table/Table.php:1320Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`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`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `nkn0q_content` AS `a` INNER JOIN `nkn0q_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `nkn0q_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `nkn0q_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `nkn0q_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `nkn0q_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray3,:preparedArray4)732μs27.94KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`741μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `nkn0q_contentitem_tag_map` AS `m` INNER JOIN `nkn0q_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)3.93ms5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`769μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM nkn0q_fields AS a LEFT JOIN `nkn0q_languages` AS l ON l.lang_code = a.language LEFT JOIN nkn0q_users AS uc ON uc.id=a.checked_out LEFT JOIN nkn0q_viewlevels AS ag ON ag.id = a.access LEFT JOIN nkn0q_users AS ua ON ua.id = a.created_user_id LEFT JOIN nkn0q_fields_groups AS g ON g.id = a.group_id LEFT JOIN `nkn0q_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC2.4ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SELECT `language`,`id` FROM `nkn0q_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0439μs944B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `nkn0q_content` AS `c` INNER JOIN `nkn0q_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `nkn0q_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `nkn0q_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `nkn0q_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-06-07 05:09:34') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-07 05:09:34') AND c2.state = 1535μs1.78KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `nkn0q_modules` AS `m` LEFT JOIN `nkn0q_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `nkn0q_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`1.1ms4.13KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `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`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `nkn0q_content` AS `a` LEFT JOIN `nkn0q_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `nkn0q_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `nkn0q_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `nkn0q_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `nkn0q_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `nkn0q_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.publish_up DESC LIMIT 10196ms97.66KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.17ms6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.14ms6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `name`,`element` FROM `nkn0q_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1635μs1.06KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:134Copy
  • SELECT `title` FROM `nkn0q_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)521μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `nkn0q_scheduler_tasks` AS `a` LEFT JOIN `nkn0q_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc616μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `nkn0q_scheduler_tasks` AS `a` LEFT JOIN `nkn0q_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc539μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`854μs6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.16ms20.31KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.12ms6.09KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.11ms6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.12ms6.73KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.12ms6.09KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `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`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `nkn0q_categories` AS `s` INNER JOIN `nkn0q_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.12ms6.09KBParams/libraries/src/Categories/Categories.php:360Copy