Back
Remote OK
Load previous page…
manage to figure out how to add sticky jobs into SQL query by doing ORDER BY max(coalesce(epoch,0),coalesce(epoch_bumped,0),(coalesce(is_sticky_day,0)+86400),(coalesce(is_sticky_week,0)+604800),(coalesce(is_sticky_month,0)+2592000))) so that we don’t need to “manually” add the sticky jobs on top with code but it just sorts it straight into db (86400 is 24h, 604800 is 7 days, 2592000 is 30 days etc.) #remoteok