SELECT id, parent_id, name, CAST(parent_id AS INTEGER) AS idInt, (parent_id & 4294967295) AS bitand
FROM orphans
LIMIT 10

id      parent_id name	idInt			bitand
------------------------------------------------------
27	11	(MEMO)	3096224743817227	11
28	27	(MEMO)	281474976710683		27
29	27	(MEMO)	281474976710683		27
30	27	(MEMO)	281474976710683		27
31	29	(MEMO)	281474976710685		29
32	29	(MEMO)	281474976710685		29
33	29	(MEMO)	281474976710685		29
34	29	(MEMO)	281474976710685		29
36	35	(MEMO)	562949953421347		35
37	5	(MEMO)	1407374883553285	5