Query:
SELECT SQL_CALC_FOUND_ROWS
products.*, pva.name as availabilityText,
IF(pva.position,pva.position,999) as avpos,
CEIL( 100 *
IF(FIND_IN_SET(pl2ct.customers_type_id,products.hidePrice) OR ctypes.hidePrice = 1,
0,
IF(
price_action_from < NOW() AND (price_action_to + INTERVAL 1 DAY) > NOW() AND price_action > 0 AND
price_action IS NOT NULL,
ROUND(price_action * (tax_rate / 100 + 1), 2) * EXP(SUM(LOG(pl2ct.coefficient)))
,
ROUND(IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) * (tax_rate / 100 + 1), 2) *
EXP(SUM(LOG(pl2ct.coefficient)))
)
)
) / 100 AS active_price,
CEIL(IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) * EXP(SUM(LOG(pl2ct.coefficient))) * (1 +
products.tax_rate / 100)) AS price,
EXP(SUM(LOG(pl2ct.coefficient))) as coefficient,
IF(pp2ct.price IS NOT NULL , pp2ct.price, price_EU) AS price_EU
FROM (
SELECT products.*
FROM products
LEFT JOIN
products_to_categories
ON products_to_categories.product_id = products.id
WHERE 1
AND visible = 1 AND productType = 1 AND products.id IN (492644, 493049, 1528526, 1548857, 1548867,
1549035, 1549158, 1549305, 1549429, 1549439, 1549484, 1549604, 492593, 492647, 3148687, 3148823,
3148890, 3283575, 3283585, 3283604, 3283625, 3283719, 3283756, 1738345)
AND base_id IS NULL
GROUP BY products.id ) as products
LEFT JOIN
productAvailability_valueList pva ON products.availability = pva.id
LEFT JOIN
products_to_price_levels ON products_to_price_levels.productId = products.id
LEFT JOIN
price_levels ON price_levels.id = products_to_price_levels.priceLevelId
LEFT JOIN price_levels_to_customers_types AS pl2ct ON pl2ct.price_level_id = price_levels.id AND
pl2ct.customers_type_id = 1
LEFT JOIN customers_types AS ctypes ON ctypes.id = 1
LEFT JOIN
products_prices_to_customer_types pp2ct
ON pp2ct.productId = products.id AND pp2ct.customersTypeId = '1'
GROUP BY products.id
ORDER BY
FIELD(products.id,492644,493049,1528526,1548857,1548867,1549035,1549158,1549305,1549429,1549439,1549484,1549604,492593,492647,3148687,3148823,3148890,3283575,3283585,3283604,3283625,3283719,3283756,1738345)
LIMIT 9,9
Error message
Can't create/write to file '/tmp/#sql-temptable-27f277-7abfaa7-16bf2da.MAI' (Errcode: 122 "Internal (unspecified) error in handler")
Trace:
#0 /var/www/vhosts/zliner.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php(151): Dibi\Drivers\MySqliDriver::createException('Can't create/wr...', 1, 'SELECT SQL_CALC...')
#1 /var/www/vhosts/zliner.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Connection.php(275): Dibi\Drivers\MySqliDriver->query('SELECT SQL_CALC...')
#2 /var/www/vhosts/zliner.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Connection.php(203): Dibi\Connection->nativeQuery('SELECT SQL_CALC...')
#3 /var/www/vhosts/zliner.cz/httpdocs/application/lib/Model/Dibi.php(66): Dibi\Connection->query(Array)
#4 /var/www/vhosts/zliner.cz/httpdocs/class/Catalogue.php(98): Model_Dibi->query(Array)
#5 /var/www/vhosts/zliner.cz/httpdocs/class/Helpers/CatalogueSmartyHelper.php(230): Catalogue->getProducts()
#6 /var/www/vhosts/zliner.cz/httpdocs/class/Template/AdvancedSearch.php(221): Helpers\CatalogueSmartyHelper::smartyCatalogue(Object(Page))
#7 /var/www/vhosts/zliner.cz/httpdocs/class/Template/AdvancedSearch.php(40): Template\AdvancedSearch->getSearchData()
#8 /var/www/vhosts/zliner.cz/httpdocs/class/Template/System.php(42): Template\AdvancedSearch->loadTemplateSmartyData()
#9 /var/www/vhosts/zliner.cz/httpdocs/class/LayoutSmarty.php(30): Template\System->render()
#10 /var/www/vhosts/zliner.cz/httpdocs/class/Reflex.php(575): LayoutSmarty::render(Object(PageData), 'pt_advanced_sea...')
#11 /var/www/vhosts/zliner.cz/httpdocs/index.php(78): Reflex::display()
#12 {main}