Received: from mail.netlandish.com (mail.netlandish.com [174.136.98.166]) by code.netlandish.com (Postfix) with ESMTP id 62A2FA4 for <~netlandish/links-dev@lists.code.netlandish.com>; Thu, 30 Jan 2025 22:28:55 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.217.44; helo=mail-vs1-f44.google.com; envelope-from=peter@netlandish.com; receiver= Authentication-Results: mail.netlandish.com; dkim=pass (1024-bit key; unprotected) header.d=netlandish.com header.i=@netlandish.com header.b=XtOj06cR Received: from mail-vs1-f44.google.com (mail-vs1-f44.google.com [209.85.217.44]) by mail.netlandish.com (Postfix) with ESMTP id 7DE951D80BE for <~netlandish/links-dev@lists.code.netlandish.com>; Thu, 30 Jan 2025 22:35:40 +0000 (UTC) Received: by mail-vs1-f44.google.com with SMTP id ada2fe7eead31-4afd68271b6so418327137.0 for <~netlandish/links-dev@lists.code.netlandish.com>; Thu, 30 Jan 2025 14:35:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=netlandish.com; s=google; t=1738276539; x=1738881339; darn=lists.code.netlandish.com; h=content-transfer-encoding:mime-version:message-id:date:subject:cc :to:from:from:to:cc:subject:date:message-id:reply-to; bh=L5O73pFHq9mPvafXf0cVSl8alk2TX+fATYdKUzdTXJY=; b=XtOj06cRs87N7ZSSfQoqYhM+en3LbAeW9GIDAPoQ+4bZXjVSzm9rgxqIiC6ArnI0aZ gCw0Ep8XWXjBlOCD5uWOkdQ0IjMLzrgBVeAEDdQzbXIZpw2sbupvO7MGc6AwWKYvKXJu vfGHu05REwDdcedoI24By5fUuUdaPIxv+mV3o= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738276539; x=1738881339; h=content-transfer-encoding:mime-version:message-id:date:subject:cc :to:from:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=L5O73pFHq9mPvafXf0cVSl8alk2TX+fATYdKUzdTXJY=; b=TsWHn6gOgtsnnvwkh0VUBzWgwdFgTN8WTbBv9VuDu8UPPx5HB8x+HzNKfYeJ/NYLhg /gXuZmXApwV+Bihe5Omv/Ltd28ge5xYbdq/YY80U4adM/Iz/Kz6KCWK76QFUktmlOD9X JD4WwrGmS9WPFUTviORzjOwmg/xoFoK24MO5TvJOBb+c6fgZmQetuuDZtS5eMvd8+BjR q1AxSvjr1LqIWseZbit0UFCMADJvKvxZz5cx9XwrWv8iRF5CDvP6kw3hB+pnSJPMOWGX MjBo7vZrRr0os2CCcGHtxZoUOuQYVlEQmNG2WpGs8sdX+S8S+ULZwqMSH+5inU6xWg6e se/Q== X-Gm-Message-State: AOJu0Yydn2P8zGdJ3LUKWq39bKG6KVFxCc7r4W9wg49GztB4Eu6CRMmz Z6HIS+9oFLQ2i4gffPl3P7SQgJmDxCUy6w8HcDgQ1ZqsrUaG97VkRbKsN5a4s7RTXw2AK349ogM x7BY= X-Gm-Gg: ASbGncttto96C9KiWFyZoVI6Lh+3Iw8MWoUfoFL4aGuuL3XiLoKOLV/A6umLjimRfXy QhDn9kvYCMbBWs1YPH6ev0Sn2CYnCBJxMpv/LZrKDjjaAz/cTvFu3RTZU8ISzTwc/1jNoVut+K5 WUjQ+nAVhz+2ToAe9fiDlz0K3MHRWGC3cCbJL6IA/9amKB6ztpQ/hXVjmoIAaWhsvk44IQOpDhG mBYT5+8PhJjis7XkasVvJIkO/AdqkmlyyTpioM7kvJf7U15ZHd7QQFd1z4WTrqoOsPwK15+OXj5 JsCdwZDEI0Pdfz97 X-Google-Smtp-Source: AGHT+IG6nDSx+zLoCbFeNF+9QGN0cQjL5shZcj6j497q/YoNbA8LxV+2/PRo3xtr/KPj+IYB096qRw== X-Received: by 2002:a05:6102:3e85:b0:4b2:48ba:9943 with SMTP id ada2fe7eead31-4b9a527dademr8845589137.24.1738276539506; Thu, 30 Jan 2025 14:35:39 -0800 (PST) Received: from localhost ([2803:2d60:1118:5ee:b492:b3d3:f684:70c8]) by smtp.gmail.com with ESMTPSA id ada2fe7eead31-4b9baa13c6dsm414202137.5.2025.01.30.14.35.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 30 Jan 2025 14:35:38 -0800 (PST) From: Peter Sanchez To: ~netlandish/links-dev@lists.code.netlandish.com Cc: Peter Sanchez Subject: [PATCH links] After number of saves, order popular list by most recent first. Date: Thu, 30 Jan 2025 16:35:20 -0600 Message-ID: <20250130223536.17520-1-peter@netlandish.com> X-Mailer: git-send-email 2.47.2 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Changelog-changed: Popular listing page will now use the database ID to order the listing after popular counter. This will allow most recent items to show first. --- api/loaders/loaders.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/api/loaders/loaders.go b/api/loaders/loaders.go index a3d99dd..9b8cde6 100644 --- a/api/loaders/loaders.go +++ b/api/loaders/loaders.go @@ -39,7 +39,7 @@ func getPopularLinks(ctx context.Context) func(key []string) ([][]*models.BaseUR sq.Eq{"b.public_ready": true}, sq.Gt{"b.counter": 0}, }, - OrderBy: "counter DESC", + OrderBy: "counter DESC, b.id DESC", Limit: 50, } -- 2.47.2