Query:
SELECT rn.OE, rn.OE_clear, rn.manufacturerId as manId, m.title as manufacturer, rn.infoRefKT,
rn.oeProductId
FROM tecdoc_reference_numbers rn
INNER JOIN tecdoc_article ta ON ta.id = rn.articleId AND ta.productId = 85210
LEFT JOIN tecdoc_manufacturer m ON m.id = rn.manufacturerId
WHERE 1=1 AND (m.PC = 0 AND m.CV = 0)
ORDER BY m.title, rn.sorting
Error message
Lost connection to MySQL server during query
Trace:
#0 /var/www/vhosts/cesomot.cz/httpdocs/vendor/dg/dibi/dibi/libs/DibiConnection.php(373): DibiMySqliDriver->query('SELECT rn.O...')
#1 /var/www/vhosts/cesomot.cz/httpdocs/vendor/dg/dibi/dibi/libs/DibiConnection.php(261): DibiConnection->nativeQuery('SELECT rn.O...')
#2 /var/www/vhosts/cesomot.cz/httpdocs/application/lib/Model/Dibi.php(60): DibiConnection->query(Array)
#3 /var/www/vhosts/cesomot.cz/httpdocs/application/lib/Model/Tecdoc/Supplier/ReferenceNumber.php(44): Model_Dibi->query(Array)
#4 /var/www/vhosts/cesomot.cz/httpdocs/class/Product.php(1679): Model_Tecdoc_Supplier_ReferenceNumber->findByProductId(85210, 1)
#5 /var/www/vhosts/cesomot.cz/httpdocs/class/Helpers/ProductsSmartyHelper.php(270): Product->getReferenceNumbers(1)
#6 /var/www/vhosts/cesomot.cz/httpdocs/class/Helpers/ProductsSmartyHelper.php(97): Helpers\ProductsSmartyHelper::smartyProductsReferenceNumbers(Object(Product), 1)
#7 /var/www/vhosts/cesomot.cz/httpdocs/class/Helpers/ProductsSmartyHelper.php(540): Helpers\ProductsSmartyHelper::smartyProductCatalogue(Object(Product), false, true, true)
#8 /var/www/vhosts/cesomot.cz/httpdocs/class/Helpers/CatalogueSmartyHelper.php(198): Helpers\ProductsSmartyHelper::smartyProducts(Array, false, true, true)
#9 /var/www/vhosts/cesomot.cz/httpdocs/class/Template/IntroTecdoc.php(72): Helpers\CatalogueSmartyHelper::smartyCatalogue(Object(Page))
#10 /var/www/vhosts/cesomot.cz/httpdocs/class/Template/IntroTecdoc.php(56): Template\IntroTecdoc->getCatalogue()
#11 /var/www/vhosts/cesomot.cz/httpdocs/class/Template/System.php(42): Template\IntroTecdoc->loadTemplateSmartyData()
#12 /var/www/vhosts/cesomot.cz/httpdocs/class/LayoutSmarty.php(30): Template\System->render()
#13 /var/www/vhosts/cesomot.cz/httpdocs/class/Reflex.php(515): LayoutSmarty::render(Object(PageData), 'pt_intro_tecdoc')
#14 /var/www/vhosts/cesomot.cz/httpdocs/index.php(78): Reflex::display()
#15 {main}