A Database Error Occurred

Error Number: 1242

Subquery returns more than 1 row

SELECT `product`.`product_name`, `product`.`product_id`, `product`.`max_order_qty`, `product`.`is_out_of_stock`, `product`.`product_image`, `product`.`order_count`, `product_category`.`product_category`, `product_category`.`product_category_id`, `product_category`.`category_image`, `product_category`.`is_wholesale`, `prod_qty_variant`.`rate_factor`, `prod_qty_variant`.`quantity`, `prod_qty_variant`.`prod_qty_variant_id`, `prod_qty_variant`.`variant_mrp`, `prod_qty_variant`.`is_default`, `prod_qty_variant`.`is_active`, `prod_rate_history`.`prod_qty_variant_id` as `base_qty_id`, (SELECT `prod_rate_history`.`rate` FROM `prod_rate_history` WHERE `prod_rate_history`.`prod_qty_variant_id` = `prod_qty_variant`.`prod_qty_variant_id` AND prod_rate_history.effective_from = (SELECT MAX(`prod_rate_history`.`effective_from`) AS `effective_from` FROM `prod_rate_history` WHERE `prod_rate_history`.`prod_qty_variant_id` = `prod_qty_variant`.`prod_qty_variant_id`)) as base_rate, `prod_rate_history`.`prod_rate_history_id`, `prod_rate_history`.`effective_from`, `product_unit`.`product_unit`, `product_unit`.`unit_abbr`, `product_unit`.`decimal_point`, `product_group`.`product_group` FROM `product` JOIN `product_unit` ON `product`.`unit_id` = `product_unit`.`product_unit_id` JOIN `product_category` ON `product_category`.`product_category_id` = `product`.`product_category_id` JOIN `product_group` ON `product_group`.`product_group_id` = `product_category`.`product_group_id` LEFT JOIN `prod_qty_variant` ON `prod_qty_variant`.`product_id` = `product`.`product_id` LEFT JOIN `prod_rate_history` ON `prod_rate_history`.`prod_qty_variant_id` = `prod_qty_variant`.`prod_qty_variant_id` WHERE `product`.`product_category_id` = '53' AND `product`.`is_active` = 1 AND `product`.`is_retail` = 1 ORDER BY `product`.`is_out_of_stock` ASC, `product`.`product_name` ASC, `prod_qty_variant`.`quantity` ASC, `base_rate` DESC, `product`.`order_count` ASC, `product`.`product_name` ASC

Filename: models/Front_model.php

Line Number: 370