Something

SELECT name1.userip, name2.lyricid, COUNT( name2.userip ) AS count
FROM lyrics_visits name1
JOIN lyrics_visits name2 ON name1.userip = name2.userip
WHERE name1.lyricid =1849701435
GROUP BY name2.userip
ORDER BY count DESC