×

Fout

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 SQL=SELECT DISTINCT (`campaign_id`) FROM `#__bwpostman_campaigns_mailinglists` WHERE `mailinglist_id` IN (0,1,2,3,4) AND `campaign_id` IN ()

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND a.archive_flag = 0 AND a.publish_up <= '2018-11-16 05:37:17' AND (a.publi' at line 4 SQL=SELECT DISTINCT(a.id), a.subject, a.mailing_date, a.hits, a.campaign_id, a.access, a.created_date, a.attachment, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.mailing_date ELSE a.publish_up END as publish_up,publish_down FROM `#__bwpostman_newsletters` AS `a` LEFT JOIN #__bwpostman_newsletters_mailinglists AS m ON a.id = m.newsletter_id WHERE `a`.`published` = 1 AND `a`.`mailing_date` != '0000-00-00 00:00:00' AND (m.mailinglist_id IN (1,2,3,4,-1) OR a.campaign_id IN ()) AND a.archive_flag = 0 AND a.publish_up <= '2018-11-16 05:37:17' AND (a.publish_down >= '2018-11-16 05:37:17' OR a.publish_down = '0000-00-00 00:00:00') GROUP BY `a`.`mailing_date` ORDER BY mailing_date DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 SQL=SELECT id,title FROM `#__bwpostman_campaigns` WHERE `id` IN ()

Date Subject # Clicks