Sidebar

 

When posting this photograph we said there were some outstanding players on this team who should be very familiar to anyone who was following Bermuda football at that time.  We wanted to know which team it was?  Who did they play against? When and where did the match take place?  Who was responsible for arranging the match? How many people in this photo could you identify and what was their connection with the Bermuda Police? And finally,  what was the score?

We have to give Davie Kerr full marks for answering most of our questions, especially naming all of the players.  This was a Bermuda Select Squad who played against English First Division team, Coventry City Football Club, in late Spring of 1967.  For the first time since its inception our Police Recreation Club organized and sponsored this visit by one of England's finest teams where the chairman of Coventry F.C.. Mr. Derrick Robins, happened to be a cousin of our then Commissioner of Police, George Robins.

Our Police team had some great players at that time and three were selected to play along with some of the Island's best players as listed below.  John Barnett was team manager, former policeman Alan Harker was coach, and the three police players were Jack Crane (Captain), Arthur Bean who was a regular member of the national squad for many years, and Alan Keagle as goalkeeper. Also playing in the team was our garage mechanic, Ben Swan. A full report of the match was published in the Summer 1967 edition of the Police Magazine in which in was reported that the Bermuda team had hoped to end to Coventry F.C's string of 30 or so games without defeat prior to their arrival on Island.  The final score was a "rather shattering 8-0 win for Coventry". For a full report on this visit see the article below.

