SELECT p.Id, REPLACE( REPLACE (p.Body, CHAR (13), ''), CH...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT p.Id, REPLACE( REPLACE (p.Body, CHAR (13), ''), CHAR(10), '') as Body
FROM Posts p
JOIN Users u ON u.Id = p.OwnerUserId
WHERE (upper( u.Location) like '%POLAND%' OR upper( u.Location) like '%POLSKA%' OR upper( u.Location) like '%WARSAW%' OR upper( u.Location) like '%WARSZAWA%' OR upper( u.Location) like '%GDANSK%' OR upper( u.Location) like '%GDAŃSK%' OR upper( u.Location) like '%CRACOW%' OR upper( u.Location) like '%KRAKÓW%' OR upper( u.Location) like '%WROCLAW%' OR upper( u.Location) like '%WROCŁAW%' OR upper( u.Location) like '%ŁÓDŹ%' OR upper( u.Location) like '%LODZ%' OR upper( u.Location) like '%RZESZÓW%' OR upper( u.Location) like '%RZESZOW%' OR upper( u.Location) like '%BIALYSTOK%' OR upper( u.Location) like '%BIAŁYSTOK%' OR upper( u.Location) like '%SZCZECIN%' OR upper( u.Location) like '%TORUN%' OR upper( u.Location) like '%TORUŃ%' OR upper( u.Location) like '%BYDGOSZCZ%' OR upper( u.Location) like '%KATOWICE%' )
AND p.ParentId IS NULL
AND u.Id >= 1000000
AND u.Id <  3000000

Enter Parameters

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