Mysql AS

SELECT IFNULL(
  (SELECT u.phone_crm_extension AS phone
    FROM vtiger_account AS acc
    LEFT JOIN vtiger_crmentity AS e ON e.crmid = acc.accountid
    LEFT JOIN vtiger_users AS u ON u.id = e.smownerid
    WHERE
     (acc.phone =7930
      OR acc.otherphone =7930
      OR acc.fax =7930)
      AND e.deleted = 0
      GROUP BY phone
      LIMIT 1),
  IFNULL(
    (SELECT u.phone_crm_extension AS phone
      FROM vtiger_contactdetails AS cd
      LEFT JOIN vtiger_crmentity AS e ON e.crmid = cd.contactid
      LEFT JOIN vtiger_users AS u ON u.id = e.smownerid
      WHERE
       (cd.phone =7930
        OR cd.mobile =7930
        OR cd.fax =7930)
        AND e.deleted =0
        GROUP BY phone
        LIMIT 1),
        IFNULL(
          (SELECT u.phone_crm_extension AS phone
            FROM vtiger_leadaddress
            AS la
            LEFT JOIN vtiger_crmentity AS e ON e.crmid = la.leadaddressid
            LEFT JOIN vtiger_users AS u ON u.id = e.smownerid WHERE(
              la.phone =7930
              OR la.mobile =7930
              OR la.fax =7930)
            AND e.deleted =0 GROUP BY phone
            LIMIT 1),
          '103'
         )
      )
);

# mysql -u root -p'573351' vtigercrm < call2responsible.sql
IFNULL(
  (SELECT u.phone_crm_extension AS 'phone'
    FROM vtiger_account AS acc
    LEFT JOIN vtiger_crmentity AS e ON e.crmid = acc.accountid
    LEFT JOIN vtiger_users AS u ON u.id = e.smownerid
    WHERE
     (acc.phone =7930
      OR acc.other
199

phone
199

199