ultima

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
'andoid' as framework, 
'googlesamples/android-play-places' as path,
q.Id as question_id,
q.Tags as question_tags,
q.ViewCount as question_view_count,
q.AnswerCount as question_answer_count,
q.Score as question_score,
q.CreationDate as question_creation_date,
'link' as question_link,
q.OwnerUserId as question_owner_id,
u.Reputation as question_owner_reputation,
u.CreationDate as question_owner_creation_date,
'tags' as question_owner_tags,
'preencher' as answer_id,
'preencher' as answer_score,
'preencher' as answer_creation_date,
'preencher' as answer_owner_id,
'preencher' as answer_owner_reputation,
'preencher' as answer_owner_creation_date,
'preencher' as answer_owner_tags,
q.AcceptedAnswerId
from 
Posts as q 
join Users as u on q.OwnerUserId = u.Id
where 
q.CreationDate >= ('05/16/2018') and
q.CreationDate < ('05/16/2020') and
q.PostTypeId = 1 and 
q.Body like('%>https://github.com/googlesamples/android-play-places%')
order by q.Id;

Enter Parameters

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