scottcrawford03 · August 15, 2018 21:40
diff --git a/bs.sql b/bs.sql
 select recommendations.link, recommendations.recommendation_type, recommendations.title, profile_question_options.option_data, recommendations.profile_question_option_id, recommendations.priority
 from recommendations
 inner join profile_question_options on profile_question_options.id = recommendations.profile_question_option_id
 where (recommendations.priority=2 and recommendations.recommendation_type='article' and recommendations.profile_question_option_id in` + oneClickParams + `)
 or (recommendations.recommendation_type='article' and recommendations.profile_question_option_id in` + questionOptionQueryParam + `)
 order by recommendations.priority
 limit 7;

 -- I want records that match the first where clause to be returned at the top and then i want to order the results of the second where clause by their priority.
 -- If i were to do this with two queries i'd basically just make the first where cluase and add it to an array and then make the second where clause and append it to that same array.
 -- i.e. combining two datasets from the same table where the second dataset is orderd by a column and the first data set is just matching something specific.
	select recommendations.link, recommendations.recommendation_type, recommendations.title, profile_question_options.option_data, recommendations.profile_question_option_id, recommendations.priority
	from recommendations
	inner join profile_question_options on profile_question_options.id = recommendations.profile_question_option_id
	where (recommendations.priority=2 and recommendations.recommendation_type='article' and recommendations.profile_question_option_id in` + oneClickParams + `)
	or (recommendations.recommendation_type='article' and recommendations.profile_question_option_id in` + questionOptionQueryParam + `)
	order by recommendations.priority
	limit 7;

	-- I want records that match the first where clause to be returned at the top and then i want to order the results of the second where clause by their priority.
	-- If i were to do this with two queries i'd basically just make the first where cluase and add it to an array and then make the second where clause and append it to that same array.
	-- i.e. combining two datasets from the same table where the second dataset is orderd by a column and the first data set is just matching something specific.