FROM node node
LEFT JOIN content_field_pic node_data_field_pic ON node.vid = node_data_field_pic.vid
LEFT JOIN files files_node_data_field_pic ON node_data_field_pic.field_pic_fid = files_node_data_field_pic.fid
LEFT JOIN content_type_gallery_image node_data_field_gallery ON node.vid = node_data_field_gallery.vid
LEFT JOIN node node_node_data_field_gallery ON node_data_field_gallery.field_gallery_nid = node_node_data_field_gallery.nid
WHERE node.TYPE IN ('gallery_image')
AND field_gallery_nid = 768 LIMIT 1;
You are about to leave the Corvias Military Living website.
This link is provided to you as a service to our website visitors. It will take you to a site maintained by a third party who is solely responsible for its contents. Corvias Military Living does not control this site.
Click "LEAVE" to proceed to the third party Web site or "STAY" to return to www.corviasmilitaryliving.com.