Too Much TV: Your TV Talking Points For Monday, August 19th, 2024

Here's everything you need to know about the world of television for Monday, August 19th, 2024:

THE DEPARTMENT OF FOLLOW-UPS
About an hour after I sent out Friday's newsletter, I was able to significantly update the story about the most recent round of layoffs at The Hollywood Reporter and if you didn't see it over the weekend, you can check it out here.

Also, there is a lot of talk today about the long-awaited addition of Homicide: Life On The Street to the world of streaming. Long-time readers of this newsletter will remember this story, which tells a crazy tale about charges of plagiarism against then-new TV producer John Wells:

In June 1992, writer David Simon issued a statement through his lawyer claiming that the upcoming CBS drama Polish Hill contained an "astonishing number of similarities" to his 1991 book "Homicide: A Year On The Killing Streets."

The book was a non-fiction account of Baltimore murder investigators and he and producer Barry Levinson had been working on a series based on the book. But according to Simon, entire accounts, dialogue and characters were lifted from his book by Polish Hill screenwriter John Wells. Simon said he learned of the similarities when Levinson began searching for a writer to work on the pilot for a proposed series based on his book.

It's just a crazy story and while there was eventually a settlement, it's not clear what terms might have been negotiated.

REMEMBERING PHIL DONAHUE
I have complicated feelings about Phil Donahue. His daytime talker was a fixture on television when I was younger and in a lot of ways, he seemed to embody the man I wanted to become: smart, kind, intellectually curious and interested in hearing people's stories - no matter what they might be.

But Phil Donahue is also the subject of my first really big national media story. When Donahue's MSNBC talker was canceled, I was able to report about the contentious behind-the-scenes battles about the direction of the show. And the results of a focus group which found that his show was seen by viewers as being "un-American" because he was opposed to the war in Iraq:

Although Donahue didn't know it at the time, his fate was sealed a number of weeks ago after NBC News executives received the results of a study commissioned to provide guidance on the future of the news channel.

That report--shared with me by an NBC news insider--gives an excruciatingly painful assessment of the channel and its programming. Some of the recommendations, such as dropping the "America's News Channel," have already been implemented. But the harshest criticism was leveled at Donahue, whom the authors of the study described as "a tired, left-wing liberal out of touch with the current marketplace."

The study went on to claim that Donahue presented a "difficult public face for NBC in a time of war......He seems to delight in presenting guests who are anti-war, anti-Bush and skeptical of the administration's motives." The report went on to outline a possible nightmare scenario where the show becomes "a home for the liberal antiwar agenda at the same time that our competitors are waving the flag at every opportunity."

It's a strange experience today to see so many stories about that MSNBC show reference my reporting, without mentioning who broke the story. But as a reporter, it's rewarding to break a story that people still discuss more than twenty years later.

DEADLINE GETS SOME FACTS ABOUT STREAMING, DRAWS THE WRONG TAKEAWAY
Samba TV just released a new State of Viewership Report, and I was going to write about it. But to be honest, I don't think there was anything in there you probably didn't know already. Churn across the industry is up, except at Netflix. And why is Netflix doing so much better when it comes to keeping its subscriber churn rate low? Here's what Deadline's Katie Campione writes:

Samba’s data shows that viewers are generally invested in a specific piece of content, choosing to leave the platform after they’ve finished watching. The only exception to this is Netflix, which is unsurprising given that the streamer has proven highly effective at using its algorithm to draw users to new content and keep them engaged on the platform. It’s a tool that many of the newer platforms have yet to perfect.

Yes, Netflix has a fairly effective content recommendation engine. But Netflix executives will tell you that something else is the big driver for the streamer when it comes to low churn rates. And the hint comes in the next two paragraphs of the story:

Netflix had the lowest level of churn and also represented 60% of the Top 50 shows in the first half of the year with series like Fool Me Once, Griselda, American Nightmare, Bridgerton and The Gentlemen in the Top 10.

