keywords in aboutme

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science Meta

Q&A about the site for scientists using computers to solve scientific problems

print '##cachebreaker##'

select word
into   #triggers
from( select 'Address' word
union select 'Business Address'
union select 'BUSINESS CATEGORY'
union select 'Business Contact Email ID'
union select 'Business Description'
union select 'Business Email'
union select 'BUSINESS HOURS'
union select 'BUSINESS KEYWORDS'
union select 'BUSINESS PHONE'
union select 'Contact us'
union select 'Email'
union select 'Employee'
union select 'Facebook'
union select 'Google'
union select 'Instagram'
union select 'Keywords'
union select 'LinkedIn'
union select 'Linked-in'
union select 'Payment'
union select 'Phone'
union select 'Pinterest'
union select 'Social links'
union select 'Social Media Links'
union select 'Twitter'
union select 'Website'
union select 'Year Est'
union select 'Youtube'
) data

select id as [User Link]
     , count(*) [# trigger words] 
     , datediff(d, min(creationdate), getdate()) [member for days]
     , datediff(d, min(creationdate), min(lastaccessdate)) [#days active]
     , min(views) [views]
from users
inner join #triggers t 
   on (aboutme like concat('%<p>', t.word, '%') collate SQL_Latin1_General_CP1_CI_AS
   or aboutme like concat('%<br>', t.word, '%') collate SQL_Latin1_General_CP1_CI_AS
   or aboutme like concat('%<p><strong>', t.word, '%') collate SQL_Latin1_General_CP1_CI_AS
   or aboutme like concat('%<br><strong>', t.word, '%') collate SQL_Latin1_General_CP1_CI_AS
   )
where reputation = 1
and not exists(select 1 from posts where owneruserid = users.id)
and not exists(select 1 from badges where userid = users.id and name <> 'Autobiographer')
and not exists(select 1 from votes where userid = users.id)
group by id
having count(*) > 1 
order by count(*) desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results