© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
The subquery clauses is working with 1000s of sprs for each spn, not 1. I have a revised query that limits the matched sprs to have exactly 1 for each spn.