使用php视图上的count的MySQL查询

$result = mysql_query(\"CREATE VIEW temporary(IngList) AS (
                         SELECT DISTINCT (r1.Ingredient) 
                           FROM recipes r1, 
                                recipes r2 
                          WHERE r1.Country = \'$temp\' 
                            AND r2.Country = \'$temp2\' 
                            AND r1.Ingredient = r2.Ingredient) 
                       SELECT COUNT(*) FROM temporary\");

$sql = sprintf(\"SELECT COUNT(DISTINCT r1.Ingredient) 
                  FROM recipes r1
                 WHERE r.country = \'%s\'
                   AND EXISTS(SELECT NULL
                                FROM recipes r2 
                               WHERE r2.Country = \'%s\' 
                                 AND r1.Ingredient = r2.Ingredient)\",
                $temp, $temp2);

$result = mysql_query($sql);

\"SELECT COUNT(DISTINCT r1.Ingredient)
 FROM recipes r1
 JOIN recipes r2 ON r1.Ingredient = r2.Ingredient
 WHERE r1.Country = \'$temp\' 
     AND r2.Country = \'$temp2\'\");