1. Home
2. php - MySQL filtering with several inner joins

594 votes

0 answers

php - MySQL filtering with several inner joins

Get the solution ↓↓↓

Solution:

SELECT
  Entities.*,
  Locations.Loc_Name as Loc_Name
FROM
  Entities
  INNER JOIN Locations ON Entities.Obj_ID=Locations.Obj_ID 
WHERE
  Entities.Ent_Type='Locations' 
  AND Loc_Name LIKE ?

UNION

SELECT
  LocEnt.*,
  Locations.Loc_Name as Loc_Name
FROM 
  TimeSensatives
  INNER JOIN Entities AS CharEnt ON TimeSensatives.Ent_ID=CharEnt.Ent_ID
  INNER JOIN Characters ON Entities.Obj_ID=Characters.Obj_ID
  INNER JOIN Entities AS LocEnt ON TS_Content.Ent_ID=LocEnt.Ent_ID
  INNER JOIN Locations ON LocEnt.Obj_ID=Locations.Obj_ID 
WHERE
  TS_Type='Location' 
  AND TS_Start<=?
  AND TS_End>=?
  AND Char_Name LIKE ?
Copy code

will give you all needed locations plus their names

Undefined asked

2023-01-29

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2023-01-29

Link To Source
Link To Answer People are also looking for solutions of the problem: using $this when not in object context laravel

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

331 How to insert 100 records in mysql procedure and loop in MySQL procedure not in PHP?

699 php - Insert file into mysql database as varbinary datatype

659 php - XAMPP Apache Won't Start with Modified php5ts.dll

804 PHP and mysql integration with apache tomcat 6 in linux

995 [PHP][MySQL] How to implement a title field for each selected file in an upload form?

136 php - Getting specific part of value in mysql database

514 mysqli - PHP Not inserting record due to Null id

863 mysql - How can I prevent SQL injection in PHP?

370 codeigniter - When i'm transfering to another page getting data(s) (PHP Error Message:Trying to get property of non-object)

351 parsing - PHP file_get_contents optimization

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/