SELECT m2.language, m2.id
FROMu5uoj_menu as m
INNERJOINu5uoj_associations as a ON a.id=m.id AND a.context='com_menus.item'
INNERJOINu5uoj_associations as a2 ON a.key=a2.key
INNERJOINu5uoj_menu as m2 ON a2.id=m2.id
WHERE m.id=286

SELECT m2.language, m2.id
FROMu5uoj_menu as m
INNERJOINu5uoj_associations as a ON a.id=m.id AND a.context='com_menus.item'
INNERJOINu5uoj_associations as a2 ON a.key=a2.key
INNERJOINu5uoj_menu as m2 ON a2.id=m2.id
WHERE m.id=286

26 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

6 × SELECT a.element AS element FROMu5uoj_extensionsAS a

2 × SELECT m2.language, m2.id FROMu5uoj_menu as m INNERJOINu5uoj_associations as a ON a.id=m.id AND a.context='com_menus.item' INNERJOINu5uoj_associations as a2 ON a.key=a2.key INNERJOINu5uoj_menu as m2 ON a2.id=m2.id