string(6) "sticky" string(7) "created" string(3) "nid" string(465) "SELECT DISTINCT node.sticky AS node_sticky, node.created AS node_created, node.nid AS nid FROM {node} node INNER JOIN {node_access} na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.vid IN ( SELECT tn.vid FROM {term_node} tn WHERE tn.tid = %d )) )ORDER BY node_sticky DESC, node_created DESC "
Assassins Creed Unity Sequence 13 Memory 6 a Crown of Thorns.
The last memory of the sequence and assassination of Captaine Rose.
Stealth
Before the fight with Captaine Rose, it's a challenge just to get to him without being seen.
Using just the hidden blade it's not that hard to make your way through the area. Also took the opportunity to achieve the double assassinations challenge.
When you start down the large flight of stairs, wait for the two guards to pass by and quickly assassinate them. Then kill the raider captain from the safety of a cover. This will cause some nearby guards to flee, making your stealth path easier.
Continuing along the route, corner kill the stationary guard. I've gotten see before by the patrolling guard during this kill, but with the timing in the video I haven't.
Now wait till the patrolling guard can't see you and hang off the edge. By this time some guards will notice the bodies of your first kill. Shimmy your way across and kill the patrolling guard, then the two posted guards. You will complete the double assassinations challenge.
When you reach the next two guards, keep an eye out to your right for guards. Kill them when the coast is clear. You won't have to worry about enemies for the rest of this as long as you keep to the roofs.
Early Death
Now that you've reached the target, time to pre-kill him. Getting close to the area starts the scene, so lure him with a firecracker from a safe distance away. Other guards will also arrive, which can be dealt with using poison bombs.
Now sneak up on the target and... he can't be assassinated or knocked out. Immune to poison bombs and berserk darts. Combine that with lots of health and you're looking at a high level boss.
Now here's the thing: If you kill him then it actually causes the scene to start. Not sure why, maybe killing him is supposed to start the next checkpoint regardless of what part you are in the memory.
Anyway, he respawns after the cutscene, so the pre-assassination is just for fun.