/*select count(*) from (*/ SELECT Id, Title, ViewCount, S...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

/*select count(*) from (*/
SELECT
  Id,
  Title,
  ViewCount,
  Score,
  Tags
FROM Posts
WHERE PostTypeId=1
  and AnswerCount > 0
  and Tags like '%<javascript>%'
  and (Title COLLATE Latin1_General_CI_AS like 'how to %'
    or Title COLLATE Latin1_General_CI_AS like 'how do %'
    or Title COLLATE Latin1_General_CI_AS like 'how may %'
    or Title COLLATE Latin1_General_CI_AS like 'how might %'
    or Title COLLATE Latin1_General_CI_AS like 'how can %'
    or Title COLLATE Latin1_General_CI_AS like 'how could %'
    or Title COLLATE Latin1_General_CI_AS like 'how should %'
  )
ORDER BY ViewCount DESC
/*) as T*/

/*
  JS Hows(all): 337,820
  JS Hows(selected): 324,217
*/

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results