Disk full (/tmp/#sql_61a7_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
query :
select exhibitions.*,
substring_index(substring_index(exhibitions.users_name, ' ', numbers.n), ' ' , -1) as name
from (
select 1 as n union all
select 2 union all
select 3 union all
select 4 union all
select 5) as numbers
inner join exhibitions
on char_length(exhibitions.users_name) - char_length(replace(exhibitions.users_name, ' ', '')) >= numbers.n - 1
order by substring_index(substring_index(exhibitions.users_name, ' ', numbers.n), ' ' , -1)