Выберите «Ревизия» в двух таблицах и используйте Внутренний перевод таблицы соединений ⇐ Php

[Anonymous]

У меня есть 4 таблицы:

rating , Университет , Школа и translate Информация.user | business_id | rate
1 | 1 | text my rate

Университет и школа
business_id | translate_id
1 | 1

translate
translate_id | text | language
1 | street | en
2 | strada | it
< /code>
Мне нужно взять все обзоры пользователей University University и школьные таблицы и использовать пакет перевода. Query
select
A.* , innerjoin.name , innerjoin.address , innerjoin.type
from rating as A
inner join (
select t.address , B.id , B.name , "university" as type from university as B
inner join translate as t on t.id = B.address where t.language = "en"

union all

select t.address , B.id , B.name , "school" as type from school as B
inner join translate as t on t.id = B.address where t.language = "en"
) innerjoin
on innerjoin.id = A.id
where A.student = "John"

my output-en
0 => Array
rate => #2 my rate
name => school-1
address => street
type => school
1 => Array
rate => #3 my rate
name => university-1
address => mall
type => university
2 => Array
rate => #1 my rate
name => school-2
address => avenue
type => school

my output-it
0 => Array
rate => #2 my rate
name => school-1
address => strada
type => school
1 => Array
rate => #3 my rate
name => university-1
address => centro commerciale
type => university
2 => Array
rate => #1 my rate
name => school-2
address => viale
type => school


Подробнее здесь: https://stackoverflow.com/questions/229 ... ranslation