Ошибка базы данных при выполнении запроса: SELECT c.* ,COUNT(rm.rubric_id) AS material_amount FROM rubric c, rubric p LEFT OUTER JOIN rubric_material rm ON c.rubric_id = rm.rubric_id WHERE p.rubric_id =1 AND c.L_index BETWEEN p.L_index AND p.R_index AND c.R_index BETWEEN p.L_index AND p.R_index AND c.rubric_id != '1' AND (c.rubric_show_in_menu='1') AND c.rubric_system='0' GROUP BY c.rubric_id ORDER BY L_index .
MySQL:Unknown column 'c.rubric_id' in 'on clause'