1 - Can't create/write to file '/tmp/#sql_8ed_0.MYI' (Errcode: 28 - No space left on device)
SELECT hi.image_name, hi.small_image_name, hi.small_height, hi.small_width, hi.big_height, hi.big_width, hi.image_title, ct.codeID, ct.catgSubCode, ct.zscDisplayName, ct.zscName, ct.zsc_flnm, ct.zsc_tree_name, ct.travel_guide_flnm, ct.package_page_create, cm.content_desc, h.slno, h.capTitle, h.capDesc, h.flnm, h.zsc_city as hotspot_city, cth.package_page_create as hotspot_package_page_create , cth.zscName as hotspot_ctname, cth.zsc_flnm as hotspot_ct_filename, cth.travel_guide_flnm as hotspot_guide_flnm, cth.catgSubCode as hotspot_state_id, lc.* FROM hotspot_category_location_cross lc
left join hotspots_detl h on h.slno = lc.hcl_hotspot_id and lc.hcl_type = 'H' and h.activestatus = 'Y'
left join hotspots_images_tbl hi on lc.hcl_hotspot_id = hi.hotspots_slno and hi.active_status = 'Y' and hi.header_img_status = 'Y'
left join country_tbl cth on cth.codeID = h.zsc_city and cth.city_level = '4'
left join state_city_general_info_master_tbl cm on cm.zsc_city = lc.hcl_city_id and cm.type_id = '1' and cm.general_info_id = '1001'
left join country_tbl ct on ct.codeID = lc.hcl_city_id and ct.city_level = '4' WHERE hcl_cl_cross_id='962' and hcl_status='Y' group by hcl_id order by h.search_volume desc, hcl_display_order desc limit 0, 30