SELECT as post_id, questions.title as post_t...


Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT as post_id, questions.title as post_title, questions.body as question_post, 
       questions.creationdate as question_data, questions.viewcount as number_view_post, 
       questions.answercount as answer_count, questions.commentcount as question_comment_count, questions.favoritecount as favorite_question, 
       questions.score as question_score, --qns_com.text as question_comment, qns_com.score as question_comment_score, qns_com.creationdate as question_comment_date,  
       answers.body as answers_post, answers.creationdate as answer_date, 
       answers.score as answer_score, answers.commentcount as answer_comment_count, answers.favoritecount as favorite_answer 
       --, ans_com.text as answer_comment, ans_com.score as answer_comment_score, ans_com.creationdate as answer_comment_date 
FROM Posts answers, Posts questions--, comments ans_com, comments qns_com
WHERE answers.parentid = --and ans_com.postid = and qns_com.postid = 
and ( = '73' or = '9')

--select t_q_a_id.q_id as q_id from

--(SELECT distinct(questions.Id) as q_id 
--FROM Posts answers, Posts questions
--WHERE answers.parentid = and ((answers.body like '% bug%' and answers.body like '%blame%') 
--                                      or (questions.body like '% bug%' and questions.body like '%blame%') 
  --                                    or (questions.title like '% bug%' and questions.title like '%blame%'))) t_q_a_id,

--(SELECT distinct( as q_id
--FROM Posts answers, Posts questions, comments ans_com, comments qns_com
--WHERE answers.parentid = and ans_com.postid = and qns_com.postid = and 
--                                            ((ans_com.text like '% bug%' and ans_com.text like '%blame%') 
--                                        or (qns_com.text like '% bug%' and qns_com.text like '%blame%'))) qc_ac_id
--where t_q_a_id.q_id = qc_ac_id.q_id

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results