::× SELECT distinct(znacka),znacka_nocs FROM produkty_pneumatiky where ( `tmp2`="Z" and `sirka`="235" and `profil`="55" and `palce`="R18" and `RF`!="" and `hlucnost2` <= "72" 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)51
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`="Z" and `sirka`="235" and `profil`="55" and `palce`="R18" 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