Liberal Democrat Performance on Large Councils, May 2022

Professor John Curtice[i] provides an impeccable analysis of the 2022 local elections and indicates where the Liberal Democrats did well. He sets out the performance in the various regions and in the social make-up of councils but the one vital statistic that he omits is the party’s lamentable performance in the big cities. The significant generic difference between these councils and the smaller boroughs and districts is the size of the individual electoral wards. Essentially, the larger the electorate the more difficult it is to win by sheer intensive local campaigning and the more significant is the party’s core vote. In wards with 10,000 or more electors Liberal Democrats need an opinion poll level of far more than the 10% that was the average between the advent of Liz Truss as Prime Minister and her resignation. (The implosion of the Conservative party under Truss did not benefit the Liberal Democrats at all.) The table below shows the pitiful state of Liberal Democrat representation on large councils and its poor performance at the 2022 elections.

Councils with over 300,000 population

Council

Population

2021 Census

2022 gains & losses

Total no. of Councillors

Number of Lib Dem Cllrs

Average
Electorate
per ward

Birmingham

1,144,900

+4

101

12

 †8250

Leeds

    812,000

-1

  99

  7

 16500

Sheffield

    556,500

0

  84

29

 11000

Manchester

    552,858

0

  96

  2

 12000

Bradford

    546,400

-1

  90

  6

 12000

Liverpool

    486,100

n/a

  90

12

 11500

*Bristol

    472,400

n/a

  70

  8

 14500

Coventry

    345,300

0

  54 

  0

 12500

*Leicester

    368,300

0

  54

  1

 12000

Wakefield

    353,300

+1

  63

  3

 11500

Sandwell

    341,900

0

  72

  0

   8000

Wigan

    329,300

0

  66

  0

 10000

*Nottingham

    323 700

n/a

  55

  0

 11000

Wirral

    320,300

0

  66

  6

 11000

Doncaster

    308,100

n/a

  55

  0

 12000

Newcastle

    300,200

+1

  78

21

   7000

Total

 

+4

1193

107

 

* Unitary Authority (the others are metropolitan boroughs.)

† Birmingham has 32 single member wards and 37 double members wards; the figure is electors per Councillor.

N/a: no elections in 2022.

We see that a quarter of the sixteen councils have no Liberal Democrat representation at all, three others have three or fewer councillors and only four have a group in double figures. Looking at these latter four councils in more detail demonstrates that the position is even worse than these overall figures indicate. One would expect that being relatively the more successful would mean that they have a powerful citywide presence, but, in practice, what prospects for expansion do they have? What one finds is depressing. In Birmingham of the 59 wards without party representation, one double member ward is split between Labour and Liberal but only one other can be regarded as marginal. In fact, apart from one further double member ward, the rest have derisory votes.

Of the seventeen unrepresented Sheffield wards only two can be regarded as marginal. In Liverpool, from the most recent (2021) figures, only one is marginal leaving 20 wards with derisory votes, plus one with a respectable by-election result. In Newcastle two are marginal, with 15 derisory. What this indicates is the abject lack of a core vote in the country’s major cities. As I know from my twenty year experience in Leeds, without a much higher basic Liberal Democrat vote, the task of establishing a party presence, or of expanding an existing one, requires a huge level of sacrificial, financial and organisational commitment over a number of years. Essentially, unless one can hold seats relatively easily it is impossible to expand without a much higher core vote. And without a powerful and noticeable municipal presence in these front line cities, the prospect of developing a sufficient vote in four or more adjoining wards to win a parliamentary seat is remote.

The difference in the task in the city with the largest wards and a rural county seat is shown in the experience of my former Leeds colleague, David Selby. In his final victory in Leeds, in 1987, he polled 3092 votes to win the Armley ward; in 2017 he gained the Newtown ward for the Powys county council with just 369 votes. He is now a key member of a Liberal Democrat led Powys administration.

