Query execution was interrupted
SELECT `pv`.`iProductVariant`, `pv`.`fPrice` AS `fCatalogPrice`, ss13_pl_calculateProductVariantPriceForUser( NULL, `pv`.`iProductVariant`, 1 ) AS `fPrice`, `pv`.`iVat`, `pv`.`TiStock` AS `iStock`, `pv`.`sShortDescription`, IFNULL( `pv`.`fPriceOld`, `p`.`fPriceOld` ) `fPriceOld`, IFNULL( `pv`.`fPriceTimeValue`, `p`.`fPriceTimeValue` ) `fPriceTimeValue`, `a`.`sText` AS `sAvailable`, `a`.`iCanBuy`, `pav`.`sAttribs`, `pf`.`iFile`, `pf`.`sFileName` FROM ( SELECT * FROM `ss13_pl_products_variants` WHERE `iProduct` = 7863 AND `iStatus` >= 1 ) `pv` INNER JOIN ( SELECT * FROM `ss13_pl_products` WHERE `iProduct` = 7863 ) `p` USING( `iProduct` ) INNER JOIN `ss13_pl_products_available` `a` ON( `a`.`iAvailable` = `pv`.`TiAvailable` ) LEFT JOIN ( SELECT GROUP_CONCAT( CONCAT( `av`.`iAttribute`, ':', `av`.`iAttributeValue` ) SEPARATOR ';' ) AS `sAttribs`, `pa`.`iProductVariant` FROM ( SELECT `iProductVariant`, `iAttributeValue` FROM ( SELECT `iProductVariant` FROM `ss13_pl_products_variants` WHERE `iProduct` = 7863 AND `iStatus` >= 1 ) `pvi1` INNER JOIN `ss13_pl_products_attributes` USING( `iProductVariant` ) UNION ALL SELECT `iProductVariant`, `iAttributeValue` FROM ( SELECT `iProduct`, `iProductVariant` FROM `ss13_pl_products_variants` WHERE `iProduct` = 7863 AND `iStatus` >= 1 ) `pvi2` INNER JOIN `ss13_pl_products_attributes_const` USING( `iProduct` ) ) AS `pa` INNER JOIN `ss13_pl_attributes_values` `av` USING( `iAttributeValue` ) GROUP BY `pa`.`iProductVariant` ) `pav` USING( `iProductVariant` ) LEFT JOIN `ss13_pl_products_files` `pf` USING( `iFile` )