Omura
Новичок
Unknown column 't1.id_groups' in 'on clause'
In query: SELECT t1.id_groups, t1.name_groups, COUNT(DISTINCT t2.id_groups) AS counter FROM novus_groups AS t1, novus_wares AS w LEFT JOIN novus_groups AS t2 ON t2.belong_groups=t1.id_groups LEFT JOIN novus_groups AS t3 ON t3.belong_groups=t2.id_groups WHERE t1.visibility='1' AND t1.belong_groups='0' AND (w.belong_groups=t2.id_groups OR w.belong_groups=t3.id_groups) AND w.visibility=1 GROUP BY t1.id_groups ORDER BY t1.sort_groups ASC
Почему ошибка добрые люди?
In query: SELECT t1.id_groups, t1.name_groups, COUNT(DISTINCT t2.id_groups) AS counter FROM novus_groups AS t1, novus_wares AS w LEFT JOIN novus_groups AS t2 ON t2.belong_groups=t1.id_groups LEFT JOIN novus_groups AS t3 ON t3.belong_groups=t2.id_groups WHERE t1.visibility='1' AND t1.belong_groups='0' AND (w.belong_groups=t2.id_groups OR w.belong_groups=t3.id_groups) AND w.visibility=1 GROUP BY t1.id_groups ORDER BY t1.sort_groups ASC
Почему ошибка добрые люди?