If we examine the situation in London we find precisely the same situation. In the 32 London Boroughs, apart from the three stand out boroughs, Kingston, Richmond and Sutton, where the Liberal Democrats have eliminated the Labour party and have maximised the Liberal Democrat vote to gain and retain control, only two have representation in double figures: the adjacent Merton and Southwark, the latter represented in parliament for 27 years by Simon Hughes. In the whole of London, Liberal Democrats have just 152 councillors out of a total of 1817 - and no less than 118 of these are in the three councils they control. Taking the same cut off figure of 300,000 population as in the cities outside London, half those fourteen London Boroughs have zero Liberal Democrat representation and only Southwark has a group in double figures. The semi-proportional electoral system used for the Greater London Authority has enabled a party presence of two to survive and Caroline Pidgeon has done a remarkable job of maintaining a Liberal Democrat presence but a party cannot claim to be national, nor to be a serious political presence, with such minimal representation in its capital city, nor similarly in almost all of the country’s major cities. Above all it is its derisory votes in the vast majority of these electoral wards, along with its scores of lost deposits at parliamentary elections, that are an embarrassment.

Unless the Liberal Democrats understand and accept its absence in these urban areas and apply themselves to establishing a clearly identifiable philosophical position that attracts many “movers and shakers” it has no chance of being able to challenge for any semblance of national political influence. In particular it cannot pose a significant challenge to the Labour party in its strongholds. It is rigorous thinking, plus the “vision thing” and its application, that is needed, not Dr Pangloss.

[i][i] The Liberal Democrat performance in the 2022 local elections, Journal of Liberal History 116: Autumn 2022

