Table: samantha_womack_awards
Columns: year
result
award
category
film_or_series
character

Question: Which character was in the sexiest female category of the British Soap Awards?
SQL: SELECT "character" FROM samantha_womack_awards WHERE "category" = 'sexiest female' AND "award" = 'british soap awards'

Question: Which film or series was nominated in the category of best fansite?
SQL: SELECT "film_or_series" FROM samantha_womack_awards WHERE "result" = 'nominated' AND "category" = 'best fansite'