SELECT 
  a1.`ID ПУ` AS ID,
  CONCAT_WS(', ', i.np,i.ul,i.dom) AS adr,
  CURDATE(),
  vp_kv1 AS val FROM import i
  LEFT OUTER JOIN ais a1 ON i.IDdom=a1.`ID дома` WHERE a1.`ID услуги`=612 ORDER BY i.np,i.ul,i.dom DESC