user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tudasklaszter.node.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_kep.field_kep_fid AS node_data_field_kep_field_kep_fid, node_data_field_kep.field_kep_title AS node_data_field_kep_field_kep_title, node_data_field_kep.field_kep_alt AS node_data_field_kep_field_kep_alt FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN content_type_bio node_data_field_megye ON node.vid = node_data_field_megye.vid LEFT JOIN content_type_bio node_data_field_jogi_forma ON node.vid = node_data_field_jogi_forma.vid LEFT JOIN content_type_bio node_data_field_a_cg_alkalmazottainak_szm ON node.vid = node_data_field_a_cg_alkalmazottainak_szm.vid LEFT JOIN content_type_bio node_data_field_kep ON node.vid = node_data_field_kep.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (node.type IN ('bio')) AND (term_node.tid IN ('42','46','47','44','43','45','55','56','57','58','60','61','62','63','64','65','59')) AND (node_data_field_megye.field_megye_value IN ('Budapest','Baranya','Bács-Kiskun','Békés','Borsod-Abaúj-Zemplén','Csongrád','Fejér','Győr-Moson-Sopron','Hajdú-Bihar','Heves','Jász-Nagykun-Szolnok','Komárom-Esztergom','Nógrád','Pest','Somogy','Szabolcs-Szatmár-Bereg','Tolna','Vas','Veszprém','Zala')) AND (node_data_field_jogi_forma.field_jogi_forma_value IN ('egyesület','alapítvány')) AND (node_data_field_a_cg_alkalmazottainak_szm.field_a_cg_alkalmazottainak_szm_value IN ('1-9','10-50','50-100','100 felett')) ) GROUP BY node.nid LIMIT 0, 25 in /var/www/vhosts/tudasklaszter.hu/httpdocs/includes/database.mysql.inc on line 172.

Partneradatbázis