Elsewhere, subscription cyclers come back for buzzy new shows, Samba says, including Peacock’s Ted, AppleTV’s Masters of the Air, and FX’s Shōgun, which aired in Hulu and Disney+. New seasons of House of the Dragon (the second most-popular premiere of the half, behind Fool Me Once), True Detective, and Reacher were also a big draw.

Subscribers want to be able to log on and find something new or at least unfamiliar every time they open the app. It might be a new scripted series, or a sports documentary or a dating show. But having new original content - as much as possible - reduces the subscriber churn rate.

The problem is that cranking out that much original programming is expensive. And while Netflix isn't spending some huge multiples on money more than its competitors, it is also not spending a big percentage of its content budget on sports. It's great that Peacock has all of this live sports programming, but every dollar spent on sports is one less dollar that can be used on everything else. And while live sports will bring in fans, the sports rights are expensive and they are basically disposable. The game streams and its over. As compared to episodes of any scripted or non-scripted series, which can be viewed for years after the premiere.

And to be honest, that is one of the reasons why Netflix has not pursued a large sports rights package more aggressively. Because ultimately that money comes out of the programming budget and it can't continue to produce thousands of hours of original programming every year also pay for the NFL or NBA.

And then there is this takeaway some people in the industry got from reading the article: 

TWEET OF THE DAY



I understand why people in the industry want to return to longer seasons like there were in the golden years of broadcast television. But that's not an economic model that works in the streaming business, for a number of reasons I've outlined in this newsletter in the past. And there's nothing in the Samba data that would support longer seasons as a way to reduce churn. But it's one of those pieces of conventional industry wisdom that people just refuse to believe.

ODDS AND SODS
* In an op-ed for The NY Times, MSNBC's Rachel Maddow writes about what worries her most about election night.

* Esquire's Josh Rosenberg asks the burning question: why do all Netflix shows look the same?

* Japan's exports of anime and other content are close to parity with steel and semiconductor devices. Which explains a lot about the success of Crunchyroll.

* Atlantic takes a look at Anna Marie Tendler's new book Men Have Called Her Crazy. And while she's probably legally prevented from discussing her ex-husband John Mulaney, it's pretty clear he is one of the men referenced in the book's title.

* Disney+ has canceled the Star Wars universe original series The Acolyte after one season. Which is not a huge surprise, given the critical response and the viewer numbers.

WHAT'S NEW TONIGHT AND TOMORROW

MONDAY, AUGUST 19TH:
* CoComelon Lane (Netflix)
* PBS News Special: Democratic National Convention (PBS)
* The Anonymous Series Premiere (USA)
* Under The Vines (Acorn TV)

TUESDAY, AUGUST 20TH:
* Divided By Design Series Premiere (HGTV)
* Face To Face With Scott Peterson (Peacock)
* Langston Kerman: Bad Poetry (Netflix)
* Muslim Matchmaker Series Premiere (Hulu)
* Spiral Season Eight Premiere (MHz Choice)
* Terror Tuesday: Extreme (Netflix)
* TouTouYouTou Series Premiere (MHz Choice)
* Untold: The Murder Of Air McNair (Netflix)


SEE YOU ON TUESDAY!


