SELECT
ir.id, ir.code_inquiry, ir.initiator_podr_name, ir.initiator_sl_name, ir.initiator_sotr_famio, ir.initiator_sotr_dolg, 
  ir.initiator_sotr_rank, ir.initiator_sotr_phone_mobile, ir.initiator_sotr_phone_work, ir.initiator_sotr_phone_temp,
  ir.initiator_type, ir.requist_number, ir.requisit_date, ir.requisit_foundation, ir.requisit_numberin,
  CONCAT_WS('-', ir.frame_dou_part_1, ir.frame_part_2, ir.frame_part_3, ir.frame_part_4, ir.frame_part_5) AS 'frame',
  ir.regime_type, 
  inquiry_lico.lico_fam as 'lico_fam',
  inquiry_lico.lico_ima as 'lico_ima',
  inquiry_lico.lico_otc as 'lico_otc',
  CONCAT_WS('.', inquiry_lico.lico_drd, inquiry_lico.lico_drm, inquiry_lico.lico_dry) as 'drlico',
  inquiry_lico.legal_lico_name,
  inquiry_lico.legal_lico_unn, inquiry_lico.adres_district, inquiry_lico.adres_city, inquiry_lico.adres_street, inquiry_lico.adres_home, inquiry_lico.adres_corpus, inquiry_lico.adres_flat,
s.txt, s1.fam as 'fio', inquiry_user.dvi, inquiry_user.dvi as dvis, inquiry_user.dvi as dvipo, inquiry_user.timeQ
FROM inquiry_requisit ir
inner JOIN inquiry_lico ON ir.code_inquiry=inquiry_lico.code_inquiry
inner JOIN inquiry_user ON ir.code_inquiry=inquiry_user.code_inquiry
inner JOIN a_cp1251.sprpodrazdelenie s ON s.code=inquiry_user.code_podr 
inner  JOIN a_cp1251.sotrudniki s1 ON s1.code=inquiry_user.code_sotr