How to fix this request?

Question

MySQL

How to fix this request?

SELECT COUNT(*)
      FROM joiners_tourdate
        JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
      WHERE joiners_tourdate.artist_id = joiners_artist.id
      AND joiners_tourdate.country_id = 3

joiners_artist.id not found here ?

Answer 1

Either way

SELECT COUNT(*)
FROM joiners_tourdate, joiners_artist
JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
WHERE joiners_tourdate.artist_id = joiners_artist.id
AND joiners_tourdate.country_id = 3

Or change it to join

SELECT COUNT(*)
FROM joiners_tourdate 
JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
JOIN joiners_artist ON joiners_tourdate.artist_id = joiners_artist.id
WHERE joiners_tourdate.country_id = 3

Answer 2

Because you don't have it ?
Add it to JOIN:

SELECT COUNT(*)
FROM joiners_tourdate
INNER JOIN joiners_country on joiners_tourdate.country_id = joiners_country.id
INNER JOIN joiners_artist on joiners_artist.id = joiners_tourdate.artist_id
WHERE joiners_tourdate.country_id = 3

Answer 3

And what is within this query joiners_artist.id ? What horrible id from joiners_artist table?
How would a pair of tables be specified, and in the condition a third one suddenly appears ... It turns out "a pen is attached to the file, how old is the train driver?" -)
Apparently, for example, the higher select from joiners_artist was lost - then everything will fall into place. Or you need to somehow join the joiners_artist table