`deviceid` ELSE CAST(NULL AS STRING) END#153, tmp.`deviceid`#154, tmp....`deviceid` ELSE CAST(NULL AS STRING) END#153, tmp.`deviceid`#154, tmp....`deviceid` ELSE CAST(NULL AS STRING) END#153, tmp.`deviceid`#154, tmp....`deviceid` ELSE CAST(NULL AS STRING) END#153, tmp.`deviceid`#154, tmp....`deviceid` ELSE CAST(NULL AS STRING) END#153, tmp.`deviceid`#154, tmp.