MySQL
0
Вклад в тег
SELECT
items.id,
items_temp.iid,
items_temp.temp,
items_style.iid,
items_style.sid,
items_lang.iid,
items_lang.lid,
items.name
FROM items_lang
INNER JOIN items
ON items_lang.aid = items.id
INNER JOIN items_style
ON items_style.mid = items.id
INNER JOIN items_temp
ON items_temp.mid = items.id
WHERE items_lang.lid = 6
AND items_style.sid = 122
AND items_temp.temp = 6
GROUP BY items.id
ORDER BY items.id