Error Number: 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 active=1' at line 1

SELECT *, CONVERT(SPLIT_STR(cant_days_nights, '/', 1), DECIMAL) as days, CONVERT(SPLIT_STR(SPLIT_STR(cant_days_nights, '-', 1), '/', 2), DECIMAL) as horas FROM tours WHERE tour_type IN (1,2) AND id IN (SELECT tour_id FROM tour_destinations WHERE destination_id IN (SELECT id FROM destinations WHERE zone_id=)) AND active=1

Filename: models/Visitchile_model.php

Line Number: 95