SELECT * FROM Dealers, DealerFields_Dealers, Dealers_Websites
WHERE CountryShort='ISRAEL'
AND Longitude <> 0
AND Latitude <> 0
AND Dealers_Websites.FK_DealerId=Dealers.DealerId
AND Dealers_Websites.FK_WebsiteId=12
GROUP BY Dealers.DealerId
ORDER BY FK_DealerClassifyId DESC, ZipCode ASC
ISRAEL
SELECT * FROM Dealers, DealerFields_Dealers, Dealers_Websites
WHERE CountryShort='ISRAEL'
AND Longitude <> 0
AND Latitude <> 0
AND Dealers_Websites.FK_DealerId=Dealers.DealerId
AND Dealers_Websites.FK_WebsiteId=12
GROUP BY Dealers.DealerId
ORDER BY FK_DealerClassifyId DESC, ZipCode ASC
