96th Oscars Announces Shortlists In 10 Awards Categories

The Academy of Motion Picture Arts and Sciences today announced shortlists in 10 categories for the 96th Academy Awards: Documentary Feature Film, Documentary Short Film, International Feature Film, Makeup and Hairstyling, Music (Original Score), Music (Original Song), Animated Short Film, Live Action Short Film, Sound and Visual Effects.

DOCUMENTARY FEATURE FILM
Fifteen films will advance in the Documentary Feature Film category for the 96th Academy Awards.  One hundred sixty-seven films were eligible in the category.  Members of the Documentary Branch vote to determine the shortlist and the nominees.

The films, listed in alphabetical order by title, are:

“American Symphony”
“Apolonia, Apolonia”
“Beyond Utopia”
“Bobi Wine: The People’s President”
“Desperate Souls, Dark City and the Legend of Midnight Cowboy”
“The Eternal Memory”
“Four Daughters”
“Going to Mars: The Nikki Giovanni Project”
“In the Rearview”
“Stamped from the Beginning”
“Still: A Michael J. Fox Movie”
“A Still Small Voice”
“32 Sounds”
“To Kill a Tiger”
“20 Days in Mariupol”

DOCUMENTARY SHORT FILM
Fifteen films will advance in the Documentary Short Film category for the 96th Academy Awards.  One hundred fourteen films qualified in the category.  Members of the Documentary Branch vote to determine the shortlist and the nominees.

The films, listed in alphabetical order by title, are:

“The ABCs of Book Banning”
“The Barber of Little Rock”
“Bear”
“Between Earth & Sky”
“Black Girls Play: The Story of Hand Games”
“Camp Courage”
“Deciding Vote”
“How We Get Free”
“If Dreams Were Lightning: Rural Healthcare Crisis”
“Island in Between”
“The Last Repair Shop”
“Last Song from Kabul”
“Nǎi Nai & Wài Pó”
“Oasis”
“Wings of Dust”

INTERNATIONAL FEATURE FILM
Fifteen films will advance to the next round of voting in the International Feature Film category for the 96th Academy Awards.  Films from 88 countries and regions were eligible in the category.

Academy members from all branches were invited to participate in the preliminary round of voting and must have met a minimum viewing requirement to be eligible to vote in the category.

In the nominations round, Academy members from all branches are invited to opt in to participate and must view all 15 shortlisted films to vote.

The films, listed in alphabetical order by country, are:

Armenia, “Amerikatsi”
Bhutan, “The Monk and the Gun”
Denmark, “The Promised Land”
Finland, “Fallen Leaves”
France, “The Taste of Things”
Germany, “The Teachers’ Lounge”
Iceland, “Godland”
Italy, “Io Capitano”
Japan, “Perfect Days”
Mexico, “Totem”
Morocco, “The Mother of All Lies”
Spain, “Society of the Snow”
Tunisia, “Four Daughters”
Ukraine, “20 Days in Mariupol”
United Kingdom, “The Zone of Interest”

MAKEUP AND HAIRSTYLING 
Ten films will advance in the Makeup and Hairstyling category for the 96th Academy Awards.  All members of the Academy’s Makeup Artists and Hairstylists Branch will be invited to view excerpts and interviews with the artists from each of the shortlisted films on Sunday, January 14, 2024.  Branch members will vote to nominate five films for final Oscar® consideration.

The films, listed in alphabetical order by title, are:

“Beau Is Afraid”
“Ferrari”
“Golda”
“Killers of the Flower Moon”
“The Last Voyage of the Demeter”
“Maestro”
“Napoleon”
“Oppenheimer”
“Poor Things”
“Society of the Snow”

MUSIC (ORIGINAL SCORE)
Fifteen scores will advance in the Original Score category for the 96th Academy Awards.  One hundred forty-eight scores were eligible in the category.  Members of the Music Branch vote to determine the shortlist and the nominees.

The scores, listed in alphabetical order by film title, are:

“American Fiction”
“American Symphony”
“Barbie”
“The Boy and the Heron”
“The Color Purple”
“Elemental”
“The Holdovers”
“Indiana Jones and the Dial of Destiny”
“Killers of the Flower Moon”
“Oppenheimer”
“Poor Things”
“Saltburn”
“Society of the Snow”
“Spider-Man: Across the Spider-Verse”
“The Zone of Interest”

