<?php
$query = 'SELECT emmsg_sequencia,emmsg_titulo,emmsg_tipo_mensagem,emmsg_data FROM akmailmkt_10001.TMEMMSG WHERE 1=1 AND emmsg_cliente = 10001 AND emmsg_tipo_mensagem != "S" ORDER BY emmsg_data DESC';
echo preg_replace('/(.*) FROM/i', 'SELECT COUNT(emmsg_sequencia) FROM', $query);
SELECT COUNT(emmsg_sequencia) FROM akmailmkt_10001.TMEMMSG WHERE 1=1 AND emmsg_cliente = 10001 AND emmsg_tipo_mensagem != "S" ORDER BY emmsg_data DESC
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
SELECT COUNT(emmsg_sequencia) FROM akmailmkt_10001.TMEMMSG WHERE 1=1 AND emmsg_cliente = 10001 AND emmsg_tipo_mensagem != "S" ORDER BY emmsg_data DESC