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-05' AND sd.day_schedule_date_end = '2010-09-05'
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_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-05' AND sd.day_schedule_date_end = '2010-09-05'
ORDER BY hStart, hEnd;