Groupe Boisset

SELECT node.nid FROM {node, content_type_client ctc} WHERE node.nid = ctc.nid AND type = 'client' AND ( node.language = 'en' or node.language = '' ) AND status = 1 ORDER BY title ASC

---