0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT P.Id as [Post Link], P.Tags, P.ViewCount, 
P.AnswerCount, P.CommentCount, P.Score, 
P.CreationDate, P.Title, P.Body, C.Text, U.Location

FROM Posts as P, Users as U , Comments as C

WHERE  P.Id = C.PostId AND C.UserId = U.Id

AND P.Tags LIKE '%ethereum%'
--AND P.Tags LIKE '%bitcoin%'


--OR P.Tags LIKE '%go-ethereum%'
--OR P.Tags LIKE '%blockchain%'  
--OR P.Tags LIKE '%bitcoind%' 
--OR P.Tags LIKE '%bitcore%' 
--OR P.Tags LIKE '%mining%' 
--OR P.Tags LIKE '%cryptocurrency%' 
--OR P.Tags LIKE '%bitcoin-testnet%' 
--OR P.Tags LIKE '%cryptography%' 
--OR P.Tags LIKE '%coinbase-api%' 
--OR P.Tags LIKE '%ethereum%' 
--AND C.Text LIKE '%bitcoin%'


ORDER BY P.CreationDate

fork query

edited jul 22 19 anonymous

created dec 21 13 jon.doe12449