Concessionari auto Land Rover in Campania

Concessionari Land Rover


Offerte per la tua ricerca

Offerte per la tua ricerca
SELECT CUSTOMER_ID, CITY, LATITUDE, LONGITUDE, STREET, DEEP_LINK,COMPANY_NAME,ZIP, PHONE_NUMBER_1, MAKES ,6371 * ACos(Cos(RADIANS( LATITUDE )) * Cos( RADIANS(41.1099473) ) * Cos( RADIANS(14.8475139) - RADIANS( LONGITUDE ) ) + Sin( RADIANS( LATITUDE ) ) * Sin( RADIANS(41.1099473))) AS Distance FROM active_dealers_it where DEEP_LINK not like 'test' and (6371 * ACos(Cos(RADIANS( LATITUDE )) * Cos( RADIANS(41.1099473) ) * Cos( RADIANS(14.8475139) - RADIANS( LONGITUDE ) ) + Sin( RADIANS( LATITUDE ) ) * Sin( RADIANS(41.1099473)))) < 20 AND MAKES like '%Land Rover%' ORDER BY DISTANCE LIMIT 1000

Concessionari Land Rover