Q&A for 3D printing enthusiasts
SELECT u.ID AS UserID, * FROM Users u inner join posts p on p.ownerUserid = u.id inner join posttags pt on pt.postid = p.id inner join tags t on t.id = pt.tagid WHERE LOWER(Location) LIKE LOWER('%##countryname##%') and t.tagname='##tagname##' ORDER BY Reputation DESC;