private static function createBahnentabelle($page_titles) {
$dbr = wfGetDB(DB_REPLICA);
- // SELECT p.page_id, p.page_title, c.length, c.walkup_time, c.top_elevation, c.bottom_elevation, c.walkup_separate, c.lift, c.night_light, c.public_transport,
- // c.sled_rental, c.information_phone, s.show_status, r.status, r.last_check, r.last_update
- // FROM (`page` p JOIN wrsledruncache c ON p.page_id=c.page_id) LEFT OUTER JOIN (wrintermapssledrun s JOIN wrintermapsreport r ON s.intermaps_sledrun_id=r.intermaps_sledrun_id) ON p.page_id=s.wr_page_id
+ // SELECT p.page_id, p.page_title, c.length, c.walkup_time, c.top_elevation, c.bottom_elevation, c.walkup_separate, c.lift, c.night_light, c.public_transport,
+ // c.sled_rental, c.information_phone, s.show_status, r.status, r.last_check, r.last_update
+ // FROM (`page` p JOIN wrsledruncache c ON p.page_id=c.page_id) LEFT OUTER JOIN (wrintermapssledrun s JOIN wrintermapsreport r ON s.intermaps_sledrun_id=r.intermaps_sledrun_id) ON p.page_id=s.wr_page_id
// WHERE p.page_title in ('Birgitzer_Alm_(vom_Adelshof)', 'Mutterer_Alm_-_Sportrodelbahn', 'Axamer_Lizum') ORDER BY page_title;
$where_array = array();
if (count($page_titles) > 0) {
$where_array[] = 'p.page_id in (' . implode(', ', $mysql_page_ids) . ')';
} else $where_array[] = 'false';
$res = $dbr->select(['AA' => ['p' => 'page', 'c' => 'wrsledruncache'], 'BB' => ['r' => 'wrintermapsreport', 's' => 'wrintermapssledrun']],
- ['p.page_id', 'p.page_title', 'p.page_namespace',
- 'c.length', 'c.walkup_time', 'c.top_elevation', 'c.bottom_elevation', 'c.walkup_possible', 'c.walkup_separate',
+ ['p.page_id', 'p.page_title', 'p.page_namespace',
+ 'c.length', 'c.walkup_time', 'c.top_elevation', 'c.bottom_elevation', 'c.walkup_possible', 'c.walkup_separate',
'c.lift', 'c.night_light', 'c.public_transport', 'c.sled_rental', 'c.information_phone', 'c.information_web',
's.show_status', 'r.status', 'r.last_check', 'r.last_update'],
- $where_array,
- 'bahnentabelleParserHook',
+ $where_array,
+ 'bahnentabelleParserHook',
['ORDER BY' => 'p.page_title'],
['p' => ['JOIN', 'p.page_id=c.page_id'], 'r' => ['JOIN', 's.intermaps_sledrun_id=r.intermaps_sledrun_id'], 'AA' => ['LEFT OUTER JOIN', 'p.page_id=s.wr_page_id']]
);