Query : select * from urunvarstok where stok > 0 AND urunID='228' AND var4 != '' AND up=1  group by var4 order by field(var4,'XS','S','S/M','M','M/L','L','L/XL','XL','XXL','XXXL','XXXXL','XXXXXL','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','') <br />Unknown column 'var4' in 'where clause'