SELECT * FROM stock, marcas where marca=id AND precio<>0 AND (foto<>'') AND estado = 0 AND marca='1' AND marca='10' ORDER BY rubro