0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT top 100
  Id AS [Post Link],
  NAAscore = 
    SUM(
    CASE WHEN body LIKE '%thank%' then 1.5 else 0 end +
    CASE WHEN body LIKE '%thx%' then 1.5 else 0 end +
    CASE WHEN body LIKE '%appreciated%' then 1.5 else 0 end +
    CASE WHEN body LIKE '%regards%' then 1.5 else 0 end +
    CASE WHEN body LIKE '%?%' then 1 else 0 end +
    CASE WHEN body LIKE '%please provide%' then 2 else 0 end +
    CASE WHEN body LIKE '%can you please%' then 2 else 0 end +
    CASE WHEN body LIKE '%can I do%' then 2 else 0 end +
    CASE WHEN body LIKE '%help me%' then 2 else 0 end +
    CASE WHEN body LIKE '%can you tell me%' then 2 else 0 end +
    CASE WHEN body LIKE '%how do you%' then 2 else 0 end +
    CASE WHEN body LIKE '%can you give me%' then 2 else 0 end +
    CASE WHEN body LIKE '%did you manage to%' then 2 else 0 end +
    CASE WHEN body LIKE '%how can I%' then 2 else 0 end +
    CASE WHEN body LIKE '%I need%' then 2 else 0 end +
    CASE WHEN body LIKE '%any solution%' then 2 else 0 end +
    CASE WHEN body LIKE '%how can we%' then 2 else 0 end +
    CASE WHEN body LIKE '%have you found a solution%' then 2 else 0 end +
    CASE WHEN body LIKE '%save my day%' then 2 else 0 end +
    CASE WHEN body LIKE '%can you explain%' then 2 else 0 end +
    CASE WHEN body LIKE '%we have the same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%please give me%' then 2 else 0 end +
    CASE WHEN body LIKE '%its not working%' then 2 else 0 end +
    CASE WHEN body LIKE '%solve this%' then 2 else 0 end +
    CASE WHEN body LIKE '%amazing%' then 2 else 0 end +
    CASE WHEN body LIKE '%please explain%' then 2 else 0 end +
    CASE WHEN body LIKE '%I have the same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%Im having the same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%I have the exact same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%did you solve%' then 2 else 0 end +
    CASE WHEN body LIKE '%I am facing the same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%please elaborate%' then 2 else 0 end +
    CASE WHEN body LIKE '%update on this%' then 2 else 0 end +
    CASE WHEN body LIKE '%does anybody know%' then 2 else 0 end +
    CASE WHEN body LIKE '%please help%' then 2 else 0 end +
    CASE WHEN body LIKE '%!!%' or body LIKE '%??%' then 1 else 0 end +
    CASE WHEN body LIKE '%doesnt work%' then 2 else 0 end +
    CASE WHEN body LIKE '%what to do if%' then 2 else 0 end +
    CASE WHEN body LIKE '%can someone help%' then 2 else 0 end +
    CASE WHEN body LIKE '%I am facing issue%' then 2 else 0 end +
    CASE WHEN body LIKE '%I am also facing the same issue%' then 2 else 0 end +
    CASE WHEN body LIKE '%your help%' then 2 else 0 end +
    CASE WHEN body LIKE '%any help would%' then 2 else 0 end +
    CASE WHEN body LIKE '%you saved my%' then 2 else 0 end +
    CASE WHEN body LIKE '%did you figure%' then 2 else 0 end +
    CASE WHEN body LIKE '%I would like to know%' then 2 else 0 end +
    CASE WHEN body LIKE '%what am I doing wrong%' then 2 else 0 end +
    CASE WHEN body LIKE '%were you able to figure out%' then 2 else 0 end +
    CASE WHEN body LIKE '%this blog%' then 2 else 0 end +
    CASE WHEN body LIKE '%but not working%' then 2 else 0 end +
    CASE WHEN body LIKE '%I have same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%this guide%' then 2 else 0 end +
    CASE WHEN body LIKE '%saved my day%' then 2 else 0 end +
    CASE WHEN body LIKE '%please tell me%' then 2 else 0 end +
    CASE WHEN body LIKE '%this article%' then 2 else 0 end +
    CASE WHEN body LIKE '%did not work%' then 2 else 0 end +
    CASE WHEN body LIKE '%Im having the same problem%' then 2 else 0 end +
    CASE WHEN body LIKE '%this article%' then 2 else 0 end +
    CASE WHEN body LIKE '%I am trying to%' then 2 else 0 end +
    CASE WHEN body LIKE '%can I do%' then 2 else 0 end +
    CASE WHEN body LIKE '%this document%' then 2 else 0 end +
    CASE WHEN body LIKE '%please show%' then 2 else 0 end +
    CASE WHEN body LIKE '%could you please%' then 2 else 0 end +
    CASE WHEN body LIKE '%please show%' then 2 else 0 end +
    CASE WHEN body LIKE '%how do I%' then 2 else 0 end +
    CASE WHEN body LIKE '%my question%' then 2 else 0 end +
    CASE WHEN body LIKE '%but nothing work%' then 2 else 0 end +
    CASE WHEN body LIKE '%I am not able to%' then 2 else 0 end +
    CASE WHEN body LIKE '%is there a solution%' then 2 else 0 end +
    CASE WHEN body not LIKE '%<code>%' then 0.5 else 0 end +
    CASE WHEN LEN(Body) < 10000 then 1 else 0 end +
    CASE WHEN score > 5 then -1 else 0 end
    ),
  Score,
  Body,
  CreationDate
FROM Posts
WHERE PostTypeId = 2 and LEN(Body) < 100
GROUP BY Id, Score, Body, CreationDate
ORDER BY NAAscore DESC;

view current version

edited dec 12

created nov 29 Starship