Don't like ads? PRO users don't see any ads ;-)
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
- SELECT "amavisd_emailaccount"."id", "amavisd_emailaccount"."created_at", "amavisd_emailaccount"."updated_at", "amavisd_emailaccount"."domain_id", "amavisd_emailaccount"."priority", "amavisd_emailaccount"."policy_id", "amavisd_emailaccount"."user_id", "amavisd_emailaccount"."localpart", "amavisd_emailaccount"."contact_id", "amavisd_emailaccount"."notification_task_id" FROM "amavisd_emailaccount" INNER JOIN "amavisd_domain" ON ("amavisd_emailaccount"."domain_id" = "amavisd_domain"."id") INNER JOIN "amavisd_priorityperiodictask" ON ("amavisd_domain"."notification_task_id" = "amavisd_priorityperiodictask"."periodictask_ptr_id") INNER JOIN "amavisd_priorityperiodictask" T4 ON ("amavisd_emailaccount"."notification_task_id" = T4."periodictask_ptr_id") INNER JOIN "djcelery_periodictask" ON (T4."periodictask_ptr_id" = "djcelery_periodictask"."id") INNER JOIN "djcelery_crontabschedule" ON ("djcelery_periodictask"."crontab_id" = "djcelery_crontabschedule"."id") INNER JOIN "djcelery_periodictask" T7 ON ("amavisd_priorityperiodictask"."periodictask_ptr_id" = T7."id") INNER JOIN "djcelery_crontabschedule" T8 ON (T7."crontab_id" = T8."id") WHERE (T4."priority" > "amavisd_priorityperiodictask"."priority" AND "djcelery_periodictask"."enabled" = TRUE AND "djcelery_crontabschedule"."day_of_week" LIKE %fri% ESCAPE '\' AND T7."enabled" = True AND T8."day_of_week" LIKE %fri% ESCAPE '\' AND T4."priority" < "amavisd_priorityperiodictask"."priority") ORDER BY "amavisd_emailaccount"."localpart" ASC, "amavisd_domain"."name" ASC
create a new version of this paste
RAW Paste Data