How does the SEF links look like ?

In general, the working ones are as normal Joomla SEF URLs look, with the alias in the URL -- words separated by hyphens -- instead of article parameter code appended onto index.php as above.

There are some of the broken URLs which leave out the first part of the appended, non-SEF Joomla URL: http://www.oursite.com/site/staging/affiliates?id=108
I've checked the code for the URL and it is the full URL.

In other URLs which look like they are SEF but do not work, I have noticed the following but not confirmed in detail:

SEF URLs which contain the following don't work:

• Any capital letters in alias
• Spaces between alias words
• Parentheses in alias

Upon checking several articles which have these converted but broken URLs, Joomla does not appear to be using the aliases entered into each article. It is actually inserting the article titles into the URLs even though those articles already have alias text (with words and hyphens).

So there appear to be three things happening,

1. Broken truncated URLs
2. Working SEF URLs
3. Broken URLs with titles as aliases (with spaces, not hyphens between words).

Thanks!