registro columna row duplicado duplicate
SELECT a.id, a.title, a.image, a.link, a.date FROM ps_aps a INNER JOIN ps_aps b ON a.date = b.date AND a.link LIKE 'https://%' WHERE a.id <> b.id ORDER BY a.date