SELECT s.`id_warehouse`, s.`physical_quantity`, wl.`name`, wl.`delivery_time`, wpl.`location`, w.`id_address`, w.`address_url`
FROM `lptu_stock` s
LEFT JOIN `lptu_warehouse` `w` ON w.id_warehouse = s.id_warehouse
LEFT JOIN `lptu_warehouse_lang` `wl` ON w.`id_warehouse` = wl.`id_warehouse` AND `id_lang` = 2
INNER JOIN `lptu_warehouse_product_location` `wpl` ON wpl.id_product = s.id_product AND 
				 wpl.id_product_attribute = s.id_product_attribute AND 
				 wpl.id_warehouse = s.id_warehouse
WHERE (s.id_product = 51800)
GROUP BY s.id_warehouse