SELECT DISTINCT products.id_product AS id_product, products.name AS name, products_stores.id_store AS id_storeFROM products LEFT JOIN products_stores ON products_stores.id_product = products.id_product;
1234567