echo"
";SELECT E.*, UNIX_TIMESTAMP(E.timestamp) AS last_updated, A.area_name, R.room_name, A.approval_enabled, A.confirmation_enabled, T.rep_type, T.end_date, T.rep_opt, T.rep_num_weeks, T.month_absolute, T.month_relative FROM mrbs_area A, mrbs_room R, mrbs_entry E, mrbs_repeat T WHERE E.repeat_id=? AND E.repeat_id=T.id AND E.room_id=R.id AND R.area_id=A.id ORDER BY E.ical_recur_id