Články

Chyba DB: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hrady_cz.vp.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT v.id, v.titl, v.ptitl, v.nice_url, DATE_FORMAT(v.datvox,'%e. %M %Y'), v.text, vp.id FROM vox AS v LEFT JOIN vox_pic AS vp ON vp.vid=v.id WHERE v.datvox < (CURDATE() + INTERVAL 1 DAY) AND DATE_FORMAT(v.datvox, '%Y') > '2017' AND v.status > 0 GROUP BY v.id ORDER BY v.datvox DESC LIMIT 0,6