8.643MBMemory Usage451msRequest 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" => 1743466564 "last" => 1743466564...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.29KB) (23.25ms)
  • afterInitialise (1.27MB) (197ms)
  • afterRoute (227.03KB) (24.53ms)
  • beforeRenderComponent com_content (38.63KB) (1.4ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.2ms)
  • After Access::preloadComponents (all components) (109.3KB) (1.65ms)
  • Before Access::preloadPermissions (com_content) (3.91KB) (20μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (13.72ms)
  • Before Access::getAssetRules (id:3096 name:com_content.article.2267) (130.8KB) (314μs)
  • After Access::getAssetRules (id:3096 name:com_content.article.2267) (8.47KB) (243μs)
  • beforeRenderRawModule mod_related_items (Read More) (844.21KB) (105ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (13.44ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (24μs)
  • afterRenderRawModule mod_related_items (Read More) (14.41KB) (7.13ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (13μs)
  • afterRenderModule mod_related_items (Read More) (3.82KB) (274μs)
  • afterRenderComponent com_content (43.25KB) (94μs)
  • afterDispatch (3.53KB) (359μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (32.79ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (759μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (6μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (243μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (54μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (175μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (5μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (122μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (100μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (4.57ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (10μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (252μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (83μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (474μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (7μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (141μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (29μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (123μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (132μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (34μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (178μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (122μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.53ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.53ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (9μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (135μs)
  • afterRender (685.13KB) (14.2ms)
  • 1 x afterInitialise (1.27MB) (43.71%)
    197.15ms
    1 x beforeRenderRawModule mod_related_items (Read More) (844.21KB) (23.37%)
    105.39ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (7.27%)
    32.79ms
    1 x afterRoute (227.03KB) (5.44%)
    24.53ms
    1 x afterLoad (528.29KB) (5.15%)
    23.25ms
    1 x afterRender (685.13KB) (3.15%)
    14.20ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (3.04%)
    13.72ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.66KB) (2.98%)
    13.44ms
    1 x afterRenderRawModule mod_related_items (Read More) (14.41KB) (1.58%)
    7.13ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (1.01%)
    4.57ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (0.78%)
    3.53ms
    1 x After Access::preloadComponents (all components) (109.3KB) (0.36%)
    1.65ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.34%)
    1.53ms
    1 x beforeRenderComponent com_content (38.63KB) (0.31%)
    1.40ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.27%)
    1.20ms
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.17%)
    759μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.11%)
    474μs
    1 x afterDispatch (3.53KB) (0.08%)
    359μs
    1 x Before Access::getAssetRules (id:3096 name:com_content.article.2267) (130.8KB) (0.07%)
    314μs
    1 x afterRenderModule mod_related_items (Read More) (3.82KB) (0.06%)
    274μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.06%)
    252μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.05%)
    243μs
    1 x After Access::getAssetRules (id:3096 name:com_content.article.2267) (8.47KB) (0.05%)
    243μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.04%)
    178μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.04%)
    175μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.03%)
    141μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.03%)
    135μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.03%)
    132μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.03%)
    123μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.03%)
    122μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.03%)
    122μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.02%)
    100μs
    1 x afterRenderComponent com_content (43.25KB) (0.02%)
    94μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.02%)
    83μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.01%)
    34μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.01%)
    29μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0%)
    20μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0%)
    13μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique184ms566.01KB
  • SELECT @@SESSION.sql_mode;1.15ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?200μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 14.08ms1.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)52.1ms944BParams/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` = 13.8ms2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`269μ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` = :guest5.33ms1.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`8.71ms3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'28.82ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC584μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=11.49ms4.09KB/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`5.33ms20.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`3.48ms5.14KBParams/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` = 1290μ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)710μ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` = 06.23ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`2.42ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '2267'19.32ms48B/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)1.2ms24.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`723μs5.19KBParams/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)2.44ms5.23KBParams/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`592μs5.19KBParams/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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC562μ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 DESC2.91ms58.03KBParams/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`696μs5.19KBParams/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.id203μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'195μ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 ordering215μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.57ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid569μ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` = :muserid602μ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 ASC693μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'197μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=51164μ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`2.71ms2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id514μ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)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 52.39ms1.82KBParams/modules/mod_related_items/src/Helper/RelatedItemsHelper.php:152Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language` FROM `tvlfg_content` AS `a` LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC1.49ms113.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_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 `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7)3.21ms5.53KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1533μ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)233μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration377μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'177μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field278μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'153μ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` = 1207μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?204μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?13.3ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy