You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and b.mag_id= and a.companyid!= and image!='' and b.rnkid=a.rank_id and CHAR_LEN' at line 1