 		inner join `PatentsView`.`temp_id_mapping_patent` tp on
 		tp.`old_patent_id` = ri.`patent_id`
 
-		inner join `uspto`.`rawlocation` rl on
+		left outer join `uspto`.`rawlocation` rl on
 		rl.`id` = ri.`rawlocation_id`
 
-		inner join `PatentsView`.`temp_id_mapping_location` tl on
+		left outer join `PatentsView`.`temp_id_mapping_location` tl on
 		tl.`old_location_id` = rl.`location_id`;
 

		inner join `PatentsView`.`temp_id_mapping_patent` tp on
		tp.`old_patent_id` = ra.`patent_id`

		inner join `uspto`.`rawlocation` rl on
		rl.`id` = ra.`rawlocation_id`

		inner join `PatentsView`.`temp_id_mapping_location` tl on
		tl.`old_location_id` = rl.`location_id`;



	(
		`assignee_id` int unsigned not null,
		`patent_id` int unsigned not null,
		`location_id` int unsigned null,
		unique index `ak0_rawassignee` (`assignee_id`, `patent_id`, `location_id`),
		unique index `ak1_rawassignee` (`patent_id`, `assignee_id`, `location_id`),
		unique index `ak2_rawassignee` (`location_id`, `assignee_id`, `patent_id`)
	)
