Joomla query regioni+province. Query Joomla inserire la gerarchia di regioni e province italiane nelle categorie

joomla_query_province.sql

INSERT INTO jos_categories
values
(NULL,50,'Abruzzo','Abruzzo','abruzzo',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,1,0,0,NULL),
(NULL,50,'Basilicata','Basilicata','basilicata',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,2,0,0,NULL),
(NULL,50,'Calabria','Calabria','calabria',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,3,0,0,NULL),
(NULL,50,'Campania','Campania','campania',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,4,0,0,NULL),
(NULL,50,'Emilia Romagna','Emilia Romagna','emilia-romagna',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,5,0,0,NULL),
(NULL,50,'Friuli Venezia Giulia','Friuli Venezia Giulia','friuli-venezia-giulia',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,6,0,0,NULL),
(NULL,50,'Lazio','Lazio','lazio',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,7,0,0,NULL),
(NULL,50,'Liguria','Liguria','liguria',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,8,0,0,NULL),
(NULL,50,'Lombardia','Lombardia','lombardia',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,9,0,0,NULL),
(NULL,50,'Marche','Marche','marche',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,10,0,0,NULL),
(NULL,50,'Molise','Molise','molise',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,11,0,0,NULL),
(NULL,50,'Piemonte','Piemonte','piemonte',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,12,0,0,NULL),
(NULL,50,'Puglia','Puglia','puglia',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,13,0,0,NULL),
(NULL,50,'Sardegna','Sardegna','sardegna',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,14,0,0,NULL),
(NULL,50,'Sicilia','Sicilia','sicilia',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,15,0,0,NULL),
(NULL,50,'Toscana','Toscana','toscana',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,16,0,0,NULL),
(NULL,50,'Trentino Alto Adige','Trentino Alto Adige','trentino-alto-adige',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,17,0,0,NULL),
(NULL,50,'Umbria','Umbria','umbria',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,18,0,0,NULL),
(NULL,50,'Valle di Aosta','Valle di Aosta','valle-di-aosta',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,19,0,0,NULL),
(NULL,50,'Veneto','Veneto','veneto',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,20,0,0,NULL)


(NULL,65,'Agrigento','Agrigento','AG',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,1,0,0,NULL),
(NULL,62,'Alessandria','Alessandria','AL',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,2,0,0,NULL),
(NULL,60,'Ancona','Ancona','AN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,3,0,0,NULL),
(NULL,69,'Aosta','Aosta','AO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,4,0,0,NULL),
(NULL,66,'Arezzo','Arezzo','AR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,5,0,0,NULL),
(NULL,60,'Ascoli Piceno','Ascoli Piceno','AP',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,6,0,0,NULL),
(NULL,62,'Asti','Asti','AT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,7,0,0,NULL),
(NULL,54,'Avellino','Avellino','AV',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,8,0,0,NULL),
(NULL,63,'Bari','Bari','BA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,9,0,0,NULL),
(NULL,70,'Belluno','Belluno','BL',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,10,0,0,NULL),
(NULL,54,'Benevento','Benevento','BN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,11,0,0,NULL),
(NULL,59,'Bergamo','Bergamo','BG',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,12,0,0,NULL),
(NULL,62,'Biella','Biella','BI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,13,0,0,NULL),
(NULL,55,'Bologna','Bologna','BO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,14,0,0,NULL),
(NULL,67,'Bolzano','Bolzano','BZ',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,15,0,0,NULL),
(NULL,59,'Brescia','Brescia','BS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,16,0,0,NULL),
(NULL,63,'Brindisi','Brindisi','BR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,17,0,0,NULL),
(NULL,64,'Cagliari','Cagliari','CA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,18,0,0,NULL),
(NULL,65,'Caltanissetta','Caltanissetta','CL',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,19,0,0,NULL),
(NULL,61,'Campobasso','Campobasso','CB',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,20,0,0,NULL),
(NULL,54,'Caserta','Caserta','CE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,21,0,0,NULL),
(NULL,65,'Catania','Catania','CT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,22,0,0,NULL),
(NULL,53,'Catanzaro','Catanzaro','CZ',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,23,0,0,NULL),
(NULL,51,'Chieti','Chieti','CH',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,24,0,0,NULL),
(NULL,59,'Como','Como','CO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,25,0,0,NULL),
(NULL,53,'Cosenza','Cosenza','CS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,26,0,0,NULL),
(NULL,59,'Cremona','Cremona','CR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,27,0,0,NULL),
(NULL,53,'Crotone','Crotone','KR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,28,0,0,NULL),
(NULL,62,'Cuneo','Cuneo','CN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,29,0,0,NULL),
(NULL,65,'Enna','Enna','EN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,30,0,0,NULL),
(NULL,55,'Ferrara','Ferrara','FE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,31,0,0,NULL),
(NULL,66,'Firenze','Firenze','FI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,32,0,0,NULL),
(NULL,63,'Foggia','Foggia','FG',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,33,0,0,NULL),
(NULL,55,'Forlì Cesena','Forlì Cesena','FC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,34,0,0,NULL),
(NULL,57,'Frosinone','Frosinone','FR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,35,0,0,NULL),
(NULL,58,'Genova','Genova','GE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,36,0,0,NULL),
(NULL,56,'Gorizia','Gorizia','GO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,37,0,0,NULL),
(NULL,66,'Grosseto','Grosseto','GR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,38,0,0,NULL),
(NULL,58,'Imperia','Imperia','IM',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,39,0,0,NULL),
(NULL,61,'Isernia','Isernia','IS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,40,0,0,NULL),
(NULL,58,'La Spezia','La Spezia','SP',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,41,0,0,NULL),
(NULL,51,'L''Aquila','L''Aquila','AQ',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,42,0,0,NULL),
(NULL,57,'Latina','Latina','LT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,43,0,0,NULL),
(NULL,63,'Lecce','Lecce','LE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,44,0,0,NULL),
(NULL,59,'Lecco','Lecco','LC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,45,0,0,NULL),
(NULL,66,'Livorno','Livorno','LI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,46,0,0,NULL),
(NULL,59,'Lodi','Lodi','LO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,47,0,0,NULL),
(NULL,66,'Lucca','Lucca','LU',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,48,0,0,NULL),
(NULL,60,'Macerata','Macerata','MC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,49,0,0,NULL),
(NULL,59,'Mantova','Mantova','MN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,50,0,0,NULL),
(NULL,66,'Massa Carrara','Massa Carrara','MS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,51,0,0,NULL),
(NULL,52,'Matera','Matera','MT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,52,0,0,NULL),
(NULL,65,'Messina','Messina','ME',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,53,0,0,NULL),
(NULL,59,'Milano','Milano','MI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,54,0,0,NULL),
(NULL,55,'Modena','Modena','MO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,55,0,0,NULL),
(NULL,54,'Napoli','Napoli','NA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,56,0,0,NULL),
(NULL,62,'Novara','Novara','NO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,57,0,0,NULL),
(NULL,64,'Nuoro','Nuoro','NU',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,58,0,0,NULL),
(NULL,64,'Oristano','Oristano','OR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,59,0,0,NULL),
(NULL,70,'Padova','Padova','PD',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,60,0,0,NULL),
(NULL,65,'Palermo','Palermo','PA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,61,0,0,NULL),
(NULL,55,'Parma','Parma','PR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,62,0,0,NULL),
(NULL,59,'Pavia','Pavia','PV',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,63,0,0,NULL),
(NULL,68,'Perugia','Perugia','PG',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,64,0,0,NULL),
(NULL,60,'Pesaro e Urbino','Pesaro e Urbino','PU',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,65,0,0,NULL),
(NULL,51,'Pescara','Pescara','PE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,66,0,0,NULL),
(NULL,55,'Piacenza','Piacenza','PC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,67,0,0,NULL),
(NULL,66,'Pisa','Pisa','PI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,68,0,0,NULL),
(NULL,66,'Pistoia','Pistoia','PT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,69,0,0,NULL),
(NULL,56,'Pordenone','Pordenone','PN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,70,0,0,NULL),
(NULL,52,'Potenza','Potenza','PZ',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,71,0,0,NULL),
(NULL,66,'Prato','Prato','PO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,72,0,0,NULL),
(NULL,65,'Ragusa','Ragusa','RG',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,73,0,0,NULL),
(NULL,55,'Ravenna','Ravenna','RA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,74,0,0,NULL),
(NULL,53,'Reggio Calabria','Reggio Calabria','RC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,75,0,0,NULL),
(NULL,55,'Reggio Emilia','Reggio Emilia','RE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,76,0,0,NULL),
(NULL,57,'Rieti','Rieti','RI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,77,0,0,NULL),
(NULL,55,'Rimini','Rimini','RN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,78,0,0,NULL),
(NULL,57,'Roma','Roma','RM',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,79,0,0,NULL),
(NULL,70,'Rovigo','Rovigo','RO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,80,0,0,NULL),
(NULL,54,'Salerno','Salerno','SA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,81,0,0,NULL),
(NULL,64,'Sassari','Sassari','SS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,82,0,0,NULL),
(NULL,58,'Savona','Savona','SV',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,83,0,0,NULL),
(NULL,66,'Siena','Siena','SI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,84,0,0,NULL),
(NULL,65,'Siracusa','Siracusa','SR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,85,0,0,NULL),
(NULL,59,'Sondrio','Sondrio','SO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,86,0,0,NULL),
(NULL,63,'Taranto','Taranto','TA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,87,0,0,NULL),
(NULL,51,'Teramo','Teramo','TE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,88,0,0,NULL),
(NULL,68,'Terni','Terni','TR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,89,0,0,NULL),
(NULL,62,'Torino','Torino','TO',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,90,0,0,NULL),
(NULL,65,'Trapani','Trapani','TP',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,91,0,0,NULL),
(NULL,67,'Trento','Trento','TN',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,92,0,0,NULL),
(NULL,70,'Treviso','Treviso','TV',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,93,0,0,NULL),
(NULL,56,'Trieste','Trieste','TS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,94,0,0,NULL),
(NULL,56,'Udine','Udine','UD',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,95,0,0,NULL),
(NULL,59,'Varese','Varese','VA',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,96,0,0,NULL),
(NULL,70,'Venezia','Venezia','VE',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,97,0,0,NULL),
(NULL,62,'Verbano Cusio Ossola','Verbano Cusio Ossola','VB',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,98,0,0,NULL),
(NULL,62,'Vercelli','Vercelli','VC',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,99,0,0,NULL),
(NULL,70,'Verona','Verona','VR',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,100,0,0,NULL),
(NULL,53,'Vibo Valentia','Vibo Valentia','VV',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,101,0,0,NULL),
(NULL,70,'Vicenza','Vicenza','VI',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,102,0,0,NULL),
(NULL,57,'Viterbo','Viterbo','VT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,103,0,0,NULL),
(NULL,55,'San Marino','San Marino','RS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,104,0,0,NULL),
(NULL,64,'Medio Campidano','Medio Campidano','VS',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,105,0,0,NULL),
(NULL,63,'Barletta Andria Trani','Barletta Andria Trani','BT',NULL,'com_contact_details','left',NULL,1,0,'0000-00-00 00:00:00',NULL,106,0,0,NULL);