Page History

MariaDB [keystone]> selectSELECT name, extra fromFROM project whereWHERE domain_id=(SELECT id fromFROM project WHERE is_domain=1 AND name='NTNU') AND DATEDIFF(STR_TO_DATE(JSON_VALUE(extra,'$.expiry'),'%d.%m.%Y'),NOW()) <= 30;