Other Publications

£14.99 + £2.40 p & p

The Royal Town of Sutton Coldfield, now part of the City of Birmingham, has 100,000 inhabitants and an interesting history.  By 1086, when it is recorded in the Domesday Book, there was a mixture of arable land, woodland, heath and common giving variety to the lives of the 500 people living there.

£7.25 + £2.40 p & p

A closer look at aspects of the History of Sutton Coldfield, ranging in date from the Prehistoric and Roman Periods, through medieval times and the 16th/17th/18th Centuries to the development of The Parade in the late 1800s and its demolition in the 1970s.

£3.75 + £2.40 p & p Out of Stock

This well illustrated book shows how the Birmingham to Sutton Coldfield Railway Line was built in 1862.

£8.99 + £2.40 p & p

This publication produced by Highcroft History Group traces the history of Erdington's well-known landmark from its origin as a 19th century workhouse, managed by the Aston Poor Law Union, through its transition to a progressive facility for mental health care in the new millennium.

£5.00 + £2.40 p & p

The author writes: These 'Tall Tales' are not written for the knowledgeable devotee of Sutton Coldfield's fascinating history.  He won't find many revelations here! Rather, they are intended for those who easily find themselves looking for signs of former generations as they walk through the old streets of the town.

£7.50 + £2.40 p & p

The construction of Manley Hall began in 1831 in the Elizabethan style, with Gothic overtones, on the instructions of John Shawe Manley.  This large country mansion was situated between Weeford and Shenstone and was set in approximately 1,200 acres.

£9.45 + £2.40 p & p

