-
SELECT *, articles.id AS articleid, topics.name AS topicname, articles.urlname AS articleurlname
FROM `articles`
LEFT JOIN `topics` ON (topics.id = articles.topic)
WHERE `type`='2' GROUP BY articles.id ORDER BY articles.date DESC LIMIT 10
Warning: Smarty error: unable to read resource: "error.html" in /var/www/vhosts/americasradionewsnetwork.com/httpdocs/includes/smarty/Smarty.class.php on line 1093