Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/veryweb/14.veryweb.z8.ru/docs/common.php on line 26
***SELECT t.*,
COUNT(m.id)-1 as cnt, MAX(m.ts) as last_message,
(SELECT title FROM agroprom_enterprise WHERE user_id = t.user_id AND is_active = 1 ORDER by id DESC) company_name
FROM agroprom_forum_topic_ru as t
LEFT JOIN agroprom_forum_messages_ru as m on t.id=m.topic_id
GROUP BY t.id
ORDER BY last_message DESC
LIMIT 0 ,20*** Subquery returns more than 1 row
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/veryweb/14.veryweb.z8.ru/docs/index_forum.php on line 235 Всероссийский агропромышленный портал. Форум