MySQL returned error
Error Description :
Error No : 1021
Description : Disk full (/tmp/#sql_1296a0_1.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 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) WHERE item.id!=0 AND (item.id!=0 and item.status='Active' and item.set_at_home='Yes' and FIND_IN_SET ('19',item.city_ids) and item_price.city_id='19' and (FIND_IN_SET ('3',item_other_data.item_category_ids))) ORDER BY item.sort_order ASC limit 0,8 
