SQL (SELECT DISTINCT P.brand, COUNT(1) FROM products P, manufacturers M WHERE P.manufacturer=M.manufacturer AND P.manufacturer ='' GROUP BY P.manufacturer ORDER BY B.priority, P.manufacturer ) failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'B.priority' in 'order clause'