since CCK can dynamically alter the database schema (when you add a field to a second content type or change the number of values) the query may break.
Fortunately CCK provides functions for finding a field's table and column names so it's simple to do it correctly
Karen Stevenson showed me how to do this ages ago, but i think i documented it in code instead of online, so here's the link to Drewish explaining.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution 3.0 Unported License.