SQL: Binary to IP Address

I'm trying to convert A binary IP to a human-readable IP

SELECT HEX( `ip_bin` ) FROM `log_metadata`

gives me 4333D26E000000000000000000000000

And

SELECT INET_NTOA(0x4333D26E)

gives me 67.51.210.110

So I tried:

SELECT
  SUBSTRING( CONVERT(HEX(`ip_bin`), CHAR(32)), 1, 8 ) AS `A`
, INET_NTOA( 
  SUBSTRING( CONVERT(HEX(`ip_bin`), CHAR(32)), 1, 8 ) 
                                                     ) AS `B`
, INET_NTOA(hex(`ip_bin`))  AS `C`
, INET_NTOA(`ip_bin`)       AS `D`
FROM `log_metadata`

But I only get

+----------+------------+------------+---------+
| A        | B          | C          | D       |
+----------+------------+------------+---------+
| 4333D26E | 0.0.16.237 | 0.0.16.237 | 0.0.0.0 |
+----------+------------+------------+---------+

Any suggestions?