9.37MBMemory Usage359msRequest Duration
Joomla! Version4.4.4
PHP Version8.2.14
Identityguest
Response200
Templatetp_advocat
Database
Server
mysql
Version
10.11.11-MariaDB
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:54 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744134512 "last" => 1744134512...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (447.52KB) (4.5ms)
  • afterInitialise (1.11MB) (28.31ms)
  • afterRoute (812.92KB) (15ms)
  • beforeRenderComponent com_content (44.26KB) (2.7ms)
  • Before Access::preloadComponents (all components) (40.91KB) (1.35ms)
  • After Access::preloadComponents (all components) (114.14KB) (1.56ms)
  • Before Access::preloadPermissions (com_content) (1.66KB) (26μs)
  • After Access::preloadPermissions (com_content) (335.15KB) (2.03ms)
  • Before Access::getAssetRules (id:883 name:com_content.article.435) (18.65KB) (49μs)
  • After Access::getAssetRules (id:883 name:com_content.article.435) (7.06KB) (141μs)
  • afterRenderComponent com_content (2.27MB) (58.43ms)
  • afterDispatch (192.95KB) (5.52ms)
  • Before Access::getAssetRules (id:16 name:com_menus) (1.27MB) (52ms)
  • After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (65μs)
  • beforeRenderRawModule mod_tags_popular (Filter articles by topic) (6.27KB) (178μs)
  • afterRenderRawModule mod_tags_popular (Filter articles by topic) (57.38KB) (13.69ms)
  • beforeRenderModule mod_tags_popular (Filter articles by topic) (736B) (16μs)
  • afterRenderModule mod_tags_popular (Filter articles by topic) (7.63KB) (578μs)
  • beforeRenderRawModule mod_menu (In this section... ) (64B) (2.15ms)
  • afterRenderRawModule mod_menu (In this section... ) (4.9KB) (1.88ms)
  • beforeRenderModule mod_menu (In this section... ) (720B) (12μs)
  • afterRenderModule mod_menu (In this section... ) (2.82KB) (210μs)
  • beforeRenderRawModule mod_tags_popular (Filter by topic:) (80B) (603μs)
  • afterRenderRawModule mod_tags_popular (Filter by topic:) (17.02KB) (11.92ms)
  • beforeRenderModule mod_tags_popular (Filter by topic:) (720B) (74μs)
  • afterRenderModule mod_tags_popular (Filter by topic:) (6.1KB) (236μs)
  • beforeRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (720B) (1.75ms)
  • afterRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (15.53KB) (1.7ms)
  • beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (736B) (11μs)
  • afterRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (3.79KB) (169μs)
  • beforeRenderRawModule mod_search (My search for top menu) (496B) (639μs)
  • afterRenderRawModule mod_search (My search for top menu) (31.91KB) (2.32ms)
  • beforeRenderModule mod_search (My search for top menu) (720B) (12μs)
  • afterRenderModule mod_search (My search for top menu) (4.84KB) (231μs)
  • beforeRenderRawModule mod_menu (Main Menu Mobile) (1KB) (404μs)
  • afterRenderRawModule mod_menu (Main Menu Mobile) (9.16KB) (4.27ms)
  • beforeRenderModule mod_menu (Main Menu Mobile) (720B) (13μs)
  • afterRenderModule mod_menu (Main Menu Mobile) (10.02KB) (207μs)
  • afterRender (459.7KB) (143ms)
  • 1 x afterRender (459.7KB) (39.83%)
    142.92ms
    1 x afterRenderComponent com_content (2.27MB) (16.28%)
    58.43ms
    1 x Before Access::getAssetRules (id:16 name:com_menus) (1.27MB) (14.49%)
    52.00ms
    1 x afterInitialise (1.11MB) (7.89%)
    28.31ms
    1 x afterRoute (812.92KB) (4.18%)
    15.00ms
    1 x afterRenderRawModule mod_tags_popular (Filter articles by topic) (57.38KB) (3.82%)
    13.69ms
    1 x afterRenderRawModule mod_tags_popular (Filter by topic:) (17.02KB) (3.32%)
    11.92ms
    1 x afterDispatch (192.95KB) (1.54%)
    5.52ms
    1 x afterLoad (447.52KB) (1.25%)
    4.50ms
    1 x afterRenderRawModule mod_menu (Main Menu Mobile) (9.16KB) (1.19%)
    4.27ms
    1 x beforeRenderComponent com_content (44.26KB) (0.75%)
    2.70ms
    1 x afterRenderRawModule mod_search (My search for top menu) (31.91KB) (0.65%)
    2.32ms
    1 x beforeRenderRawModule mod_menu (In this section... ) (64B) (0.6%)
    2.15ms
    1 x After Access::preloadPermissions (com_content) (335.15KB) (0.57%)
    2.03ms
    1 x afterRenderRawModule mod_menu (In this section... ) (4.9KB) (0.52%)
    1.88ms
    1 x beforeRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (720B) (0.49%)
    1.75ms
    1 x afterRenderRawModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (15.53KB) (0.47%)
    1.70ms
    1 x After Access::preloadComponents (all components) (114.14KB) (0.44%)
    1.56ms
    1 x Before Access::preloadComponents (all components) (40.91KB) (0.38%)
    1.35ms
    1 x beforeRenderRawModule mod_search (My search for top menu) (496B) (0.18%)
    639μs
    1 x beforeRenderRawModule mod_tags_popular (Filter by topic:) (80B) (0.17%)
    603μs
    1 x afterRenderModule mod_tags_popular (Filter articles by topic) (7.63KB) (0.16%)
    578μs
    1 x beforeRenderRawModule mod_menu (Main Menu Mobile) (1KB) (0.11%)
    404μs
    1 x afterRenderModule mod_tags_popular (Filter by topic:) (6.1KB) (0.07%)
    236μs
    1 x afterRenderModule mod_search (My search for top menu) (4.84KB) (0.06%)
    231μs
    1 x afterRenderModule mod_menu (In this section... ) (2.82KB) (0.06%)
    210μs
    1 x afterRenderModule mod_menu (Main Menu Mobile) (10.02KB) (0.06%)
    207μs
    1 x beforeRenderRawModule mod_tags_popular (Filter articles by topic) (6.27KB) (0.05%)
    178μs
    1 x afterRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (3.79KB) (0.05%)
    169μs
    1 x After Access::getAssetRules (id:883 name:com_content.article.435) (7.06KB) (0.04%)
    141μs
    1 x beforeRenderModule mod_tags_popular (Filter by topic:) (720B) (0.02%)
    74μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (0.02%)
    65μs
    1 x Before Access::getAssetRules (id:883 name:com_content.article.435) (18.65KB) (0.01%)
    49μs
    1 x Before Access::preloadPermissions (com_content) (1.66KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_tags_popular (Filter articles by topic) (736B) (0%)
    16μs
    1 x beforeRenderModule mod_menu (Main Menu Mobile) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_menu (In this section... ) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_search (My search for top menu) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs Advanced) (736B) (0%)
    11μs
