SET SESSION group_concat_max_len = 10240 ; insert into `test_text` values (null, ( concat( ( select SUBSTRING_INDEX(GROUP_CONCAT(title separator ' '), ',', 10) from news where id>4000123 and lang='french' ORDER BY rand() ), ' ', ( select SUBSTRING_INDEX(GROUP_CONCAT(description separator ' '), ',', 10) from news where id>4000123 and lang='french' ORDER BY rand() ) ) ) )