SELECT scales.id, type.name as cat, man.name as brand, type.des as t_des FROM scales, scale_type, type, man WHERE scales.man = man.id AND scales.id = scale_type.scale_id AND type.id = scale_type.type_id AND scale_type.type_id LIKE '39' ORDER BY 12 [nativecode=1054 ** Unknown column '12' in 'order clause'] DB Error: no such field