select *,DATE_FORMAT(calc_hour, '%H:%i') as calc_hour, DATE_FORMAT(date_start, '%d.%m.%Y') as date_start from alb_tours a, alb_pages b where (a.id=b.id) AND (b.`parent`= or b.`id`=) AND b.`enabled`>0 order by b.`order`