1 - Can't create/write to file '/tmp/#sql_1a9d_1.MYI' (Errcode: 28 - No space left on device)
select a1.* from job_posting as a1, job_posting_state as a2 where a1.slno=a2.job_id and a1.mem_slno='734861' and a1.active_status='Y' and a2.city_id='102684' group by a1.slno order by a1.recv_date desc