SELECT `prefisso`, `id` FROM `prefissi_internazionali` INNER JOIN stati_en ON value=stato WHERE 1AD - +376 AE - +971 AF - +93 AL - +355 AM - +374 AO - +244 AQ - +672 AR - +54 AT - +43 AU - +61 AW - +297 AZ - +994 BA - +387 BD - +880 BE - +32 BF - +226 BG - +359 BH - +973 BI - +257 BJ - +229 BO - +591 BR - +55 BT - +975 BW - +267 BY - +375 BZ - +501 CA - +1 CF - +236 CH - +41 CK - +682 CL - +56 CM - +237 CO - +57 CR - +506 CU - +53 CW - +599 CX - +61-8 CY - +357 CZ - +420 DE - +49 DG - +246 DJ - +253 DK - +45 DZ - +213 EC - +593 EE - +372 EG - +20 ER - +291 ES - +34 ET - +251 FI - +358 FO - +298 FR - +33 GB - +44 GE - +995 GF - +594 GH - +233 GI - +350 GL - +299 GM - +220 GN - +224 GP - +590 GQ - +240 GR - +30 GT - +502 GW - +245 GY - +592 HN - +504 HR - +385 HT - +509 HU - +36 ID - +62 IE - +353 IL - +972 IN - +91 IQ - +964 IR - +98 IS - +354 IT - +39 JO - +962 JP - +81 KE - +254 KH - +855 KI - +686 KM - +269 KW - +965 KZ - +7 LA - +856 LB - +961 LI - +423 LK - +94 LR - +231 LS - +266 LT - +370 LU - +352 LV - +371 LY - +218 MA - +212 MC - +377 MD - +373 ME - +382 MG - +261 MH - +692 MN - +976 MQ - +596 MR - +222 MT - +356 MU - +230 MV - +960 MW - +265 MX - +52 MY - +60 MZ - +258 NA - +264 NC - +687 NE - +227 NF - +672 NG - +234 NI - +505 NL - +31 NO - +47 NP - +977 NR - +674 NU - +683 NZ - +64 OM - +968 PA - +507 PE - +51 PF - +689 PG - +675 PH - +63 PK - +92 PL - +48 PM - +508 PT - +351 PW - +680 PY - +595 QA - +974 RO - +40 RS - +381 RU - +7 SA - +966 SB - +677 SD - +249 SE - +46 SG - +65 SH - +290 SI - +386 SL - +232 SM - +378 SN - +221 SR - +597 SV - +503 SY - +963 SZ - +268 TD - +235 TH - +66 TJ - +992 TK - +690 TM - +993 TN - +216 TR - +90 TV - +688 TW - +886 TZ - +255 UA - +380 UG - +256 UY - +598 UZ - +998 VA - +39 VE - +58 VN - +84 VU - +678 WS - +685 YE - +967 ZA - +27 ZM - +260 ZW - +263