A string of characters that are found to be the longest in a jq string and appear more than twice

for example: abcd12345bnfdvvabcd12345hhnvgabcd1234567abc
look up the string next to the string that appears more than twice. The longest string meets the condition first. The result of the character search is that the number of abcd12345 occurrences is 3

.
Sep.25,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b39a56-4d84b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b39a56-4d84b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?