View difference between Paste ID: xYshiPZw and tDv2iiHV

 SELECT
-sc.id, u.telefono, sc.servicio_id,
+sc.id, u.telefono, sc.servicio_id, (
 SELECT COUNT(mt.id)
 FROM mobi_mensajemt AS mt
 JOIN mobi_contenidomensaje AS co ON co.id = mt.contenido_id AND co.servicio_id = 23
 JOIN mobi_envio AS env ON env.id = mt.envio_id AND env.fecha_envio BETWEEN  '2011-12-19' AND '2011-12-19'
-LEFT JOIN mobi_mensajemt AS mt ON mt.estado = 100 AND u.id = mt.usuario_id
+WHERE mt.estado = 100 AND u.id = mt.usuario_id
-LEFT JOIN mobi_contenidomensaje AS co ON co.id = mt.contenido_id AND co.servicio_id = 23
+
-LEFT JOIN mobi_envio AS env ON env.id = mt.envio_id AND env.fecha_envio BETWEEN  '2011-12-19' AND '2011-12-19'
+)
 FROM mobi_suscripcion AS sc
 INNER JOIN mobi_usuariomovil AS u ON u.id = sc.usuario_id AND u."idEstado" = True
 INNER JOIN mobi_servicio AS s ON sc.servicio_id = s.id
 
 WHERE  sc.servicio_id = 23
-AND env.fecha_envio BETWEEN  '2011-12-19' AND '2011-12-19'
+
 AND sc.fecha_suscripcion < '2011-12-19'
 
 
 GROUP BY sc.id, u.id, s.id
 HAVING COUNT(mt.id) < s.max_mt_day;