This snippet displays a list of themes and associated fields.
SELECT * FROM `system` WHERE type = 'theme';
