Too Much TV: Your TV Talking Points For Tuesday, February 20th, 2024

Here's everything you need to know about the world of television for Tuesday, February 20th, 2024.

IF CONTENT IS KING, THEN AD-TECH IS THE KING'S CASTLE
After a few weeks of rumors, Walmart announced today it plans to acquire Irvine, Calif.-based consumer electronics manufacturer Vizio in a deal worth about $2.3 billion.

Now, Walmart might be Vizio's biggest customer but that's not the reason why this deal happened. It took place because Walmart is expanding its advertising business and Vizio’s SmartCast Operating System (OS) - which is what Vizio uses on its smart TV and other devices - currently has 18 million active accounts. Walmart plans to to roll that account information into Walmart Connect, the retailer’s closed-loop omnichannel media business and use the data as a way to reach and target across its massive customer base.

While this might not sound like a television story at first glance, the merger is being done for the same reason why Tubi asks customers to create a free account in order to "personalize" its service. Collecting data - and being able to attribute to a specific household - is incredibly important and it's the reason why digital advertising is becoming such a revenue driver.

With the addition of Vizio's viewing data, Walmart connect can create non-personally identifiable profiles that include an email address, IP address, location, shopping data along with other information gathered from outside sources. It allows Walmart to market directly to its customers in a way that can be highly lucrative.

And the average person has no idea how much money is in play with digital advertising. Digital advertising is a much higher-margin business than the retail sales business (or most traditional media businesses), which is why Walmart is estimating it will soon be making more revenue selling digital advertising across its retail and digital platforms that it will in store sales.

And that's the second part of this for Walmart. It's not just that Hoovering up as much customer data as possible makes its core business more effective. Having that first-person data about tens of millions of households allows the company to sell increasingly targeted digital advertising to anyone who will pay the price.

Developing that first-person customer relationship is perhaps the most important thing any media business can do right now. Being able to somehow connect email and IP info with viewing data and credit card information opens up all sorts of new ways to monetize the customer relationship.

That is why some streamers don't want to be associated with Amazon Channels. Because while streamers do nab some new subscription money, Amazon is the one who has access to the specific customer data. In fact, Disney head Bob Iger has frequently argued in recent months that developing that first-person relationship allows Disney to sell to a customer directly and by targeting them with marketing and advertising pitches tailored to their previous behavior across the Disney network.

As streamers continue to launch ad-supported tiers, there is a tendency to focus on how much advertising gets sold and whether an ad-supported option brings in new subscribers. But it's also about trying to figure out new ways to develop and expand customer relationships. 

And that question colors every big media deal these days. One of the biggest challenges for that proposed sports app (which I am increasingly convinced may never happen) is deciding how the ad tech rolls out advertising on the platform and how the customer data is shared across the partner's very different ad-tech systems. 

It's also the lesser-covered part of every conversation that involves revenue from an ad-supported tier. It's not just how any subscribers you can garner for your service. Revenue is also tied into how well the ad-delivery technology does the job of matching viewers to the specific demographics desired by an advertiser. Generally speaking, the more accuracy, the higher CPM (cost per thousand views) the platform can charge.

The digital advertising business isn't one that is all that familiar to most TV critics and industry analysts. But it's hard to find a part of the TV industry that isn't impacted by advertising and how data is collected and used.

SPEAKING OF NEWS THAT DOESN'T MEAN WHAT YOU THINK IT DOES
Disney announced today that it is licensing its films to Sony for the manufacture, distribution and marketing of DVDs, Blu-ray Discs, and 4K Ultra HD Blu-rays. 

The deal includes both new releases and catalog titles, which Sony will sell and distribute through retailers and distributors throughout the North American market. 

There has been a lot of whining today about Disney exiting physical media and how it's the end of an era.

But as anyone who still buys physical media can tell you, Disney's Home Entertainment division has been less than aggressive in recent years with its releases. Many popular titles don't get a 4K release and much of the packaging just seems thrown together.

So I don't think this move is all that big of a deal. The arrangement is similar to the deal Universal Pictures Home Entertainment and Warner Bros. Discovery Home Entertainment have with their joint venture, SDS. That company distributes the physical media products while each studio’s home entertainment division retains control over marketing, promotions and publicity.

That will be the case here, with Sony handling the manufacturing, distribution and sales of the physical media. While Disney is responsible for the PR and marketing.

AND ABOUT THAT SPORTS-CENTRIC APP
You could write a medium-length novella recounting all the reasons why that proposed Disney/Fox/Warner Bros. Discovery proposed sports-centric app is in trouble. 

