Ev & Yaşam

SELECT IFNULL( ( SELECT `price` FROM `oc_product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ps.product_id=p.product_id LIMIT 1 ), IFNULL( ( SELECT `price` FROM `oc_product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = 1 AND `pd2`.`quantity` >= 1 LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` , ( SELECT `tr2`.`rate` FROM `oc_tax_rule` AS `tr1` INNER JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'F' LIMIT 1 ) AS f_tax , ( SELECT `tr2`.`rate` FROM `oc_tax_rule` AS `tr1` INNER JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'P' LIMIT 1 ) AS p_tax FROM `oc_product` AS `p` INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` WHERE `p`.`status` = 1 AND `p`.`quantity` > 0 AND `p`.`manufacturer_id` IN(215,225,227,208,67,684) AND `p2c`.`category_id` IN(4524)