Fatal error has occoured.
The page will not load.
An email has been sent to the
administration to notify about
the problem.
Click here to
try refreshing the page
Please try again later.
-------------------------------- Error #256 --------------------------------
FATAL ERROR: Could not execute query - Unknown column 'n.num_of_comments' in 'order clause' - Query: SELECT *,
COUNT(DISTINCT CASE WHEN com.status = 1 THEN com.commentid END) AS `num_of_comments`,
n.timestamp AS `timestamp`,
n.news_title,
n.news_name,
n.news,
c2.category_name,
com.status
FROM `site_newscategories` AS c1
LEFT JOIN `site_newscategory` AS c2 ON c1.categoryid = c2.categoryid
LEFT JOIN `site_news` AS n ON n.newsid = c1.newsid
LEFT JOIN `site_newscomment` AS com ON com.newsid = n.newsid
WHERE
n.status = 1 AND
`c2`.`category_title` = "xbox-360-achievements"
GROUP BY n.newsid
ORDER BY n.`num_of_comments` DESC
LIMIT 0, 12
IN FILE: /homepages/38/d193326501/htdocs/MyXbox360/class/Core/Database.php
ON LINE: 107
CONTEXT: Array
----------------------------------------------------------------------------