Notice: Undefined offset: 1 in /var/www/f.scan-sport.com/application/config/router_forum.inc on line 34
SELECT m.msg, mn.id, mn.object_id, mn.name, u.login as u_login, u.id as u_id, m.date_ins as msg_date_ins
FROM `f_msg` as m
LEFT JOIN users as u ON (u.id = m.user_id)
LEFT JOIN `f_msg_name` as mn ON (mn.id = m.object_id)
WHERE m.object_id IN (SELECT id FROM f_msg_name WHERE object_id IN (27,28)) AND m.type_id = 1 AND m.date_ins IN (-1,'2013-01-09 11:20:08','2012-06-16 08:49:55','2016-07-31 16:22:48','2011-12-26 10:25:55','2011-12-05 07:46:06','2017-02-05 16:13:55','2012-11-04 16:48:47','2013-02-02 09:54:32','2016-01-29 12:30:23','2016-07-10 04:00:41')
GROUP BY m.object_id
ORDER BY m.date_ins
Notice: SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scansport.m.msg' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/f.scan-sport.com/application/lib/webdim/MysqlDriver.php on line 94 Теория. Форум Scan-Sport.com