In May 2008, following a newspaper article in the Sutton Coldfield News, it was discovered that the entire Household Contents & Personal Items of 'Chalford', a Victorian house situated in Belwell Lane, Four Oaks, was due to be sold via public auction.  The Auctioneer, Charles Hanson (of television fame including "Bargain Hunt' and 'Antiques Road Trip') subsequently went on to say that  "It was like walking back in time and had the magical feel of a Mary Poppins era".

Settings10.224MBMemory Usage509msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
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" => 1745228008 "last" => 1745228008...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (339.64KB) (55.39ms)
  • afterInitialise (3.3MB) (175ms)
  • afterRoute (620.37KB) (23.55ms)
  • beforeRenderComponent com_content (98.46KB) (12.05ms)
  • Before Access::preloadComponents (all components) (106.33KB) (10.15ms)
  • After Access::preloadComponents (all components) (142.83KB) (1.13ms)
  • Before Access::preloadPermissions (com_content) (1.95KB) (16μs)
  • After Access::preloadPermissions (com_content) (734.65KB) (2.68ms)
  • Before Access::getAssetRules (id:311 name:com_content.category.91) (34.65KB) (83μs)
  • After Access::getAssetRules (id:311 name:com_content.category.91) (7.25KB) (863μs)
  • afterRenderComponent com_content (1.58MB) (86.74ms)
  • afterDispatch (72.44KB) (2.86ms)
  • beforeRenderRawModule mod_footer (Copyright) (194.13KB) (9.46ms)
  • afterRenderRawModule mod_footer (Copyright) (10.41KB) (1.67ms)
  • beforeRenderModule mod_footer (Copyright) (720B) (5μs)
  • afterRenderModule mod_footer (Copyright) (3.56KB) (588μs)
  • beforeRenderRawModule mod_menu (Support) (2.52KB) (301μs)
  • afterRenderRawModule mod_menu (Support) (127.24KB) (5.36ms)
  • beforeRenderModule mod_menu (Support) (704B) (7μs)
  • afterRenderModule mod_menu (Support) (3.08KB) (130μs)
  • beforeRenderRawModule mod_articles_categories (Shop) (2.21KB) (60μs)
  • afterRenderRawModule mod_articles_categories (Shop) (115.09KB) (4.62ms)
  • beforeRenderModule mod_articles_categories (Shop) (704B) (5μs)
  • afterRenderModule mod_articles_categories (Shop) (4.66KB) (341μs)
  • beforeRenderRawModule mod_custom (Purchasing) (1.06KB) (21μs)
  • afterRenderRawModule mod_custom (Purchasing) (4.19KB) (2.62ms)
  • beforeRenderModule mod_custom (Purchasing) (720B) (5μs)
  • afterRenderModule mod_custom (Purchasing) (3.17KB) (150μs)
  • beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.7KB) (67μs)
  • afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (3.16ms)
  • beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (5μs)
  • afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (292μs)
  • beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (60μs)
  • afterRenderRawModule mod_icmsocial (Social Links) (10KB) (956μs)
  • beforeRenderModule mod_icmsocial (Social Links) (720B) (5μs)
  • afterRenderModule mod_icmsocial (Social Links) (6.98KB) (260μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (54μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.54KB) (1.11ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (102μs)
  • beforeRenderRawModule mod_menu (NavBar) (1.18KB) (53μs)
  • afterRenderRawModule mod_menu (NavBar) (444.38KB) (8.58ms)
  • beforeRenderModule mod_menu (NavBar) (704B) (5μs)
  • afterRenderModule mod_menu (NavBar) (6.64KB) (125μs)
  • beforeRenderRawModule mod_login (Members) (2.83KB) (18μs)
  • afterRenderRawModule mod_login (Members) (24.73KB) (5.03ms)
  • beforeRenderModule mod_login (Members) (704B) (6μs)
  • afterRenderModule mod_login (Members) (4.33KB) (125μs)
  • beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (20μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (134.63KB) (15.77ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (9μs)
  • afterRenderModule mod_finder (Smart Search Module) (3.11KB) (184μs)
  • afterRender (1.32MB) (75.32ms)
  • 1 x afterInitialise (3.3MB) (34.41%)
    175ms
    1 x afterRenderComponent com_content (1.58MB) (17.03%)
    86.74ms
    1 x afterRender (1.32MB) (14.78%)
    75.32ms
    1 x afterLoad (339.64KB) (10.87%)
    55.39ms
    1 x afterRoute (620.37KB) (4.62%)
    23.55ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (134.63KB) (3.1%)
    15.77ms
    1 x beforeRenderComponent com_content (98.46KB) (2.36%)
    12.05ms
    1 x Before Access::preloadComponents (all components) (106.33KB) (1.99%)
    10.15ms
    1 x beforeRenderRawModule mod_footer (Copyright) (194.13KB) (1.86%)
    9.46ms
    1 x afterRenderRawModule mod_menu (NavBar) (444.38KB) (1.68%)
    8.58ms
    1 x afterRenderRawModule mod_menu (Support) (127.24KB) (1.05%)
    5.36ms
    1 x afterRenderRawModule mod_login (Members) (24.73KB) (0.99%)
    5.03ms
    1 x afterRenderRawModule mod_articles_categories (Shop) (115.09KB) (0.91%)
    4.62ms
    1 x afterRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (98.3KB) (0.62%)
    3.16ms
    1 x afterDispatch (72.44KB) (0.56%)
    2.86ms
    1 x After Access::preloadPermissions (com_content) (734.65KB) (0.53%)
    2.68ms
    1 x afterRenderRawModule mod_custom (Purchasing) (4.19KB) (0.51%)
    2.62ms
    1 x afterRenderRawModule mod_footer (Copyright) (10.41KB) (0.33%)
    1.67ms
    1 x After Access::preloadComponents (all components) (142.83KB) (0.22%)
    1.13ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.54KB) (0.22%)
    1.11ms
    1 x afterRenderRawModule mod_icmsocial (Social Links) (10KB) (0.19%)
    956μs
    1 x After Access::getAssetRules (id:311 name:com_content.category.91) (7.25KB) (0.17%)
    863μs
    1 x afterRenderModule mod_footer (Copyright) (3.56KB) (0.12%)
    588μs
    1 x afterRenderModule mod_articles_categories (Shop) (4.66KB) (0.07%)
    341μs
    1 x beforeRenderRawModule mod_menu (Support) (2.52KB) (0.06%)
    301μs
    1 x afterRenderModule mod_jsvisit_counter (Module jsvisit counter) (5.63KB) (0.06%)
    292μs
    1 x afterRenderModule mod_icmsocial (Social Links) (6.98KB) (0.05%)
    260μs
    1 x afterRenderModule mod_finder (Smart Search Module) (3.11KB) (0.04%)
    184μs
    1 x afterRenderModule mod_custom (Purchasing) (3.17KB) (0.03%)
    150μs
    1 x afterRenderModule mod_menu (Support) (3.08KB) (0.03%)
    130μs
    1 x afterRenderModule mod_menu (NavBar) (6.64KB) (0.02%)
    125μs
    1 x afterRenderModule mod_login (Members) (4.33KB) (0.02%)
    125μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.94KB) (0.02%)
    102μs
    1 x Before Access::getAssetRules (id:311 name:com_content.category.91) (34.65KB) (0.02%)
    83μs
    1 x beforeRenderRawModule mod_jsvisit_counter (Module jsvisit counter) (3.7KB) (0.01%)
    67μs
    1 x beforeRenderRawModule mod_articles_categories (Shop) (2.21KB) (0.01%)
    60μs
    1 x beforeRenderRawModule mod_icmsocial (Social Links) (2.77KB) (0.01%)
    60μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (2.68KB) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_menu (NavBar) (1.18KB) (0.01%)
    53μs
    1 x beforeRenderRawModule mod_custom (Purchasing) (1.06KB) (0%)
    21μs
    1 x beforeRenderRawModule mod_finder (Smart Search Module) (5.27KB) (0%)
    20μs
    1 x beforeRenderRawModule mod_login (Members) (2.83KB) (0%)
    18μs
    1 x Before Access::preloadPermissions (com_content) (1.95KB) (0%)
    16μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Support) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_login (Members) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_footer (Copyright) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_articles_categories (Shop) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Purchasing) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_jsvisit_counter (Module jsvisit counter) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (NavBar) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_icmsocial (Social Links) (720B) (0%)
    5μs
