Town    STATUS  COUNT
--------------------------------
Blagoevgrad Inactive    1
Blagoevgrad Published   1
Burgas  Published       1
Dobrich Published       1
Dobrich Waiting Approval    2
Pleven  Inactive        1
Ruse    Published       1
Shoumen Published       2
Sofia   Inactive        1
Sofia   Published       1
Stara Zagora    Published   2
Veliko Tarnovo  Published   1
Yambol  Waiting Approval    1

SELECT t.Name AS [Town], adt.STATUS, COUNT(a.Id) AS [COUNT] FROM Ads a
INNER JOIN AdStatuses adt ON a.StatusId = adt.Id
INNER JOIN Towns t ON a.TownId = t.Id
GROUP BY t.Name, adt.STATUS
HAVING COUNT(a.Id) > 0
ORDER BY t.Name, adt.STATUS ASC