Hi HMED,

You can run the example sql query as below and change the userid, categoryid, email, fullname, created and send_out accordingly:

INSERT INTO `jos_discuss_subscription` (`id`, `userid`, `member`, `type`, `cid`, `email`, `fullname`, `interval`, `created`, `sent_out`, `sort`, `count`, `state`) VALUES (NULL, '706', '1', 'category', '10', 'admin@m.com', 'Super Useraaawd', 'weekly', '2018-02-28 02:49:02', '2018-02-28 02:49:02', 'recent', '10', '1')

Also change the database prefix according to yours

You're suggested to backup, before doing customize beforehand for precaution

Thank you,
we have around 30 members that we want to add to a specific categorie,
the sql querry request more effort then introducing emails one by one on the front end (category > subscribe)

is there another query to subscribe a joomla group members at once ?
So we dont need to introduce emails, names, ids, time ..

thank you again

Hi HMED,

Unfortunately, there is not possible to make a single sql query for subscribe a joomla group members at once.
It might need to write a php script for that to be run