0

Please login or register to vote for this query.

(click on this box to dismiss)

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 >= 6000000
AND u.Id <  40000000000

view current version

edited jan 21 20

created jan 21 20 TomaszL