MySQL Fehler bei Abfrage nach Bestellungen pro Land

[sugar99]

Ich würde gern eine Karte anzeigen lassen in welchem Land bzw. Kontinent wieviele Bestellungen von einem bestimmten Produkt es gibt. Folgendes Script zeigt mir leider alle Bestellungen von den entsprechenden Ländern an, nicht diese die zu dem Produkt (0001) gehören. Also irgendwie scheint die "WHERE" Abfrage falsch zu sein? Kann mir jemand helfen?

PHP-Code:

 $query = "SELECT 
DISTINCT COUNT(*) as count, orders.orders_id, orders.customers_country, countries.countries_name, orders_products.products_model
      
  FROM orders

JOIN
      orders_products ON orders.orders_id = orders_products.orders_id
JOIN
      countries ON orders.customers_country = countries.countries_name
WHERE 
      countries.countries_name='Andorra' OR countries.countries_name='Austria' OR countries.countries_name='Belgium' OR countries.countries_name='Bosnia and Herzegowina' OR countries.countries_name='Bulgaria' OR countries.countries_name='Denmark' OR countries.countries_name='Germany' OR countries.countries_name='Estonia' OR countries.countries_name='Faroe Islands' OR countries.countries_name='Finland' OR countries.countries_name='France' OR countries.countries_name='Gibraltar' OR countries.countries_name='Greenland' OR countries.countries_name='Greece' OR countries.countries_name='United Kingdom' OR countries.countries_name='Ireland' OR countries.countries_name='Iceland' OR countries.countries_name='Italy' OR countries.countries_name='Croatia' OR countries.countries_name='Latvia' OR countries.countries_name='Liechtenstein' OR countries.countries_name='Lithuania' OR countries.countries_name='Luxembourg' OR countries.countries_name='Malta' OR countries.countries_name='Macedonia' OR countries.countries_name='Moldova' OR countries.countries_name='Monaco' OR countries.countries_name='Netherlands' OR countries.countries_name='Norway' OR countries.countries_name='Poland' OR countries.countries_name='Portugal' OR countries.countries_name='Romania' OR countries.countries_name='San Marino' OR countries.countries_name='Sweden' OR countries.countries_name='Switzerland' OR countries.countries_name='Slovakia' OR countries.countries_name='Slovenia' OR countries.countries_name='Spain' OR countries.countries_name='Turkey' OR countries.countries_name='Czech Republic' OR countries.countries_name='Ukraine' OR countries.countries_name='Hungary' OR countries.countries_name='Cyprus'
     
     AND orders_products.products_model ='0001'
      
GROUP BY 
      countries.countries_name";
      
  $result = mysql_query($query) or die("Temporary query failure: " . mysql_error());
  
  echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
    <td width=\"25%\"><img src=\"/images/map_europe.gif\" width=\"246\" height=\"185\" /></td>
    <td width=\"75%\">";
 
  echo "    <table>\n";
  while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    echo "      <tr>\n";
    echo "        <td>$row[2]</td>\n";
    echo "        <td align=\"center\">$row[0]</td>\n";
    echo "      </tr>\n";
  }
  echo "    </table>\n";
   echo " </td>
  </tr>
</table>\n";
 
  mysql_free_result($result); 


Danke!