List of subscriptions

[indiat]

Hello

Could you please help me to take output of Subscriptions in txt or csv

I want only primary domain names which are listed under subscription...

in domains table subdomain as well as addon domains are also included so i cant use domains table...

any other solution ?

 

[IgorG]

You can use following SQL query for getting this list:

mysql> select name from domains where id in(select object_id from Subscriptions where object_type='domain');