SQL Error:
Out of resources when opening file './lyrics_site/artists.MYD' (Errcode: 24 - Too many open files)
SQL:
SELECT
mis.ID,
CONCAT(IF(a.FirstName="","",CONCAT(a.FirstName," ")),a.Name) AS Artist,
mis.ArtistID,
s.Name AS Song,
mis.SongID,
AES_DECRYPT(mem.Username,"MUS1CANDLYR1CS") AS Username,
mis.MemberID,
mis.RealLyric,
mis.Misheard,
mis.Details,
mis.Convinced,
mis.MedicatedYN,
mis.BetterYN,
mis.AgeRealized,
mis.DateSubmitted,
mis.Popularity,
mis.YouTubeLink
FROM misheards mis
LEFT JOIN artists a on mis.ArtistID=a.ID
LEFT JOIN songs s on mis.SongID=s.ID
LEFT JOIN members mem on mis.MemberID=mem.ID
WHERE mis.ID="11566"
LIMIT 1