SELECT {__mfp_select__} FROM( SELECT ( `price_tmp` * ( 1 + IFNULL(`p_tax`, 0) / 100 ) + IFNULL(`f_tax`, 0) ) AS `price` FROM(
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 `p2c`.`category_id` IN(5)
) AS `tmp` ) AS `tmp` Women's Blouses
