select shop.*,product.*,stock.*,sale.*,stock.count - sale.count as ss from shop 
left join product on shop.id = product.shop_id 
left join stock on product.id = stock.productid 
left join sale on product.id = sale.product_id 
where stock.count > 0 and sale.count > 0;