Posts on books in spain

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

select p.Id, u.Id, p.body, u.AboutMe, u.WebsiteUrl, u.DisplayName, p.CreationDate from Users u left join Posts p on p.OwnerUserID = u.Id where 
u.Location='Spain'
and ( 
p.Body  LIKE '%Beck%'
OR p.Body  LIKE '%Mancuso%'
OR p.Body  LIKE '%Fowler%'
OR p.Body  LIKE '%Uncle Bob%'
OR p.Body  LIKE '%Andy Hunt%'
OR p.Body  LIKE '%Hunt%'
OR p.Body  LIKE '%Gamma%'
OR p.Body  LIKE '%Frederick P. Brook%'
OR p.Body  LIKE '%Freeman%'
OR p.Body  LIKE '%Feathers%'
OR p.Body  LIKE '%Evans%'
OR p.Body  LIKE '%Vernon%'
OR p.Body  LIKE '%Meetup%'
OR p.Body  LIKE '%Craftman%'
OR p.Body  LIKE '%Craftperson%'
OR p.Body  LIKE '%monolith%'
OR p.Body  LIKE '%tdd%'
OR p.Body  LIKE '%TDD%'
OR p.Body  LIKE '%beck%'
OR p.Body  LIKE '%mancuso%'
OR p.Body  LIKE '%fowler%'
OR p.Body  LIKE '%uncle bob%'
OR p.Body  LIKE '%andy hunt%'
OR p.Body  LIKE '%hunt%'
OR p.Body  LIKE '%frederick p. brook%'
OR p.Body  LIKE '%freeman%'
OR p.Body  LIKE '%feathers%'
OR p.Body  LIKE '%evans%'
OR p.Body  LIKE '%vernon%'
OR p.Body  LIKE '%meetup%'
OR p.Body  LIKE '%craftman%'
OR p.Body  LIKE '%craftperson%'
)

Enter Parameters

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