Apxu

SELECT
    position, count(1) AS n
  FROM (
    SELECT
        position, row_number() OVER (PARTITION BY position) rn
      FROM tbl
  ) t
  GROUP BY position, (rn+1) div 2
;

class CombinationsCalculator
{
    protected $result;
    protected $combination;

    public function getCombinations($array, $group) {
        $this->result = [];
        $this->combination = [];
        $this->iteration(0, $group, $array, count($array));
        return $this->result;
    }

    protected function iteration($start, $step, $array, $n) {
        if ($step == 0) {
            array_push($this->result,$this->combination);
        }
        else {
            for ($i = $start; $i <= $n - $step; ++$i) {
                array_push($this->combination, $array[$i]);
                $this->iteration($i + 1, $step - 1, $array, $n);
                array_pop($this->combination);
            }
        }
    }
}

$calculator = new CombinationsCalculator();
$result = $calculator->getCombinations([1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15], 8);

UPDATE main m 
INNER JOIN test t ON (m.email1 = t.email AND m.email2 = t.email)
SET m.flag = 1

INSERT
  INTO `main` (`email1`, `email2`, `flag`) 
  SELECT `email`, `email`, 1
    FROM `test`
  ON DUPLICATE KEY UPDATE `flag` = 1

(select ... from tablename where id < 88 order by id desc limit 50)
union all
(select ... from tablename where id > 88 order by id asc limit 50)
order by id

<?php
echo hexdec("0x97a80e19d978000"); // 683000000000000000
// или
echo 0x97a80e19d978000; // 683000000000000000