FUNCTION m1012_tge.ss5_lt_calculateProductVariantPriceForUser does not exist
SELECT `ot`.`iProductVariant`, `ot`.`iQuantity`, ss5_lt_calculateProductVariantPriceForUser( NULL, `ot`.`iProductVariant`, 1 ) AS `fPrice`, `p`.`iProduct`, IFNULL( `pv`.`fPriceTimeValue`, `p`.`fPriceTimeValue` ) AS `fPriceTimeValue`, `p`.`iPriceTimeFrom`, `p`.`iPriceTimeTo`, `p`.`iPriceTimeMaxCount`, `p`.`iPriceTimeCount`, CONCAT( `p`.`sName`, ', ', `p`.`sMeasure` ) AS `sName`, `p`.`sWeight`, `v`.`fVatValue` AS `fVat`, `pa`.`sText` AS `sAvailability` FROM `ss5_orders_temp` AS `ot` LEFT JOIN `ss5_lt_products_variants` AS `pv` USING( `iProductVariant` ) LEFT JOIN `ss5_lt_products` AS `p` USING( `iProduct` ) LEFT JOIN `ss5_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 `ss5_lt_products_variants` AS `products_variants` INNER JOIN `ss5_lt_products` AS `products` USING( `iProduct` ) INNER JOIN `ss5_orders_temp` AS `orders_temp` USING( `iProductVariant` ) WHERE `orders_temp`.`iCustomer` = '1711722506814' AND `products_variants`.`iStatus` >= 1) AS `pag` USING( `iProductVariant` ) LEFT JOIN `ss5_lt_products_available` AS `pa` USING( `iAvailable` ) WHERE `iCustomer` = '1711722506814' AND `pv`.`iStatus` >= 1