PDO og MySQL NOT IN

PHP kode 

 $sql = "SELECT id FROM products WHERE category = ? AND id NOT IN (";
         for($i = 1; $i <= $thecount; $i++) {
             if($i < $thecount) {
                 $sql .= "?,";
             } else {
                 $sql .= "?";
             }
         }
         $sql .= ") ORDER BY RAND() LIMIT 1";
         
         $query = $this->db->prepare($sql);
         $query->bindValue(1, $maincat);
         for($i = 1; $i <= $thecount; $i++) {
             $query->bindValue($i+1, $array[$i-1]);
         }
         $query->execute();