Close Text for 5-Vote Closures

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

SELECT postid [Post Link], text
FROM   posthistory 
WHERE  posthistoryTypeID = 10 
       AND id IN (SELECT ph.id
                      FROM   posthistory ph 
                             OUTER APPLY (SELECT Substring(',' + TEXT + ',', 
                                                 NUMBER + 1 
                                                 , 
                                                 Charindex(',', 
                                                 ',' + TEXT + ',', NUMBER 
                                                         + 
                                                         1) - NUMBER - 1) 
                                                                        AS VALUE 
                                          FROM   MASTER..spt_values 
                                          WHERE  TYPE = 'P' 
                                                 AND NUMBER <= Len( 
                                                     ',' + TEXT + ',') 
                                                               - 1 
                                                 AND Substring(',' + TEXT + ',', 
                                                     NUMBER 
                                                     , 1) 
                                                     = ',' 
                                                 AND ph.posthistorytypeid = 10) 
                                         t 
                      WHERE  ph.posthistorytypeid = 10 
                             AND ( t.VALUE LIKE '"DisplayName":%' 
                                    OR t.VALUE IS NULL ) 
                      GROUP  BY ph.id 
                      HAVING COUNT(t.VALUE) = 5)

Enter Parameters

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