EverSQL Database Performance Knowledge Base

Table transport

Id  | FirstLevSubcat | SecondLevSubcat | ThirdLevSubcat 
--------------------------------------------------------
 8  |   4            |   27            |  1418

Table categories

Id    | CategoriesUrl
--------------------
 4    |   cars          
 27   |   audi          
 1418 |   audi-100

Query if not to use categories table (without inner join) would be like

SELECT count(*) FROM transport
WHERE FirstLevSubcat = 4 AND SecondLevSubcat = 27 AND ThirdLevSubcat = 1418

Trying to get the same result using INNER JOIN

SELECT count(*) FROM transport main_table 
INNER JOIN categories cat_table_first ON cat_table_first.IdRows = main_table.FirstLevSubcat 
INNER JOIN categories cat_table_second ON cat_table_second.IdRows = main_table.SecondLevSubcat 
INNER JOIN categories cat_table_third ON cat_table_third.IdRows = main_table.ThirdLevSubcat 
WHERE 
cat_table_first.CategoriesUrl = 'cars' 
AND cat_table_second.CategoriesUrl = 'audi' 
AND cat_table_third.CategoriesUrl = 'audi-100' 

At first sight all works

But is such query ok? May be can improve something?

• Using-IN-Condition-with-large-number-of-items
• MySQL:-Optimizing-JOINs-to-find-non-matching-records
• MySQL:-Select-a-Range-of-Ordered-Records-Based-on-a-Separator-Type
• MySQL-JOIN-searching-too-many-rows
• Optimizing-a-query-with-many-subqueries
• Average-calculation-by-eliminating-top-10%-&-bottom-10%-values-using-T-SQL
• LINQ-query-to-select-rows-matching-an-array-of-pairs
• Converting-SQL-query-with-FORMAT-command-to-use-in-entity-framework-core
• Best-Way-to-Handle-Multiple-Selects-Per-Object
• Highlight-matched-words-MySQL-FULLTEXT-index
• Optimize-the-SQL-Statement-with-MAX()-and-VALUES()
• Disabling-join-on-CakePHP-find-function
• Query-to-fetch-old-data-(imported-from-identical-dbs)-and-new-data-using-joins
• Where-do-I-find-the-meaning-of-TdsInputBufferError-numbers?
• Do-MAX()-improves-performance-of-a-query?
• Why-subselect-makes-the-SQL-request-slower?
• Mysql---The-Best-Way-to-Manage-and-Find-Point-in-Latitude-Longitude-Inside-a-Polygon
• sql---retrieving-order
• How-to-tweak-Hibernate-queries
• Is-it-possible-to-improve-efficiency-of-this-iterative-algorithm?
• Running-total-with-over-clause-on-SQL-Server-2014
• How-can-this-SQL-be-improved?-(MySQL-database)
• MySQL-Query-optimize-for-performance
• How-to-optimize-this-my-mysql-query?
• Improve-query-with-WHERE-clause-using-same-subquery-multiple-times