keywords in aboutme

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology

Q&A for biology researchers, academics, and students

select word
into   #triggers
from( select 'Business Address' word
union select 'Phone'
union select 'Address'
union select 'Email'
union select 'Contact us'
union select 'Website'
union select 'Social links'
union select 'Year Est'
union select 'Employee'
union select 'Keywords'
union select 'Business Description'
union select 'Business Email'
union select 'Payment'
union select 'Facebook'
union select 'LinkedIn'
union select 'Linked-in'
union select 'Instagram'
union select 'Twitter'
union select 'Pinterest'
union select 'Youtube'
union select 'Google'
) 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
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')
group by id
having count(*) > 1 
order by count(*) desc

Enter Parameters

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