SELECT c.* FROM cms_module_products c INNER JOIN cms_module_products_prodtohier ph ON ph.product_id = c.id LEFT JOIN cms_module_products_hierordering ordtbl ON (ordtbl.hier_id = 8 AND ordtbl.product_id = c.id) LEFT JOIN cms_module_products_fieldvals AS FLT_ORDERING ON FLT_ORDERING.product_id = c.id WHERE c.status = 'published' AND ph.hierarchy_id IN (359,102,101,196,8) GROUP BY c.id ORDER BY c.order_stock ASC, c.order_priority ASC, c.create_date desc LIMIT 1800, 20
Error on delete of '/var/tmp/#sql-temptable-6cce-147279d-107.MAD' (Errcode: 2 "No such file or directory")