Ana sayfa › Cyprus Environmental Publications Database › Databases

Environmental Publications

  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ('35','36','39','38','41','42','40','43','37','26','29','28','32','30','31','' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM cyef0406_node node LEFT JOIN cyef0406_content_field_epdb_publicationlanguage node_data_field_epdb_publicationlanguage ON node.vid = node_data_field_epdb_publicationlanguage.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_typeofpublication ON node.vid = node_data_field_epdb_typeofpublication.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_authors ON node.vid = node_data_field_epdb_authors.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_year ON node.vid = node_data_field_year.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_publication ON node.vid = node_data_field_epdb_publication.vid LEFT JOIN cyef0406_term_node term_node ON node.nid = term_node.nid LEFT JOIN cyef0406_term_data term_data ON term_node.tid = term_data.tid LEFT JOIN cyef0406_i18n_node i18n ON node.nid = i18n.nid INNER JOIN cyef0406_node_access na ON na.nid = node.nid WHERE (i18n.language ='tr' OR i18n.language ='' OR i18n.language IS NULL) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.status = '1') AND (node.type IN ('envdbentry')) AND (node_data_field_epdb_publicationlanguage.field_epdb_publicationlanguage_value IN ('english','french','german','greek','hungarian','italian','turkish','other')) AND (node_data_field_epdb_typeofpublication.field_epdb_typeofpublication_value IN ('journal','book','report','Proceedings','chapterinbook','thesis','other')) AND (.tid IN ('35','36','39','38','41','42','40','43','37','26','29','28','32','30','31','27','33','34','20','22','24','21','25','23')) ) in /home/content/c/y/e/cyefhost/html/includes/database.mysql.inc on line 172.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ('35','36','39','38','41','42','40','43','37','26','29','28','32','30','31','' at line 1 query: SELECT DISTINCT(node.nid), node_data_field_epdb_authors.field_epdb_authors_value AS node_data_field_epdb_authors_field_epdb_authors_value, node_data_field_year.field_year_value AS node_data_field_year_field_year_value, node.title AS node_title, node.changed AS node_changed, node_data_field_epdb_publication.field_epdb_publication_value AS node_data_field_epdb_publication_field_epdb_publication_value, term_data.name AS term_data_name, term_data.tid AS term_data_tid, node_data_field_epdb_typeofpublication.field_epdb_typeofpublication_value AS node_data_field_epdb_typeofpublication_field_epdb_typeofpublication_value FROM cyef0406_node node LEFT JOIN cyef0406_content_field_epdb_publicationlanguage node_data_field_epdb_publicationlanguage ON node.vid = node_data_field_epdb_publicationlanguage.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_typeofpublication ON node.vid = node_data_field_epdb_typeofpublication.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_authors ON node.vid = node_data_field_epdb_authors.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_year ON node.vid = node_data_field_year.vid LEFT JOIN cyef0406_content_type_envdbentry node_data_field_epdb_publication ON node.vid = node_data_field_epdb_publication.vid LEFT JOIN cyef0406_term_node term_node ON node.nid = term_node.nid LEFT JOIN cyef0406_term_data term_data ON term_node.tid = term_data.tid LEFT JOIN cyef0406_i18n_node i18n ON node.nid = i18n.nid INNER JOIN cyef0406_node_access na ON na.nid = node.nid WHERE (i18n.language ='tr' OR i18n.language ='' OR i18n.language IS NULL) AND (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( (node.status = '1') AND (node.type IN ('envdbentry')) AND (node_data_field_epdb_publicationlanguage.field_epdb_publicationlanguage_value IN ('english','french','german','greek','hungarian','italian','turkish','other')) AND (node_data_field_epdb_typeofpublication.field_epdb_typeofpublication_value IN ('journal','book','report','Proceedings','chapterinbook','thesis','other')) AND (.tid IN ('35','36','39','38','41','42','40','43','37','26','29','28','32','30','31','27','33','34','20','22','24','21','25','23')) ) LIMIT 0, 50 in /home/content/c/y/e/cyefhost/html/includes/database.mysql.inc on line 172.
Type of Publication
Subject