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 (24,29,5,6,20,12,13,14,16,17,19,21,30,31,32,33,35,36,38,8,37,40,41,42,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,62,63,64,65,66,67,68,69,70,71,72,73,75,74,22,27,28,25,26)) AND m.type_id = 1 AND m.date_ins IN (-1,'2017-07-26 15:14:03','2016-03-22 11:41:33','2016-02-09 13:41:50','2017-10-08 14:30:03','2012-11-04 17:21:11','2019-09-27 19:27:39','2012-11-04 17:21:49','2012-11-04 17:22:05','2017-04-17 16:08:05','2012-11-04 17:22:54','2017-03-31 19:56:38','2019-08-07 14:07:37','2013-01-09 11:20:08','2016-05-31 09:39:22','2012-06-16 08:49:55','2013-02-02 09:30:09','2020-06-11 21:47:03','2016-07-31 16:22:48','2013-04-02 09:29:08','2011-12-26 10:25:55','2018-02-05 19:56:07','2011-11-08 09:08:17','2012-11-04 16:50:20','2011-11-21 07:06:52','2012-11-25 10:44:23','2011-11-25 18:35:17','2011-12-05 07:46:06','2018-03-02 14:55:11','2017-09-27 13:14:42','2017-12-29 18:44:42','2017-10-08 14:35:46','2017-10-08 14:51:07','2017-02-05 16:13:55','2016-03-22 11:55:53','2013-03-01 18:13:56','2012-11-04 16:48:47','2018-03-29 14:29:00','2018-04-02 11:16:00','2012-08-05 02:12:07','2012-09-03 10:38:58','2016-11-14 14:25:14','2019-07-18 10:36:58','2019-04-14 18:20:52','2019-09-28 16:22:37','2019-02-03 18:30:25','2019-02-26 07:22:45','2019-03-19 19:08:03','2017-11-21 21:20:42','2013-01-24 12:55:57','2013-03-01 18:08:02','2016-11-30 15:02:36','2016-02-09 13:38:38','2013-01-24 10:04:13','2017-01-06 12:21:19','2018-12-21 12:01:33','2019-01-08 08:09:44','2019-01-08 08:14:47','2016-11-09 19:06:03','2013-01-11 10:08:46','2018-06-26 14:39:15','2013-02-02 09:54:32','2013-02-02 10:05:28','2016-08-06 13:06:39','2016-01-29 12:30:23','2013-04-02 09:23:49','2013-04-29 11:31:37','2016-10-12 16:12:26','2016-05-09 20:35:28','2014-09-08 12:24:37','2016-08-19 20:11:52','2018-08-21 15:34:32','2016-03-04 20:04:29','2016-03-29 22:39:28','2016-06-02 18:49:59','2015-11-27 20:14:12','2017-07-19 05:51:25','2018-10-02 17:06:45','2016-02-12 14:16:28','2016-10-23 09:47:01','2019-12-06 07:20:08','2016-05-11 18:26:31','2016-04-23 17:09:52','2016-04-29 14:32:34','2016-07-10 04:00:41','2016-07-01 16:23:03','2017-07-25 18:28:27','2017-01-09 09:47:46','2017-08-31 08:05:21','2016-10-25 16:28:59','2017-07-13 17:42:44','2019-10-15 16:08:49','2020-06-06 15:48:04','2020-08-06 14:00:34','2020-08-06 14:17:51','2020-11-28 19:04:21','2020-12-16 13:50: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
