Hibernate: 
    select
        i1_0.id,
        case 
            when i1_1.id is not null then 3 
            when i1_0.id is not null then 1 
            when i1_2.id is not null then 0 
        end,
        i1_2.fileName,
        i1_0.height,
        i1_0.original_id,
        i1_0.thumbnail_id,
        i1_0.width,
        i1_1.croppedHeight,
        i1_1.croppedWidth,
        i1_1.leftPosition,
        i1_1.presetKey,
        i1_1.topPosition 
    from
        ImageItem i1_0 
    left join
        PartialImage i1_1 
            on i1_0.id=i1_1.id 
    join
        MediaItem i1_2 
            on i1_0.id=i1_2.id 
    join
        ImageItem o1_0 
            on o1_0.id=i1_0.original_id 
    join
        ImageItem t1_0 
            on t1_0.id=i1_0.thumbnail_id 
    where
        i1_0.original_id is null 
        and i1_0.thumbnail_id is not null