MySQL returned error

Error Description :

Error No : 1021
Description : Disk full (/tmp/#sql_1296a0_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SQL Query
SELECT item.*, item_description.test_parameters AS item_description_test_parameters, item_other_data.id AS item_other_data_id, item_other_data.item_id AS item_other_data_item_id, item_other_data.item_category_ids AS item_other_data_item_category_ids, item_other_data.item_key_fetures_ids AS item_other_data_item_key_fetures_ids, item_other_data.item_department_ids AS item_other_data_item_department_ids, item_other_data.pagewise_test AS item_other_data_pagewise_test, item_other_data.item_diseases_ids AS item_other_data_item_diseases_ids, item_other_data.item_type_id AS item_other_data_item_type_id, item_other_data.description AS item_other_data_description, item_other_data.meta_title AS item_other_data_meta_title, item_other_data.meta_keywords AS item_other_data_meta_keywords, item_other_data.meta_desc AS item_other_data_meta_desc, item_other_data.meta_schema AS item_other_data_meta_schema, item_price.id AS item_price_id, item_price.item_id AS item_price_item_id, item_price.city_id AS item_price_city_id, item_price.state_id AS item_price_state_id, item_price.api_city_id AS item_price_api_city_id, item_price.api_state_id AS item_price_api_state_id, item_price.price AS item_price_price, item_price.mrp AS item_price_mrp, item_price.sch_price AS item_price_sch_price, item_price.sch_start_date AS item_price_sch_start_date, item_price.sch_end_date AS item_price_sch_end_date, item_price.item_certificate_ids AS item_price_item_certificate_ids, item_price.item_lab_ids AS item_price_item_lab_ids, item_price.entry_date_time AS item_price_entry_date_time, item_for_doctors_services_data.id AS item_for_doctors_services_data_id, item_for_doctors_services_data.item_id AS item_for_doctors_services_data_item_id, item_for_doctors_services_data.for_doctors_services_id AS item_for_doctors_services_data_for_doctors_services_id, item_for_doctors_services_data.sort_order AS item_for_doctors_services_data_sort_order, item_for_doctors_services_data.entry_date_time AS item_for_doctors_services_data_entry_date_time FROM item LEFT JOIN item_description AS item_description ON(item_description.item_id=item.id) LEFT JOIN item_other_data AS item_other_data ON(item_other_data.item_id=item.id) LEFT JOIN item_price AS item_price ON(item_price.item_id=item.id) LEFT JOIN item_for_doctors_services_data AS item_for_doctors_services_data ON(item_for_doctors_services_data.item_id=item.id) WHERE item.id!=0 AND (item_for_doctors_services_data.for_doctors_services_id='14' and item.status='Active') GROUP BY item.id ORDER BY item.sort_order ASC limit 0,12