MagmaX

Orario

 

Magma X

Lunedì - giovedì

7.00 - 24.00

Venerdì

7.00 - 02.00

Sabato

8.00 - 02.00

Domenica

8.00 - 24.00

 

Magma Bowling

Lunedì - giovedì

16.00 - 24.00

Venerdì

16.00 - 02.00

Sabato

12.00 - 02.00

Domenica

12.00 - 24.00

  

Magma Biliardo

Lunedì - giovedì

16.00 - 24.00

Venerdì

16.00 - 02.00

Sabato

12.00 - 02.00

Domenica

12.00 - 24.00

  

Magma Fitness, attività di gruppo

Lunedì - venerdì

7.00 - 22.00

Sabato, domenica

8.00 - 21.00

 

Magma Beauty

Lunedì - venerdì

8.00 -19.00

Sabato

9.00-15.00

Domenica e giorni festivi (tranne con la previa prenotazione)

chiuso

  

Ristorante Etna

Lunedì - giovedì

11.00 - 23.00

Venerdì

11.00 - 02.00

Sabato

10.00 - 02.00

Domenica

10.00 - 23.00

 

Intra studio

Lunedì - venerdì

11.00 - 29.00

Sabato

10.00 - 15.00

Domenica e giorni festivi

chiuso

SELECT
				sd.id as id,
				sd.day_schedule_hour_start as hStart, 	
				sd.day_schedule_hour_end as hEnd,
				dsp.place,
				dsa.activity,
				sd.important,
				sd.event_ita as event
			FROM day_schedule_data sd
				LEFT JOIN day_schedule_place_has_global_languages dsp ON sd.day_schedule_place_id = dsp.day_schedule_place_id AND dsp.global_languages_code = 'ita'
				LEFT JOIN day_schedule_activity_has_global_languages dsa ON sd.day_schedule_activity_id = dsa.day_schedule_activity_id AND dsa.global_languages_code = 'ita'				
			WHERE
				sd.day_schedule_date_start = '2010-09-09' AND sd.day_schedule_date_end = '2010-09-09'
				
			ORDER BY hStart, hEnd;


















8+4=


SELECT
				sd.id as id,
				sd.day_schedule_hour_start as hStart, 	
				sd.day_schedule_hour_end as hEnd,
				dsp.place,
				dsa.activity,
				sd.important,
				sd.event_ita as event
			FROM day_schedule_data sd
				LEFT JOIN day_schedule_place_has_global_languages dsp ON sd.day_schedule_place_id = dsp.day_schedule_place_id AND dsp.global_languages_code = 'ita'
				LEFT JOIN day_schedule_activity_has_global_languages dsa ON sd.day_schedule_activity_id = dsa.day_schedule_activity_id AND dsa.global_languages_code = 'ita'				
			WHERE
				sd.day_schedule_date_start = '2010-09-09' AND sd.day_schedule_date_end = '2010-09-09'
				
			ORDER BY hStart, hEnd;
Thursday, 2010-09-09