MagmaX

Delovni čas

 

Urniki pričnejo veljati s 1.9.2010

 

Magma X

Ponedeljek - četrtek6.30 - 24.00
Petek6.30 - 02.00
Sobota10.00 - 02.00
Nedelja10.00 - 24.00

 

Magma Bowling, Biljard

Ponedeljek - četrtek16.00 - 24.00
Petek16.00 - 02.00
Sobota12.00 - 02.00
Nedelja12.00 - 24.00

 

 

Magma Fitnes, Skupinske vadbe

Ponedeljek - petek6.30 - 22.00
Sobota, nedelja10.00 - 20.00

 

 Magma Beauty

Ponedeljek - petek8.00 -19.00
Sobota9.00-15.00
Nedelja in prazniki (razen po predhodnem naročilu)zaprto

  

Restavracija Etna

Ponedeljek-četrtek11.00 - 23.00
Petek11.00 - 02.00
Sobota10.00 - 02.00
Nedelja10.00 - 23.00

 

Intra studio

Torek- petek17.00 - 21.00
Ponedeljek, sobota, nedelja in prazniki

zaprto

Svetovalec osvetlitve vsak petek18.30-21.00

 

 

 

 

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_slo 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 = 'slo'
				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 = 'slo'				
			WHERE
				sd.day_schedule_date_start = '2010-09-09' AND sd.day_schedule_date_end = '2010-09-09'
				
			ORDER BY hStart, hEnd;


















0+9=


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_slo 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 = 'slo'
				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 = 'slo'				
			WHERE
				sd.day_schedule_date_start = '2010-09-09' AND sd.day_schedule_date_end = '2010-09-09'
				
			ORDER BY hStart, hEnd;
Četrtek, 09.09.2010