Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
205
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.66 KB | None | 0 0
  1. SELECT
  2. `surveyEntries`.`ID` AS EntryID,
  3. `surveyEntries`.`created` AS EntryDate,
  4. `hw_services`.`name` AS Provider,
  5. `surveyQuestions`.`ID` AS QuestionID,
  6. `surveyQuestions`.`label` AS Question,
  7. `survey_meta`.`answer` AS Answer,
  8. `surveyQuestions`.`parentID` AS ParentQuestion
  9. FROM `survey` , `surveyQuestions` , `surveyEntries` , `survey_meta` , `hw_services`
  10. WHERE `survey`.`ID` =2
  11. AND `survey`.`ID` = `surveyQuestions`.`surveyID`
  12. AND `survey`.`ID` = `surveyEntries`.`surveyID`
  13. AND `surveyEntries`.`ID` = `survey_meta`.`entryID`
  14. AND `hw_services`.`ID` = `surveyEntries`.`hw_serviceID`
  15. AND `surveyQuestions`.`ID` = `survey_meta`.`questionID`
  16.  
  17. SELECT
  18. `surveyEntries`.`ID` AS EntryID,
  19. `surveyEntries`.`created` AS EntryDate,
  20. `hw_services`.`name` AS Provider,
  21. `surveyQuestions`.`ID` AS QuestionID,
  22. `surveyQuestions`.`label` AS Question,
  23. `survey_meta`.`answer` AS Answer,
  24. `surveyQuestions`.`parentID` AS ParentQuestion
  25. FROM `survey`
  26. JOIN `surveyQuestions`
  27. ON `survey`.`ID` = `surveyQuestions`.`surveyID`
  28. JOIN `surveyEntries`
  29. ON `survey`.`ID` = `surveyEntries`.`surveyID`
  30. JOIN `survey_meta`
  31. ON `survey`.`ID` = `survey_meta`.`entryID`
  32. JOIN `hw_services`
  33. ON `survey`.`ID` = `hw_services`.`ID`
  34. WHERE `survey`.`ID` =2
  35.  
  36. SELECT
  37. `surveyEntries`.`ID` AS EntryID,
  38. `surveyEntries`.`created` AS EntryDate,
  39. `hw_services`.`name` AS Provider,
  40. `surveyQuestions`.`ID` AS QuestionID,
  41. `surveyQuestions`.`label` AS Question,
  42. `survey_meta`.`answer` AS Answer,
  43. `surveyQuestions`.`parentID` AS ParentQuestion
  44. FROM `survey`
  45. JOIN `surveyQuestions`
  46. ON `survey`.`ID` = `surveyQuestions`.`surveyID`
  47.  
  48. JOIN `surveyEntries`
  49. ON `survey`.`ID` = `surveyEntries`.`surveyID`
  50.  
  51. JOIN `survey_meta`
  52. ON `surveyEntries`.`surveyID` = `survey_meta`.`entryID`
  53.  
  54. JOIN `hw_services`
  55. ON `hw_services`.`ID` = `surveyEntries `.`hw_serviceID`
  56.  
  57. JOIN `surveyQuestions`
  58. ON `surveyQuestions`.`ID` = `survey_meta`.`questionID`
  59.  
  60. WHERE `survey`.`ID` =2
  61.  
  62. SELECT
  63. `surveyEntries`.`ID` AS EntryID,
  64. `surveyEntries`.`created` AS EntryDate,
  65. `hw_services`.`name` AS Provider,
  66. `surveyQuestions`.`ID` AS QuestionID,
  67. `surveyQuestions`.`label` AS Question,
  68. `survey_meta`.`answer` AS Answer,
  69. `surveyQuestions`.`parentID` AS ParentQuestion
  70. FROM `survey`
  71. JOIN `surveyQuestions`
  72. ON `survey`.`ID` = `surveyQuestions`.`surveyID`
  73. JOIN `surveyEntries`
  74. ON `survey`.`ID` = `surveyEntries`.`surveyID`
  75. JOIN `survey_meta`
  76. ON (`surveyEntries`.`ID` = `survey_meta`.`entryID` AND ` surveyQuestions`.`ID` = `survey_meta`.`questionID`)
  77. JOIN `hw_services`
  78. ON `surveyEntries`.`hw_serviceID` = `hw_services`.`ID`
  79. WHERE `survey`.`ID` =2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement