WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]
SELECT a.id AS artist_pk,
ae.external_id AS artist_id,
a.artist_name,
a.image_link,
COUNT(DISTINCT t.id) as play_count
FROM tpn_track_plays t
JOIN tpn_genre_to_track gt ON t.track_pk = gt.track_pk
JOIN tpn_artists a ON t.artist_pk = a.id
LEFT JOIN tpn_artist_external_ids ae
ON ae.artist_pk = a.id AND ae.platform_id = 1
WHERE gt.genre_id = 432
GROUP BY a.id
ORDER BY play_count DESC
LIMIT 10
WordPress database error: [Table 'cipekany_tipinostag.tpn_artist_external_ids' doesn't exist]
SELECT td.id AS track_pk,
te.external_id AS track_id,
td.track_name,
a.id AS artist_pk,
ae.external_id AS artist_id,
a.artist_name,
td.image_link,
COUNT(DISTINCT t.id) as play_count
FROM tpn_track_plays t
JOIN tpn_genre_to_track gt ON t.track_pk = gt.track_pk
JOIN tpn_tracks td ON t.track_pk = td.id
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 = 1
LEFT JOIN tpn_artist_external_ids ae
ON ae.artist_pk = a.id AND ae.platform_id = 1
WHERE gt.genre_id = 432
GROUP BY td.id
ORDER BY play_count DESC
LIMIT 10