Concesionarios Citroen en Comunidad de Rioja

Citroen


Ofertas para tu búsqueda

Ofertas para tu búsqueda
SELECT CUSTOMER_ID, CITY, LATITUDE, LONGITUDE, STREET, DEEP_LINK,COMPANY_NAME,ZIP, PHONE_NUMBER_1, MAKES ,6371 * ACos(Cos(RADIANS( LATITUDE )) * Cos( RADIANS(36.9450225) ) * Cos( RADIANS(-2.4631181) - RADIANS( LONGITUDE ) ) + Sin( RADIANS( LATITUDE ) ) * Sin( RADIANS(36.9450225))) AS Distance FROM active_dealers_es where DEEP_LINK not like 'test' and (6371 * ACos(Cos(RADIANS( LATITUDE )) * Cos( RADIANS(36.9450225) ) * Cos( RADIANS(-2.4631181) - RADIANS( LONGITUDE ) ) + Sin( RADIANS( LATITUDE ) ) * Sin( RADIANS(36.9450225)))) < 20 and STATE like '%true%' AND MAKES like '%Citroen%' ORDER BY DISTANCE LIMIT 1000

Autohändler in Ihrer Gegend