SELECT fuel_calendar_posts.*, fuel_calendar_users.display_name, CONCAT(fuel_users.first_name, " ", fuel_users.last_name) as author_name, YEAR(fuel_calendar_posts.post_date) as year, DATE_FORMAT(fuel_calendar_posts.post_date, "%m") as month, DATE_FORMAT(fuel_calendar_posts.post_date, "%d") as day FROM (`fuel_calendar_posts`) LEFT JOIN `fuel_relationships` ON `fuel_relationships`.`candidate_key` = `fuel_calendar_posts`.`id` AND fuel_relationships.candidate_table = "fuel_calendar_posts" AND fuel_relationships.foreign_table = "fuel_calendar_categories" LEFT JOIN `fuel_calendar_users` ON `fuel_calendar_users`.`fuel_user_id` = `fuel_calendar_posts`.`author_id` LEFT JOIN `fuel_users` ON `fuel_users`.`id` = `fuel_calendar_posts`.`author_id` LEFT JOIN `fuel_calendar_categories` ON `fuel_calendar_categories`.`id` = `fuel_relationships`.`foreign_key` WHERE `fuel_calendar_posts`.`post_date` <= '2018-01-18 07:43:37' AND `date` <= '2018-01-19 00:00:00' AND YEAR(fuel_calendar_posts.date) = 2017 AND MONTH(fuel_calendar_posts.date) = 11 AND DAY(fuel_calendar_posts.date) = 9 AND `fuel_calendar_posts`.`published` = 'yes' GROUP BY `fuel_calendar_posts`.`id` ORDER BY `sticky`, `post_date` desc 9 : Dec : 2017 : Calendar <span></span>

Calendar


There are no posts available.

Make a Donation

Donate Now
Arts Consortium