Сергей

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