WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]
SELECT
td.id AS track_pk,
COALESCE(te.external_id, td.primary_external_id) AS track_id,
td.track_name,
COUNT(DISTINCT t.id) AS play_count,
SUM(td.duration_ms) / 60000 AS total_minutes_played,
COUNT(DISTINCT t.wp_user_id) AS unique_listeners,
td.image_link AS track_image,
a.id AS artist_pk,
COALESCE(ae.external_id, a.primary_external_id) AS artist_id,
a.artist_name,
t.platform_id,
p.slug AS platform_slug,
CASE
WHEN tdets.estimated_duration_ms > 0
AND tdets.duration_confidence IS NOT NULL
AND tdets.duration_confidence >= 0.5
THEN 1 ELSE 0
END AS duration_verified
FROM tpn_track_plays t
JOIN tpn_tracks td ON t.track_pk = td.id
LEFT JOIN tpn_track_details tdets ON tdets.track_pk = td.id
LEFT JOIN tpn_artists a ON t.artist_pk = a.id
LEFT JOIN tpn_track_external_ids te ON te.track_pk = td.id AND te.platform_id = t.platform_id
LEFT JOIN tpn_artist_external_ids ae ON ae.artist_pk = a.id AND ae.platform_id = t.platform_id
LEFT JOIN tpn_platforms p ON p.id = t.platform_id
WHERE t.played_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)
GROUP BY td.id
ORDER BY play_count DESC, total_minutes_played DESC
LIMIT 5
WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]
SELECT
td.id AS track_pk,
COALESCE(te.external_id, td.primary_external_id) AS track_id,
td.track_name,
COUNT(DISTINCT t.id) AS play_count,
SUM(td.duration_ms) / 60000 AS total_minutes_played,
COUNT(DISTINCT t.wp_user_id) AS unique_listeners,
td.image_link AS track_image,
a.id AS artist_pk,
COALESCE(ae.external_id, a.primary_external_id) AS artist_id,
a.artist_name,
t.platform_id,
p.slug AS platform_slug,
CASE
WHEN tdets.estimated_duration_ms > 0
AND tdets.duration_confidence IS NOT NULL
AND tdets.duration_confidence >= 0.5
THEN 1 ELSE 0
END AS duration_verified
FROM tpn_track_plays t
JOIN tpn_tracks td ON t.track_pk = td.id
LEFT JOIN tpn_track_details tdets ON tdets.track_pk = td.id
LEFT JOIN tpn_artists a ON t.artist_pk = a.id
LEFT JOIN tpn_track_external_ids te ON te.track_pk = td.id AND te.platform_id = t.platform_id
LEFT JOIN tpn_artist_external_ids ae ON ae.artist_pk = a.id AND ae.platform_id = t.platform_id
LEFT JOIN tpn_platforms p ON p.id = t.platform_id
WHERE t.played_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)
GROUP BY td.id
ORDER BY play_count DESC, total_minutes_played DESC
LIMIT 10
WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]SELECT DISTINCT
a.id AS artist_pk,
ae.external_id AS artist_id,
a.artist_name,
a.image_link,
a.popularity,
a.created
FROM tpn_artists a
LEFT JOIN tpn_artist_external_ids ae
ON ae.artist_pk = a.id AND ae.platform_id = 1
WHERE EXISTS (
SELECT 1 FROM tpn_track_plays tp
WHERE tp.artist_pk = a.id
)
ORDER BY a.created DESC
LIMIT 5
WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]
SELECT
gt.genre_id,
gt.genre_name,
gt.total_plays,
gt.top_artist_pk,
gt.top_artist_name,
gt.top_artist_image,
gt.top_artist_plays,
gt.top_track_pk,
gt.top_track_name,
gt.top_track_image,
gt.top_track_plays,
gt.top_track_artist_name,
gt.top_track_artist_pk,
ae.external_id AS top_artist_spotify_id,
te.external_id AS top_track_spotify_id,
tae.external_id AS top_track_artist_spotify_id
FROM tpn_genres_top gt
LEFT JOIN tpn_artist_external_ids ae
ON ae.artist_pk = gt.top_artist_pk AND ae.platform_id = 1
LEFT JOIN tpn_track_external_ids te
ON te.track_pk = gt.top_track_pk AND te.platform_id = 1
LEFT JOIN tpn_artist_external_ids tae
ON tae.artist_pk = gt.top_track_artist_pk AND tae.platform_id = 1
ORDER BY gt.total_plays DESC
LIMIT 8