Константин Симонов – поэт. История любви.

{$node->nid} ORDER BY node_data_field_date_love_story_field_date_love_story_value ASC Limit 0,1"; $result = _db_query($sql); if($result) { $res=db_fetch_array($result); $nid_next=$res["nid"]; } //предыдущая $sql="SELECT node.nid AS nid, node.title AS node_title, node_data_field_love_image_small.field_love_image_small_fid AS node_data_field_love_image_small_field_love_image_small_fid, node_data_field_love_image_small.field_love_image_small_list AS node_data_field_love_image_small_field_love_image_small_list, node_data_field_love_image_small.field_love_image_small_data AS node_data_field_love_image_small_field_love_image_small_data, node.type AS node_type, node.vid AS node_vid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node_data_field_date_love_story.field_date_love_story_value AS node_data_field_date_love_story_field_date_love_story_value FROM node node LEFT JOIN content_type_love_story node_data_field_love_image_small ON node.vid = node_data_field_love_image_small.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_love_story node_data_field_date_love_story ON node.vid = node_data_field_date_love_story.vid WHERE node.type in ('love_story') AND node.nid<{$node->nid} ORDER BY node_data_field_date_love_story_field_date_love_story_value DESC Limit 0,1"; $result = _db_query($sql); if($result) { $res=db_fetch_array($result); $nid_prev=$res["nid"]; } ?>

Первая история любви