$SphQLResultTor = $SphQLTor->query(); $TorrentIDs = $SphQLResultTor->to_pair('id', 'id'); // Because isset() is faster than in_array() } } } /** End run search query and collect results **/ if ($NumResults == 0) { $DB->query("\n\tSELECT\n\t\ttags.Name,\n\t\t((COUNT(tags.Name) - 2) * (SUM(tt.PositiveVotes) - SUM(tt.NegativeVotes))) / (tags.Uses * 0.8) AS Score\n\tFROM xbt_snatched AS s\n\t\tINNER JOIN torrents AS t ON t.ID = s.fid\n\t\tINNER JOIN torrents_group AS g ON t.GroupID = g.ID\n\t\tINNER JOIN torrents_tags AS tt ON tt.GroupID = g.ID\n\t\tINNER JOIN tags ON tags.ID = tt.TagID\n\tWHERE s.uid = '{$LoggedUser['ID']}'\n\t\tAND tt.TagID != '13679'\n\t\tAND tt.TagID != '4820'\n\t\tAND tt.TagID != '2838'\n\t\tAND g.CategoryID = '1'\n\t\tAND tags.Uses > '10'\n\tGROUP BY tt.TagID\n\tORDER BY Score DESC\n\tLIMIT 8"); $JsonYouMightLike = array(); while (list($Tag) = $DB->next_record()) { $JsonYouMightLike[] = $Tag; } json_die("success", array('results' => array(), 'youMightLike' => $JsonYouMightLike)); } $Bookmarks = Bookmarks::all_bookmarks('torrent'); $JsonGroups = array(); foreach ($Results as $Result) { $GroupID = $Result['groupid']; $GroupInfo = $Groups[$GroupID]; if (empty($GroupInfo['Torrents'])) { continue; } $CategoryID = $Result['categoryid']; $GroupYear = $GroupInfo['Year']; $ExtendedArtists = $GroupInfo['ExtendedArtists']; $GroupCatalogueNumber = $GroupInfo['CatalogueNumber']; $GroupName = $GroupInfo['Name']; $GroupRecordLabel = $GroupInfo['RecordLabel']; $ReleaseType = $GroupInfo['ReleaseType']; if ($GroupResults) {