fix left join query for textFlow and target