New Dealer Signup

SELECT * FROM cars_listings WHERE code != '' AND code IS NOT NULL AND images IS NOT NULL AND images != '' AND REPLACE (REPLACE (LOWER(car_make),' ', ''), '-', '') LIKE '%lexus%' AND REPLACE (REPLACE (LOWER(car_model),' ', ''), '-', '') LIKE '%is%' AND dtc_inventory='Y' AND abm='Y' ORDER BY year ASC LIMIT 0, 100