Query : select * from urunvarstok where urunID='46701' AND var1 != '' AND up=1 group by var1 order by field(var1,'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','26','100CM','20','STD','24','2Lİ','TEKLİ','28','10MMX60CM','10MMX150CM','8MMX65CM','12MMX65CM','26 -28','500ML','ÖN','26-28','700ML','1000ML','XL','M-L','S','600ML','55LT','20LT','20X100','10X120','14X110','10X110','8X80','15X185','12X185','10X180','112.5 CM','25.4','31.8','29','M/L','180X14','BILBY','BILBY JR','GUPPY','KOOLAH','6x120','180X12','10X220','5X53','2X90','12X120','15L','PLS','12MMX100CM','12MMX150CM','XS','XXL','42','41','43','39-40','41-44','45-50','45-48','45','46','47','3XL','kısa','uzun','38-40','42.5','38','39','43.5','44.5','36','41.5','39,5','46,5','38,5','45.5','170MM','175MM','24/34/42','32','5Lİ','4LÜ','İNCE','KALIN','36H','28H','100MM','60MM','40MM','16','20H','143','145','163','165','187','188','190','230','236','238','250','255','260','262','263','265','270','272','280','285','290','292','295','300','305','286','303','135MM','146MM','3N','3U','5U','7T','9.50MM','14/28','14/32','34.9','31,8','1.80CM','3.M','BMX','MTB','ÜST ÇEKME','3X7','6LI','7Lİ','114','580MM','22.2','90MM','120MM','1-1/8','14X1-3/8','14*1-3/8','1.90x2.25','16X190/225','26X1-3/8','26X1.15','26X190/225','700X35-43','254','256','264','32H','10-12-15','SINTERED','203','1700MM','3000MM','113MM','116MM','119MM','121MM','127MM','131MM','122MM','118MM','185MM','48H','26X36H','24H','2300MM','1,5','28.6','710 MM','780MM','110MM','100MM/6','90MM/6','100MM/-0','110MM/0','110MM/6','L1','27.5*2.10','27.5X2.10','26*210','26X2.10','700X30','700*35-622','26*225','26*250','700*23','200','1000','500','10.000','31.8MM','34.9MM','116L','114L','580','31.6','11/32','11/26','11/28','11/34','11/36','11/23','10/42','30T','32T','34T','36T','38T','42-28','44-33-22','46-36','50-34','53-39','52-36','900MM','720 MM','42CM','44 CM','40CM','10x135','12X142','5X130','9QR','15X100','2000MM','73/68','83MM','108X68','113X68','118X68','160MM','180MM','31.6/330MM','27.2/330MM','31.6/350MM','27.2/400MM','30.9/400MM','31.6/400MM','2X10','2X11','42T','48T','3X10','3X9','142X12 TB','27.5/28/29','162','166','176','27.2/250MM','27.2/350MM','27.5X1.90','CARBON','2100MM','620MM','SAĞ','SOL','27.2','30,9','150MM','11/25','12/26','1600MM','640MM','25MM','48-38-28','39-26','68/73MM','CRN','RMT','1750MM','44T','PS','86.5X41MM','116X68','35/45MM','29X190/235','28*175','25.8','26X150/250','116','1.25CM','1800MM','950MM','700*35','10'LU','100MM/-7','280/580MM','400/700MM','29X2.10','JELLİ','140MM','SOLOAIR','200x51/57','216/222x70','178MM','40T','12X142 XD','24X1.50','31,6','30.9','AER-OME 32','BLAZE30','FIRST 30','VIVAIR','BLAZE','CAPA','GILA','OMEGA26','OMG29-27.5','27.5','ARKA','S2','S1','10'LU','11'Lİ','10'LU','11'Lİ','246','252','278','120 ML','ORTA','30.9/390MM','31.6/390MM','9'LU','27.2/375MM','30.9/375MM','31.6/375MM','700X35','240X76','288','26*215','48-32','130MM','36-24','36-22','50T','52T','65MM','28*200','28X2.00','700X28','3X8','53T','39T','24X1.75','26X2.35','20X2.10','29X2.00','26X2.00','60ML','20X1.35','20X1.50','20X1-1/8','27.5X2.25','700X32','700X22','700*18-25','700*18-28','700*28-45','242','244','248','258','271','273','274','276','277','294','234','275','281','282','283','284','233','257','20*195','20x1.95','700X19-23','25MTR','11/30','700X33','3.3MM','3.23/3.45','3.2/3.4 MM','4.3/4.4','SAĞ-SOL','3200MM','8-9-10','10-11','17MM','24X35MM','32X50MM','7-8-9','700X28-32','300ML','3LÜ','2500MM','15MM','150ML','26*200','700X23','31,4','26.8','45,5','11/42','L2','4XL','180X10','650ML','750ML','700X38','12X210','55X55','660MM','16X1.35','10-50T','17','19','54CM','685MM','635MM','27.5*225','11Y','13Y','5Y','7Y','9Y','37','37,5','560MM','44CM','38CM','208CM','226CM','34MM','26X1.50','27.5X2.00','16X1.50','12*1/2','12X1/2','700X25','11'Lİ','11'Lİ','8'Lİ','15X110','12X148','2200MM','27.5X2.60','550ML','S/M','70MM/6','80MM/6','20X1.10','29X2.25','XXS','XL-XXL','8X150','20*1-3/8','26X2.25','11'Lİ','52/55.8MM','XS-S','150x14','130X10','S3','L3','135/142','40/43','44/46','35/39','3.5MM','420X100MM','420X125MM','BYK','700X40','20X1.60','26X1.75','16X1.75','20X1.75','27.5X1.65','28X1.75','27.5x2.35','26X1.35','27.5X1.35','26X0.90','650MM','28T','184X44MM','1850MM','18,5','46T','44-48CM','46-53CM','203MM','460MM','51MM','25M','20X0.90','18T','16X2.00','20X2.00','24X2.0','26X1.90','700X45','16X1.95','24X1.95','26X1.95','700X23/25','27.5X1.50','12X100','89/92','11'Lİ','11'Lİ','315','2.0X14MM','117MM','800ML','27.5X1.40','2M','26-29','M6','42-32-24','170CM','90CM','11-50','18','126MM','40-28','42-30','26X4.00','3X6','2X8','100MM/-12','110MM/-7','80MM/-7','90MM/-12','90MM/-7','155/200','610MM','100MM/+17','120/+35','15,5','386','117.5MM','123MM','12/32','BRAKETLİ','BRAKETSİZ','L6','42-32-22','GS','2X9','L/XL','10/26','10/28','56CM','59CM','52CM','130 MM PRO','SGS','SS','10/33','48-35','1LİTRE','700x18-25','10X185','120X10','10METRE','50M','216X63.5','350ML','27,2','10'LU','10'LU','11'Lİ','10'LU','11'Lİ','9'LU','11'Lİ','11'Lİ','8'Lİ','11'Lİ','11'Lİ','11'Lİ','10'LU','10'LU','11'Lİ','10'LU','11'Lİ','9'LU','11'Lİ','11'Lİ','8'Lİ','11'Lİ','11'Lİ','11'Lİ','24-26','10'LU','10'LU','11'Lİ','10'LU','11'Lİ','9'LU','11'Lİ','11'Lİ','8'Lİ','11'Lİ','11'Lİ','11'Lİ','49CM','51CM','55CM','49.5','48.5','53CM','57CM','110','12056 cm','GÜMÜŞ','10'LU','10'LU','11'Lİ','9'LU','11'Lİ','8'Lİ','11'Lİ','11'Lİ','11'Lİ','10'LU','11'Lİ','9'LU','8'Lİ','','26','100CM','20','STD','24','2Lİ','TEKLİ','28','10MMX60CM','10MMX150CM','8MMX65CM','12MMX65CM','26 -28','500ML','ÖN','26-28','700ML','1000ML','XL','M-L','S','600ML','55LT','20LT','20X100','10X120','14X110','10X110','8X80','15X185','12X185','10X180','112.5 CM','25.4','31.8','24-26','29','M/L','180X14','BILBY','BILBY JR','GUPPY','KOOLAH','6x120','180X12','10X220','5X53','2X90','12X120','15L','PLS','12MMX100CM','12MMX150CM','XS','XXL','42','41','43','39-40','41-44','45-50','45-48','45','46','47','3XL','kısa','uzun','38-40','42.5','38','39','43.5','44.5','36','41.5','39,5','46,5','38,5','45.5','170MM','175MM','24/34/42','32','5Lİ','4LÜ','İNCE','KALIN','36H','28H','100MM','60MM','40MM','16','20H','143','145','163','165','187','188','190','230','236','238','250','255','260','262','263','265','270','272','280','285','290','292','295','300','305','286','303','135MM','146MM','3N','3U','5U','7T','9.50MM','14/28','14/32','34.9','31,8','1.80CM','3.M','BMX','MTB','ÜST ÇEKME','3X7','6LI','7Lİ','114','580MM','22.2','90MM','120MM','1-1/8','14X1-3/8','14*1-3/8','1.90x2.25','16X190/225','26X1-3/8','26X1.15','26X190/225','700X35-43','254','256','264','32H','10-12-15','SINTERED','203','1700MM','3000MM','113MM','116MM','119MM','121MM','127MM','131MM','122MM','118MM','185MM','48H','26X36H','24H','2300MM','1,5','28.6','710 MM','780MM','110MM','100MM/6','90MM/6','100MM/-0','110MM/0','110MM/6','L1','27.5*2.10','27.5X2.10','26*210','26X2.10','700X30','700*35-622','26*225','26*250','700*23','200','1000','500','10.000','31.8MM','34.9MM','116L','114L','580','31.6','11/32','11/26','11/28','11/34','11/36','11/23','10/42','30T','32T','34T','36T','38T','42-28','44-33-22','46-36','50-34','53-39','52-36','900MM','720 MM','42CM','44 CM','40CM','10x135','12X142','5X130','9QR','15X100','2000MM','73/68','83MM','108X68','113X68','118X68','160MM','180MM','31.6/330MM','27.2/330MM','31.6/350MM','27.2/400MM','30.9/400MM','31.6/400MM','2X10','2X11','42T','48T','3X10','3X9','142X12 TB','27.5/28/29','162','166','176','27.2/250MM','27.2/350MM','27.5X1.90','CARBON','2100MM','620MM','SAĞ','SOL','27.2','30,9','150MM','11/25','12/26','1600MM','640MM','25MM','48-38-28','39-26','68/73MM','CRN','RMT','1750MM','44T','PS','86.5X41MM','116X68','35/45MM','29X190/235','28*175','25.8','26X150/250','116','1.25CM','1800MM','950MM','700*35','100MM/-7','280/580MM','400/700MM','29X2.10','JELLİ','140MM','SOLOAIR','200x51/57','216/222x70','178MM','40T','12X142 XD','24X1.50','31,6','30.9','AER-OME 32','BLAZE30','FIRST 30','VIVAIR','BLAZE','CAPA','GILA','OMEGA26','OMG29-27.5','27.5','ARKA','S2','S1','246','252','278','120 ML','ORTA','30.9/390MM','31.6/390MM','27.2/375MM','30.9/375MM','31.6/375MM','700X35','240X76','288','26*215','48-32','130MM','36-24','36-22','50T','52T','65MM','28*200','28X2.00','700X28','3X8','53T','39T','24X1.75','26X2.35','20X2.10','29X2.00','26X2.00','60ML','20X1.35','20X1.50','20X1-1/8','27.5X2.25','700X32','700X22','700*18-25','700*18-28','700*28-45','242','244','248','258','271','273','274','276','277','294','234','275','281','282','283','284','233','257','20*195','20x1.95','700X19-23','25MTR','11/30','700X33','3.3MM','3.23/3.45','3.2/3.4 MM','4.3/4.4','SAĞ-SOL','3200MM','8-9-10','10-11','17MM','24X35MM','32X50MM','7-8-9','700X28-32','300ML','3LÜ','2500MM','15MM','150ML','26*200','700X23','31,4','26.8','45,5','11/42','L2','4XL','180X10','650ML','750ML','700X38','12X210','55X55','660MM','16X1.35','10-50T','17','19','54CM','685MM','635MM','27.5*225','11Y','13Y','5Y','7Y','9Y','37','37,5','560MM','44CM','38CM','208CM','226CM','34MM','26X1.50','27.5X2.00','16X1.50','12*1/2','12X1/2','700X25','15X110','12X148','2200MM','27.5X2.60','550ML','S/M','70MM/6','80MM/6','20X1.10','29X2.25','XXS','XL-XXL','8X150','20*1-3/8','26X2.25','52/55.8MM','XS-S','150x14','130X10','S3','L3','135/142','40/43','44/46','35/39','3.5MM','420X100MM','420X125MM','BYK','700X40','20X1.60','26X1.75','16X1.75','20X1.75','27.5X1.65','28X1.75','27.5x2.35','26X1.35','27.5X1.35','26X0.90','650MM','28T','184X44MM','1850MM','18,5','46T','44-48CM','46-53CM','203MM','460MM','51MM','25M','20X0.90','18T','16X2.00','20X2.00','24X2.0','26X1.90','700X45','16X1.95','24X1.95','26X1.95','700X23/25','27.5X1.50','12X100','89/92','315','2.0X14MM','117MM','800ML','27.5X1.40','2M','26-29','M6','42-32-24','170CM','90CM','11-50','18','126MM','40-28','42-30','26X4.00','3X6','2X8','100MM/-12','110MM/-7','80MM/-7','90MM/-12','90MM/-7','155/200','610MM','100MM/+17','120/+35','15,5','386','117.5MM','123MM','12/32','BRAKETLİ','BRAKETSİZ','48-36-26','L6','42-32-22','GS','2X9','L/XL','10/26','10/28','56CM','59CM','52CM','130 MM PRO','10/33','48-35','1LİTRE','700x18-25','10X185','120X10','10METRE','50M','216X63.5','350ML','49CM','51CM','55CM','49.5','48.5','Medium','M/S10'LU','11'Lİ','9'LU','8'Lİ','','26','100CM','20','STD','24','2Lİ','TEKLİ','28','10MMX60CM','10MMX150CM','8MMX65CM','12MMX65CM','26 -28','500ML','ÖN','26-28','700ML','1000ML','XL','M-L','S','600ML','55LT','20LT','20X100','10X120','14X110','10X110','8X80','15X185','12X185','10X180','112.5 CM','25.4','31.8','24-26','29','M/L','180X14','BILBY','BILBY JR','GUPPY','KOOLAH','6x120','180X12','10X220','5X53','2X90','12X120','15L','PLS','12MMX100CM','12MMX150CM','XS','XXL','42','41','43','39-40','41-44','45-50','45-48','45','46','47','3XL','kısa','uzun','38-40','42.5','38','39','43.5','44.5','36','41.5','39,5','46,5','38,5','45.5','170MM','175MM','24/34/42','32','5Lİ','4LÜ','İNCE','KALIN','36H','28H','100MM','60MM','40MM','16','20H','143','145','163','165','187','188','190','230','236','238','250','255','260','262','263','265','270','272','280','285','290','292','295','300','305','286','303','135MM','146MM','3N','3U','5U','7T','9.50MM','14/28','14/32','34.9','31,8','1.80CM','3.M','BMX','MTB','ÜST ÇEKME','3X7','6LI','7Lİ','114','580MM','22.2','90MM','14X1-3/8','14*1-3/8','1.90x2.25','16X190/225','26X1-3/8','26X1.15','26X190/225','700X35-43','254','256','264','32H','10-12-15','SINTERED','203','1700MM','3000MM','113MM','116MM','119MM','121MM','127MM','131MM','122MM','118MM','185MM','48H','26X36H','24H','2300MM','1-1/8','1,5','28.6','710 MM','780MM','110MM','100MM/6','90MM/6','100MM/-0','110MM/0','110MM/6','27,2','30,9','31,6','30.9','L1','27.5*2.10','27.5X2.10','26*210','26X2.10','700X30','700*35-622','26*225','26*250','700*23','200','1000','500','10.000','31.8MM','34.9MM','116L','114L','580','11/32','11/26','11/28','11/34','11/36','11/23','10/42','30T','32T','34T','36T','38T','42-28','44-33-22','46-36','50-34','53-39','52-36','900MM','720 MM','42CM','44 CM','40CM','10x135','12X142','5X130','9QR','15X100','2000MM','120MM','73/68','83MM','108X68','113X68','118X68','160MM','180MM','31.6/330MM','27.2/330MM','31.6/350MM','27.2/400MM','30.9/400MM','31.6/400MM','2X10','2X11','42T','48T','3X10','3X9','142X12 TB','27.5/28/29','162','166','176','27.2/250MM','27.2/350MM','27.5X1.90','CARBON','2100MM','620MM','SAĞ','SOL','27.2','31.6','150MM','11/25','12/26','1600MM','640MM','25MM','48-38-28','39-26','68/73MM','CRN','RMT','1750MM','44T','PS','86.5X41MM','116X68','35/45MM','29X190/235','28*175','25.8','26X150/250','116','1.25CM','1800MM','950MM','700*35','100MM/-7','280/580MM','400/700MM','29X2.10','JELLİ','140MM','SOLOAIR','200x51/57','216/222x70','178MM','40T','12X142 XD','24X1.50','AER-OME 32','BLAZE30','FIRST 30','VIVAIR','BLAZE','CAPA','GILA','OMEGA26','OMG29-27.5','27.5','ARKA','S2','S1','246','252','278','284','120 ML','ORTA','30.9/390MM','31.6/390MM','27.2/375MM','30.9/375MM','31.6/375MM','700X35','240X76','288','26*215','48-32','130MM','36-24','36-22','50T','52T','65MM','28*200','28X2.00','700X28','3X8','53T','39T','24X1.75','26X2.35','20X2.10','29X2.00','26X2.00','60ML','20X1.35','20X1.50','20X1-1/8','27.5X2.25','700X32','700X22','700x18-25','700*18-28','700*28-45','242','244','248','258','271','273','274','276','277','294','234','275','281','282','283','233','257','20*195','20x1.95','700X19-23','25MTR','11/30','700X33','3.3MM','3.23/3.45','3.2/3.4 MM','4.3/4.4','SAĞ-SOL','3200MM','8-9-10','10-11','17MM','24X35MM','32X50MM','7-8-9','700X28-32','300ML','3LÜ','2500MM','15MM','150ML','26*200','700X23','31,4','26.8','45,5','11/42','L2','4XL','180X10','650ML','750ML','700X38','12X210','55X55','660MM','16X1.35','17','19','54CM','685MM','635MM','27.5*225','11Y','13Y','5Y','7Y','9Y','37','37,5','560MM','700*18-25','44CM','38CM','208CM','226CM','34MM','26X1.50','27.5X2.00','16X1.50','12*1/2','12X1/2','700X25','15X110','12X148','2200MM','27.5X2.60','550ML','S/M','70MM/6','80MM/6','20X1.10','29X2.25','XXS','XL-XXL','8X150','20*1-3/8','26X2.25','XS-S','150x14','130X10','S3','L3','135/142','40/43','44/46','35/39','3.5MM','420X100MM','420X125MM','BYK','700X40','20X1.60','26X1.75','16X1.75','20X1.75','27.5X1.65','28X1.75','27.5x2.35','26X1.35','27.5X1.35','26X0.90','650MM','28T','184X44MM','1850MM','18,5','46T','10-50T','44-48CM','46-53CM','203MM','460MM','51MM','25M','20X0.90','18T','16X2.00','20X2.00','24X2.0','26X1.90','700X45','16X1.95','24X1.95','26X1.95','700X23/25','27.5X1.50','12X100','89/92','315','2.0X14MM','117MM','800ML','27.5X1.40','2M','26-29','M6','42-32-24','170CM','90CM','11-50','126MM','40-28','42-30','26X4.00','3X6','2X8','100MM/-12','110MM/-7','80MM/-7','90MM/-12','90MM/-7','155/200','610MM','100MM/+17','120/+35','15,5','386','117.5MM','123MM','12/32','BRAKETLİ','BRAKETSİZ','48-36-26','L6','42-32-22','GS','2X9','L/XL','10/26','10/28','56CM','59CM','52CM','130 MM PRO','10/33','48-35','1LİTRE','10X185','120X10','10METRE','50M','216X63.5','350ML','2x12','10ML','20ML','49CM','51CM','55CM','49.5','48.5','1X12','52/55.8MM','750/180MM','57CM','TRİSUİT','2.5W','24*1-3/8','27*1-1/4','24*195','16*195','12*1/2*1/4','700X35/40','420MM','26X195/225','26*195','S-28LT','1350MM','250gr','500gr','1kg','44-32-22','68MM','18','46CM','26*140','1145MM','29*225','14*175','700*45','20X1.90','27.5*200','29*200','40,5','SMALL','MEDIUM','SM','M-S','LARGE','26 /26','310','380MM','2.0X16MM','2.0X12MM','234X14.5MM','40-30-22','2.5MM','3.2MM','1400MM','1450MM','1500MM','1000MM','11-23','11-36','750/160MM','3SPD','38-26','SGS','42-34-24','DSGS','48-36-24','SS','28,6','M3','12/23','11-28','14/34','700X24','400ML','16GR','126L','26x2.40','Beyaz-Pembe','BOOST','100gr','17L','10-52T','36CM','700X37','22MMX150CM','440MM','26.8x350','27.2/300MM','230MM')
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 '','11'Lİ','9'LU','8'Lİ','','26','100CM','20','STD','24','2Lİ','TEKLİ','28','' at line 1