TD_API::query_fetch_all: Exec query Error:Error writing file 'C:\Windows\SERVIC~1\NETWOR~1\AppData\Local\Temp\MY6C36.tmp' (Errcode: 28 - No space left on device) Query: #EXPLAIN

(SELECT 

  mfa_id,

  mfa_brand,

  mod_id,   

  get_cds_txt(mod_id,1,186) mod_name,

  mod_pc,

  mod_cv,

  typ_id,            

  get_cds_txt(typ_mmt_cds_id,1,186)typ_mmt_cds,

  get_cds_txt(typ_cds_id,1,186)typ_cds,

  typ_pcon_start,   

  typ_pcon_end, 

  typ_kw_from,   

  typ_hp_from,   

  typ_ccm,   



  IF(IFNULL(get_des_txt(typ_kv_body_des_id,1),'')<>'',get_des_txt(typ_kv_body_des_id,1), get_des_txt(typ_kv_model_des_id,1)) body_des,

  get_des_txt(typ_kv_engine_des_id,1)typ_kv_engine_des,   

  get_des_txt(typ_kv_axle_des_id,1)typ_kv_axle_des,   



  typ_max_weight,   

  lat_typ_id   

FROM   

  tof_link_art   

  JOIN tof_link_la_typ ON la_id = lat_la_id

  JOIN tof_types ON typ_id = lat_typ_id

  JOIN tof_models ON  mod_id=typ_mod_id

  JOIN tof_manufacturers ON  mfa_id=mod_mfa_id



WHERE  

  la_art_id=1238052 /* art_id */



)



UNION



(SELECT 

  mfa_id,

  mfa_brand,

  mod_id,   

  get_des_txt(mod_id,1) mod_name,

  mod_pc,

  mod_cv,

  typ_id,            

  get_cds_txt(typ_mmt_cds_id,1,186)typ_mmt_cds,

  get_cds_txt(typ_cds_id,1,186)typ_cds,

  typ_pcon_start,   

  typ_pcon_end, 

  typ_kw_from,   

  typ_hp_from,   

  typ_ccm,   



  IF(IFNULL(get_des_txt(typ_kv_body_des_id,1),'')<>'',get_des_txt(typ_kv_body_des_id,1), get_des_txt(typ_kv_model_des_id,1)) body_des,

  get_des_txt(typ_kv_engine_des_id,1)typ_kv_engine_des,   

  get_des_txt(typ_kv_axle_des_id,1)typ_kv_axle_des,   



  typ_max_weight,   

  lat_typ_id      

FROM   

  tof_article_lists

  join tof_link_art on ali_art_id = la_art_id 

  JOIN tof_link_la_typ ON la_id = lat_la_id

  JOIN tof_types ON lat_typ_id = typ_id

  JOIN tof_models ON  mod_id=typ_mod_id

  JOIN tof_manufacturers ON  mfa_id=mod_mfa_id

WHERE  

  ali_art_id_component = 1238052 /* art_id */



)

ORDER BY

  mfa_brand, mod_name, typ_mmt_cds

;