Of all the sports activities by members of the Bermuda Police Force, one must surely stand out as the only one in which our team remained unbeaten from start to finish -- and that is Tug o’ War. Here are some reflections on the history of our Police Tug o’ War Team through the eyes of the person who inspired our team to be the best on the Island throughout his time in Bermuda. His name, of course, is Pat McBride.

He might have been a legendary tough guy but even
Pat McBride could exhibit his "feminine" side!
For more details see footnote at the bottom of this article.
 
Early Tug o’ War Notes – 1969
STEADY BOYS STEADY

This article, written by Pat McBride, first appeared in the Police Magazine in 1969

Credit for the introduction of Tug o’ War as a PRC sponsored sport must be placed squarely on the shoulders of that well-known sporting correspondent of the Bermuda Police Magazine, Sergeant “Grim Jim” McNiven.

"Grim" Jim McNiven
 

Casting my mind back a few months, I remember the original proposal for the event coming from a gathering of sporting types at the Police Club on a Saturday evening when the “Grim One” was recalling his days in the British Army and the happy times he spent pulling on ropes!

There then followed a lively discussion by the sporting types on training and pulling techniques, resulting in Sergeant McNiven, with his limited knowledge, declaring that he could train a team to beat any other in the Force …. Tug of War was back!

The first event of any significance was an Inter-Divisional competition held opposite the Gymnasium at Frog Lane on 15th February 1969, when the Central team pulled its way to victory with wins over Dog Section and St. George’s.

They were duly awarded the Ocean Monarch Cup, presented by the Commissioner, Mr. George Robins. To the readers who have been waiting patiently to hear what happened to the McNiven team – well - we can reveal that they went out early, panting and puffing!!

COP George H. Robins presented the
Ocean Monarch Cup to the winners
 

The victorious Central Team that day was Pat McBride, Ray Sousa, Davie Kerr, Mike Parris, Barrie Mancell, John Balsden, Brian Hanney, John Eve, and Inspector Dave Parsons coaching.

The Triumphant Central Division Team
 Standing (l-r) Barrie Mancell, John Balsden, Brian Hanney, John "Cocoa" Eve,
Mike Parris,  Inspector Dave Parson (Coach)
Kneeling (l-r) Ray Sousa, Pat McBride, and Davie Kerr

Shortly afterwards a headline article in the Sports Section of the Royal Gazette read,

"A GRAND OLD SPORT TO BE REVIVED HERE"

The article went on to announce that Tug o’ War was going to return to the Island with the introduction of a competition planned for the 1969 annual Agricultural Exhibition.

Again, Pat McBride takes up the story in another article published in the Police Magazine:

Shortly after (the inter-Divisional Tug o’ War competition) an invitation to enter a Police Team at the Annual Agricultural Show was sent to the PRC. This caused a little consternation because nobody wanted to see the Boys in Blue humbled in a public event such as the Agricultural Show.

At a meeting that followed the invite, P.C. Pat McBride (who had pulled with the Glasgow City Police for four years) was asked if he could raise and train a team that would be good enough for the competition. The answer was a resounding “YES.”

Training started one month before the Show, and the comedians from the Traffic Department had a field day as the potential team strained and heaved to move a pick-up truck (with its hand-brake on); pulled against each other; ran with heavy boots on; lifted telegraph poles above their heads, and sweated on the hill at Prospect (as only yours truly could make them!)

Members of the Tug o' War team fight an uphill battle in training on
the hill at Prospect. Can you assist in identifying the 'tuggers'?
 

They also began to learn teamwork. Come the Show we were as ready as we ever would be.

On the first day of the Show the spectators were treated to the sight of eight giants from the N.O.B. Fire Brigade annihilating the Bermuda Regiment. Inspector Harry Lister, in police uniform, informed Pat that no team on the Island could beat the Brigade (Oh ye of little faith!).

On the second day the Police came on and had a good pull against HMS Malabar, beating them by two pulls to nil. The scene was now set (fat versus fit). Could we overcome the weight advantage which was about two stone (28 pounds) per man?

Saturday came and it was quite obvious which event the crowd wanted to see. Our team was nervous, but not the Motor Cycle Display team and Ian “Baby” Douris who were quick to reach for their wallets when a gentleman shouted, “Twenty pounds on the Brigade!”

At 4 p.m. we strode into the arena like a bunch of schoolboys against our gigantic opponents who were already behaving as if they had won. The team that Spring day was Pat McBride, Gary Perinchief, Davie Kerr, Owen Marsh, Barrie Mancell, Ray Sousa, Mike Parris and Keith Pratt, with Mike Caulkett as coach.

The Boys in Blue taking the strain - with encouragement from George Rushe (front right)
 

By five minutes past four there wasn’t one Police chest which wasn’t bursting with pride, as we walked off with the Shield (after two quick pulls) , leaving the Brigade wondering what had hit them, Deputy Commissioner Frank B. Williams waited outside the arena and shook every man’s hand as the team left the park. Also delighted were the members of the Motor Cycle Display Team (no wonder!)

