/** * @param int $id * @return \POIModel|null */ public static function loadNew($id) { $r = db()->select()->all('poi_new')->col('border', 'poi_new')->op(AS_TEXT)->alias('borderWKT')->col('name', 'poiNear')->alias('nearName')->col('name', 'poiCountry')->alias('countryName')->col('name', 'poiType')->alias('subName')->from('poi_new')->leftJoin('poi')->alias('poiNear')->on('id', 'nearId')->leftJoin('poi')->alias('poiCountry')->on('id', 'countryId')->leftJoin('poi_type')->alias('poiType')->on('id', 'sub')->where('id', 'poi_new', EQ, $id)->exec(); if ($r->numRows() == 0) { return NULL; } return POIModel::fromObject($r->fetchObject()); }