Ajuda com count em query com varios campos

Olá a todos.

preciso contar quantos registros tem em determinada cidade em determinada data, a query abaixo esta mostrando 306, e na consulta no mysql mostra 102

>

Citar

consulta no mysql retorna 102

 [SELECT](https://usve112712.serverprofi24.com:8443/domains/databases/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html) * FROM `places` WHERE city_id=5270 [and](https://usve112712.serverprofi24.com:8443/domains/databases/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) submission_date BETWEEN NOW() - [INTERVAL](https://usve112712.serverprofi24.com:8443/domains/databases/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#function_interval) 1 DAY [AND](https://usve112712.serverprofi24.com:8443/domains/databases/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) NOW() ORDER BY `submission_date` DESC

  

 nessa consulta retorna 306

  

 $sql2 = "SELECT  cities.city_name,cities.slug,cities.state, places.city_id as cidade_id,COUNT(places.city_id) As contar,places.place_id,places.place_name,places.description,places.submission_date,places.email,places.jobid,COUNT(subscriptions.city_id),subscriptions.email,subscriptions.city_id FROM cities, places,subscriptions WHERE places.submission_date BETWEEN NOW() - INTERVAL 1 DAY AND NOW()  and cities.city_id=places.city_id and places.city_id=subscriptions.city_id and places.status='approved' GROUP BY subscriptions.city_id HAVING COUNT(subscriptions.city_id) > 1";

>

Citar

agradeço qualquer ajuda.