Victorious Bermuda Police Team - 1969 Agricultural Show Tug o' War Champions 
(l-r) Pat McBride, Davie Kerr, Gary Perinchief, Owen Marsh, Barrie Mancell,
Ray Sousa, Keith Pratt, Mike Caulkett and Mike Parris
 

The following month saw us invited to the Sandys Flower Show where we again lifted the silverware, beating HMS Malabar and the U.S. Marines. The only change to the team was Mike Caulkett pulling and Owen Marsh coaching.

All that’s left now is our contribution to retaining the Commodore’s Cup. So here’s hoping that we can preserve our unbeaten record. A last word of thanks to all the lads who trained so hard. Thanks also to the boys from the barracks who we used as cannon-fodder as the event came closer.

Last but not least a big thank you to Jim McNiven for remembering his Army days!

Pat McBride

Editors Note - The Police Tug o’War team went on to beat all comers for the next seven or eight years. They were a source of great pride within the Force and tremendous goodwill ambassadors.

MORE TUG O’ WAR SNIPPETS

The longest and toughest pull by the Police Tug o’ War Team was at the 1971 Agricultural Show against the Royal Navy ship, HMS Bacchanti. The Police Team won the first pull but the sailors took the second.  However, the second pull certainly seperated the men from the boys, lasting for more than 4 minutes.  This was the toughest competition the Police Team had ever encountered, and in Pat's own words, "that was the day our boys discovered what tug o' war was all about"!

Pat remained confident that the Team would pull off the victory, but just before the deciding pull started he spotted Police Commissioner George Duckett bounding out of the stands and bearing down on the boys. Pat immediately realized that this was not a social visit!   Commissioner Duckett explained to Pat that he had wagered quite a substantial sum on his team winning, and he they lost then the whole gange would be heading west  - transferred to Somerset!

Needless to say the old fighting Police spirit came through and the team handily won the last pull.  When asked if the Commissioner's threat of immediate transfers had any effect on the result, Pat laughed and said that he seriously doubted it because, as soon as the referee called, "Take the strain" he knew by the tension on the rope that the sailors were finished.

Pat also noted that, “A beaming Mr. Duckett was waiting outside the area for us, along with "Gruff" Hammond and Inspector Dave Parsons, and they presented us with a PRC chit for 4 cases of beer."

These two teams were matched against each other at the next Sandys Flower Show but this time the Police coasted to victory by 2 pulls to nil.
Members of the Police Tug o' War Team display their trophies outside the PRC
Standing (l-r)  Barrie Mancell, Keith Pratt, Mike Parris, Alex Arnfield, Graham Maddocks
Seated -  Davie Kerr, Bill Butterworth, Commissioner of Police  George Duckett,
Supt Jim McMaster, Pat McBride, and Andy Lavery

................................................................

In December 1972, Mr. Duckett was again butting heads with the Royal Navy – HMS Glamorgan, one of the guard ships for the Heath-Nixon Talks   The Royal Navy was providing two guard ships for the Summit,  HMS Glamorgan and HMS Phoebe, both of which were berthed on Front Street. Glamorgan had challenged Phoebe to a tug o' war match on the jetty and had beaten the smaller ship 2-0 so they were casting their eyes for bigger fish and had heard about the much vaunted Bermuda Police Team.  Darby Allan, the ship's PTI then challenegd the Police who explained that it was out of season for tug o' war in Bermuda.  He hinted to his Captain that the Police might be a little "windy" of the "Jolly Jack".   This was obviously music to the ears of Commander Baird who promptly issued a challenge to Commissioner Duckett and he even had the temerity to suggest that the Police Team was scared of his ship's team

George Duckett sent back the famous reply shown below accepting the challenge and concluding with the words, “Put your money where your mouth is.”

 

Chief Inspector J.C.P. Hanlon then duly sent the following memo to P.C. McBride making it clear that "The Commissioner instructs that you inform your team, hold practices and win the event!!"

 

The result was another comprehensive victory for the Police Team much to the delight of Commissioner Duckett and the rest of the Police Force.

When Major and Mrs R.L. Johnson, Commanding Officer of the Marine Barracks,  Bermuda was departing the Island he wrote a letter to the Commissioner of Police in which he stated:-

"... Many names and faces will be embedded in our thoughts. Of course with all the seeet must be some bitter.  We never beat your Tug o' War Team.  I still think you import your strong talent.  Please relay to your men my grateful appreciation for the cooperation and professional attitude we received and also in which my Marine have been treated."

.............................................................

Pat points ot that during this time period the Police Team used about 20 men on the rope ALL of whom contributed to the great record and stories.

The old grunt and groaners included:-

Patrick McBride, Keith Pratt, Barrie Mancell, Mike Caulkett, Ray Sousa, Mike Parris, Davie Kerr, Gary Perinchief, Owen Marsh, John Balsden, Steve Bond, Paul Wakefield, Alex Arnfield, Graham Maddocks, Bill Butterworth, Andy Lavery, Eddie Foggo, Mick Richardson, Tony Laughton, Paul Deans, Roger Brydon, Pete Swan. P. Gimson, Dave Cook and Peter Brown.

