mysql> select username,phone_number,allow_country_code,country_code,created_date FROM whatsapp_api_v2.clients WHERE username = 'balic_analyticswa';
+-------------------+--------------+--------------------+--------------+---------------------+
| username | phone_number | allow_country_code | country_code | created_date |
+-------------------+--------------+--------------------+--------------+---------------------+
| balic_analyticswa | 8657037601 | ^(91)\d+$ | 91 | 2023-09-14 14:56:18 |
+-------------------+--------------+--------------------+--------------+---------------------+
1 row in set (0.00 sec)
mysql> select * from pepipost_whatsapp.trans_whatsapp_config where username = 'balic_analyticswa' AND setting_name in ('client_type','countrycode','country_NSN');
+----------+-------------------+------------+--------------+---------------+---------------------+---------------------+--------+
| clientid | username | ph_number | setting_name | setting_value | added | updated_date | status |
+----------+-------------------+------------+--------------+---------------+---------------------+---------------------+--------+
| 180859 | balic_analyticswa | 8657037601 | client_type | domestic | 2026-01-29 16:21:33 | 2026-01-29 16:21:33 | 1 |
| 180859 | balic_analyticswa | 8657037601 | countrycode | 91 | 2026-01-29 16:21:34 | 2026-01-29 16:21:34 | 1 |
| 180859 | balic_analyticswa | 8657037601 | country_NSN | 10 | 2026-01-29 16:21:34 | 2026-01-29 16:21:34 | 1 |
+----------+-------------------+------------+--------------+--------