DBI::MySQL error: Invalid SQL: SELECT COUNT(*) as num_views,
s.t_stamp, c.product_id, c.product_name
FROM phpc_catalog c,
phpcatalog_stats s
WHERE s.product_id = c.product_id
AND s.t_stamp > 1623279868
GROUP BY c.product_id
ORDER BY num_views DESC
LIMIT 5
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'limeligh_phpcatalog.s.t_stamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/limeligh/romacireland.com/phpcatalog/include/phpcatalog.inc
Line: 286
Session halted |