Database error: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'killboard.dl.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL: select inv.icon, inv.typeID, itp.price, kb3_item_types.*, dga.value as metalevel, dgb.value as techlevel, dc.value as usedcharge, dl.value as usedlauncher, inv.groupID, inv.typeName, inv.capacity, inv.raceID, inv.mass, inv.volume, inv.basePrice, inv.marketGroupID, te.effectID as slotIndicator, if(dl.attributeID IS NULL,sum(itd.itd_quantity),truncate(sum(itd.itd_quantity)/count(dl.attributeID),0)) as itd_quantity, itd_itm_id, itd_itl_id, itl_flagText, itd_singleton from kb3_invtypes inv left join kb3_dgmtypeattributes dga on dga.typeID=inv.typeID and dga.attributeID=633 left join kb3_dgmtypeattributes dgb on dgb.typeID=inv.typeID and dgb.attributeID=422 left join kb3_item_price itp on itp.typeID=inv.typeID left join kb3_item_types on inv.groupID=itt_id left join kb3_dgmtypeattributes dc on dc.typeID = inv.typeID AND dc.attributeID IN (128) left join kb3_dgmtypeattributes dl on dl.typeID = inv.typeID AND dl.attributeID IN (137,602) left join kb3_dgmtypeeffects te on te.typeID = inv.typeID AND te.effectID IN (12, 13, 11, 2663, 3772, 6306) join kb3_items_destroyed itd on inv.typeID = itd_itm_id and itd_kll_id in (11859) left join kb3_item_locations itl on (itd.itd_itl_id = itl.itl_flagID )group by itd.itd_itm_id, itd.itd_itl_id, itd.itd_singleton order by itd.itd_itl_id