::× SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="215" and `profil`="55" and `palce`="R18" and `RF`!="" and `hlucnost2` <= "71" 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)48
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 COOPER×:ANO×: SELECT distinct(hlucnost2) FROM produkty_pneumatiky where ( `tmp2`="L" and `sirka`="215" and `profil`="55" and `palce`="R18" and `znacka_nocs`="cooper" and `RF`!="" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by hlucnost2