1 - Can't create/write to file '/tmp/#sql_2fa5_0.MYI' (Errcode: 28 - No space left on device)

select a1.product_slno, a1.product_name, a1.short_detail, a1.detail, a1.file_name, a1.small_image, a1.full_image, a1.image_disp_status, a1.small_image_width_height, a1.catalog_slno, a1.product_file_name, a1.water_mark, a1.img_dir, a1.water_mark_img_dir, c1.spam_status from product_tbl a1 INNER JOIN member_classified_trans b1 FORCE INDEX(member_id) ON (a1.member_classified_slno=b1.mem_classified_trans_slno) INNER JOIN product_kword c1 ON (b1.prod_id=c1.prod_id) where b1.member_id='285330' and b1.status='1' && b1.product_detail_status='1' && b1.product_type='2' && c1.spam_status not in(1,3) order by a1.product_name, a1.product_slno desc

[TEP STOP]