Incorrect key file for table '/var/lib/mysqltmp/#sql_52122_4.MYI'; try to repair it
SELECT DISTINCTROW `attributes`.`iAttribute`, `attributes`.`sName`, `attributes`.`iPosition`, `attributes_values`.`sValue`, `attributes_values`.`iAttributeValue`, `products_attributes`.`const`
FROM ( SELECT `iAttributeValue`, 0 `const` FROM `ss13_pl_products_variants` AS `products_variants`
INNER JOIN `ss13_pl_products_attributes` USING( `iProductVariant` )
WHERE `products_variants`.`iProduct` = 1884
AND `products_variants`.`iStatus` >= 1
UNION ALL
SELECT `iAttributeValue`, 1 `const` FROM `ss13_pl_products_attributes_const` WHERE `iProduct` = 1884
) AS `products_attributes`
INNER JOIN `ss13_pl_attributes_values` AS `attributes_values` USING( `iAttributeValue` )
INNER JOIN `ss13_pl_attributes` AS `attributes` USING( `iAttribute` )
ORDER BY `attributes`.`iPosition`, `attributes`.`sName`, `attributes`.`iAttribute`, `attributes_values`.`iPosition`, `attributes_values`.`sValue`, `attributes_values`.`iAttributeValue`