SELECT
                DISTINCT SQL_CALC_FOUND_ROWS `products`.*
                ,
        CASE
            WHEN `products`.`price_prom` < `products`.`price`
                AND `products`.`price_prom` > '0'
            THEN (
                CASE
                    WHEN (`producenci`.`commission` IS NOT NULL AND `categories`.`commission` IS NOT NULL)
                        THEN (`products`.`price_prom` * (1 + (`products`.`commission` / 100) + (`producenci`.`commission` / 100) + (`categories`.`commission` / 100) ))
                    WHEN (`producenci`.`commission` IS NOT NULL AND `categories`.`commission` IS NULL)
                        THEN (`products`.`price_prom` * (1 + (`products`.`commission` / 100) + (`producenci`.`commission` / 100) ))
                    WHEN (`producenci`.`commission` IS NULL AND `categories`.`commission` IS NOT NULL)
                        THEN (`products`.`price_prom` * (1 + (`products`.`commission` / 100) + (`categories`.`commission` / 100) ))
                    ELSE (`products`.`price_prom` * (1 + (`products`.`commission` / 100) ))
                END
            )
            ELSE (
                CASE
                    WHEN (`producenci`.`commission` IS NOT NULL AND `categories`.`commission` IS NOT NULL)
                        THEN (`products`.`price` * (1 + (`products`.`commission` / 100) + (`producenci`.`commission` / 100) + (`categories`.`commission` / 100) ))
                    WHEN (`producenci`.`commission` IS NOT NULL AND `categories`.`commission` IS NULL)
                        THEN (`products`.`price` * (1 + (`products`.`commission` / 100) + (`producenci`.`commission` / 100) ))
                    WHEN (`producenci`.`commission` IS NULL AND `categories`.`commission` IS NOT NULL)
                        THEN (`products`.`price` * (1 + (`products`.`commission` / 100) + (`categories`.`commission` / 100) ))
                    ELSE (`products`.`price` * (1 + (`products`.`commission` / 100) ))
                END
            )
        END AS `price_correct`
            FROM `products`
             LEFT JOIN `producenci` ON `producenci`.`id` = `products`.`producent` LEFT JOIN `categories` ON `categories`.`id` = `products`.`prod_cat`
        LEFT JOIN `features_prod` ON features_prod.prod_id = products.id
        LEFT JOIN `features_opcje` ON features_opcje.id = features_prod.cecha_id
        LEFT JOIN `meta_tags` ON meta_tags.id_prod = products.id






        WHERE (1=1 ) AND `active`= '1' AND `prod_cat` NOT IN (3841, 3840, 3845, 3837, 3700, 3828, 3827, 3821, 3846, 3819, 3842, 3843, 3847, 3788, 3838) AND  (1=1) AND `products`.`id` IN (SELECT `pp`.`id` FROM `products` `pp`  JOIN `features_prod` ON `features_prod`.`prod_id` = `pp`.`id` AND  ( `features_prod`.`cecha_id` IN (3054) )  WHERE `pp`.`active` = 1
                        AND 1=1 GROUP BY `pp`.`id` HAVING COUNT( `pp`.`id` ) >= 1) AND  1=1 ORDER BY `name` DESC
             LIMIT 48,24;