Django 2.2.23 vs 3.2.3
4 removals
33 lines
0 additions
33 lines
SELECT "vle_journal"."id",
SELECT "vle_journal"."id",
"vle_journal"."creation_date",
"vle_journal"."creation_date",
"vle_journal"."update_date",
"vle_journal"."update_date",
"vle_journal"."assignment_id",
"vle_journal"."assignment_id",
"vle_journal"."bonus_points",
"vle_journal"."bonus_points",
"vle_journal"."author_limit",
"vle_journal"."author_limit",
"vle_journal"."stored_name",
"vle_journal"."stored_name",
"vle_journal"."stored_image",
"vle_journal"."stored_image",
"vle_journal"."locked",
"vle_journal"."locked",
"vle_journal"."lms_grade",
"vle_journal"."lms_grade",
"vle_participation"."user_id" AS "p_user",
"vle_participation"."user_id" AS "p_user",
"vle_role"."can_have_journal" AS "can_have_journal"
"vle_role"."can_have_journal" AS "can_have_journal"
FROM "vle_journal"
FROM "vle_journal"
INNER JOIN "vle_assignment"
INNER JOIN "vle_assignment"
ON ( "vle_journal"."assignment_id" = "vle_assignment"."id" )
ON ( "vle_journal"."assignment_id" = "vle_assignment"."id" )
LEFT OUTER JOIN "vle_assignment_courses"
LEFT OUTER JOIN "vle_assignment_courses"
ON ( "vle_assignment"."id" =
ON ( "vle_assignment"."id" =
"vle_assignment_courses"."assignment_id" )
"vle_assignment_courses"."assignment_id" )
LEFT OUTER JOIN "vle_course"
LEFT OUTER JOIN "vle_course"
ON ( "vle_assignment_courses"."course_id" =
ON ( "vle_assignment_courses"."course_id" =
"vle_course"."id" )
"vle_course"."id" )
LEFT OUTER JOIN "vle_participation"
LEFT OUTER JOIN "vle_participation"
ON ( "vle_course"."id" = "vle_participation"."course_id" )
ON ( "vle_course"."id" = "vle_participation"."course_id" )
LEFT OUTER JOIN "vle_role"
LEFT OUTER JOIN "vle_role"
ON ( "vle_participation"."role_id" = "vle_role"."id" )
ON ( "vle_participation"."role_id" = "vle_role"."id" )
LEFT OUTER JOIN "vle_assignmentparticipation"
LEFT OUTER JOIN "vle_assignmentparticipation"
ON ( "vle_journal"."id" =
ON ( "vle_journal"."id" =
"vle_assignmentparticipation"."journal_id" )
"vle_assignmentparticipation"."journal_id" )
WHERE ( "vle_assignment"."is_group_assignment" = true
WHERE ( "vle_assignment"."is_group_assignment"
OR ( "vle_role"."can_have_journal" = true
OR ( "vle_role"."can_have_journal"
AND "vle_participation"."user_id" IN
AND "vle_participation"."user_id" IN
( "vle_assignmentparticipation"."user_id" ) ) )
"vle_assignmentparticipation"."user_id" ) )
LIMIT 1
LIMIT 1