SELECT cpc.id, cpc.country
FROM catalog_purchases_countries AS cpc
INNER JOIN catalog_shipments_types AS cst ON cst.country = cpc.id
INNER JOIN catalog_payments_types AS cpt ON cpt.country = cpc.id