$field_coverdate_value

";//echo "

";echo "

";//echo "

Magazine Content

";

$query=mysql_query("select cfgf.field_gated_field_value,fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf ,content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and cfgf.nid=n.nid and fs.vid=n.vid andfs.field_issueno_value=$field_issueno_value and td.tid='95' and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

$query=mysql_query("select fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_issueno fs,term_node t,term_data td, node n ,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid andfs.field_issueno_value=$field_issueno_value and td.tid='102' and n.status=1 and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");

$query=mysql_query("select cfgf.field_gated_field_value, fs.field_issueno_value,t.tid,t.vid,td.name,n.title,n.nid from content_field_gated_field cfgf, content_field_issueno fs,term_node t,term_data td, node n,content_type_article ct where t.tid=td.tid and t.vid=fs.vid and fs.vid=n.vid and cfgf.nid=n.nid andfs.field_issueno_value=$field_issueno_value and td.tid='103' and n.status=1 and n.status=1 and ct.field_coverdate_value like '%$value%'and ct.nid=n.nid ORDER BY n.vid DESC");