Topbright

SELECT 
                    P.products_id,
                    IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
                    (
                        SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
                    ) manufacturers_name,
                    PD.products_name,
                    P.products_date_added,
                    P.manufacturers_id,
                    P.products_price_text,
					
                    ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
             
                FROM products P
                 LEFT JOIN products_to_categories P2C on P2C.products_id = P.products_id 
                INNER JOIN manufacturers M ON M.manufacturers_id = '1623'  AND P.manufacturers_id = M.manufacturers_id
            LEFT JOIN products_to_manufacturers p2m ON p2m.products_id=P.products_id AND p2m.manufacturers_id=P.manufacturers_id
                JOIN products_description PD ON P.is_exclusive='0'
                AND P.manufacturers_id NOT IN (
                    SELECT manufacturers_id
                    FROM manufacturers_excluidos_por_idioma
                    WHERE profile_id=0 
                        AND language_id=15
                ) 
                AND P.manufacturers_id = '1623' AND PD.language_id = '15' AND PD.publicar = 1 AND P.products_status = '1' AND PD.products_id = P.products_id AND ('15'!='15' OR PD.ya_editado='1')
                
                LEFT JOIN filtros_products fp ON
                    P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
                LEFT JOIN specials s ON 
                    P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
                LEFT JOIN specials svip ON 
                    P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
                
        
                WHERE P.products_type!='4' AND P.products_type!='8' AND P.products_id NOT IN (
            SELECT pa1.products_id
            FROM  products_attributes pa1
            WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
            UNION
            SELECT cp1.parent_products_id
            FROM  products_attributes pa1
            JOIN combined_products cp1 ON
            pa1.products_id=cp1.child_products_id
            WHERE pa1.options_id IN (70) AND pa1.options_values_id IN (1678) AND pa1.active=0
            )
                
                group by P.products_id
                ORDER BY p2m.orderPositionInYourManufacturer, PD.products_id DESC  LIMIT 36