Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- `surveyEntries`.`ID` AS EntryID,
- `surveyEntries`.`created` AS EntryDate,
- `hw_services`.`name` AS Provider,
- `surveyQuestions`.`ID` AS QuestionID,
- `surveyQuestions`.`label` AS Question,
- `survey_meta`.`answer` AS Answer,
- `surveyQuestions`.`parentID` AS ParentQuestion
- FROM `survey` , `surveyQuestions` , `surveyEntries` , `survey_meta` , `hw_services`
- WHERE `survey`.`ID` =2
- AND `survey`.`ID` = `surveyQuestions`.`surveyID`
- AND `survey`.`ID` = `surveyEntries`.`surveyID`
- AND `surveyEntries`.`ID` = `survey_meta`.`entryID`
- AND `hw_services`.`ID` = `surveyEntries`.`hw_serviceID`
- AND `surveyQuestions`.`ID` = `survey_meta`.`questionID`
- SELECT
- `surveyEntries`.`ID` AS EntryID,
- `surveyEntries`.`created` AS EntryDate,
- `hw_services`.`name` AS Provider,
- `surveyQuestions`.`ID` AS QuestionID,
- `surveyQuestions`.`label` AS Question,
- `survey_meta`.`answer` AS Answer,
- `surveyQuestions`.`parentID` AS ParentQuestion
- FROM `survey`
- JOIN `surveyQuestions`
- ON `survey`.`ID` = `surveyQuestions`.`surveyID`
- JOIN `surveyEntries`
- ON `survey`.`ID` = `surveyEntries`.`surveyID`
- JOIN `survey_meta`
- ON `survey`.`ID` = `survey_meta`.`entryID`
- JOIN `hw_services`
- ON `survey`.`ID` = `hw_services`.`ID`
- WHERE `survey`.`ID` =2
- SELECT
- `surveyEntries`.`ID` AS EntryID,
- `surveyEntries`.`created` AS EntryDate,
- `hw_services`.`name` AS Provider,
- `surveyQuestions`.`ID` AS QuestionID,
- `surveyQuestions`.`label` AS Question,
- `survey_meta`.`answer` AS Answer,
- `surveyQuestions`.`parentID` AS ParentQuestion
- FROM `survey`
- JOIN `surveyQuestions`
- ON `survey`.`ID` = `surveyQuestions`.`surveyID`
- JOIN `surveyEntries`
- ON `survey`.`ID` = `surveyEntries`.`surveyID`
- JOIN `survey_meta`
- ON `surveyEntries`.`surveyID` = `survey_meta`.`entryID`
- JOIN `hw_services`
- ON `hw_services`.`ID` = `surveyEntries `.`hw_serviceID`
- JOIN `surveyQuestions`
- ON `surveyQuestions`.`ID` = `survey_meta`.`questionID`
- WHERE `survey`.`ID` =2
- SELECT
- `surveyEntries`.`ID` AS EntryID,
- `surveyEntries`.`created` AS EntryDate,
- `hw_services`.`name` AS Provider,
- `surveyQuestions`.`ID` AS QuestionID,
- `surveyQuestions`.`label` AS Question,
- `survey_meta`.`answer` AS Answer,
- `surveyQuestions`.`parentID` AS ParentQuestion
- FROM `survey`
- JOIN `surveyQuestions`
- ON `survey`.`ID` = `surveyQuestions`.`surveyID`
- JOIN `surveyEntries`
- ON `survey`.`ID` = `surveyEntries`.`surveyID`
- JOIN `survey_meta`
- ON (`surveyEntries`.`ID` = `survey_meta`.`entryID` AND ` surveyQuestions`.`ID` = `survey_meta`.`questionID`)
- JOIN `hw_services`
- ON `surveyEntries`.`hw_serviceID` = `hw_services`.`ID`
- WHERE `survey`.`ID` =2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement