mysql> select * from blocks where module like "%" and theme="bluebreeze"; +-------------------+-----------------+------------+--------+--------+--------+--------+----------+------------+-------+-------+ | module | delta | theme | status | weight | region | custom | throttle | visibility | pages | title | +-------------------+-----------------+------------+--------+--------+--------+--------+----------+------------+-------+-------+ | devel | 2 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | devel | 1 | bluebreeze | 1 | 9 | right | 0 | 0 | 0 | | | | devel | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | views | comments_recent | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | devel_node_access | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | user | 3 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | user | 2 | bluebreeze | 1 | 3 | left | 1 | 0 | 0 | | | | user | 1 | bluebreeze | 1 | 0 | left | 0 | 0 | 0 | | | | user | 0 | bluebreeze | 1 | -1 | left | 0 | 0 | 0 | | | | search | 0 | bluebreeze | 0 | -1 | | 0 | 0 | 0 | | | | profile | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | poll | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | node | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | menu | 103 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | menu | 94 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | menu | 51 | bluebreeze | 1 | 0 | right | 0 | 0 | 0 | | | | menu | 2 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | forum | 1 | bluebreeze | 1 | 0 | left | 0 | 0 | 0 | | | | forum | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | event | 1 | bluebreeze | 1 | 1 | right | 0 | 0 | 0 | | | | event | 0 | bluebreeze | 1 | 2 | right | 0 | 0 | 0 | | | | comment | 0 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | | book | 0 | bluebreeze | 1 | 0 | left | 0 | 0 | 0 | | | | block | 1 | bluebreeze | 1 | 5 | left | 0 | 0 | 0 | | | | block | 2 | bluebreeze | 0 | 0 | | 0 | 0 | 0 | | | +-------------------+-----------------+------------+--------+--------+--------+--------+----------+------------+-------+-------+