mysql1241 错误,出现错误 - SQLSTATE [21000]：基数违规：1241操作数应该包含1列(s)

我收到这个错误

SQLSTATE [21000]：基数违规：1241操作数应该包含1列(s)

有人能帮我理解为什么吗？

这是我的代码：

session_start();

$turk_number ='';

$serial='';

$version='';

if(isset($_POST['turk_number']))

{

$_SESSION['turk_number'] = $_POST['turk_number'];

$turk_number= $_POST['turk_number'];

}

$hostname = "localhost";

$username = "root";

$password = "";

$dbname = "resolver";

try

{

$dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query1 = "SELECT ((SELECT * FROM participants ORDER BY serial DESC LIMIT 0, 1) % 10) + 1 as version";

//$results = $dbh->query($query1);

$results = $dbh->prepare($query1);

$results->execute();

$serial = $results->fetchColumn(0);

if($test= $results->fetchColumn(1))

{

$version = $test; //last version on record + 1

}

else //if no user ever played any games

{

$version = 1;

}

$query2 = "INSERT INTO participants (version) VALUES (:version, :turk_number)";

$stmt = $dbh ->prepare($query2);

$stmt ->execute(array(':version' => $version,

':turk_number' => $turk_number));

}

catch(PDOException $e)

{

echo $e->getMessage();

}

$_SESSION['serial']= $serial;

$_SESSION['version']=$version;

?>

serial <?php print $serial; ?>

version <?php print $version; ?>

turk <?php print $turk_number; ?>