MUSIC (ORIGINAL SONG)
Fifteen songs will advance in the Original Song category for the 96th Academy Awards.  Ninety-four songs were eligible in the category.  Members of the Music Branch vote to determine the shortlist and the nominees.

The original songs, along with the motion picture in which each song is featured, are listed below in alphabetical order by film title:

“It Never Went Away” from “American Symphony”
“Dear Alien (Who Art In Heaven)” from “Asteroid City”
“Dance The Night” from “Barbie”
“I’m Just Ken” from “Barbie”
“What Was I Made For?” from “Barbie”
“Keep It Movin’” from “The Color Purple”
“Superpower (I)” from “The Color Purple”
“The Fire Inside” from “Flamin’ Hot”
“High Life” from “Flora and Son”
“Meet In The Middle” from “Flora and Son”
“Can’t Catch Me Now” from “The Hunger Games: The Ballad of Songbirds & Snakes”
“Wahzhazhe (A Song For My People)” from “Killers of the Flower Moon”
“Quiet Eyes” from “Past Lives”
“Road To Freedom” from “Rustin”
“Am I Dreaming” from “Spider-Man: Across the Spider-Verse”

ANIMATED SHORT FILM
Fifteen films will advance in the Animated Short Film category for the 96th Academy Awards.  Ninety-three films qualified in the category.  Members of the Short Films and Feature Animation Branch vote to determine the shortlist and the nominees.

The films, listed in alphabetical order by title, are:

“Boom”
“Eeva”
“Humo (Smoke)”
“I’m Hip”
“A Kind of Testament”
“Koerkorter (Dog Apartment)”
“Letter to a Pig”
“Ninety-Five Senses”
“Once upon a Studio”
“Our Uniform”
“Pachyderme”
“Pete”
“27”
“War Is Over! Inspired by the Music of John & Yoko”
“Wild Summon”

LIVE ACTION SHORT FILM
Fifteen films will advance in the Live Action Short Film category for the 96th Academy Awards.  One hundred eighty-seven films qualified in the category.  For the first time, Academy members from all branches were invited to participate in the preliminary round of voting and must have met a minimum viewing requirement to be eligible to vote in the category.

In the nominations round, Academy members from all branches are invited to opt in to participate and must view all 15 shortlisted films to vote.

The films, listed in alphabetical order by title, are:

“The After”
“The Anne Frank Gift Shop”
“An Avocado Pit”
“Bienvenidos a Los Angeles”
“Dead Cat”
“Good Boy”
“Invincible”
“Invisible Border”
“Knight of Fortune”
“The One Note Man”
“Red, White and Blue”
“The Shepherd”
“Strange Way of Life”
“The Wonderful Story of Henry Sugar”
“Yellow”

SOUND
Ten films will advance in the Sound category for the 96th Academy Awards.  All eligible members of the Sound Branch vote to determine the shortlist and the nominees.  Academy members will be invited to view excerpts from each of the shortlisted films beginning Thursday, January 11, 2024, in the San Francisco Bay area, followed by London, Los Angeles and New York.  Branch members will vote to nominate five films for final Oscar consideration.

The films, listed in alphabetical order by title, are:

“Barbie”
“The Creator”
“Ferrari”
“The Killer”
“Killers of the Flower Moon”
“Maestro”
“Mission: Impossible – Dead Reckoning Part One”
“Napoleon”
“Oppenheimer”
“The Zone of Interest”

VISUAL EFFECTS
Ten films remain in the running in the Visual Effects category for the 96th Academy Awards.  The Visual Effects Branch Executive Committee determined the shortlist.  All members of the Visual Effects Branch will be invited to view excerpts and interviews with the artists from each of the shortlisted films on Saturday, January 13, 2024.  Branch members will vote to nominate five films for final Oscar consideration.

The films, listed in alphabetical order by title, are:

