Anonymous

SELECT KEY, value                    FROM settings                    WHERE                        (section='general' AND KEY='demo_mode') OR                        (section='network' AND KEY='single_user_mode') OR                        (section='core' AND KEY='locale') OR                        (section='core' AND KEY='date_format')UNION  SELECT 'updates_available', CASE         WHEN count(id) = 0                      THEN 't'        ELSE 't'         END AS updates_available        FROM releases         WHERE STATUS='NEW';