keywords in aboutme

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

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')
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