48 statements were executed, 10 of which were duplicates, 38 unique14.59ms282.98KB
  • SELECT @@SESSION.sql_mode;97μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `mnjcl_session` WHERE `session_id` = ?150μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = :session_id LIMIT 194μ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)508μ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` = 1436μs17.86KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mnjcl_viewlevels`138μ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` = :guest159μ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`623μs5.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `mnjcl_admintools_storage` WHERE `key` = 'cparams'92μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `mnjcl_admintools_wafexceptions`69μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'139μ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;75μs0B/plugins/system/marcosinterceptor/marcosinterceptor.php:53Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.219.194.232' AND `hackcount` >= 368μs536B/plugins/system/marcosinterceptor/marcosinterceptor.php:61Copy
  • SELECT COUNT(*) from `mnjcl_mi_iptable` WHERE ip = '18.219.194.232' AND `hackcount` >= 357μ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`573μs68.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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`368μs3.95KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `mnjcl_languages` WHERE `published` = 1 ORDER BY `ordering` ASC168μs2.84KB/libraries/src/Language/LanguageHelper.php:179Copy
  • 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` = 1272μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • 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)585μs7.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` = 0826μs69.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`422μ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 8572μs22.47KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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)236μ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)285μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `name` FROM `mnjcl_extensions` WHERE `type` = 'package' AND `element` = 'pkg_eventgallery_full'179μ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`429μ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)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC900μs4.81KBParams/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`396μs3.94KBParams/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)294μ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`675μs18.44KBParams/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`,( SELECT COUNT(`i`.`id`) FROM `mnjcl_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` 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`674μs4.03KBParams/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`274μs3.92KBParams/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`257μs6.42KBParams/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`260μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • select SUM(count) from mnjcl_visitors_country177μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mnjcl_visitors_country where count>0113μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mnjcl_visitors_country ORDER BY count DESC LIMIT 5155μs720B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mnjcl_visitors where id = '7'79μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'95μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '1'57μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '1'58μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mnjcl_visitors where id = '7'55μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mnjcl_visitors where id = '7'57μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • SELECT `name`,`element` FROM `mnjcl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 11.26ms672B/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)320μ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` = 1265μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `mnjcl_session` WHERE `session_id` = ?95μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `mnjcl_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?460μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch