SELECT adMX2820M13PrvSlotTable.adMX2820M13NetFuncServState.value
  FROM adMX2820M13PrvSlotTable
  WHERE adMX2820M13PrvSlotTable.adMX2820M13NetFuncServState.index_val[0]
  IN ( 
    SELECT adGenPortSlotMapTable.adGenSlotAddress.index_val[0]
      FROM adGenPortSlotMapTable
      WHERE adGenPortSlotMapTable.adGenSlotAddress.value
      IN (
        SELECT adMX2820M13StatDS3Table.adMX2820M13PrvCardPairID.index_val[0]
          FROM adMX2820M13StatDS3Table
          WHERE adMX2820M13StatDS3Table.adMX2820M13PrvCardPairID.value !~ /not in use/i 
          AND adMX2820M13StatDS3Table.adMX2820M13PrvCardPairID.value != ''
      )
  )