The union select one with the repeated hex looks to me a lot like certain automated scanner tools trying to identify a column through which they can exfil the output of a SQL query.
It's just looking for the number of columns returned by the initial query. UNION queries have to return the same number of columns as the query they are added to.