Io ho provato in questo modo ma dà errore

codice:
SELECT catalog_purchases_country.id AS id ,
		                 catalog_purchases_country.country AS country,
FROM catalog_purchases_countries
WHERE ( SELECT COUNT(catalog_payments_types.id) 
          FROM catalog_payments_types WHERE country = id ) > 0
AND ( SELECT COUNT(catalog_shipments_types.id)
        FROM catalog_shipments_types WHERE country = id ) > 0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM catalog_purchases_countries WHERE ( SELECT COUNT(catalog_payments_t' at line 3