SELECT DISTINCT
  alltext_sa_parts_v.*,
  CLASS, APPINF, AGGTYPE, alltext_bm_saidx_v.CATNUM, TYPE, 
  GROUP_CONCAT(SUBBM1 SEPARATOR ' ') SUBMODS,
  GROUPNUM,
  IFNULL(noun_L.NOUN, noun_E.NOUN) AS NOUN,
  IFNULL(des_L.DESCRIPTION, des_E.DESCRIPTION) AS DESCRIPTION 
FROM 
  alltext_sa_parts_v 
  #связь с авто
  LEFT OUTER JOIN alltext_bm_saidx_v 
    ON alltext_sa_parts_v.SANUM = alltext_bm_saidx_v.SANUM
  LEFT OUTER JOIN alltext_models_v
    ON alltext_bm_saidx_v.CATNUM = alltext_models_v.CATNUM
  #локальный язык
  LEFT OUTER JOIN alltext_part_descs_v des_L
    ON des_L.DESCIDX = alltext_sa_parts_v.DESCIDX AND des_L.LANG = 'F'
  #поумолчанию язык
  LEFT OUTER JOIN alltext_part_descs_v des_E
    ON des_E.DESCIDX = alltext_sa_parts_v.DESCIDX AND des_E.LANG = 'E'
  #локальный язык
  LEFT OUTER JOIN alltext_part_nouns_v noun_L
    ON noun_L.NOUNIDX = alltext_sa_parts_v.NOUNIDX AND noun_L.LANG = 'F'
  #поумолчанию язык
  LEFT OUTER JOIN alltext_part_nouns_v noun_E
    ON noun_E.NOUNIDX = alltext_sa_parts_v.NOUNIDX AND noun_E.LANG = 'E'
WHERE 
  SEARCH_NUMBER LIKE 'A0035422619%'
GROUP BY `TYPE`, CATNUM, AGGTYPE, APPINF, CLASS, GROUPNUM
LIMIT 15
MySQLi_conn::query: Exec query Error: Disk full (/tmp/#sql_789b_16.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")