text: SELECT 
  ASSET.ID AS PRIMARY_KEY,
  ASSET.NAME AS SERIAL_NUMBER,
  ASSET.ASSET_DATA_ID AS ASSET_DATA_5_ID,
  ASSET.LOCATION_ID AS LOCATION_ID,
  ASSET.MAPPED_ID AS MACHINE_MAPPED_ID,
  FIELD_9921,
  FIELD_9922,
  FIELD_9923,
  FIELD_9924,
  FIELD_9925,
  FIELD_9926,
  FIELD_9927,
  FIELD_9928,
  FIELD_9928,
  FIELD_9930,
  FIELD_9931,
  FIELD_9932,
  FIELD_9933,
  FIELD_9934,
  FIELD_9935,
  FIELD_9936,
  FIELD_9937,
  FIELD_9938,
  FIELD_9939,
  FIELD_10004,
  FIELD_10007 AS REPLACEMENT_DATE_QUARTER,
  FIELD_10008 AS PURCHASE_DATE_QUARTER,
  FIELD_10009,
  FIELD_10010 AS NOTES,
  FIELD_10011 AS ASSIGNMENT_TYPE,
  FIELD_10012 AS FUNDING_TYPE,
  FIELD_10029,
  FIELD_10031 AS PURCHASE_DATE,
  FIELD_10030 AS YEAR_ASSIGNED,
  FIELD_10032 AS REPLACEMENT_YEAR,
  FIELD_10033 AS PO_NUMBER,
  FIELD_10036 AS ROOM_NUMBER
  FROM
  ASSET_DATA_5
  JOIN ASSET ON ASSET.ASSET_DATA_ID = ASSET_DATA_5.ID;
  #JOIN ASSET ON ASSET.ASSET_DATA_ID = ASSET_DATA_2.ID
  #WHERE ASSET.NAME = 'C02C9BBQMD6R';