Added `SharedContent.objects.get_for_slug()` API and others.

* Added `published() and `_single_site()` logic to be consistent with other fluent-apps.
* Added `get_for_slug()` for convenience.