Wednesday, 18 September 2013
  0 Replies
  2.5K Visits
0
Votes
Undo
Hello, I have just installed J!MailAlerts and after setting up everything I get this in the preview:

0 SQL=SELECT a.id,a.title,a.created,a.catid,b.name,b.image FROM ujthj_k2_items as a, ujthj_k2_categories as b WHERE a.catid=b.id AND a.published = 1 AND a.trash=0 AND a.catid IN () ORDER BY created DESC LIMIT 5

Also I want to ask how can I insert this in K2 so that people can insert their email to get updated off the articles?