::× SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="C" and `sirka`="215" and `profil`="60" and `palce`="R17" and `prilnavost_na_mokru2` <= "E" 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)81
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
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 TYFOON×: SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `tmp2`="C" and `sirka`="215" and `profil`="60" and `palce`="R17" and `znacka_nocs`="tyfoon" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2