Rsa97

SELECT *
  FROM Author
  WHERE Authorld NOT IN (
    SELECT Authorld
      FROM Book
      WHERE PublishDateTime > CURDATE() - INTERVAL 2 YEAR
  )

WITH RECURSIVE `cte` AS (
  SELECT `id`, `pid`, `name`, 0 AS `level`
    FROM `table`
  UNION SELECT `p`.`id`, `p`.`pid`, `p`,`name`, `cte`.`level` + 1 AS `level`
    FROM `cte` 
    JOIN `table` AS `p` ON `p`.`id` = `cte`.`pid`
)
SELECT `id`, `name`, `level`
  FROM `cte`
  ORDER BY `level`

SELECT `d`.*, `p`.*
  FROM (
    SELECT `device_id`, MAX(`type`) AS `type`
      FROM `price`
    ) AS `t`
    JOIN `price` AS `p`
      ON `p`.`device_id` = `t`.`device_id`
        AND `p`.`type` = `t`.`type`
    RIGHT JOIN `device` AS `d`
      ON `d`.`id` = `p`.`device_id`

--$conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
--$conn -> query("SET NAMES utf8");
++$conn = new PDO(
++    "mysql:host=$host;dbname=$dbname",
++    $username,
++    $password
++    [
++        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
++        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'",
++    ],
++);
--$err = $conn -> query("INSERT INTO RECIPE(recipe_id,aspect_ratio,yields,cook_time_minutes,country,descriptions,prep_time_minutes,total_time_minutes,name,thumnai_url) VALUES('$id','$asp','$yie','$c_t_m','$country','$desc','$p_t_m','$t_t_m','$name','$t_url')");
--echo "\nrec PDOStatement::errorCode(): ";
--print $err->errorCode();
++$req = $conn->prepare(<<<REQ
++    INSERT INTO RECIPE (
++        recipe_id, aspect_ratio, yields, cook_time_minutes, country, descriptions,
++        prep_time_minutes,total_time_minutes,name,thumnai_url
++    ) VALUES (
++        :recipe_id, :aspect_ratio, :yields, :cook_time_minutes, :country, :descriptions,
++        :prep_time_minutes, :total_time_minutes, :name, :thumnai_url
++    )
++REQ);
++$req->execute([
++    'recipe_id' => $data['id'],
++    'aspect_ratio' => $data['aspectRatio'],
++    'yields' => $data['yields'],
++    'cook_time_minutes' => $data['cookTimeMinutes'],
++    'country' => $data['country'],
++    'descriptions' => $data['description'],
++    'prep_time_minutes' => $data['prepTimeMinutes'],
++    'total_time_minutes' => $data['totalTimeMinutes'],
++    'name' => $data['name'],
++    'thumnai_url' => $data['thumbnailUrl'],
++]);

WITH `cte` AS (
  SELECT `date`, `state`,
         IFNULL(NTH_VALUE(`state`, 2) OVER `win`, -1)  AS `prev_state`
    FROM `test`
    WINDOW `win` AS (
      ORDER BY `date` DESC
      RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
    )
)
SELECT *
  FROM `cte`
  WHERE `state` != `prev_state`