Query:(SELECT `ind`.*, `m`.`count_m` AS `messages`, `co`.`name` AS `company`, `u`.`name` AS `creator_name`, `u`.`surname` AS `creator_surname`, `uf`.`file` AS `image` FROM `abies_news` AS `ind` LEFT JOIN (SELECT `abies_news_messages`.`news_id`, count(id) AS `count_m` FROM `abies_news_messages` GROUP BY `news_id`) AS `m` ON ind.id=m.news_id LEFT JOIN `abies_companies` AS `co` ON ind.company_id=co.id INNER JOIN `abies_users` AS `u` ON ind.creator_id=u.id and u.access>=10 LEFT JOIN `abies_uploaded_files` AS `uf` ON ind.image_id=uf.id GROUP BY `ind`.`id` ORDER BY `comments` DESC limit 0, 10)
НОВОСТИ КОМПАНИЙ
MySQL:Unknown column 'comments' in 'order clause'
Query:(SELECT `ind`.*, `m`.`count_m` AS `messages`, `co`.`name` AS `company`, `u`.`name` AS `creator_name`, `u`.`surname` AS `creator_surname`, `uf`.`file` AS `image` FROM `abies_news` AS `ind` LEFT JOIN (SELECT `abies_news_messages`.`news_id`, count(id) AS `count_m` FROM `abies_news_messages` GROUP BY `news_id`) AS `m` ON ind.id=m.news_id LEFT JOIN `abies_companies` AS `co` ON ind.company_id=co.id INNER JOIN `abies_users` AS `u` ON ind.creator_id=u.id and u.access>=10 LEFT JOIN `abies_uploaded_files` AS `uf` ON ind.image_id=uf.id GROUP BY `ind`.`id` ORDER BY `comments` DESC limit 0, 10)
Query:(SELECT `ind`.*, `m`.`count_m` AS `messages`, `co`.`name` AS `company`, `u`.`name` AS `creator_name`, `u`.`surname` AS `creator_surname`, `uf`.`file` AS `image` FROM `abies_news` AS `ind` LEFT JOIN (SELECT `abies_news_messages`.`news_id`, count(id) AS `count_m` FROM `abies_news_messages` GROUP BY `news_id`) AS `m` ON ind.id=m.news_id LEFT JOIN `abies_companies` AS `co` ON ind.company_id=co.id INNER JOIN `abies_users` AS `u` ON ind.creator_id=u.id and u.access>=10 LEFT JOIN `abies_uploaded_files` AS `uf` ON ind.image_id=uf.id GROUP BY `ind`.`id` ORDER BY `comments` DESC limit 0, 10)