Добрый день
пытаюсь получить данные из друпала
SELECT
node.nid AS nid, node.title AS node_title, node.language AS node_language, node_data_field_img2.field_img2_fid AS node_data_field_img2_field_img2_fid, node_data_field_img2.field_img2_list AS node_data_field_img2_field_img2_list, node_data_field_img2.field_img2_data AS node_data_field_img2_field_img2_data, node.type AS node_type, node.vid AS node_vid, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node.sticky AS node_sticky, node.created AS node_created
FROM
node
LEFT OUTER JOIN content_type_image_n node_data_field_img2 ON node.vid = node_data_field_img2.vid
LEFT OUTER JOIN node_revisions ON node.vid = node_revisions.vid
WHERE
node.promote <> 0 AND node.status <> 0 AND node.type = 'image_n'
ORDER BY
node_sticky DESC, node_created DESC
подскажите как получить ссылку на картинку которая хранится в поле node_data_field_img2