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_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_description.id AS item_description_id, item_description.item_id AS item_description_item_id, item_description.item_name AS item_description_item_name, item_description.sample_remark AS item_description_sample_remark, item_description.sample_type_name AS item_description_sample_type_name, item_description.sample_remark1 AS item_description_sample_remark1, item_description.test_parameters AS item_description_test_parameters, item_description.prescription_required AS item_description_prescription_required, item_description.required_attachment AS item_description_required_attachment, item_description.from_age_days AS item_description_from_age_days, item_description.to_age_days AS item_description_to_age_days, item_description.gender AS item_description_gender FROM item 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_description AS item_description ON(item_description.item_id=item.id) WHERE item.id!=0 AND (item.id!=0 and item.slug='x-ray-left-hip-frogs-view' and FIND_IN_SET ('1',item.city_ids) and item_price.city_id='1') ORDER BY item.sort_order ASC limit 0,1