SELECT 
   p.objID,
   dbo.fPhotoTypeN(p.type) as type,
   petroR90_r 
FROM #upload u
      JOIN #x x ON x.up_id = u.up_id
      JOIN PhotoTag p ON p.objID = x.objID 
ORDER BY x.up_id