FUNCTION webcre_malowanaskrzynia.ss6_pl_calculateProductVariantPriceForUser does not exist
SELECT `ot`.`iProductVariant`, `ot`.`iQuantity`, ss6_pl_calculateProductVariantPriceForUser( NULL, `ot`.`iProductVariant`, 1 ) AS `fPrice`, `ot`.`iFotoliaPhoto`, `p`.`iProduct`, IFNULL( `pv`.`fPriceTimeValue`, `p`.`fPriceTimeValue` ) AS `fPriceTimeValue`, `p`.`iPriceTimeFrom`, `p`.`iPriceTimeTo`, `p`.`iPriceTimeMaxCount`, `p`.`iPriceTimeCount`, IF( `sq`.`sAttributes` IS NULL, `p`.`sName`, CONCAT( `p`.`sName`, ', ', `sq`.`sAttributes` ) ) AS `sName`, `p`.`sWeight`, `p`.`iFotolia`, `v`.`fVatValue` AS `fVat`, `pa`.`sText` AS `sAvailability` FROM `ss6_orders_temp` AS `ot` LEFT JOIN `ss6_pl_products_variants` AS `pv` USING( `iProductVariant` ) LEFT JOIN `ss6_pl_products` AS `p` USING( `iProduct` ) LEFT JOIN `ss6_vat` AS `v` ON( IFNULL( `pv`.`iVat`, `p`.`iVat` ) = `v`.`iVat` ) LEFT JOIN (SELECT IF( ( `products_variants`.`iStock`-`orders_temp`.`iQuantity` >= 0 ), IFNULL( `products_variants`.`iAvailableOnStock`, `products`.`iAvailableOnStock` ), IFNULL( `products_variants`.`iAvailableOutOfStock`, `products`.`iAvailableOutOfStock` ) ) AS `iAvailable`, `iProductVariant` FROM `ss6_pl_products_variants` AS `products_variants` INNER JOIN `ss6_pl_products` AS `products` USING( `iProduct` ) INNER JOIN `ss6_orders_temp` AS `orders_temp` USING( `iProductVariant` ) WHERE `orders_temp`.`iCustomer` = '1741922077633' AND `products_variants`.`iStatus` >= 1) AS `pag` USING( `iProductVariant` ) LEFT JOIN `ss6_pl_products_available` AS `pa` USING( `iAvailable` ) LEFT JOIN ( SELECT GROUP_CONCAT( CONCAT( `sName`, ': ', `sValue` ) SEPARATOR ', ' ) AS `sAttributes`, `iProductVariant` FROM `ss6_pl_products_attributes` LEFT JOIN `ss6_pl_attributes_values` USING( `iAttributeValue` ) LEFT JOIN `ss6_pl_attributes` USING( `iAttribute` ) GROUP BY `iProductVariant` ) AS `sq` USING( `iProductVariant` ) WHERE `iCustomer` = '1741922077633' AND `pv`.`iStatus` >= 1