$foretag_ids[] = $foretag["id"]; } } $sql = "SELECT foretag_id, medlem_id, aNamn FROM " . Foretag::KEY_TABLE . " f INNER JOIN " . Medlem::TABLE . " m ON f.medlem_id=m.id WHERE medlem_id > 0 AND foretag_id IN (" . implode(",", $foretag_ids) . ")"; $res = $db->query($sql); while ($row = mysql_fetch_array($res)) { try { $tForetag = Foretag::loadById($row["foretag_id"]); $medlem_id = $row["medlem_id"]; $medlem_anamn = $row["aNamn"]; } catch (Exception $e) { // Foretag doesn't exist (we check this just in case) continue; } if (!empty($medlem_id)) { $stegindex = Medlem::getStegIndexForMedlemId($medlem_id, $tForetag); if ($tForetag != null && $stegindex != null && strtotime($tForetag->getSlutDatum()) >= $slutDatum_ts) { $tm[] = array("stegindex" => $stegindex, "namn" => $medlem_anamn, "id" => $medlem_id); } } } unset($tForetag); unset($medlem_stegtotal_cache); unset($res); if (count($tm) != 0) { array_multisort($tm, SORT_DESC); } unset($positioner); unset($topplistan); unset($tmObjects); unset($tlObjects);