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 `rand_val`, `products`.`is_promoted` DESC' at line 18

SELECT DISTINCT `products`.*, `users`.`username` AS `user_username`, `users`.`brand_name` AS `brand_name`, `users`.`supplier_speciality` AS `user_supplier_speciality`, `users`.`id` AS `user_id`, `users`.`shop_name` AS `shop_name`, `users`.`role` AS `user_role`, `users`.`slug` AS `user_slug`, `users`.`is_shop_open` AS `is_shop_open`, (SELECT title FROM product_details WHERE product_details.product_id = products.id AND product_details.lang_id = 1 LIMIT 1) AS title, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1) AS image, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1, 1) AS image_second, (SELECT COUNT(wishlist.id) FROM wishlist WHERE products.id = wishlist.product_id) AS wishlist_count, 0 AS `is_in_wishlist` FROM `products` JOIN `users` ON `products`.`user_id` = `users`.`id` JOIN `category_feature` ON `products`.`category_id`=`category_feature`.`category_id` WHERE `products`.`id` IS NOT NULL AND `users`.`id` IS NOT NULL AND `users`.`banned` = 0 AND `products`.`status` = 1 AND `products`.`visibility` = 1 AND `products`.`is_draft` = 0 AND `products`.`is_deleted` = 0 AND `users`.`role` != 'member' AND ( ( `category_feature`.`feature_id` = '25' OR `products`.`is_organic` = 'Y' ) ORDER BY `rand_val`, `products`.`is_promoted` DESC

Filename: models/Product_model.php

Line Number: 2458