“The Creator”
“Godzilla Minus One”
“Guardians of the Galaxy Vol. 3”
“Indiana Jones and the Dial of Destiny”
“Mission: Impossible – Dead Reckoning Part One”
“Napoleon”
“Poor Things”
“Rebel Moon – Part One: A Child of Fire”
“Society of the Snow”
“Spider-Man: Across the Spider-Verse”

Nominations voting begins on Thursday, January 11, 2024, and concludes on Tuesday, January 16, 2024.

Nominations for the 96th Academy Awards will be announced on Tuesday, January 23, 2024.

The 96th Oscars will be held on Sunday, March 10, 2024, at the Dolby® Theatre at Ovation Hollywood and will be televised live on ABC and in more than 200 territories worldwide.

8.646MBMemory Usage195msRequest 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" => 1743469029 "last" => 1743469029...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (528.66KB) (5.61ms)
  • afterInitialise (1.27MB) (27.37ms)
  • afterRoute (226.77KB) (8.14ms)
  • beforeRenderComponent com_content (44.03KB) (1.13ms)
  • Before Access::preloadComponents (all components) (34.7KB) (1.02ms)
  • After Access::preloadComponents (all components) (109.26KB) (877μs)
  • Before Access::preloadPermissions (com_content) (3.91KB) (24μs)
  • After Access::preloadPermissions (com_content) (2.39MB) (9.45ms)
  • Before Access::getAssetRules (id:1852 name:com_content.article.1029) (130.8KB) (22.24ms)
  • After Access::getAssetRules (id:1852 name:com_content.article.1029) (8.47KB) (222μs)
  • beforeRenderRawModule mod_related_items (Read More) (841.13KB) (31ms)
  • Before Access::getAssetRules (id:8 name:com_content) (79.37KB) (11.68ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (32μs)
  • afterRenderRawModule mod_related_items (Read More) (5.37KB) (4.48ms)
  • beforeRenderModule mod_related_items (Read More) (704B) (10μs)
  • afterRenderModule mod_related_items (Read More) (3.2KB) (201μs)
  • afterRenderComponent com_content (42.35KB) (89μs)
  • afterDispatch (3.53KB) (246μs)
  • beforeRenderRawModule mod_finder (Head Search) (356.66KB) (25.27ms)
  • afterRenderRawModule mod_finder (Head Search) (68.57KB) (30.61ms)
  • beforeRenderModule mod_finder (Head Search) (720B) (11μs)
  • afterRenderModule mod_finder (Head Search) (3.3KB) (272μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (1.41KB) (88μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (416μs)
  • beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.91KB) (206μs)
  • beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (31μs)
  • afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (119μs)
  • beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (6μs)
  • afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (124μs)
  • beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (30μs)
  • afterRenderRawModule mod_menu (Off Canvas) (4.27KB) (387μs)
  • beforeRenderModule mod_menu (Off Canvas) (720B) (5μs)
  • afterRenderModule mod_menu (Off Canvas) (3.78KB) (125μs)
  • beforeRenderRawModule mod_menu (mainmenu) (44.9KB) (1.14ms)
  • afterRenderRawModule mod_menu (mainmenu) (1.22KB) (169μs)
  • beforeRenderModule mod_menu (mainmenu) (704B) (5μs)
  • afterRenderModule mod_menu (mainmenu) (1.65KB) (112μs)
  • afterRender (686.76KB) (11.71ms)
  • 1 x beforeRenderRawModule mod_related_items (Read More) (841.13KB) (15.89%)
    31.00ms
    1 x afterRenderRawModule mod_finder (Head Search) (68.57KB) (15.69%)
    30.61ms
    1 x afterInitialise (1.27MB) (14.03%)
    27.37ms
    1 x beforeRenderRawModule mod_finder (Head Search) (356.66KB) (12.95%)
    25.27ms
    1 x Before Access::getAssetRules (id:1852 name:com_content.article.1029) (130.8KB) (11.4%)
    22.24ms
    1 x afterRender (686.76KB) (6%)
    11.71ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (79.37KB) (5.99%)
    11.68ms
    1 x After Access::preloadPermissions (com_content) (2.39MB) (4.85%)
    9.45ms
    1 x afterRoute (226.77KB) (4.17%)
    8.14ms
    1 x afterLoad (528.66KB) (2.88%)
    5.61ms
    1 x afterRenderRawModule mod_related_items (Read More) (5.37KB) (2.3%)
    4.48ms
    1 x beforeRenderRawModule mod_menu (mainmenu) (44.9KB) (0.59%)
    1.14ms
    1 x beforeRenderComponent com_content (44.03KB) (0.58%)
    1.13ms
    1 x Before Access::preloadComponents (all components) (34.7KB) (0.52%)
    1.02ms
    1 x After Access::preloadComponents (all components) (109.26KB) (0.45%)
    877μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (3.88KB) (0.21%)
    416μs
    1 x afterRenderRawModule mod_menu (Off Canvas) (4.27KB) (0.2%)
    387μs
    1 x afterRenderModule mod_finder (Head Search) (3.3KB) (0.14%)
    272μs
    1 x afterDispatch (3.53KB) (0.13%)
    246μs
    1 x After Access::getAssetRules (id:1852 name:com_content.article.1029) (8.47KB) (0.11%)
    222μs
    1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.91KB) (0.11%)
    206μs
    1 x afterRenderModule mod_related_items (Read More) (3.2KB) (0.1%)
    201μs
    1 x afterRenderRawModule mod_menu (mainmenu) (1.22KB) (0.09%)
    169μs
    1 x afterRenderModule mod_menu (Off Canvas) (3.78KB) (0.06%)
    125μs
    1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.06%)
    124μs
    1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.06%)
    119μs
    1 x afterRenderModule mod_menu (mainmenu) (1.65KB) (0.06%)
    112μs
    1 x afterRenderComponent com_content (42.35KB) (0.05%)
    89μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (1.41KB) (0.05%)
    88μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0.02%)
    31μs
    1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0.02%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (3.91KB) (0.01%)
    24μs
    1 x beforeRenderModule mod_finder (Head Search) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_related_items (Read More) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (mainmenu) (704B) (0%)
    5μs
