::× SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="60" and `palce`="R16" and `RF`!="" and `hlucnost2` <= "73" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by znacka_nocs
$sql_shop->num_rows($res)72
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched
1 row fetched TRISTAR×:ANO×: SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="205" and `profil`="60" and `palce`="R16" and `znacka_nocs`="tristar" and `RF`!="" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by hlucnost2