Error
SQLSTATE[42S22]: Column not found: 1054 Unknown column '(n.views * (86400) / (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(n.date_add)))' in 'order clause', query was: SELECT `n`.*, `nes`.`visit_url` AS `site_visit_url`, `nes`.`title` AS `site_title`, `u`.`username`, `u`.`avatar` FROM `rmg_news` AS `n`
INNER JOIN `rmg_external_sites` AS `nes` ON n.site_id = nes.id AND nes.del = 0 AND nes.status = 1
LEFT JOIN `rmg_users` AS `u` ON n.add_by = u.id
INNER JOIN `rmg_news_companies` AS `nc` ON n.id = nc.news_id AND nc.company_id IN (15,408) WHERE (n.related_to = 0) AND (n.del = 0) GROUP BY `n`.`id` ORDER BY `(n`.`views * (86400) / (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(n`.`date_add)))` DESC, `n`.`id` DESC LIMIT 15
Highly rated gadgets
- 9.1 Apple iPhone XS
- 8.0 BlackBerry Motion
- 9.0 Sony WH-1000XM3
- 9.0 FujiFilm XF10
- 9.1 Apple iPhone XS Max
- 9.0 Panasonic LUMIX LX100 II
- 10.0 FujiFilm X-T3
- 10.0 Nikon Z 7
- 8.5 Xiaomi Mi A2