SELECT *, vv.nome nomevariacao
FROM products_variations v
LEFT JOIN products_variations_options_lang vl ON v.options = vl.intid
LEFT JOIN (SELECT * FROM products_variations_names_lang WHERE idioma = '1' ) vv ON v.variation = vv.intid
WHERE v.product = '14105'
AND vl.idioma = '1'
GROUP BY v.options
ORDER BY v.ord ASC
Disk full (/var/tmp/#sql_50c_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")