The coaches included Pat McBride, Mike Caulkett, Mike Parris, and Dave Garland.

The legend lives on!

Editors Notes -   If you have any photographs, or  reminisences of your own involvement in our Tug o' War Team we would be delighted to hear from you.  Photos can be sent in either TIFF or JPEG format by email to info@expobermuda.com 

*   The photo of Pat McBride in "drag" was taken during the time when Bermuda was experiencing a spate of handbag snatches by "diddlybops" from women riding livery cycles.  Both Pat McBride and Tommy Barnes were used as decoys.  To the best of our knowledge neither fell victim to the handbag snatchers although this had nothing to do with the fact that they refused to shave their hairy legs!


 

 

 

 

 

21.497MBMemory Usage251msRequest 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" => "" "DOC...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745846800 "last" => 1745846800...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (34.1ms)
  • afterInitialise (7.21MB) (76.89ms)
  • afterRoute (1.94MB) (25.28ms)
  • beforeRenderComponent com_content (401.38KB) (4.88ms)
  • Before Access::preloadComponents (all components) (483.66KB) (5.13ms)
  • After Access::preloadComponents (all components) (120.02KB) (1.13ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (29μs)
  • After Access::preloadPermissions (com_content) (935.39KB) (3.31ms)
  • Before Access::getAssetRules (id:141 name:com_content.article.91) (34.65KB) (101μs)
  • After Access::getAssetRules (id:141 name:com_content.article.91) (25.52KB) (481μs)
  • afterRenderComponent com_content (3.83MB) (51.6ms)
  • afterDispatch (4.59KB) (391μs)
  • beforeRenderModule mod_custom (Spacer) (312.37KB) (6.53ms)
  • afterRenderRawModule mod_custom (Spacer) (99.21KB) (1.56ms)
  • beforeRenderModule mod_custom (Spacer) (704B) (8μs)
  • afterRenderModule mod_custom (Spacer) (43.19KB) (868μs)
  • beforeRenderModule mod_finder (Smart Search) (648B) (68μs)
  • afterRenderRawModule mod_finder (Smart Search) (480.12KB) (10.77ms)
  • beforeRenderModule mod_finder (Smart Search) (720B) (12μs)
  • afterRenderModule mod_finder (Smart Search) (1.95KB) (189μs)
  • afterRender (1.56MB) (26.58ms)
  • 1 x afterInitialise (7.21MB) (30.66%)
    76.89ms
    1 x afterRenderComponent com_content (3.83MB) (20.57%)
    51.60ms
    1 x afterLoad (3.65MB) (13.6%)
    34.10ms
    1 x afterRender (1.56MB) (10.6%)
    26.58ms
    1 x afterRoute (1.94MB) (10.08%)
    25.28ms
    1 x afterRenderRawModule mod_finder (Smart Search) (480.12KB) (4.3%)
    10.77ms
    1 x beforeRenderModule mod_custom (Spacer) (312.37KB) (2.6%)
    6.53ms
    1 x Before Access::preloadComponents (all components) (483.66KB) (2.05%)
    5.13ms
    1 x beforeRenderComponent com_content (401.38KB) (1.94%)
    4.88ms
    1 x After Access::preloadPermissions (com_content) (935.39KB) (1.32%)
    3.31ms
    1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.62%)
    1.56ms
    1 x After Access::preloadComponents (all components) (120.02KB) (0.45%)
    1.13ms
    1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.35%)
    868μs
    1 x After Access::getAssetRules (id:141 name:com_content.article.91) (25.52KB) (0.19%)
    481μs
    1 x afterDispatch (4.59KB) (0.16%)
    391μs
    1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.08%)
    189μs
    1 x Before Access::getAssetRules (id:141 name:com_content.article.91) (34.65KB) (0.04%)
    101μs
    1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%)
    68μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    29μs
    1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)
    8μs
35 statements were executed, 6 of which were duplicates, 29 unique15.14ms598.69KB
  • SELECT @@SESSION.sql_mode;120μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `dztir_session` WHERE `session_id` = ?139μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 188μ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)320μ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` = 1333μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `dztir_viewlevels`89μ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` = :guest143μ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`633μ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`661μ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`430μ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` = 1303μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC214μ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)675μ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` = 01.29ms137.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `dztir_content`410μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `dztir_content` SET `hits` = (`hits` + 1) WHERE `id` = '91'310μ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)456μs55.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`360μ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)230μ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`463μ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 ASC714μ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 DESC1.79ms21.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`424μ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.03ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1400μ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 = 1114μ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)547μ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)153μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM dztir_igallery ORDER BY parent, ordering340μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
  • SELECT * FROM `dztir_schemaorg` WHERE `itemId` = :itemId AND `context` = :context179μ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)558μs54.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)411μs54.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` = 1216μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?154μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?446μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy