Today's 70s Song You Should Know: 'Dancing In The Moonlight' By Boffalongo

Today's 70s Song You Should Know: 'Dancing In The Moonlight' By Boffalongo

Even in the one-hit wonder rich era of the 1970s, the King Harvest hit "Dancing In The Moonlight" was something memorable. It was recorded as a single by the band in 1972 and released as a single in France, but they couldn't interest a label in the song. The band disbanded six months later and more than year after the song was recorded, it was picked up Perception Records, a small label that mostly specialized in jazz and R&B releases.

"Dancing In The Moonlight" eventually went to #13 on the Billboard American Top 40 chart and #5 on Canada's RPM chart. The band recorded an album to accompany the single, but it peaked at #134 on the album charts. And after a follow-up album in 1974 (with a slightly different lineup), King Harvest was no more.

But this version of the song was actually the second time the song had been recorded.

It had been written in 1970 by Sean Kelly, who was a member of an upstate New York band named Boffalongo. He wrote the song while recovering from a vicious assault by a gang:

On a trip to St. Croix in 1969, I was the first victim of a vicious St. Croix gang who eventually murdered 8 American tourists. At that time, I suffered multiple facial fractures and wounds and was left for dead. While I was recovering, I wrote "Dancin In The Moonlight" in which I envisioned an alternate reality, the dream of a peaceful and joyful celebration of life. The song became a huge hit and was recorded by many musicians worldwide. "Dancin In The Moonlight" continues to be popular to this day.

In 1971 I ran a night club called "The Grass Shack" in St. Thomas Virgin Islands with Alex Brooks, Larry Hoppen, Bob Leinbach, Milton Jay, Wells Kelly, Paul Lisseck and Bobby Simone, the former road manager for the Mama's & The Papa's, and a host of other friends. After that, I joined a band named "Boffolongo" with Larry Hoppen (later of Orleans) and my brother Wells. My original version of "Dancin In The Moonlight" was on the Boffolongo album "Beyond Your Head" released in 1970, which featured my brother Wells on drums and Larry Hoppen on guitar and myself on lead vocal.

A year later, Wells Kelly was in Paris playing drums in King Harvest, along with former Boffalongo member Dave "Doc" Robinson, who was the band's lead vocalist, bassist, and keyboardist.

When King Harvest broke up, Wells Kelly went on to be a founding member of Orleans while Sean Kelly struggled with health problems:

Roughly a year later in 1973, while meditating with Maharishi Mahesh Yogi at a teacher training course in Spain, I was notified that my old Cornell friends in the band "King Harvest" had a big hit with "Dancin' in the Moonlight". They invited me to join the group and tour in support of the hit record. Later that year we recorded an album that was never released until 2007 entitled "King Harvest: The Lost Tapes" featuring 5 songs that I wrote or co-wrote and on which I played and sang.

After having toured with King Harvest, I settled down in the Ithaca NY area in 1974. I had some less than successful low back surgery that took me out of commission for many years. I continued to write songs, frequently collaborating with my brother, Wells, who was a brilliant musician. Wells performed and recorded with many great musicians including "Al Kooper", "The Beach Boys", "Bonnie Raitt" and many others. He was a founding member of the group "Orleans" and played and recorded with them for years. During Wells's tenure with the band, I also co-wrote several songs for "Orleans". After his tragic death in 1984, I found it too painful to work on music and pursued other interests. I received a Masters degree in Social Work and Psychotherapy from Syracuse University. For many years, I have been employed as a social worker/psychotherapist.

The Boffalongo version of "Dancing In The Moonlight" is breezy and fun, but you can also see why it wasn't a hit. The King Harvest version is a bit more-stripped down and doesn't include as much jazzy doodling as the original version. But the original is worth hearing and it's a fun look at what might have been.

Today's 70s Song You Should Know: 'Dancing In The Moonlight' By Boffalongo
Watch the video

Even in the one-hit wonder rich era of the 1970s, the King Harvest hit "Dancing In The Moonlight" was something memorable. It was recorded as a single by the band in 1972 and released as a single in France, but they couldn't interest a label in the song. The band disbanded six months later and more than year after the song was recorded, it was picked up Perception Records, a small label that mostly specialized in jazz and R&B releases.

"Dancing In The Moonlight" eventually went to #13 on the Billboard American Top 40 chart and #5 on Canada's RPM chart. The band recorded an album to accompany the single, but it peaked at #134 on the album charts. And after a follow-up album in 1974 (with a slightly different lineup), King Harvest was no more.

But this version of the song was actually the second time the song had been recorded.

It had been written in 1970 by Sean Kelly, who was a member of an upstate New York band named Boffalongo. He wrote the song while recovering from a vicious assault by a gang:

On a trip to St. Croix in 1969, I was the first victim of a vicious St. Croix gang who eventually murdered 8 American tourists. At that time, I suffered multiple facial fractures and wounds and was left for dead. While I was recovering, I wrote "Dancin In The Moonlight" in which I envisioned an alternate reality, the dream of a peaceful and joyful celebration of life. The song became a huge hit and was recorded by many musicians worldwide. "Dancin In The Moonlight" continues to be popular to this day.

In 1971 I ran a night club called "The Grass Shack" in St. Thomas Virgin Islands with Alex Brooks, Larry Hoppen, Bob Leinbach, Milton Jay, Wells Kelly, Paul Lisseck and Bobby Simone, the former road manager for the Mama's & The Papa's, and a host of other friends. After that, I joined a band named "Boffolongo" with Larry Hoppen (later of Orleans) and my brother Wells. My original version of "Dancin In The Moonlight" was on the Boffolongo album "Beyond Your Head" released in 1970, which featured my brother Wells on drums and Larry Hoppen on guitar and myself on lead vocal.

A year later, Wells Kelly was in Paris playing drums in King Harvest, along with former Boffalongo member Dave "Doc" Robinson, who was the band's lead vocalist, bassist, and keyboardist.

When King Harvest broke up, Wells Kelly went on to be a founding member of Orleans while Sean Kelly struggled with health problems:

Roughly a year later in 1973, while meditating with Maharishi Mahesh Yogi at a teacher training course in Spain, I was notified that my old Cornell friends in the band "King Harvest" had a big hit with "Dancin' in the Moonlight". They invited me to join the group and tour in support of the hit record. Later that year we recorded an album that was never released until 2007 entitled "King Harvest: The Lost Tapes" featuring 5 songs that I wrote or co-wrote and on which I played and sang.

After having toured with King Harvest, I settled down in the Ithaca NY area in 1974. I had some less than successful low back surgery that took me out of commission for many years. I continued to write songs, frequently collaborating with my brother, Wells, who was a brilliant musician. Wells performed and recorded with many great musicians including "Al Kooper", "The Beach Boys", "Bonnie Raitt" and many others. He was a founding member of the group "Orleans" and played and recorded with them for years. During Wells's tenure with the band, I also co-wrote several songs for "Orleans". After his tragic death in 1984, I found it too painful to work on music and pursued other interests. I received a Masters degree in Social Work and Psychotherapy from Syracuse University. For many years, I have been employed as a social worker/psychotherapist.

The Boffalongo version of "Dancing In The Moonlight" is breezy and fun, but you can also see why it wasn't a hit. The King Harvest version is a bit more-stripped down and doesn't include as much jazzy doodling as the original version. But the original is worth hearing and it's a fun look at what might have been.

