A Database Error Occurred

Error Number: 1064

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 'ORDER BY `i`.`year` DESC, `i`.`month` DESC, `date` DESC, `p`.`hit` DESC LIMIT 6' at line 10

SELECT `p`.`title`, `p`.`post_id`, `p`.`guid`, `i`.`month`, `i`.`year`, `i`.`issue_id`, `i`.`issue_no`, `p`.`content`, `p`.`slug` as post_slug, `p`.`excerpt`, `p`.`thumbnail`, `p`.`slide_show`, `a`.`name` as author, `a`.`slug` as author_slug, `p`.`photographer`, `p`.`post_date` as date, `c`.`name` as category, `c`.`slug` as category_slug, `c`.`id` as category_id FROM (`ecs18_posts` as p) JOIN `ecs18_category` as c ON `c`.`id` = `p`.`category_id` LEFT JOIN `ecs18_issue` as i ON `i`.`issue_id` = `p`.`issue_id` LEFT JOIN `ecs18_author` as a ON `a`.`id` = `p`.`author_id` WHERE `i`.`publish` = 'yes' AND `p`.`status` = 1 AND `p`.`post_id` != '1903' AND ( p.title LIKE "%holi%" ORDER BY `i`.`year` DESC, `i`.`month` DESC, `date` DESC, `p`.`hit` DESC LIMIT 6

Filename: /home/ecscom/public_html/app/modules/web/models/web_model.php

Line Number: 409