::× SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R18" and `li`="100" and `prilnavost_na_mokru2` <= "B" 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)38
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 GOODRIDE×: SELECT distinct(li) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R18" and `znacka_nocs`="goodride" and `prilnavost_na_mokru2` <= "B" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by li
$sql_shop->num_rows($res)1
1 row fetched 100×: SELECT distinct(prilnavost_na_mokru2) FROM produkty_pneumatiky where ( `sirka`="235" and `profil`="55" and `palce`="R18" and `znacka_nocs`="goodride" and `li`="100" and kategorie_pneu NOT IN("MOTORKOVÉ","ČTYŘKOLKOVÉ","VETERÁNSKÉ","PŘÍVĚSOVÉ")) AND skladem>3 order by prilnavost_na_mokru2