SELECT --qns_com.text as question_comment, qns_com.s...

0

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 questions.id 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 = questions.id --and ans_com.postid = answers.id and qns_com.postid = questions.id )




SELECT --qns_com.text as question_comment, qns_com.score as question_comment_score, qns_com.creationdate as question_comment_date,  
       
       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 = questions.id and ans_com.postid = answers.id --and qns_com.postid = questions.id
and questions.id = '73'







--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 = questions.id 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(questions.id) as q_id
--FROM Posts answers, Posts questions, comments ans_com, comments qns_com
--WHERE answers.parentid = questions.id and ans_com.postid = answers.id and qns_com.postid = questions.id 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

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