"Disk full (/tmp/#sql_910_0); waiting for someone to free some space..." :: SELECT SQL_CALC_FOUND_ROWS B.*, C.*, G.group_uid, PG.group_uid AS parent_uid FROM kmn_catalog_params_binds AS A LEFT JOIN kmn_catalog_stuff AS B ON A.stuff_id = B.stuff_id LEFT JOIN kmn_catalog_stuff_names AS C ON A.stuff_id = C.stuff_id AND C.languages_id = 1 LEFT JOIN kmn_catalog_groups AS G ON A.group_id = G.group_id LEFT JOIN kmn_catalog_groups AS PG ON G.group_parent = PG.group_id WHERE A.param_id = 10 AND B.stuff_status = '0' AND B.stuff_active = '0' GROUP BY A.stuff_id ORDER BY B.stuff_priority LIMIT 0, 10000