SELECTt0.idASid_1,t0.originASorigin_2,t0.messageASmessage_3,t0.linkASlink_4,t0.dateASdate_5,t0.categoryAScategory_6,t0.organization_idASorganization_id_7,t0.user_idASuser_id_8FROMnotificationt0WHEREt0.category=?ANDt0.user_idISNULLAND ((t0.organization_id=1)) ORDER BYt0.dateDESC
SELECTt0.idASid_1,t0.originASorigin_2,t0.messageASmessage_3,t0.linkASlink_4,t0.dateASdate_5,t0.categoryAScategory_6,t0.organization_idASorganization_id_7,t0.user_idASuser_id_8FROMnotificationt0WHEREt0.category=?ANDt0.user_idISNULLAND (
(t0.organization_id=1)
)
ORDER BYt0.dateDESC
SELECTt0.idASid_1,t0.originASorigin_2,t0.messageASmessage_3,t0.linkASlink_4,t0.dateASdate_5,t0.categoryAScategory_6,t0.organization_idASorganization_id_7,t0.user_idASuser_id_8FROMnotificationt0WHEREt0.category='homework_to_do'ANDt0.user_idISNULLAND ((t0.organization_id=1)) ORDER BYt0.dateDESC;
SELECTf0_.idASid_0,f0_.titleAStitle_1,f0_.created_atAScreated_at_2,f0_.updated_atASupdated_at_3,f0_.is_pinnedASis_pinned_4,f0_.is_solvedASis_solved_5,f0_.tagsAStags_6,f0_.organization_idASorganization_id_7,f1_.idASid_8,f1_.nameASname_9,f1_.slugASslug_10,f1_.organization_idASorganization_id_11,f2_.idASid_12,f2_.contentAScontent_13,f2_.created_atAScreated_at_14,f2_.is_solutionASis_solution_15,f2_.organization_idASorganization_id_16,f0_.category_idAScategory_id_17,f0_.author_idASauthor_id_18,f2_.topic_idAStopic_id_19,f2_.author_idASauthor_id_20FROMforum_topicf0_LEFT JOINforum_categoryf1_ONf0_.category_id=f1_.idAND (f1_.organization_id=1) LEFT JOINforum_postf2_ONf0_.id=f2_.topic_idAND (f2_.organization_id=1) WHERE (f0_.organization_id=1) ORDER BYf0_.is_pinnedDESC,f0_.updated_atDESC
SELECTf0_.idASid_0,f0_.titleAStitle_1,f0_.created_atAScreated_at_2,f0_.updated_atASupdated_at_3,f0_.is_pinnedASis_pinned_4,f0_.is_solvedASis_solved_5,f0_.tagsAStags_6,f0_.organization_idASorganization_id_7,f1_.idASid_8,f1_.nameASname_9,f1_.slugASslug_10,f1_.organization_idASorganization_id_11,f2_.idASid_12,f2_.contentAScontent_13,f2_.created_atAScreated_at_14,f2_.is_solutionASis_solution_15,f2_.organization_idASorganization_id_16,f0_.category_idAScategory_id_17,f0_.author_idASauthor_id_18,f2_.topic_idAStopic_id_19,f2_.author_idASauthor_id_20FROMforum_topicf0_LEFT JOINforum_categoryf1_ONf0_.category_id=f1_.idAND (f1_.organization_id=1)
LEFT JOINforum_postf2_ONf0_.id=f2_.topic_idAND (f2_.organization_id=1)
WHERE
(f0_.organization_id=1)
ORDER BYf0_.is_pinnedDESC,f0_.updated_atDESC
SELECTf0_.idASid_0,f0_.titleAStitle_1,f0_.created_atAScreated_at_2,f0_.updated_atASupdated_at_3,f0_.is_pinnedASis_pinned_4,f0_.is_solvedASis_solved_5,f0_.tagsAStags_6,f0_.organization_idASorganization_id_7,f1_.idASid_8,f1_.nameASname_9,f1_.slugASslug_10,f1_.organization_idASorganization_id_11,f2_.idASid_12,f2_.contentAScontent_13,f2_.created_atAScreated_at_14,f2_.is_solutionASis_solution_15,f2_.organization_idASorganization_id_16,f0_.category_idAScategory_id_17,f0_.author_idASauthor_id_18,f2_.topic_idAStopic_id_19,f2_.author_idASauthor_id_20FROMforum_topicf0_LEFT JOINforum_categoryf1_ONf0_.category_id=f1_.idAND (f1_.organization_id=1) LEFT JOINforum_postf2_ONf0_.id=f2_.topic_idAND (f2_.organization_id=1) WHERE (f0_.organization_id=1) ORDER BYf0_.is_pinnedDESC,f0_.updated_atDESC;