[EXEC failed in SQL: INSERT INTO lolashop_tempTbls.tmpVirtCat_8eqrtg0v082j8tg446jof7qig1 SELECT lp.productID, lp.Price, ns.colorNamShort, ns.sizeNamShort, vp.name AS prodNam, lp.enabled FROM lolashop_test.lola_products lp LEFT JOIN lolashop_test.vNew_colorSizes ns ON lp.productID = ns.idProduct LEFT JOIN lolashop_test.vProductProducer vp ON vp.productID = lp.productID WHERE lp.categoryID IN (SELECT categoryID FROM lolashop_test.lola_categories WHERE relation LIKE CONCAT((SELECT relation FROM lolashop_test.lola_categories WHERE categoryID = 135), '%')) UNION SELECT lp.productID, lp.Price, ns.colorNamShort, ns.sizeNamShort, vp.name AS prodNam, lp.enabled FROM lolashop_test.lola_category_product lcp LEFT JOIN lola_products lp ON lcp.productID = lp.productID LEFT JOIN vNew_colorSizes ns ON lp.productID = ns.idProduct LEFT JOIN vProductProducer vp ON vp.productID = lp.productID WHERE lcp.categoryID IN (SELECT categoryID FROM lolashop_test.lola_categories WHERE relation LIKE CONCAT((SELECT relation FROM lolashop_test.lola_categories WHERE categoryID = 135), '%')) ] ( 1213 : Deadlock found when trying to get lock; try restarting transaction )