And possibly other keys.
Look at your WHERE clauses:
AND SITES_PRODUCT.LIVE =1
AND SITES_RANGE.CAT_OR_LINK =1
AND SITES_RANGE.RANGE_ID = ...
And so on. Any place you see a WHERE condition that might be forcing MySQL to do a complete table scan (and where the number of records in the table is high...in the thousands), you have a potential index candidate.
You know your data better than we do.
One thing: You can always add an index just to see if it helps. If it doesn't, remove it.