How to call a CCK Field value in a node
I will tell you that the easier way it to use node_load. You do your query to simply get the last nodes according your criteria and then with the nid you load each node with node_load.

Why ? Because CCK changes his database structure according the fields that are attached or not to one or more content type. If you will change the CCK field one day, you will have to change your code, so the easier way to avoid it, its simply use node_load.