The latest problem comes from Fubo TV, which has filed a lawsuit claiming the three companies have colluded to shut out competitors:

“Instead of competition, Defendants have chosen collusion — giving their own cartel, and no one else, the ability to market and sell a live-sports-centric package,” FuboTV alleges in the lawsuit. “They have thus ensured that their combined entity will not face effective competition. They are now harming, and threaten further harm, to United States competition and consumers."

FuboTV has a couple of good points. First, it's easy to see a scenario in which this new joint venture might be able to get exclusive access to games and channels rivals such as Fubo wouldn't be able to license at a competitive price.

But I suspect it's also driven by Fubo's desire to unbundle each company's entertainment channels from their sports networks. Currently, FuboTV is forced to take a number of entertainment and news channels it doesn't want in order to get the sports networks it needs to be a sports-oriented streamer. Removing those channels would allow it to drop the cost to consumers and get its price down closer to the $45-50 a month range that the new sports JV is reported to be considering.

And that might be the biggest consequence of this proposed JV. As things stand now, each of the big media companies forces vMVPD's, cable and satellite systems to take an entire bundle of often useless channels in order to get the smaller number of core networks most consumers want. 

If Disney, Fox and Warner Bros. Discovery are forced to unbundle their networks when they sell their programming to rivals, you are going to see some massively different lineups on some platforms.

ODDS AND SODS
* David Katzenberg will helm a spinoff of Ferris Bueller’s Day Off for Paramount. Produced by the creators of Cobra Kai, Sam and Victor’s Day Off will follow the valets from the original 1986 John Hughes film.

* I review the really interesting documentary Becoming King, which premiered yesterday on Paramount+

WHAT'S NEW TONIGHT AND TOMORROW

TUESDAY, FEBRUARY 20TH:
* American Experience: Fly With Me (PBS)
* Crime Nation Series Premiere (The CW)
* Little People, Big World Season Premiere (TLC)
* Mike Epps: Ready To Sell Out (Netflix)
* Quantum Leap Season Two Finale (NBC)
* Renovation Aloha Series Premiere (HGTV)
* Risqué Business: Netherlands & Germany Series Premiere (Netflix)
* The Good Doctor Season Premiere (ABC)
* The Rookie Season Premiere (ABC)
* Will Trent Season Premiere (ABC)

WEDNESDAY, FEBRUARY 21ST:
* Can I Tell You A Secret? Series Premiere (Netflix)
* Constellation Series Premiere (Apple TV+)
* Criminal Record Season One Finale (Apple TV+)
* Dolly Parton's Pet Gala (CBS)
* Messi’s World Cup: The Rise Of A Legend (Apple TV+)
* Pawn Stars Season Premiere (History)
* Pawn Stars Do America Season Premiere (History)
* Star Wars: The Bad Batch Season Premiere (Disney+)
* The Family Stallone Season Two Premiere (Paramount+)

SEE YOU ON WEDNESDAY!

Follow me on Twitter: @aysrick
Follow me on Threads:
Follow me on Bluesky:

