|
Members of Antichat - Level 5
Регистрация: 25.02.2007
Сообщений: 495
Провел на форуме: 3244717
Репутация:
1980
|
|
@WisP™
error in query 'select *, count(news_id) as news_count, news_id, category.category_id from category left join news using(category_id) where category.category_id = 38 union select 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 ,21,22,23,24/* group by category.category_id' Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
там же LEFT JOIN, нужно так:
-1 GROUP BY category.category_id UNION SELECT 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 ,21,22,23,24/*
|