Monthly Subscription Plans

SELECT `n`.`nid` AS `id`, `n`.`title`, 'bne IntelliNews' AS authors, 'bne IntelliNews' AS bylines, `wc`.`field_website_callout_value` AS `summary`, `smc`.`field_social_media_callout_value` AS `social`, `pd`.`published_at` AS `date`, `p`.`field_publication__tid` AS `publication_id`, `fm`.`uri` AS `image`, `fspcaption`.`field_story_photo_caption_value` AS `image_credit`, `fspcredit`.`field_story_photo_credit_value` AS `image_author`, `ws`.`field_website_sections_tid` AS `section_id`, `fdfs`.`field_subject_tid` AS `subject_id`, `db`.`body_value` AS `body`, `fm2`.`uri` AS `pdf`, `et`.`field_enable_tracking_value` AS `tracking`, `ht`.`field_head_tags_value` AS `headTags`, `bt`.`field_body_tags_value` AS `bodyTags` FROM `node` AS `n` LEFT JOIN `field_data_field_website_callout` AS `wc` ON wc.entity_id = n.nid LEFT JOIN `field_data_field_social_media_callout` AS `smc` ON smc.entity_id = n.nid LEFT JOIN `publication_date` AS `pd` ON pd.nid = n.nid LEFT JOIN `field_data_field_publication_` AS `p` ON p.entity_id = n.nid LEFT JOIN `field_data_field_story_picture` AS `sp` ON sp.entity_id = n.nid LEFT JOIN `file_managed` AS `fm` ON fm.fid = sp.field_story_picture_fid LEFT JOIN `field_data_field_story_photo_caption` AS `fspcaption` ON fspcaption.entity_id = n.nid LEFT JOIN `field_data_field_story_photo_credit` AS `fspcredit` ON fspcredit.entity_id = n.nid LEFT JOIN `workflow_node` AS `wn` ON wn.nid = n.nid LEFT JOIN `field_data_field_website_sections` AS `ws` ON ws.entity_id = n.nid LEFT JOIN `field_data_field_subject` AS `fdfs` ON fdfs.entity_id = n.nid LEFT JOIN `field_data_body` AS `db` ON db.entity_id = n.nid LEFT JOIN `field_data_field_file` AS `ff` ON ff.entity_id = n.nid LEFT JOIN `file_managed` AS `fm2` ON fm2.fid = ff.field_file_fid LEFT JOIN `field_data_field_enable_tracking` AS `et` ON et.entity_id = n.nid LEFT JOIN `field_data_field_head_tags` AS `ht` ON ht.entity_id = n.nid LEFT JOIN `field_data_field_body_tags` AS `bt` ON bt.entity_id = n.nid WHERE (n.status = 1) AND (n.type = 'page') AND (n.nid = '200429') LIMIT 1