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 86400 AND `tour_ort`.`city` = "7."))) GROUP BY `tour_ort`.`tour_id`' at line 1
SELECT COUNT(`tour_ort`.`tour_id`) AS `counted` FROM `d2m_tour_ort` AS `tour_ort` INNER JOIN `d2m_tour` AS `tour` ON (`tour`.`id`=`tour_ort`.`tour_id` AND `tour_ort`.`is_online`='yes') WHERE ( `tour`.`is_online`='yes' AND `tour_ort`.`datum` >= 1540084313 AND `tour`.`cat` NOT LIKE 'ph' AND ((`tour_ort`.`datum` BETWEEN AND 86400 AND `tour_ort`.`city` = "7."))) GROUP BY `tour_ort`.`tour_id`