SELECT A.goods_A, A.name, A.manufactor, B.cnt as rem 
FROM 

(
SELECT Goods.goods_id AS goods_A, Goods.name AS name, Goods.manufactor AS manufactor
FROM Goods 
WHERE Goods.forbidden <> 1 and  LOWER(Goods.name) like 'ана%'
) AS A

LEFT JOIN  

(
SELECT Goods_remnants.goods_id AS goods_B, SUM(Goods_remnants.count) AS cnt
FROM Goods_remnants 
WHERE Goods_remnants.trade_pnt_id IN
 (SELECT Trade_points.trade_pnt_id FROM Trade_points WHERE LOWER(Trade_points.town) = 'Мой город')
GROUP BY goods_B
) AS B

ON B.goods_B = A.goods_A
WHERE B.cnt > 0
ORDER BY A.goods_A;