"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.