SELECT cru.*, proj.base_url, proj.base_url || cru.url AS full_url
  FROM code_review_url cru,
       projects proj
 WHERE cru.pv_id = :PV_ID
   AND cru.proj_id = proj.proj_id
