Redmine

I'm using 1.4.3 and I don't know if this changed but give it a try:

SELECT c.name FROM redmine.custom_fields a
INNER JOIN redmine.custom_values b ON a.id=b.custom_field_id
INNER JOIN redmine.projects c ON b.customized_id=c.id
WHERE a.name='TEST'

Replace TEST on the last line with the name of the field your're looking for.

thx Jan

This put me on the right track
I had to join on the custom_fields_projects table rather than custom_values table (at least in this version):

SELECT c.name FROM redmine.custom_fields a
INNER JOIN redmine.custom_fields_projects b ON a.id=b.custom_field_id
INNER JOIN redmine.projects c ON b.project_id=c.id
WHERE a.name='TEST';

regards,
Mark

NP :-)
For reference:
The table custom_fields_projects also exists in 1.4.3 but it's empty.