MagmaX

Kontakt

Magma X
Industrijska cesta 11,
5000 Nova Gorica, Slovenija

Bowling in biljard
T: +386 (0)8 200 48 20 (od 12.00 - 22.00 ure)
E: rezervacije@magma-x.com

Fitnes in skupinske vadbe:
T: +386 (0)8 200 48 21
E: rezervacije@magma-x.com

Spa & beauty:
T: +386 (0)5 30 22 111
G: +386 (0)41 713 344
E: beauty@magma-x.com

Restavracija Etna:
T: +386 (0)5 333 39 31
E: etna@magma-x.com

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-05' AND sd.day_schedule_date_end = '2010-09-05'
				
			ORDER BY hStart, hEnd;
		
stdClass Object
(
    [id] => 2010061615115246
    [hStart] => 12:00:00
    [hEnd] => 00:00:00
    [place] => 
    [activity] => 
    [important] => 
    [event] => Bowling igra ''Striker''
)
hello


















7-3=


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-05' AND sd.day_schedule_date_end = '2010-09-05'
				
			ORDER BY hStart, hEnd;
		
stdClass Object
(
    [id] => 2010061615115246
    [hStart] => 12:00:00
    [hEnd] => 00:00:00
    [place] => 
    [activity] => 
    [important] => 
    [event] => Bowling igra ''Striker''
)
hello
Nedelja, 05.09.2010
  • 12.00 - 00.00 Bowling igra ''Striker''