A Councillor has been told he will not be re-selected for next year's elections after posting a 'How Sexy Am I' quiz on Facebook.