MagmaX

Magma Biljard

 

Pripravljeni na tekmo? Biljard ni le zabava, je tekma z nasprotnikom in samim seboj. 10 miz magma biljarda omogoča vrhunsko igro. Pod vodstvom profesionalca Andreasa Maimone so na voljo skupinski tečaji in individualne ure vadbe, organizirani bodo tudi turnirji. Sodobne videoigre in pikado dopolnjujejo magmatično ponudbo. Kdor zna, zna!


 

Biljardi

 

 

Učne ure biljarda

Pod vodstvom italijanskega državnega prvaka v biljardu, Andreasa Maimoneja, so vam na voljo skupinski tečaji ali individualne ure vadbe. Pohitite s prijavami na učne ure profesionalnega igranja biljarda! Za več informacij vprašajte na recepcji.

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


















9+6=


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''