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 pq.Id, REPLACE( REPLACE (pq.Body, CHAR (13), ''), CHAR(10), '') as Body
FROM Posts pa
JOIN Posts pq ON pq.Id = pa.ParentId 
JOIN Users u ON u.Id = pa.OwnerUserId AND (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%' )
WHERE u.Id >=00000
AND u.Id <   400000
GROUP BY pq.Id,pq.Body

view current version

edited jan 21 20

created jan 21 20 TomaszL