script要素の１つ前の要素を取得する

<img src="img0.gif" alt="a">
<script>
(function(b,c,d){
d = (function A(e){return e.nodeType==1?e:A(e)})(
    (function A(e){return e.tagName=='SCRIPT'?e:A(e.lastChild)})(document).previousSibling);
setInterval(function(){d.alt=b[Math.random()*b.length|0]},c);
})([
'img1.gif',
'img2.gif',
'img3.gif'
], 1000);
</script>

MySQL サブクエリを学ぶ

SELECT
  CONCAT("'",Y.SEIBETU,"性(", Y.AGE_RANGE,"歳未満)'"),
  SUM((@t:=FLOOR(Y.KTIME/5))=0),
  SUM(@t=1), SUM(@t=2), SUM(@t=3), SUM(@t=4), SUM(@t=5), SUM(@t=6),
  SUM(@t=7), SUM(@t=8), SUM(@t=9), SUM(@t=10),SUM(@t=11),SUM(@t=12),
  SUM(@t=13),SUM(@t=14),SUM(@t=15),SUM(@t=16),SUM(@t=17),SUM(@t=18),
  SUM(@t=19),SUM(@t=20),SUM(@t=21),SUM(@t=22),SUM(@t=23),SUM(@t=24),
  SUM(@t=25),SUM(@t=26),SUM(@t=27)
FROM 
(SELECT
  X.SEIBETU,
  CASE
    WHEN X.AGE <10 then 10
    WHEN X.AGE <20 then 20
    WHEN X.AGE <30 then 30
    WHEN X.AGE <40 then 40
    WHEN X.AGE <50 then 50
    WHEN X.AGE <60 then 60
    WHEN X.AGE <70 then 70
    WHEN X.AGE <80 then 80
    WHEN X.AGE <90 then 90
    WHEN X.AGE <120 then 120
  END AS AGE_RANGE,
  KTIME
  FROM
(SELECT
  SEIBETU,
  ((YEAR(SIBOUBI)-YEAR(SEINENGAPPI))-(RIGHT(SIBOUBI,5) < RIGHT(SEINENGAPPI,5))) AS AGE,
  FLOOR(TIME_TO_SEC(TIMEDIFF(SHUURYO_TIME,KAISI_TIME))/60) AS KTIME
FROM
  KUJISAIJOU.YOYAKU
WHERE
  (KASOU_KUBUN="遺体" OR KASOU_KUBUN="小人") AND SHUURYO_TIME IS NOT NULL AND SEIBETU="女"
) AS X
) AS Y
GROUP BY
  Y.SEIBETU, Y.AGE_RANGE
ORDER BY AGE_RANGE