0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for apps, scripts, and development with the Stack Exchange API

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

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

WHERE  P.OwnerUserId = U.Id
--P.Id = C.PostId AND P.OwnerUserId = 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 anonymous

created dec 21 13 jon.doe12449