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 = 365 AND ordtbl.product_id = c.id) WHERE c.status = 'published' AND ph.hierarchy_id = 365 AND c.id != 11199 GROUP BY c.id ORDER BY product_name asc LIMIT 0, 3
Error on delete of '/var/tmp/#sql-temptable-463-1eec69a-1e4a.MAD' (Errcode: 2 "No such file or directory")