mySQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cars.is_active = 1 AND cars.is_deleted = 0 GROUP BY models.id_model OR' at line 5
Error occurred while running query:
SELECT models.id_model, CONCAT(car_types.permalink, '/', models.permalink) AS permalink, models.model FROM cars LEFT JOIN models ON models.id_model = cars.id_model LEFT JOIN car_types ON car_types.id_car_type = models.id_car_type WHERE models.id_brand = 1 AND models.id_car_type = AND cars.is_active = 1 AND cars.is_deleted = 0 GROUP BY models.id_model ORDER BY cars.price ASC - Toyota
ver mapa

  • Matrix
    desde $0.00 MN*
    hasta $0.00 MN*

  • Avanza
    desde $185,800.00 MN*
    hasta $195,400.00 MN*

  • Yaris
    desde $204,800.00 MN*
    hasta $222,000.00 MN*

  • Corolla
    desde $224,100.00 MN*
    hasta $275,400.00 MN*

  • Camry
    desde $315,100.00 MN*
    hasta $401,800.00 MN*

  • Prius
    desde $428,300.00 MN*
    hasta $428,300.00 MN*

  • Land Cruiser
    desde $75,500.00*
    hasta $75,500.00*

  • Rav 4
    desde $293,200.00*
    hasta $360,700.00*

  • Sienna
    desde $381,100.00*
    hasta $647,100.00*

  • Highlander
    desde $418,000.00*
    hasta $530,900.00*

  • Fj Cruiser
    desde $498,000.00*
    hasta $498,000.00*

  • Sequoia
    desde $584,000.00*
    hasta $730,000.00*

  • Hilux
    desde $267,000.00*
    hasta $279,500.00*

  • Hiace
    desde $319,800.00*
    hasta $391,800.00*

  • Tacoma
    desde $375,500.00*
    hasta $410,800.00*

  • Tundra
    desde $456,300.00*
    hasta $565,500.00*

Busque por

Ver todo el inventario