An Error Was Encountered

Error Number: 1054

Champ 'boutique.club' inconnu dans where clause

SELECT s.id,s.nom,(SELECT COUNT(boutique.id) FROM boutique WHERE boutique.id_station=s.id AND boutique.club!="oui") as boutiques FROM station s WHERE id>0 AND s.categorie="SPORTS" GROUP BY id ORDER BY s.nom