We use cookies to provide a better service and tailor advertising according to your navigation habits. If you continue using our site, we will assume you accept their use. You can change the configuration or get more information. here.
SELECT
products.products_id as id,
stocks.id_stock,
thumb as imagen
FROM
products
JOIN stocks
ON products.products_id=stocks.products_id
WHERE codigo='86065'
AND stocks.stock>0
AND thumb!=''
AND products.online='1'
group by products.products_id