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 = 2 AND ordtbl.product_id = c.id) LEFT JOIN cms_module_products_fieldvals FLTtitle_search0 ON FLTtitle_search0.product_id = c.id WHERE c.status = 'published' AND ph.hierarchy_id IN (297,296,295,294,290,293,292,281,275,274,273,271,272,269,270,184,277,289,288,279,287,286,285,284,282,278,182,283,266,267,268,265,181,130,179,178,180,131,322,176,175,321,177,129,172,169,163,165,170,171,198,164,173,168,197,167,166,132,262,261,260,263,259,258,208,186,256,255,254,257,253,252,251,250,144,248,247,246,245,244,249,243,140,241,240,239,238,237,236,235,242,234,233,142,231,230,229,228,227,226,232,153,225,224,139,222,221,220,223,219,218,217,216,325,185,331,330,329,328,327,326,207,136,2) AND ( FLTtitle_search0.value_20 LIKE '%Shakespeare%' OR FLTtitle_search0.value_122 LIKE 'Shakespeare' OR FLTtitle_search0.value_117 LIKE '%Shakespeare%' ) AND (FLTtitle_search0.value_126 = 'English' OR FLTtitle_search0.value_126 LIKE '%"English"%') GROUP BY c.id ORDER BY c.order_stock ASC, c.order_priority ASC, c.create_date desc LIMIT 0, 20
Error on delete of '/var/tmp/#sql_741_0.MAD' (Errcode: 2 "No such file or directory")