"Akciós" (2021 október) árnyalataink

  • user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hegyalja_n.content_type_color.field_color_color_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT COUNT(*) FROM ( SELECT node.nid AS nid FROM node node LEFT JOIN content_type_color node_data_field_color_color ON node.vid = node_data_field_color_color.vid INNER JOIN ( SELECT webform_submitted_data.`data` AS ID, content_type_color.field_color_color_value AS COLOUR, Count(webform_submitted_data.`data`) AS VOTES FROM webform_submitted_data INNER JOIN content_type_color ON webform_submitted_data.`data` = content_type_color.field_color_id_value WHERE webform_submitted_data.nid = 1570 AND webform_submitted_data.cid = 6 GROUP BY webform_submitted_data.`data` ORDER BY VOTES DESC, ID DESC LIMIT 64 ) webform on webform.ID = node_data_field_color_color.field_color_id_value 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'))) AND ( node.type in ('color') )) count_alias in /var/www/hegyalja.my-nailart.net/sites/all/modules/views/includes/view.inc on line 802.
  • user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hegyalja_n.content_type_color.field_color_color_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT node.nid AS nid, node_data_field_color_color.field_color_imagedot_fid AS node_data_field_color_color_field_color_imagedot_fid, node_data_field_color_color.field_color_imagedot_list AS node_data_field_color_color_field_color_imagedot_list, node_data_field_color_color.field_color_imagedot_data AS node_data_field_color_color_field_color_imagedot_data, node.title AS node_title, node_data_field_color_color.field_color_color_value AS node_data_field_color_color_field_color_color_value, node_data_field_color_color.field_color_color_value AS node_data_field_color_color_field_color_color_value, node.type AS node_type, node.vid AS node_vid, node_data_field_color_color.field_color_brand_value AS node_data_field_color_color_field_color_brand_value, node_data_field_color_color.field_color_collection_value AS node_data_field_color_color_field_color_collection_value, node_data_field_color_color.field_color_id_value AS node_data_field_color_color_field_color_id_value, webform.VOTES AS node_data_field_color_id_field_color_fb2_value FROM node node LEFT JOIN content_type_color node_data_field_color_color ON node.vid = node_data_field_color_color.vid INNER JOIN ( SELECT webform_submitted_data.`data` AS ID, content_type_color.field_color_color_value AS COLOUR, Count(webform_submitted_data.`data`) AS VOTES FROM webform_submitted_data INNER JOIN content_type_color ON webform_submitted_data.`data` = content_type_color.field_color_id_value WHERE webform_submitted_data.nid = 1570 AND webform_submitted_data.cid = 6 GROUP BY webform_submitted_data.`data` ORDER BY VOTES DESC, ID DESC LIMIT 64 ) webform on webform.ID = node_data_field_color_color.field_color_id_value 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'))) AND ( node.type in ('color') ) LIMIT 0, 16 in /var/www/hegyalja.my-nailart.net/sites/all/modules/views/includes/view.inc on line 807.
  • user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hegyalja_n.quotes_res.code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT n.nid FROM quotes q INNER JOIN node n ON q.vid=n.vid INNER JOIN content_type_color ctc ON q.vid=ctc.vid INNER JOIN (SELECT content_type_color.nid AS nid, IFNULL( res.ndate, CURDATE() - INTERVAL 1 YEAR ) AS ndate, IFNULL( res.code, content_type_color.field_color_id_value ) AS code, IFNULL( res.diff, TIMESTAMPDIFF( DAY, CURDATE() - INTERVAL 1 YEAR, NOW())) AS diff FROM content_type_color LEFT JOIN ( SELECT nid, MAX(ndate) AS ndate, CODE, TIMESTAMPDIFF(DAY, MAX(ndate), NOW()) AS diff FROM quotes_res GROUP BY nid ORDER BY nid ) res ON res.nid = content_type_color.nid WHERE content_type_color.field_color_inactive_value = 0 AND content_type_color.field_color_napi_exclude_value = 0 AND content_type_color.field_color_fb_value = 0 ORDER BY content_type_color.nid) qr ON n.vid = qr.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site'))) AND ( n.status=1 AND n.type='color' AND ctc.field_color_inactive_value = 0 AND ctc.field_color_napi_exclude_value = 0 AND ctc.field_color_fb_value = 0 AND TIMESTAMPDIFF(DAY,qr.ndate,NOW()) > DAY(LAST_DAY(NOW())) AND q.promote = 1 AND 1=1 )ORDER BY RAND() LIMIT 0, 1 in /var/www/hegyalja.my-nailart.net/sites/all/modules/quotes/quotes.module on line 1378.