$query = "SELECT
      DISTINCT COUNT(*) as count, address_book.entry_country_id,  countries.countries_name
FROM
    address_book
JOIN
      customers ON address_book.customers_id = address_book.customers_id
JOIN
      countries ON address_book.entry_country_id = countries.countries_id
WHERE
      customers.customers_default_address_id = address_book.address_book_id
      AND countries.countries_name='Spain'
      
GROUP BY
      entry_country_id
ORDER BY
      countries.countries_name";  
  $result = mysql_query($query) or die("Temporary query failure: " . mysql_error());

  echo "    <table>\n";
  echo "      <tr class=\"header\"><th>country</th><th>customers</th></tr>\n";
  while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    echo "      <tr>\n";
    echo "        <td><a href=\"cities.php?country_id=$row[1]\">$row[2]</a></td>\n";
    echo "        <td align=\"center\">$row[0]</td>\n";
    echo "      </tr>\n";
  }
  echo "    </table>\n";

  mysql_free_result($result);
?>

(SELECT products_model
          FROM orders_products
         WHERE products_model = '0003')

SELECT 
	DISTINCT COUNT(*) AS count, 
	c.countries_name, 
FROM 
	orders o
INNER JOIN
	orders_products op ON o.orders_id = op.orders_id
INNER JOIN
	countries c ON o.customers_country = c.countries_name
WHERE
	c.countries_name = 'Spain'
  AND 
	op.products_model = '0003';