Bermuda Select squad chosen to play Coventry City FC  during their visit in 1967
Back row (l-r) - John Barnett (Police, manager), Ben Swan (Police motorcycle mechanic, Winfield Smith (PHC),
Arthur Bean (Police), Dennis Wainwright (YMSC), Alan Keagle (Police), Noel Symons (PHC),
Gilbert Darrell (Dev Colts), Gladwin Daniels (S'ton Rangers), Alan Harker (former Policeman, coach).
Front row - Guiseppe Cammarotto (Hotels), Jimmy Copeland (St G Colts), Jack Crane (Police, captain),
Doug Clarke (BAA), Kurt Thein (Hotels), Gary Darrell (Dev Colts), Leroy Lewis (PHC).

His Excellency the Governor, Lord Martonmere, shakes hands with
Jack Crane (Captain) with Alan Keagle and Leroy "Nibs" Lewis.
Photos by Ron Wallace.
 
 
Extracts from the Summer 1967 edition of the Police Magazine
 

30th January 2018

Photo of Coventry City FC -  We  received the following photo of Coventry FC from Mike Caulkett. It was believed that it was taken while they were on tour in Bermuda in 1967.  Mike remembered the tour very well (for the most part!) and sent us the following comments:-

"All this talk of Coventry City Football team in Bermuda (Who, When & Where and John Barnett’s Then and Now) reminded me that I had the attached photo and thought you might like to see it. I believe Noel Cantwell was the manager during the visit 

Editors note  - This must have been around the time that Coventry was changing managers because according to the article in the Police Magazine (Summer edition 1967)  Jimmy Hill came on as substitute late in the game, and his teammates tried everything to set him up to score a goal!

In the centre of the front row is George Robins' cousin Derrick Robins, as mentioned elsewhere the then Chairman of Coventry City football Club. 

I couldn’t play football for toffy but, like most teams visiting Bermuda, the players and manager enjoyed a drink, and that’s a game I could play so I spent quite a lot of time with the team in the PRC and elsewhere

I can vaguely remember several valuable members of the team being taken to the airport in a police car which had a slight collision on the way there about which I will make no further comment!  Fortunately,  they all arrived safely at their destination, and oh yes, the car was repaired before the said driver went off duty!"

Editors note -  When we first published this photo from Mike we believed that it was the Coventry City FC team taken on the Police Field Prospect during their visit to Bermuda in in 1967. We knew that the gentleman kneeling with the ball was Derrick Robins, cousin of then COP George Robins, and we enquired if we had any Coventry City FC fans who would like to try naming the Coventry players and staff. We had no responses from our ExPo members but we can now identify all of these players and officials from Coventry City FC thanks to their official historian Jim Brown.   We thought this would be quite straightforward so we were bowled over when Jim advised us that all was not quite what it seemed as you can read below!

Coventry City FC Squad - 1979
Back row (l-r) -  Norman Pilgrim (Physiotherapist), Maurice Setters, George Curtis,
Mick Coop, Bill Glazier, Brian Hill, Jeff Blockley, Chris Cattlin, Noel Cantwell (manager).
Front row: Dietmar Bruck, Trevor Shepherd, Willie Carr, Derrick Robins (Chairman),
Neil Martin, Ernie Hunt, David Clements, Ernie Machin.
 
8th March 2018
UPDATE
 OOPS - WRONG TOUR PHOTO!

For those of you who follow our "Who, When and Where" column you may have already read what we thought were all of the answers to our series of questions except for the names of the Coventry players.

I'm sure we have lots of Coventry City fans in Bermuda but no-one from our ExPo group had tackled trying to name their players in the photo of the Coventry team kindly submitted to us by Mike Caulkett. Mike had made a brief comment to the effect that he believed Noel Cantwell was the Coventry manager during the tour even though our Police Magazine specifically mentioned that Jimmy Hill, their legendary manager, came on as a substitute late in the game at which time his players tried everything to set him up to score a goal. Great manager - not such a great striker!

Before moving onto our next "Who, When and Where" photo I decided to write to Coventry City FC to ask if anyone might assist us in identifying the members of the Coventry team.

It was a lovely surprise, to receive the following information and documents from Jim Brown, their Official Historian, who went above and beyond the call of duty in answering my enquiry. However,  it was a complete surprise to hear from Jim  that the photo of the Coventry City FC team provided to us by Mike Caulkett was NOT the team that visited Bermuda in 1967, but the Coventry team that re-visited the Island 2 years later, in 1969, by which time Noel Cantwell had replaced Jimmy Hill as their manager.  

Mike was correct with regard to his photo being of Coventry City FC, and in all fairness it was taken at our Police Sports Field field, and he did say he thought Noel Cantwell was the Team Manager.  

It is noteworthy that Commissioner George Robins' cousin, Derrick Robins was still Chairman of the Board for this second visit in 1969.

Jim Brown would be very interested in obtaining any programme or team sheets for the match against Somerset which took place on 4th June 1969. If you happen to know of any Coventry fans here on Island, or officials from Somerset Trojans who might be able to assist please let us know.

Once again, many thanks to Jim for all the extra information he has provided to confirm the "Who" the "When" and the "Where" in this article.  


E mail letter dated 7th March 1028
From Jim Brown
To: Roger Sherratt


Dear Roger

I've now had a proper chance to read the article on your website and study the picture.

The facts about the game in 1967 are absolutely correct from my point of view. The game was played on 18th June 1967, one of several games Coventry played in the Caribbean on a tour celebrating winning the Second Division championship in May.

The Coventry team picture was not taken then, but two years later when Coventry returned to the island. Noel Cantwell had replaced Jimmy Hill as manager in October 1967 and on 4th June 1969 they played a friendly game against Somerset which ended 1-1.

The Coventry line up is as follows: Back row: Norman Pilgrim (Physiotherapist), Maurice Setters, George Curtis, Mick Coop, Bill Glazier, Brian Hill, Jeff Blockley, Chris Cattlin, Noel Cantwell (manager).

Front row: Dietmar Bruck, Trevor Shepherd, Willie Carr, Derrick Robins (Chairman), Neil Martin, Ernie Hunt, David Clements, Ernie Machin.

I am attaching a scan of the complete programme for the 1967 game which may be of interest. I would be very interested in seeing any produced for the 1969 game as I have never seen a programme or team sheet.

Hope this helps

Kind regards
Jim Brown
Official Historian
Coventry City FC

 

 


 

 

 

 

 

21.407MBMemory Usage267msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.28
Identityguest
Response200
Templatepurity_iii
Database
Server
mysql
Version
10.6.21-MariaDB-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:58 [ "CONTEXT_DOCUMENT_ROOT" => "/home/bermyxpo/public_html" "CONTEXT_PREFIX" => "/~bermyx...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746103605 "last" => 1746103605...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (35.07ms)
  • afterInitialise (7.21MB) (82.39ms)
  • afterRoute (1.94MB) (25.79ms)
  • beforeRenderComponent com_content (401.41KB) (5.04ms)
  • Before Access::preloadComponents (all components) (483.66KB) (5.31ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.46ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (32μs)
  • After Access::preloadPermissions (com_content) (935.88KB) (4.21ms)
  • Before Access::getAssetRules (id:750 name:com_content.article.637) (34.65KB) (120μs)
  • After Access::getAssetRules (id:750 name:com_content.article.637) (25.52KB) (497μs)
  • afterRenderComponent com_content (3.79MB) (55.18ms)
  • afterDispatch (4.6KB) (408μs)
  • beforeRenderModule mod_custom (Spacer) (312.63KB) (7.75ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (1.61ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (10μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (898μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (99μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.21KB) (12.24ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (14μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (197μs)
  • afterRender (1.55MB) (28.01ms)
  • 1 x afterInitialise (7.21MB) (30.83%)
    82.39ms
    1 x afterRenderComponent com_content (3.79MB) (20.65%)
    55.18ms
    1 x afterLoad (3.65MB) (13.12%)
    35.07ms
    1 x afterRender (1.55MB) (10.48%)
    28.01ms
    1 x afterRoute (1.94MB) (9.65%)
    25.79ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.21KB) (4.58%)
    12.24ms
    1 x beforeRenderModule mod_custom (Spacer) (312.63KB) (2.9%)
    7.75ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (1.99%)
    5.31ms
    1 x beforeRenderComponent com_content (401.41KB) (1.89%)
    5.04ms
    1 x After Access::preloadPermissions (com_content) (935.88KB) (1.57%)
    4.21ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.6%)
    1.61ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.55%)
    1.46ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.34%)
    898μs
    1 x After Access::getAssetRules (id:750 name:com_content.article.637) (25.52KB) (0.19%)
    497μs
    1 x afterDispatch (4.6KB) (0.15%)
    408μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.07%)
    197μs
    1 x Before Access::getAssetRules (id:750 name:com_content.article.637) (34.65KB) (0.04%)
    120μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.04%)
    99μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0.01%)
    14μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    10μs
35 statements were executed, 6 of which were duplicates, 29 unique20.52ms502.69KB
  • SELECT @@SESSION.sql_mode;148μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?185μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 1134μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `dztir_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)349μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `dztir_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1449μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`136μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `dztir_usergroups` AS `a` LEFT JOIN `dztir_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest204μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `dztir_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`926μs3.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 `dztir_menu` AS `m` LEFT JOIN `dztir_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`866μs52.67KBParams/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 `dztir_categories` AS `s` INNER JOIN `dztir_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`526μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `dztir_template_styles` AS `s` LEFT JOIN `dztir_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` = 1359μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC231μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `dztir_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)957μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `dztir_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.09ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`730μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '637'356μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_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)539μs23.38KBParams/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 `dztir_categories` AS `s` INNER JOIN `dztir_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`476μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `dztir_contentitem_tag_map` AS `m` INNER JOIN `dztir_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)297μs3.95KBParams/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 `dztir_categories` AS `s` INNER JOIN `dztir_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`553μs3.89KBParams/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 dztir_fields AS a LEFT JOIN `dztir_languages` AS l ON l.lang_code = a.language LEFT JOIN dztir_users AS uc ON uc.id=a.checked_out LEFT JOIN dztir_viewlevels AS ag ON ag.id = a.access LEFT JOIN dztir_users AS ua ON ua.id = a.created_user_id LEFT JOIN dztir_fields_groups AS g ON g.id = a.group_id LEFT JOIN `dztir_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (: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 ASC922μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC2.89ms21.69KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `dztir_categories` AS `s` INNER JOIN `dztir_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`445μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `dztir_modules` AS `m` LEFT JOIN `dztir_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `dztir_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`1.6ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1574μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT f.data, f.params FROM `dztir_finder_filters` AS f WHERE f.filter_id = 1140μs592B/administrator/components/com_finder/src/Indexer/Query.php:514Copy
  • SELECT t1.id, t1.title, t2.title AS branch FROM `dztir_finder_taxonomy` AS t1 LEFT JOIN `dztir_finder_taxonomy` AS t2 ON t2.lft < t1.lft AND t1.rgt < t2.rgt AND t2.level = 1 WHERE t1.state = 1 AND t1.access IN (1) AND t1.id IN (4,39,57,58,59,60,74,41,46,66,67,71,43,47,49,50,51,52,61,62,63,64,65,68,72,69,70,73,75) AND t2.state = 1 AND t2.access IN (1)867μs1.13KB/administrator/components/com_finder/src/Indexer/Query.php:566Copy
  • SELECT `title` FROM `dztir_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)198μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering483μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context269μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_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)586μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `dztir_content` AS `a` INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_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)360μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `dztir_scheduler_tasks` AS `a` WHERE `a`.`state` = 1166μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?152μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?361μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy