Musikwunsch
WordPress-Datenbank-Fehler: [Table 'songs' is marked as crashed and should be repaired]SELECT COUNT(DISTINCT s.ID) FROM `songs` AS s WHERE s.enabled = 1 AND s.song_type IN(0)
WordPress-Datenbank-Fehler: [Table 'songs' is marked as crashed and should be repaired]SELECT s.`ID`, s.`artist`, s.`title`, s.`duration`, s.`date_played`, s.`artist_played`,
TIMESTAMPDIFF(MINUTE, s.`date_played`, NOW()) AS `played_minutes`,
TIMESTAMPDIFF(MINUTE, s.`artist_played`, NOW()) AS `artist_played_minutes`,
MAX(CASE WHEN r.played = 0 THEN 1 ELSE 0 END) AS requested,
MIN(CASE WHEN r.played = 0 THEN TIMESTAMPDIFF(MINUTE, r.requested, NOW()) END) AS `requested_minutes`,
MAX(CASE WHEN q.songID IS NOT NULL THEN 1 ELSE 0 END) AS in_queue
FROM `songs` AS s
LEFT JOIN `requests` AS r ON( s.ID = r.songID )
LEFT JOIN `queuelist` AS q ON ( s.ID = q.songID )
WHERE s.enabled = 1
AND s.song_type IN(0)
GROUP BY s.ID
ORDER BY s.artist, s.title ASC
LIMIT 0, 100
