SELECT scales.id, man.name as brand, man.img as m_img, man.des as m_des, man.keywords as keywords FROM scales, man WHERE scales.man = man.id AND scales.man LIKE 5 GROUP BY search.id ORDER BY 2 [nativecode=1054 ** Unknown column 'search.id' in 'group statement'] DB Error: no such field