8.636MBMemory Usage178msRequest 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" => 1743293132 "last" => 1743293132...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.94ms)
  • afterInitialise (1.27MB) (52.86ms)
  • afterRoute (227.03KB) (6.84ms)
  • beforeRenderComponent com_content (38.16KB) (882μs)
  • Before Access::preloadComponents (all components) (34.7KB) (972μs)
  • After Access::preloadComponents (all components) (109.3KB) (773μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (18μs)
  • After Access::preloadPermissions (com_content) (2.38MB) (8.29ms)
  • Before Access::getAssetRules (id:2151 name:com_content.article.1327) (130.8KB) (145μs)
  • After Access::getAssetRules (id:2151 name:com_content.article.1327) (8.47KB) (186μs)
  • beforeRenderRawModule mod_related_items (Read More) (846.12KB) (36.88ms)
  • Before Access::getAssetRules (id:8 name:com_content) (81.09KB) (2.96ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (18μs)
  • afterRenderRawModule mod_related_items (Read More) (13.55KB) (5.14ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (4.07KB) (244μs)
  • afterRenderComponent com_content (43.56KB) (126μs)
  • afterDispatch (3.53KB) (331μs)
  • beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (31.52ms)
  • afterRenderRawModule mod_menu (Newsletters) (14.71KB) (760μs)
  • beforeRenderModule mod_menu (Newsletters) (720B) (7μs)
  • afterRenderModule mod_menu (Newsletters) (1.89KB) (242μs)
  • beforeRenderRawModule mod_menu (Other Content) (712B) (62μs)
  • afterRenderRawModule mod_menu (Other Content) (944B) (165μs)
  • beforeRenderModule mod_menu (Other Content) (720B) (6μs)
  • afterRenderModule mod_menu (Other Content) (1.3KB) (137μs)
  • beforeRenderRawModule mod_finder (Head Search) (1.94KB) (106μs)
  • afterRenderRawModule mod_finder (Head Search) (66.49KB) (3.93ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (8μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (207μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (73μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (375μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (120μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (28μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (101μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (5μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (121μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (28μs)
  • afterRenderRawModule mod_menu (Off Canvas) (944B) (153μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (1.28KB) (109μs)
  • beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (1.52ms)
  • afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (3.35ms)
  • beforeRenderModule mod_menu (magazine-menu-3) (720B) (8μs)
  • afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (137μs)
  • afterRender (681.13KB) (11.89ms)
  • 1 x afterInitialise (1.27MB) (29.66%)
    52.86ms
    1 x beforeRenderRawModule mod_related_items (Read More) (846.12KB) (20.69%)
    36.88ms
    1 x beforeRenderRawModule mod_menu (Newsletters) (355.27KB) (17.69%)
    31.52ms
    1 x afterRender (681.13KB) (6.67%)
    11.89ms
    1 x After Access::preloadPermissions (com_content) (2.38MB) (4.65%)
    8.29ms
    1 x afterRoute (227.03KB) (3.84%)
    6.84ms
    1 x afterLoad (528.66KB) (3.33%)
    5.94ms
    1 x afterRenderRawModule mod_related_items (Read More) (13.55KB) (2.88%)
    5.14ms
    1 x afterRenderRawModule mod_finder (Head Search) (66.49KB) (2.2%)
    3.93ms
    1 x afterRenderRawModule mod_menu (magazine-menu-3) (116.6KB) (1.88%)
    3.35ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (81.09KB) (1.66%)
    2.96ms
    1 x beforeRenderRawModule mod_menu (magazine-menu-3) (55.45KB) (0.85%)
    1.52ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.55%)
    972μs
    1 x beforeRenderComponent com_content (38.16KB) (0.49%)
    882μs
    1 x After Access::preloadComponents (all components) (109.3KB) (0.43%)
    773μs
    1 x afterRenderRawModule mod_menu (Newsletters) (14.71KB) (0.43%)
    760μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.21%)
    375μs
    1 x afterDispatch (3.53KB) (0.19%)
    331μs
    1 x afterRenderModule mod_related_items (Read More) (4.07KB) (0.14%)
    244μs
    1 x afterRenderModule mod_menu (Newsletters) (1.89KB) (0.14%)
    242μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.12%)
    207μs
    1 x After Access::getAssetRules (id:2151 name:com_content.article.1327) (8.47KB) (0.1%)
    186μs
    1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.09%)
    165μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.09%)
    153μs
    1 x Before Access::getAssetRules (id:2151 name:com_content.article.1327) (130.8KB) (0.08%)
    145μs
    1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.08%)
    137μs
    1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.08%)
    137μs
    1 x afterRenderComponent com_content (43.56KB) (0.07%)
    126μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.07%)
    121μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (4.82KB) (0.07%)
    120μs
    1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.06%)
    109μs
    1 x beforeRenderRawModule mod_finder (Head Search) (1.94KB) (0.06%)
    106μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    101μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (864B) (0.04%)
    73μs
    1 x beforeRenderRawModule mod_menu (Other Content) (712B) (0.03%)
    62μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    18μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Other Content) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique43.1ms541.95KB
  • SELECT @@SESSION.sql_mode;155μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?16.35ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 1103μ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)272μ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` = 1698μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`108μ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` = :guest189μ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`725μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'417μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC141μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1156μs4.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`378μ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`267μs5.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` = 1194μ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)481μ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` = 03.2ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.76ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1327'394μ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)466μ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`374μ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)1.91ms5.25KBParams/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`992μ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 ASC447μ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.69ms58.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`487μ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.id144μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'154μ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 ordering162μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.34ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid166μ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` = :muserid186μ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 ASC441μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'100μ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`810μs2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id151μ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)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2) LIMIT 5859μs1.85KBParams/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.1ms89.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)2.1ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1446μ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)191μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration259μ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_field88μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'86μ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` = 1146μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?143μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?473μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy