Sitemap


Fedmarket Marketing Emails

SELECT `a`.`newsletter_name`, `a`.`newsletter_node_name`, `b`.*, `c`.* FROM `fmk_newsletters` AS `a` LEFT JOIN `fmk_newsletter_articles` AS `b` ON a.newsletter_id = b.newsletter_id LEFT JOIN `fmk_articles` AS `c` ON b.article_id = c.article_id WHERE (a.newsletter_node_name = 'marketing') AND (c.article_published = 'Y') ORDER BY `c`.`article_published_date` desc