These user profiles pollute your authority and you probably want to delete them, but first you have to identify them. I found the following query helpful for this purpose:
U.UserID = P.UserID
CSU.MembershipID = U.UserID
P.PropertyValuesString LIKE '%<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %<a %' OR
P.PropertyValuesString LIKE '%position:absolute%'
P.PropertyValuesString LIKE '%overflow:hidden%'
(SELECT COUNT(*) FROM CS_Posts P WHERE P.UserID = CSU.UserID) = 0</a>
Make sure to check your results for false positives! Once you are sure you got all the culprits and nobody else, iterate over it and delete each spammer e. g. by running
While the code is simple the reason I don’t include it here is because I want you to think about what you are doing and not blindly copy/paste it and accidentally delete “real” users - you will likely have to customize the above SQL snippet to achieve this.