Statistics

user warning: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vps1_d6jdfnet.c2.cat_weight' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT c2.category, c2.summary_sub_cat, c2.cat_weight, c2.sub_cat_weight, c2.summary_desc, SUM(e.amount) AS cost FROM jdfnet_expenses e LEFT JOIN jdfnet_categories c1 ON c1.sub_cat = e.sub_cat LEFT JOIN jdfnet_categories c2 ON c2.sub_cat = c1.summary_sub_cat WHERE e.include = 1 AND c1.summary_sub_cat > 0 GROUP BY c2.category, c2.summary_sub_cat ORDER BY c2.cat_weight, c2.sub_cat_weight in /home/vps1/public_html/d6jdfnet/includes/common.inc(1743) : eval()'d code on line 757.