mysql> select filename, name, status from system where type ='theme' ;
+---------------------------------------------------------+---------------+--------+
| filename                                                | name          | status |
+---------------------------------------------------------+---------------+--------+
| themes/bluemarine/bluemarine.info                       | bluemarine    |      0 |
| themes/chameleon/chameleon.info                         | chameleon     |      0 |
| themes/chameleon/marvin/marvin.info                     | marvin        |      0 |
| themes/garland/garland.info                             | garland       |      0 |
| themes/garland/minnelli/minnelli.info                   | minnelli      |      0 |
| themes/pushbutton/pushbutton.info                       | pushbutton    |      0 |
| sites/all/themes/itsme/breem/breem.info                 | breem         |      1 |
| sites/all/themes/itsme/eselektro/eselektro.info         | eselektro     |      1 |
| sites/all/themes/itsme/hoogland/hoogland.info           | hoogland      |      1 |
| sites/all/themes/itsme/itsme.info                       | itsme         |      1 |
| sites/all/themes/itsme/itsme_colored/itsme-colored.info | itsme-colored |      1 |
| sites/all/themes/itsme/schultz/schultz.info             | schultz       |      1 |
+---------------------------------------------------------+---------------+--------+
12 rows in set (0.00 sec)

mysql> select filename, name, status from system where type ='theme' ;
+----------------------------------------------------------------+---------------+--------+
| filename                                                       | name          | status |
+----------------------------------------------------------------+---------------+--------+
| themes/bluemarine/bluemarine.info                              | bluemarine    |      0 |
| themes/chameleon/chameleon.info                                | chameleon     |      0 |
| themes/chameleon/marvin/marvin.info                            | marvin        |      0 |
| themes/garland/garland.info                                    | garland       |      0 |
| themes/garland/minnelli/minnelli.info                          | minnelli      |      0 |
| themes/pushbutton/pushbutton.info                              | pushbutton    |      0 |
| sites/all/themes/itsme/css/breem.info                          | breem         |      1 |
| sites/all/themes/itsme/eselektro/eselektro.info                | eselektro     |      1 |
| sites/all/themes/itsme/hoogland/hoogland.info                  | hoogland      |      1 |
| sites/all/themes/itsme/images/itsme_colored/itsme-colored.info | itsme-colored |      1 |
| sites/all/themes/itsme/itsme.info                              | itsme         |      1 |
| sites/all/themes/itsme/schultz/schultz.info                    | schultz       |      1 |
+----------------------------------------------------------------+---------------+--------+
12 rows in set (0.00 sec)