113 statements were executed, 89 of which were duplicates, 24 unique52.48ms538.07KB
  • SELECT @@SESSION.sql_mode;100μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jto7c_session` WHERE `session_id` = ?124μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jto7c_session` WHERE `session_id` = :session_id LIMIT 1117μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jto7c_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)279μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jto7c_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1758μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jto7c_viewlevels`110μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jto7c_usergroups` AS `a` LEFT JOIN `jto7c_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest207μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jto7c_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`2.21ms3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `jto7c_menu` AS `m` LEFT JOIN `jto7c_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`2.71ms165.17KBParams/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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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`607μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `jto7c_content` WHERE `alias` = :alias AND `catid` = :catid277μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT `template`,`id`,`title`,`params`,`home` FROM `jto7c_template_styles` WHERE `id`='36'137μs768B/libraries/astroid/framework/library/astroid/Template.php:223Copy
  • SELECT * FROM `jto7c_languages` WHERE `published` = 1 ORDER BY `ordering` ASC174μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jto7c_template_styles` AS `s` LEFT JOIN `jto7c_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` = 1462μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jto7c_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)1.03ms7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jto7c_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.02ms29.48KBParams/libraries/src/Access/Access.php:301Copy
  • 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 `jto7c_content` AS `a` INNER JOIN `jto7c_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jto7c_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jto7c_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jto7c_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jto7c_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) 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 (:preparedArray1,:preparedArray2)573μs23.42KBParams/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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`507μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jto7c_contentitem_tag_map` AS `m` INNER JOIN `jto7c_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)1.64ms3.98KBParams/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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`661μs3.91KBParams/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 jto7c_fields AS a LEFT JOIN `jto7c_languages` AS l ON l.lang_code = a.language LEFT JOIN jto7c_users AS uc ON uc.id=a.checked_out LEFT JOIN jto7c_viewlevels AS ag ON ag.id = a.access LEFT JOIN jto7c_users AS ua ON ua.id = a.created_user_id LEFT JOIN jto7c_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jto7c_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) 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 ASC1.51ms4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM jto7c_categories WHERE id=40285μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34181μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40163μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34205μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40156μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34172μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40190μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34180μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40166μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34154μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40143μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34152μs5.5KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40134μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34152μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40143μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34174μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40156μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34188μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40184μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34160μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40248μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34175μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40213μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34164μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40156μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34142μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40130μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34214μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40144μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34150μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40134μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34135μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40153μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34146μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40148μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34155μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40146μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34125μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40124μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34123μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40121μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34122μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40143μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34161μs14KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40127μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34123μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40123μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34138μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40166μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34159μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40136μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34179μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40136μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34145μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40154μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34142μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40172μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34126μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40162μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34138μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40176μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34149μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40140μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34152μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40162μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34159μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40135μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34125μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40157μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34187μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40139μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34129μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40122μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34168μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40131μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34153μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40127μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34122μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40184μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34160μs3KB/plugins/content/articletool/articletool.php:239Copy
  • SELECT * FROM jto7c_categories WHERE id=40180μs3KB/plugins/content/articletool/articletool.php:234Copy
  • SELECT * FROM jto7c_categories WHERE id=34138μs3KB/plugins/content/articletool/articletool.php:239Copy
  • 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 `jto7c_categories` AS `s` INNER JOIN `jto7c_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`594μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `params` FROM `jto7c_categories` WHERE `id`=40112μs536B/libraries/astroid/framework/library/astroid/Article.php:677Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jto7c_modules` AS `m` LEFT JOIN `jto7c_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jto7c_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)) 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`2.92ms1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`tag_id`,`a`.`count`,`a`.`title`,`a`.`access`,`a`.`alias`,`a`.`language` FROM ( SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `jto7c_contentitem_tag_map` AS `m` INNER JOIN `jto7c_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `jto7c_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `jto7c_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `jto7c_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray2) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 70) AS `a` ORDER BY `a`.`title` ASC LIMIT 709.56ms2.16KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `a`.`tag_id`,`a`.`count`,`a`.`title`,`a`.`access`,`a`.`alias`,`a`.`language` FROM ( SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `jto7c_contentitem_tag_map` AS `m` INNER JOIN `jto7c_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `jto7c_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `jto7c_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `jto7c_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray2) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 70) AS `a` ORDER BY `a`.`title` ASC LIMIT 7010.39ms2.16KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `alias` FROM `jto7c_content` WHERE `id` = :id190μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jto7c_content` WHERE `id` = :id128μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `jto7c_scheduler_tasks` AS `a` WHERE `a`.`state` = 1262μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jto7c_session` WHERE `session_id` = ?146μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jto7c_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?238μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy