Sutton Coldfield Local History Research Group

Regular meeting, Tuesday - Sutton Coldfield Library (2.00pm to 4.30pm)

Stephen Roberts PhotoThe late Stephen Roberts (1958-2022) was born in Sutton Coldfield and educated at Bishop Vesey’s Grammar School before going on to study at Birmingham University.

He became well known as a Birmingham Historian and was the author of several books.

He was an excellent communicator and gave many talks on various topics of local history in and around the Sutton Coldfield area.

He was also an active member of numerous groups, including the Sutton Coldfield Local History Research Group.

One of the last projects he worked on was a weekly article for the Sutton Coldfield ‘Chronicle Week’, which began on the 29th April 2021 and ended on the 5th May 2022, shortly before his death.

Photo courtesy of Zoe Toft

This series of articles is reproduced here for the benefit of all.

Click the column headings to change the order of these articles.

Title Author Hits
The Horse & Jockey, 1892
The Horse & Jockey, 1892

Highly Regarded Pub

I recently wrote about the Top Swan, adjacent to Bishop Vesey's Grammar School, which benefited from trade coming into Sutton from Lichfield. In this week's column we will take a look at the Horse & Jockey, which also well situated - the ...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 98
The Cup c. 1890
The Cup c. 1890

The Cup Runneth Over

I am always saddened when I see another part of Sutton's heritage disappear. This is how I felt a decade or so ago when I learned that there would no longer be a pub in the town called the Cup. There had been a pub called the Cup in this plac...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 116
The Top Swan, demolished 1904.
The Top Swan, demolished 1904.

Pub Endured Tragedy

This is my fiftieth local history column for the newspaper. Later today I will mark the occasion by enjoying a glass of Manns Brown Ale. (Yes, really…) Manns' Brown Ale was first produced in 1902. Sadly for our predecessors this marginally s...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 123
Sam Timmins
Sam Timmins

Sam's Bard Vision Led to New-library Chapter

On April 23 - Shakespeare's birthday - a copy of the First Folio will be on display at Sutton Library. This is a major coup for the library and for FOLIO, who have - arranged the display as part of a breathtaking Shakespeare festival in Sutton....

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 115
Holy Trinity churchyard c. 1880
Holy Trinity churchyard c. 1880

Held in High Regard

On Thursday, January 27, 1887, Robert Green, aged 58, became a resident of the churchyard of Holy Trinity. It was said that 'no man living within the radius of the parish (was) more widely known or more genuinely esteemed and beloved for upri...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 111
Home Guard Association
Home Guard Association

PoW Camp Became an Attraction in the Park

In 1944, as the Second World War drew to a close, a Prisoner of War camp was established in Sutton Park. It was intended to house the German soldiers captured after the D-Day landings. It was located near Longmoor Pool, and the prisoners l...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 107
A motor car in early 20th century Sutton
A motor car in early 20th century Sutton

Age of Car Motors On

The automobile is very slowly making its way in England', it was reported in a local newspaper in 1899. At that time prices for 'a decent motor car' ranged from £110 to £150. The purchasers of cars were men with money in search of a new inte...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 119
the Royal Oak
the Royal Oak

Moving on from past

Today, when we move house, a removal van pulls up, our furniture is loaded up and off it goes. It's a time-consuming business. In centuries past many of our predecessors in Sutton did it all in a different way. There wasn't a train of wagons ...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 87
Main gates in Sutton Park, 1920s
Main gates in Sutton Park, 1920s

Park Music Lifts Spirits

Bands played regularly in the parks of Birmingham. Whether this practice should be extended to Sutton Park became a contentious issue in the early decades of the 20th century. Advocates of the idea believed the park was more than just a p...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 98
Sutton Park in the 19205
Sutton Park in the 19205

'Keep hands off park'

'Sutton is a funny place', a Birmingham journalist observed in 1933. 'The people are so touchy and, if you talk about the park, they at once sit up and take notice and then it is time for you to watch your step.' There was some truth in this...

  • Serendipity
  • Remembering Stephen Roberts
  • Read more …
 		(SCLHRG) Hits: 109
J! InfoRequestSessionProfileQueries61Log2
10.964MBMemory Usage628msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.28
Identityguest
Response200
Templatesclhrg_2024
Database
Server
mysql
Version
10.6.21-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744488411 "last" => 1744488411...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (342.71KB) (75.48ms)
  • afterInitialise (3.38MB) (211ms)
  • afterRoute (389KB) (16.04ms)
  • beforeRenderComponent com_content (146.38KB) (10.7ms)
  • Before Access::preloadComponents (all components) (180.3KB) (11.74ms)
  • After Access::preloadComponents (all components) (142.52KB) (1.9ms)
  • Before Access::preloadPermissions (com_content) (1.95KB) (24μs)
  • After Access::preloadPermissions (com_content) (734.65KB) (3.49ms)
  • Before Access::getAssetRules (id:3687 name:com_content.category.179) (34.65KB) (104μs)
  • After Access::getAssetRules (id:3687 name:com_content.category.179) (7.25KB) (986μs)
  • afterRenderComponent com_content (1.98MB) (128ms)
  • afterDispatch (72.75KB) (2.88ms)
  • beforeRenderRawModule mod_footer (Copyright) (195.19KB) (9.6ms)
  • afterRenderRawModule mod_footer (Copyright) (6.14KB) (1.8ms)
  • beforeRenderModule mod_footer (Copyright) (720B) (7μs)
  • afterRenderModule mod_footer (Copyright) (3.56KB) (664μs)
  • beforeRenderRawModule mod_menu (Support) (2.52KB) (310μs)
  • afterRenderRawModule mod_menu (Support) (127.43KB) (5.31ms)
  • beforeRenderModule mod_menu (Support) (704B) (8μs)
  • afterRenderModule mod_menu (Support) (3.08KB) (170μs)
  • beforeRenderRawModule mod_articles_categories (Serendipity) (2.2KB) (74μs)
  • afterRenderRawModule mod_articles_categories (Serendipity) (235.6KB) (8.36ms)
  • beforeRenderModule mod_articles_categories (Serendipity) (720B) (12μs)
  • afterRenderModule mod_articles_categories (Serendipity) (4.91KB) (529μs)
  • beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (86μs)
  • afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (3.54ms)
  • beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (7μs)
  • afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (345μs)
  • beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (83μs)
  • afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (1.17ms)
  • beforeRenderModule mod_icmsocial (Social Links) (720B) (5μs)
  • afterRenderModule mod_icmsocial (Social Links) (6.98KB) (283μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (65μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.54KB) (1.25ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.69KB) (1.8ms)
  • beforeRenderRawModule mod_menu (NavBar) (1.18KB) (172μs)
  • afterRenderRawModule mod_menu (NavBar) (473.69KB) (15.15ms)
  • beforeRenderModule mod_menu (NavBar) (704B) (13μs)
  • afterRenderModule mod_menu (NavBar) (6.64KB) (264μs)
  • beforeRenderRawModule mod_login (Members) (2.83KB) (37μs)
  • afterRenderRawModule mod_login (Members) (33.27KB) (7.42ms)
  • beforeRenderModule mod_login (Members) (704B) (11μs)
  • afterRenderModule mod_login (Members) (4.33KB) (226μs)
  • beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (35μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (117.62KB) (13.41ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (9μs)
  • afterRenderModule mod_finder (Smart Search Module) (3.11KB) (168μs)
  • afterRender (1.47MB) (92.09ms)
  • 1 x afterInitialise (3.38MB) (33.53%)
    211ms
    1 x afterRenderComponent com_content (1.98MB) (20.39%)
    128ms
    1 x afterRender (1.47MB) (14.66%)
    92.09ms
    1 x afterLoad (342.71KB) (12.02%)
    75.48ms
    1 x afterRoute (389KB) (2.55%)
    16.04ms
    1 x afterRenderRawModule mod_menu (NavBar) (473.69KB) (2.41%)
    15.15ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (117.62KB) (2.14%)
    13.41ms
    1 x Before Access::preloadComponents (all components) (180.3KB) (1.87%)
    11.74ms
    1 x beforeRenderComponent com_content (146.38KB) (1.7%)
    10.70ms
    1 x beforeRenderRawModule mod_footer (Copyright) (195.19KB) (1.53%)
    9.60ms
    1 x afterRenderRawModule mod_articles_categories (Serendipity) (235.6KB) (1.33%)
    8.36ms
    1 x afterRenderRawModule mod_login (Members) (33.27KB) (1.18%)
    7.42ms
    1 x afterRenderRawModule mod_menu (Support) (127.43KB) (0.85%)
    5.31ms
    1 x afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (0.56%)
    3.54ms
    1 x After Access::preloadPermissions (com_content) (734.65KB) (0.56%)
    3.49ms
    1 x afterDispatch (72.75KB) (0.46%)
    2.88ms
    1 x After Access::preloadComponents (all components) (142.52KB) (0.3%)
    1.90ms
    1 x afterRenderRawModule mod_footer (Copyright) (6.14KB) (0.29%)
    1.80ms
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.69KB) (0.29%)
    1.80ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.54KB) (0.2%)
    1.25ms
    1 x afterRenderRawModule mod_icmsocial (Social Links) (8.75KB) (0.19%)
    1.17ms
    1 x After Access::getAssetRules (id:3687 name:com_content.category.179) (7.25KB) (0.16%)
    986μs
    1 x afterRenderModule mod_footer (Copyright) (3.56KB) (0.11%)
    664μs
    1 x afterRenderModule mod_articles_categories (Serendipity) (4.91KB) (0.08%)
    529μs
    1 x afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (0.05%)
    345μs
    1 x beforeRenderRawModule mod_menu (Support) (2.52KB) (0.05%)
    310μs
    1 x afterRenderModule mod_icmsocial (Social Links) (6.98KB) (0.05%)
    283μs
    1 x afterRenderModule mod_menu (NavBar) (6.64KB) (0.04%)
    264μs
    1 x afterRenderModule mod_login (Members) (4.33KB) (0.04%)
    226μs
    1 x beforeRenderRawModule mod_menu (NavBar) (1.18KB) (0.03%)
    172μs
    1 x afterRenderModule mod_menu (Support) (3.08KB) (0.03%)
    170μs
    1 x afterRenderModule mod_finder (Smart Search Module) (3.11KB) (0.03%)
    168μs
    1 x Before Access::getAssetRules (id:3687 name:com_content.category.179) (34.65KB) (0.02%)
    104μs
    1 x beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.63KB) (0.01%)
    86μs
    1 x beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (0.01%)
    83μs
    1 x beforeRenderRawModule mod_articles_categories (Serendipity) (2.2KB) (0.01%)
    74μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (0.01%)
    65μs
    1 x beforeRenderRawModule mod_login (Members) (2.83KB) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (0.01%)
    35μs
    1 x Before Access::preloadPermissions (com_content) (1.95KB) (0%)
    24μs
    1 x beforeRenderModule mod_menu (NavBar) (704B) (0%)
    13μs
    1 x beforeRenderModule mod_articles_categories (Serendipity) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_login (Members) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Support) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_footer (Copyright) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_icmsocial (Social Links) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
61 statements were executed, 13 of which were duplicates, 48 unique33.06ms392.41KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5
  • SELECT @@SESSION.sql_mode;6.91ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `mnjcl_session` WHERE `session_id` = ?232μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = :session_id LIMIT 1159μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `mnjcl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)462μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mnjcl_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1483μs17.86KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mnjcl_viewlevels`278μs672B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `mnjcl_usergroups` AS `a` LEFT JOIN `mnjcl_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest219μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `mnjcl_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.05ms5.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `mnjcl_admintools_storage` WHERE `key` = 'cparams'241μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `mnjcl_admintools_wafexceptions`138μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'242μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • DELETE FROM `mnjcl_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 300 SECOND) < NOW() AND `autodelete`=1;102μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:53Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '3.21.41.164' AND `hackcount` >= 3129μs536B/plugins/system/marcosinterceptor/marcosinterceptor.php:61Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '3.21.41.164' AND `hackcount` >= 383μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:65Copy
  • 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 `mnjcl_menu` AS `m` LEFT JOIN `mnjcl_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`939μs68.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `mnjcl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC324μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `mnjcl_template_styles` AS `s` LEFT JOIN `mnjcl_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` = 1357μs2.08KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mnjcl_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,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51)1.15ms7.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mnjcl_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.51ms69.48KBParams/libraries/src/Access/Access.php:301Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`594μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_content` AS `a` LEFT JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_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`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 10845μs70.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `mnjcl_contentitem_tag_map` AS `m` INNER JOIN `mnjcl_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `t`.`access` IN (:preparedArray11,:preparedArray12)3.11ms4.84KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT COUNT(*) FROM `mnjcl_content` AS `a` LEFT JOIN `mnjcl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mnjcl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `mnjcl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `mnjcl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mnjcl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mnjcl_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`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)485μs4.6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:197Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `mnjcl_contentitem_tag_map` AS `m` INNER JOIN `mnjcl_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)292μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `name` FROM `mnjcl_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'278μs536B/administrator/components/com_eventgallery/version.php:26Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`401μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mnjcl_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC768μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT article.id,'https://sclhrg.jonessoft.co.uk/serendipity/remembering-stephen-roberts.html\n[150] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.getResults\n[ 80] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `mnjcl_content` AS `article` WHERE `article`.`catid` = 179 AND `article`.`state` = 1331μs17.44KB/plugins/system/articlesanywhere/src/Database.php:115Copy
  • 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 mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC739μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`364μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mnjcl_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC650μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 mnjcl_fields AS a LEFT JOIN `mnjcl_languages` AS l ON l.lang_code = a.language LEFT JOIN mnjcl_users AS uc ON uc.id=a.checked_out LEFT JOIN mnjcl_viewlevels AS ag ON ag.id = a.access LEFT JOIN mnjcl_users AS ua ON ua.id = a.created_user_id LEFT JOIN mnjcl_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC638μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`443μs6.44KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT folder.* FROM `mnjcl_eventgallery_folder` AS folder LEFT JOIN `mnjcl_eventgallery_file` AS file ON folder.folder = file.folder and file.published=1 and file.ismainimage=0 WHERE file.file IS NULL AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4 OR folder.foldertypeid=5)241μs4.55KB/plugins/system/picasaupdater/src/Extension/PicasaUpdater.php:79Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `mnjcl_modules` AS `m` LEFT JOIN `mnjcl_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `mnjcl_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) ORDER BY `m`.`position`,`m`.`ordering`666μs18.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`472μs4.06KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`361μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`320μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`307μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`314μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`326μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`333μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`360μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`328μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • select SUM(count) from mnjcl_visitors_country297μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mnjcl_visitors_country where count>0105μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mnjcl_visitors_country ORDER BY count DESC LIMIT 5139μs720B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mnjcl_visitors where id = '7'101μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'59μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '1'69μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '1'55μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '7'67μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'54μs40B/modules/mod_jsvisit_counter/helper.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 `mnjcl_categories` AS `s` INNER JOIN `mnjcl_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`642μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1584μs672B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `mnjcl_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)304μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `mnjcl_scheduler_tasks` AS `a` WHERE `a`.`state` = 1639μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `mnjcl_content` WHERE `id` = :id184μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `mnjcl_content` WHERE `id` = :id111μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = ?167μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `mnjcl_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?506μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch