 (1,'2014-11-02',14232,(select t.id from swimming_pools t where t.nick_name = 'milanosamuele50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
 (2,'2014-11-09',14233,(select t.id from swimming_pools t where t.nick_name = 'civitavecchiastadiodelnuoto50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
 (2,'2014-11-09',14234,(select t.id from swimming_pools t where t.nick_name = 'napoliscandone50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
+/* Sessione Domenica mattina non presente per il meeting 14235 */
 (1,'2014-11-09',14236,(select t.id from swimming_pools t where t.nick_name = 'saronnocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
 (1,'2014-11-09',14237,(select t.id from swimming_pools t where t.nick_name = 'laquilacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
 (3,'2014-11-16',14238,(select t.id from swimming_pools t where t.nick_name = 'palermocomunale50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),

(2,'2015-03-26',14321,(select t.id from swimming_pools t where t.nick_name = 'civitanovamarcheilgrillo25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-04-26',14322,(select t.id from swimming_pools t where t.nick_name = 'massarosacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-04-26',14323,(select t.id from swimming_pools t where t.nick_name = 'massalubrenseatlantis25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(2,'2015-05-02',14325,(select t.id from swimming_pools t where t.nick_name = 'bastiaumbracomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-03',14326,(select t.id from swimming_pools t where t.nick_name = 'giulianocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-03',14327,(select t.id from swimming_pools t where t.nick_name = 'siracusacittadelladellosport50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-10',14328,(select t.id from swimming_pools t where t.nick_name = 'tarantomeridiana25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE());

INSERT INTO meeting_sessions (session_order,scheduled_date,meeting_id,swimming_pool_id,warm_up_time,begin_time,notes,description,user_id,day_part_type_id,lock_version,created_at,updated_at) VALUES 
(1,'2015-05-17',14329,(select t.id from swimming_pools t where t.nick_name = 'siracusacittadelladellosport50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(2,'2015-05-24',14332,(select t.id from swimming_pools t where t.nick_name = 'cremonacanottieribaldesio50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(2,'2015-05-24',14333,(select t.id from swimming_pools t where t.nick_name = 'putignanonadir25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(3,'2015-05-24',14334,(select t.id from swimming_pools t where t.nick_name = 'napoliscandone50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-24',14335,(select t.id from swimming_pools t where t.nick_name = 'palermocomunale50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-31',14339,(select t.id from swimming_pools t where t.nick_name = 'romapietralata50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-05-31',14340,(select t.id from swimming_pools t where t.nick_name = 'nociotr25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(3,'2015-06-06',14344,(select t.id from swimming_pools t where t.nick_name = 'cittadicastellobelvedere50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-06-07',14345,(select t.id from swimming_pools t where t.nick_name = 'comohappyvillage50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),
(1,'2015-06-07',14346,(select t.id from swimming_pools t where t.nick_name = 'romahappyvillage50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE()),

(1,'2015-06-07',14348,(select t.id from swimming_pools t where t.nick_name = 'pietrelcinaaquacenter25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'M'),0,CURDATE(),CURDATE());

--
-- Dump dei dati per la tabella meeting_sessions per Domenica mattina
-- 
INSERT INTO meeting_sessions (session_order,scheduled_date,meeting_id,swimming_pool_id,warm_up_time,begin_time,notes,description,user_id,day_part_type_id,lock_version,created_at,updated_at) VALUES 
(2,'2014-10-26',14230,(select t.id from swimming_pools t where t.nick_name = 'firenzenannini50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-10-26',14231,(select t.id from swimming_pools t where t.nick_name = 'rovigopoloacquatico25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14232 */
/* Sessione Domenica mattina non presente per il meeting 14233 */
/* Sessione Domenica mattina non presente per il meeting 14234 */
(1,'2014-11-09',14235,(select t.id from swimming_pools t where t.nick_name = 'genovasciorba25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-09',14236,(select t.id from swimming_pools t where t.nick_name = 'saronnocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-09',14237,(select t.id from swimming_pools t where t.nick_name = 'laquilacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14238 */
(4,'2014-11-16',14239,(select t.id from swimming_pools t where t.nick_name = 'vicenzacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-16',14240,(select t.id from swimming_pools t where t.nick_name = 'novaracomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-16',14241,(select t.id from swimming_pools t where t.nick_name = 'andriacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-16',14242,(select t.id from swimming_pools t where t.nick_name = 'osimocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(3,'2014-11-23',14243,(select t.id from swimming_pools t where t.nick_name = 'gorgonzolaseveninfinity25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-11-23',14244,(select t.id from swimming_pools t where t.nick_name = 'romasociale50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14245 */
(2,'2014-11-23',14246,(select t.id from swimming_pools t where t.nick_name = 'mugnanorhyfelvillage25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14247 */
/* Sessione Domenica mattina non presente per il meeting 14248 */
(2,'2014-11-30',14249,(select t.id from swimming_pools t where t.nick_name = 'casalemonferratocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(3,'2014-12-07',14250,(select t.id from swimming_pools t where t.nick_name = 'bergamoitalcementi25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-12-07',14251,(select t.id from swimming_pools t where t.nick_name = 'massarosacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2014-12-07',14252,(select t.id from swimming_pools t where t.nick_name = 'bolzanopircher25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14253 */
/* Sessione Domenica mattina non presente per il meeting 14254 */
(2,'2015-12-13',14255,(select t.id from swimming_pools t where t.nick_name = 'sondriocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14256 */
/* Sessione Domenica mattina non presente per il meeting 14257 */
/* Sessione Domenica mattina non presente per il meeting 14258 */
/* Sessione Domenica mattina non presente per il meeting 14259 */
(2,'2014-12-21',14260,(select t.id from swimming_pools t where t.nick_name = 'palermocomunale50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14261 */
/* Sessione Domenica mattina non presente per il meeting 14262 */
(2,'2015-01-11',14263,(select t.id from swimming_pools t where t.nick_name = 'conversanoaironclub25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14264 */
/* Sessione Domenica mattina non presente per il meeting 14265 */
/* Sessione Domenica mattina non presente per il meeting 14266 */
(2,'2015-01-18',14267,(select t.id from swimming_pools t where t.nick_name = 'romaforum25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-01-18',14268,(select t.id from swimming_pools t where t.nick_name = 'taorminacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14269 */
/* Sessione Domenica mattina non presente per il meeting 14270 */
(2,'2015-01-25',14271,(select t.id from swimming_pools t where t.nick_name = 'certaldofiammetta25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14272 */
(2,'2015-02-01',14273,(select t.id from swimming_pools t where t.nick_name = 'catanianesima50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14274 */
/* Sessione Domenica mattina non presente per il meeting 14275 */
/* Sessione Domenica mattina non presente per il meeting 14276 */
/* Sessione Domenica mattina non presente per il meeting 14277 */
/* Sessione Domenica mattina non presente per il meeting 14278 */
(2,'2015-02-15',14279,(select t.id from swimming_pools t where t.nick_name = 'genovasciorba25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14280 */
(4,'2015-02-22',14281,(select t.id from swimming_pools t where t.nick_name = 'torinopalazzodelnuoto25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(4,'2015-02-22',14282,(select t.id from swimming_pools t where t.nick_name = 'collevaldelsacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14283 */
(2,'2015-02-22',14284,(select t.id from swimming_pools t where t.nick_name = 'umbertidecomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-02-22',14285,(select t.id from swimming_pools t where t.nick_name = 'fabrianocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14286 */
(2,'2015-03-01',14287,(select t.id from swimming_pools t where t.nick_name = 'campodipietranp258'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-01',14288,(select t.id from swimming_pools t where t.nick_name = 'seregnotrabattoni25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-01',14289,(select t.id from swimming_pools t where t.nick_name = 'lignanosabbiadorovillaggiogetur50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-08',14290,(select t.id from swimming_pools t where t.nick_name = 'livornolabastia25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14291 */
(2,'2015-03-08',14292,(select t.id from swimming_pools t where t.nick_name = 'molfettacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-15',14293,(select t.id from swimming_pools t where t.nick_name = 'nibionnowetlife25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-15',14294,(select t.id from swimming_pools t where t.nick_name = 'trentocentrosportivotrentonord25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-15',14295,(select t.id from swimming_pools t where t.nick_name = 'battipagliabalnea25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-15',14296,(select t.id from swimming_pools t where t.nick_name = 'pomeziaromansportcity25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-15',14297,(select t.id from swimming_pools t where t.nick_name = 'lameziatermecomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14298,(select t.id from swimming_pools t where t.nick_name = 'padovaplebisicito25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14299,(select t.id from swimming_pools t where t.nick_name = 'rapallocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14300,(select t.id from swimming_pools t where t.nick_name = 'lumezzanecomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14301,(select t.id from swimming_pools t where t.nick_name = 'barisportclub25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14302,(select t.id from swimming_pools t where t.nick_name = 'catanianesima50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-22',14303,(select t.id from swimming_pools t where t.nick_name = 'cagliariterramaini25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(3,'2015-03-29',14304,(select t.id from swimming_pools t where t.nick_name = 'romababel25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-29',14305,(select t.id from swimming_pools t where t.nick_name = 'paviacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-29',14306,(select t.id from swimming_pools t where t.nick_name = 'luccaitiefermi25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-03-29',14307,(select t.id from swimming_pools t where t.nick_name = 'calimeracalimera25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-12',14308,(select t.id from swimming_pools t where t.nick_name = 'legnanovilla25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-12',14309,(select t.id from swimming_pools t where t.nick_name = 'follonicacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-12',14310,(select t.id from swimming_pools t where t.nick_name = 'strianofalcosportvillage25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-12',14311,(select t.id from swimming_pools t where t.nick_name = 'castellanagrottecomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-12',14312,(select t.id from swimming_pools t where t.nick_name = 'campodipietrapuntocom25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14313 */
/* Sessione Domenica mattina non presente per il meeting 14314 */
(3,'2015-03-19',14315,(select t.id from swimming_pools t where t.nick_name = 'baritinto50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(4,'2015-03-19',14316,(select t.id from swimming_pools t where t.nick_name = 'palermopolisportivapalermo25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14317 */
/* Sessione Domenica mattina non presente per il meeting 14318 */
(2,'2015-04-19',14319,(select t.id from swimming_pools t where t.nick_name = 'sandonadelpiavecomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14320 */
/* Sessione Domenica mattina non presente per il meeting 14321 */
(2,'2015-04-26',14322,(select t.id from swimming_pools t where t.nick_name = 'massarosacomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-04-26',14323,(select t.id from swimming_pools t where t.nick_name = 'massalubrenseatlantis25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14324 */
/* Sessione Domenica mattina non presente per il meeting 0 */
/* Sessione Domenica mattina non presente per il meeting 14325 */
(2,'2015-05-03',14326,(select t.id from swimming_pools t where t.nick_name = 'giulianocomunale25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-05-03',14327,(select t.id from swimming_pools t where t.nick_name = 'siracusacittadelladellosport50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-05-10',14328,(select t.id from swimming_pools t where t.nick_name = 'tarantomeridiana25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-05-17',14329,(select t.id from swimming_pools t where t.nick_name = 'siracusacittadelladellosport50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14330 */
/* Sessione Domenica mattina non presente per il meeting 14331 */
/* Sessione Domenica mattina non presente per il meeting 14332 */
(3,'2015-05-24',14333,(select t.id from swimming_pools t where t.nick_name = 'putignanonadir25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(4,'2015-05-24',14334,(select t.id from swimming_pools t where t.nick_name = 'napoliscandone50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-05-24',14335,(select t.id from swimming_pools t where t.nick_name = 'palermocomunale50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14336 */
/* Sessione Domenica mattina non presente per il meeting 14337 */
/* Sessione Domenica mattina non presente per il meeting 14338 */
(2,'2015-05-31',14339,(select t.id from swimming_pools t where t.nick_name = 'romapietralata50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-05-31',14340,(select t.id from swimming_pools t where t.nick_name = 'nociotr25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
/* Sessione Domenica mattina non presente per il meeting 14341 */
/* Sessione Domenica mattina non presente per il meeting 14342 */
/* Sessione Domenica mattina non presente per il meeting 14343 */
/* Sessione Domenica mattina non presente per il meeting 14344 */
(2,'2015-06-07',14345,(select t.id from swimming_pools t where t.nick_name = 'comohappyvillage50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-06-07',14346,(select t.id from swimming_pools t where t.nick_name = 'romahappyvillage50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-06-07',14347,(select t.id from swimming_pools t where t.nick_name = 'cataniaplaia50'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE()),
(2,'2015-06-07',14348,(select t.id from swimming_pools t where t.nick_name = 'pietrelcinaaquacenter25'),'00:00:00','00:00:00','','FINALI',2,(select t.id from day_part_types t where t.code = 'P'),0,CURDATE(),CURDATE());

COMMIT;
-- End script

/*
-- Elenco meeting stagione
select m.id, m.header_date, ms.scheduled_date, m.description, m.code
from meetings m
	join meeting_sessions ms on ms.meeting_id = m.id and ms.session_order = 1
where m.season_id = 142;

-- Elenco meeting incompleti stagione
select m.id, m.header_date, m.description, m.code
from meetings m
where m.season_id = 142
	and not exists (select 1 from meeting_sessions ms where ms.meeting_id = m.id and ms.session_order = 1);
*/