SELECT idproduct, user1, price, idsupplier, description, imageurl, isInvest, stock from products as p,stock as s WHERE isInvest='0' AND idsupplier='2' AND price>'24237,5' AND price<'96950' AND `details` NOT LIKE '%ména%' AND `details` NOT LIKE '%Mená%' AND imageurl<>'Neni.gif' AND p.idproduct=s.idProductMain AND s.stock>0 AND imageurl3<>'' order by rand() limit 1