POSEBNE CENE IN UGODNOST ZA ŠTUDENTE 
 

Igra bowlinga cel večer samo 2,20€

Posebna gostinska ponudba do 20:00:
KUPIŠ ENO ŽIRAFO PIJAČE IN DOBIŠ ZRAVEN PICO PO ŽELJI!

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;
		

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;