8.638MBMemory Usage158msRequest Duration
Joomla! Version4.4.4
PHP Version8.1.31
Identityguest
Response200
Templateja_blockk
Database
Server
mysql
Version
8.0.39-cll-lve
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743264275 "last" => 1743264275...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (8.38ms)
  • afterInitialise (1.27MB) (31.92ms)
  • afterRoute (281.69KB) (15.67ms)
  • beforeRenderComponent com_content (38.54KB) (1.35ms)
  • Before Access::preloadComponents (all components) (34.7KB) (997μs)
  • After Access::preloadComponents (all components) (109.3KB) (1.5ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (16μs)
  • After Access::preloadPermissions (com_content) (2.38MB) (10.15ms)
  • Before Access::getAssetRules (id:4610 name:com_content.article.3776) (130.8KB) (208μs)
  • After Access::getAssetRules (id:4610 name:com_content.article.3776) (8.47KB) (186μs)
  • beforeRenderRawModule mod_related_items (Read More) (854.05KB) (30.63ms)
  • afterRenderRawModule mod_related_items (Read More) (40.94KB) (11.15ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (17μs)
  • afterRenderModule mod_related_items (Read More) (1.92KB) (248μs)
  • afterRenderComponent com_content (43.41KB) (100μs)
  • afterDispatch (2.28KB) (340μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (23.98ms)
  • afterRenderRawModule mod_menu (Newsletters) (15.96KB) (568μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (5μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (198μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (47μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (120μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (4μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (89μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (70μs)
  • afterRenderRawModule mod_finder (Head Search) (67.99KB) (3.48ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (5μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (189μs)
  • beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (42μs)
  • afterRenderRawModule mod_custom (Lead Info) (3.87KB) (332μs)
  • beforeRenderModule mod_custom (Lead Info) (720B) (6μs)
  • afterRenderModule mod_custom (Lead Info) (2.38KB) (89μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (42μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (105μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (104μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (32μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (99μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (90μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (21μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (139μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (88μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.22ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (2.52ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (6μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (104μs)
  • afterRender (681.13KB) (10.16ms)
  • 1 x afterInitialise (1.27MB) (20.21%)
    31.92ms
    1 x beforeRenderRawModule mod_related_items (Read More) (854.05KB) (19.39%)
    30.63ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (15.18%)
    23.98ms
    1 x afterRoute (281.69KB) (9.92%)
    15.67ms
    1 x afterRenderRawModule mod_related_items (Read More) (40.94KB) (7.06%)
    11.15ms
    1 x afterRender (681.13KB) (6.43%)
    10.16ms
    1 x After Access::preloadPermissions (com_content) (2.38MB) (6.43%)
    10.15ms
    1 x afterLoad (528.29KB) (5.3%)
    8.38ms
    1 x afterRenderRawModule mod_finder (Head Search) (67.99KB) (2.2%)
    3.48ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.55KB) (1.6%)
    2.52ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.95%)
    1.50ms
    1 x beforeRenderComponent com_content (38.54KB) (0.85%)
    1.35ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.77%)
    1.22ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.63%)
    997μs
    1 x afterRenderRawModule mod_menu (Newsletters) (15.96KB) (0.36%)
    568μs
    1 x afterDispatch (2.28KB) (0.22%)
    340μs
    1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.21%)
    332μs
    1 x afterRenderModule mod_related_items (Read More) (1.92KB) (0.16%)
    248μs
    1 x Before Access::getAssetRules (id:4610 name:com_content.article.3776) (130.8KB) (0.13%)
    208μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.13%)
    198μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    189μs
    1 x After Access::getAssetRules (id:4610 name:com_content.article.3776) (8.47KB) (0.12%)
    186μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.09%)
    139μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.08%)
    120μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.45KB) (0.07%)
    105μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.07%)
    104μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.07%)
    104μs
    1 x afterRenderComponent com_content (43.41KB) (0.06%)
    100μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    99μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    90μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.06%)
    89μs
    1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.06%)
    89μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    88μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.04%)
    70μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    47μs
    1 x beforeRenderRawModule mod_custom (Lead Info) (1.91KB) (0.03%)
    42μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (392B) (0.03%)
    42μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    17μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    4μs
46 statements were executed, 3 of which were duplicates, 43 unique35.14ms407.21KB
  • SELECT @@SESSION.sql_mode;143μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?210μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 198μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tvlfg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)925μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tvlfg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1430μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`116μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tvlfg_usergroups` AS `a` LEFT JOIN `tvlfg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest218μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tvlfg_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`784μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'318μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC201μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='3776-todays-70s-song-you-should-know-dancing-in-the-moonlight-by-boffalongo' AND published=1226μs4.08KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352Copy
  • 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 `tvlfg_menu` AS `m` LEFT JOIN `tvlfg_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`635μs20.92KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_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`685μs5.33KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tvlfg_template_styles` AS `s` LEFT JOIN `tvlfg_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` = 1317μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_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)698μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tvlfg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 04.66ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.77ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '3776'466μs48B/libraries/src/Table/Table.php:1325Copy
  • 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 `tvlfg_content` AS `a` INNER JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tvlfg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_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)474μs24.63KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`691μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tvlfg_contentitem_tag_map` AS `m` INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)1.56ms5.27KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`491μs5.17KBParams/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 tvlfg_fields AS a LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id LEFT JOIN `tvlfg_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC410μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) 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.58ms2.08KBParams/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 `tvlfg_categories` AS `s` INNER JOIN `tvlfg_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`626μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT u.id, u.name, u.username, u.params FROM tvlfg_users AS u LEFT JOIN tvlfg_user_usergroup_map AS g ON g.user_id = u.id WHERE u.id = '51' GROUP BY u.id138μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'144μs856B/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:467Copy
  • SELECT profile_key, profile_value FROM tvlfg_user_profiles WHERE user_id = 51 AND profile_key LIKE 'profile.%' ORDER BY ordering137μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.5ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid162μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `tvlfg_usergroups` AS `g` INNER JOIN `tvlfg_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid157μs1.7KBParams/libraries/src/Table/User.php:132Copy
  • 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 tvlfg_fields AS a LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC455μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'92μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5183μs856B/plugins/system/t4/src/t4/MVC/Router/T4.php:288Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tvlfg_modules` AS `m` LEFT JOIN `tvlfg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tvlfg_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.13ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id112μs1.63KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:88Copy
  • SELECT `a`.`id` FROM `tvlfg_content` AS `a` WHERE ( ( (`a`.`id` != :id AND `a`.`state` = 1 AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`metakey` LIKE :preparedArray3 OR `a`.`metakey` LIKE :preparedArray4 OR `a`.`metakey` LIKE :preparedArray5)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 59.22ms1.77KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1469μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `tvlfg_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)198μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration225μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'125μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field126μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'105μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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 `tvlfg_scheduler_tasks` AS `a` WHERE `a`.`state` = 1153μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?140μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.55ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy