user warning: Expression #1 of ORDER BY clause is not in SELECT list, references column 'antclub.n.sticky' which is not in SELECT list; this is incompatible with DISTINCT
query:
SELECT SQL_CACHE DISTINCT(n.nid), n.type, n.uid, GREATEST(n.changed, n.created) as changed, n.title, u.name, root.title as rtitle, root.type as rtype, root.nid as rnid, parent.title as ptitle, parent.type as ptype, parent.nid as pnid, file.tpath, file.twidth div 2 as twidth, file.theight div 2 as theight
FROM node n LEFT JOIN xcat_node b ON (b.nid = n.nid AND b.rnid <> n.nid) LEFT JOIN node root ON b.rnid = root.nid LEFT JOIN node parent ON b.rnid = parent.nid
LEFT JOIN users u ON u.uid = n.uid LEFT JOIN upload file ON (file.nid = n.nid),
term_node tn
WHERE n.nid = tn.nid AND tn.tid = 636 AND n.status > 0 ORDER BY n.sticky DESC, changed DESC LIMIT 0, 25 in /var/www/wwwantstoreru/htdocs.6/modules/xcat/xcat.module on line 198.
user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'antclub.s.timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT DISTINCT(u.uid), u.name, s.timestamp FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.timestamp >= 1561435878 AND s.uid > 0 GROUP BY u.uid ORDER BY s.timestamp DESC in /var/www/wwwantstoreru/htdocs.6/modules/user/user.module on line 559.
