developer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select top 100
  p.Id as [Post Link],
  p.CreationDate,
  p.title,
  p.tags,
  u.displayname,
  u.location,
  u.reputation,
  u.accountid,
  u.websiteurl
from posts p inner join 
     users u on p.OwnerUserId = u.Id
     where  (u.location like '%##country##%') 
     and (p.body like '%##tech##%' or p.title like '%##tech##%' or
     p.tags like '%##tags##%')

Enter Parameters

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