Click on the photo of our suppliers and if we don’t have your product available in our warehouse, order it on request and receive it in the door of your house with the guarantee of buying from an authorized dealer.
SELECT r.*, m.nombre FROM mercarel r, marcas m WHERE id_mercado=1 and r.id_marca= m.id_marca order by nombre
