CoreFiles by mySites.guru
3.7.0-2017-03-09.sql17 lines, 649 bytes, from Joomla_3.7.0-Stable-Full_Package.zip
Raw History Compare with 3.6.5
md5
edb09fa85d417ec5cd5959840aa5e615
sha1
da51485068c2f7a5be3dd8f47644d15e0f44c5b8
sha256
150dcd37f39f637624ef744b35d7d0add4da99ca86b0d7e6f180061b3936fecc
UPDATE "c"
SET published = c2.newPublished
FROM "#__categories" AS "c"
INNER JOIN (
SELECT c2.id,CASE WHEN MIN(p.published) > 0 THEN MAX(p.published) ELSE MIN(p.published) END AS newPublished
FROM "#__categories" AS "c2"
INNER JOIN "#__categories" AS "p" ON p.lft <= c2.lft AND c2.rgt <= p.rgt
GROUP BY c2.id) AS c2 ON c2.id = c.id;

UPDATE "c"
SET published = c2.newPublished
FROM "#__menu" AS "c"
INNER JOIN (
SELECT c2.id,CASE WHEN MIN(p.published) > 0 THEN MAX(p.published) ELSE MIN(p.published) END AS newPublished
FROM "#__menu" AS "c2"
INNER JOIN "#__menu" AS "p" ON p.lft <= c2.lft AND c2.rgt <= p.rgt
GROUP BY c2.id) AS c2 ON c2.id = c.id;

The same content is in 10 releases, Joomla 3.7.0-beta4 to 3.7.2. See them all, or every version of this file.