48 statements were executed, 3 of which were duplicates, 45 unique52.71ms439.12KB
  • SELECT @@SESSION.sql_mode;98μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tvlfg_session` WHERE `session_id` = ?199μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = :session_id LIMIT 186μ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)2.65ms944BParams/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` = 1393μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tvlfg_viewlevels`95μ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` = :guest206μ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`759μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • UPDATE tvlfg_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'455μs1.3KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
  • SELECT * FROM `tvlfg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC243μs2.17KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT * FROM tvlfg_menu WHERE alias ='latest-news' AND published=1228μ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`571μ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`302μ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` = 1241μ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)521μ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.27ms225.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tvlfg_content`1.48ms4.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `tvlfg_content` SET `hits` = (`hits` + 1) WHERE `id` = '1029'886μ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)517μ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`566μ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.92ms5.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`488μ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 ASC548μ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.3ms19.53KBParams/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`455μ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.id179μs1KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:279Copy
  • SELECT enabled FROM tvlfg_extensions WHERE `type` = 'plugin' AND `element` = 'profile'173μ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 ordering190μs1.09KB/plugins/system/t4/src/t4/MVC/Model/AuthorModel.php:420Copy
  • SHOW FULL COLUMNS FROM `tvlfg_users`1.24ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tvlfg_users` WHERE `id` = :userid148μ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` = :muserid178μ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 ASC355μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name` FROM `tvlfg_users` WHERE id = '51'83μs11.84KB/plugins/system/t4/src/t4/MVC/Router/Content/Router.php:66Copy
  • SELECT username FROM tvlfg_users WHERE id=5172μ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.1ms2.31KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `metakey` FROM `tvlfg_content` WHERE `id` = :id168μ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 59.52ms1.8KBParams/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) 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 ASC878μs25.47KBParams/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) AND `t`.`access` IN (:preparedArray3,:preparedArray4)2.06ms5.34KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `name`,`element` FROM `tvlfg_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1444μ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)208μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM tvlfg_acym_configuration301μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_list WHERE type = 'standard'138μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_field156μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'107μ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` = 1151μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `tvlfg_session` WHERE `session_id` = ?151μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `tvlfg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?16.25ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy