Unknown column 'mygroup' in 'where clause'<br>select count(*) as total from ***_ecms_housing where  ismember=1 and columns=3 and mygroup=5810 and web=58