EXPLAIN SELECT * FROM sub_resume INNER JOIN resume ON ( sub_resume.id_resume=resume.id AND resume.STATUS = '') AND ( (resume.emailaddress LIKE '%[email protected]%' OR resume.id LIKE '%[email protected]%' OR resume.surname LIKE '%[email protected]%' OR resume.REF LIKE '%[email protected]%' OR sub_resume.alinkid LIKE '%[email protected]%' OR sub_resume.REF LIKE '%[email protected]%' OR sub_resume.lastrecord LIKE '%[email protected]%' OR resume.nationality LIKE '%[email protected]%' OR resume.carowner LIKE '%[email protected]%' OR resume.drivinglicense LIKE '%[email protected]%' OR resume.mobile LIKE '%[email protected]%' OR resume.maritalstatus LIKE '%[email protected]%' OR resume.eng_speak LIKE '%[email protected]%' OR resume.thainame LIKE '%[email protected]%' OR resume.name LIKE '%[email protected]%' OR resume.ossystem LIKE '%[email protected]%' OR resume.msoffice LIKE '%[email protected]%' OR resume.internet LIKE '%[email protected]%' OR resume.programming LIKE '%[email protected]%' OR resume.xdatabase LIKE '%[email protected]%' OR resume.othercomputer LIKE '%[email protected]%' OR resume.highschool LIKE '%[email protected]%' OR resume.hist1_jobdesc LIKE '%[email protected]%' OR resume.hist2_jobdesc LIKE '%[email protected]%' OR resume.hist3_jobdesc LIKE '%[email protected]%' OR resume.hist4_jobdesc LIKE '%[email protected]%' OR resume.hist5_jobdesc LIKE '%[email protected]%' OR resume.address LIKE '%[email protected]%' OR resume.hist1_companyname LIKE '%[email protected]%' OR resume.hist2_companyname LIKE '%[email protected]%' OR resume.hist3_companyname LIKE '%[email protected]%' OR resume.hist4_companyname LIKE '%[email protected]%' OR resume.hist5_companyname LIKE '%[email protected]%' OR resume.hist1_typeofbusiness LIKE '%[email protected]%' OR resume.hist2_typeofbusiness LIKE '%[email protected]%' OR resume.hist3_typeofbusiness LIKE '%[email protected]%' OR resume.hist4_typeofbusiness LIKE '%[email protected]%' OR resume.hist5_typeofbusiness LIKE '%[email protected]%' OR resume.qualitysystem LIKE '%[email protected]%' OR resume.otherengineer LIKE '%[email protected]%' OR resume.complocprov1 LIKE '%[email protected]%' OR resume.complocprov2 LIKE '%[email protected]%' OR resume.complocprov3 LIKE '%[email protected]%' OR resume.complocprov4 LIKE '%[email protected]%' OR resume.complocprov5 LIKE '%[email protected]%' OR resume.complocdist1 LIKE '%[email protected]%' OR resume.complocdist2 LIKE '%[email protected]%' OR resume.complocdist3 LIKE '%[email protected]%' OR resume.complocdist4 LIKE '%[email protected]%' OR resume.complocdist5 LIKE '%[email protected]%' OR resume.hist1_positionstart LIKE '%[email protected]%' OR resume.hist2_positionstart LIKE '%[email protected]%' OR resume.hist3_positionstart LIKE '%[email protected]%' OR resume.hist4_positionstart LIKE '%[email protected]%' OR resume.hist5_positionstart LIKE '%[email protected]%' OR resume.hist1_positionend LIKE '%[email protected]%' OR resume.hist2_positionend LIKE '%[email protected]%' OR resume.hist3_positionend LIKE '%[email protected]%' OR resume.hist4_positionend LIKE '%[email protected]%' OR resume.hist5_positionend LIKE '%[email protected]%' OR resume.other1_typeofbusiness LIKE '%[email protected]%' OR resume.other2_typeofbusiness LIKE '%[email protected]%' OR resume.other3_typeofbusiness LIKE '%[email protected]%' OR resume.other4_typeofbusiness LIKE '%[email protected]%' OR resume.other5_typeofbusiness LIKE '%[email protected]%' OR resume.other1_product LIKE '%[email protected]%' OR resume.other2_product LIKE '%[email protected]%' OR resume.other3_product LIKE '%[email protected]%' OR resume.other4_product LIKE '%[email protected]%' OR resume.other5_product LIKE '%[email protected]%' OR resume.hist1_product LIKE '%[email protected]%' OR resume.hist2_product LIKE '%[email protected]%' OR resume.hist3_product LIKE '%[email protected]%' OR resume.hist4_product LIKE '%[email protected]%' OR resume.hist5_product LIKE '%[email protected]%' OR resume.highschool LIKE '%[email protected]%' OR resume.highschool_major LIKE '%[email protected]%' OR resume.university LIKE '%[email protected]%' OR resume.university_major LIKE '%[email protected]%' OR sub_resume.allinfo LIKE '%[email protected]%' OR resume.position1 LIKE '%[email protected]%' OR resume.position2 LIKE '%[email protected]%' OR resume.location LIKE '%[email protected]%' OR resume.saturday LIKE '%[email protected]%' OR resume.salary LIKE '%[email protected]%' OR resume.salary2 LIKE '%[email protected]%' OR resume.phone LIKE '%[email protected]%' OR resume.race LIKE '%[email protected]%' OR resume.religion LIKE '%[email protected]%' OR resume.specialcourse LIKE '%[email protected]%' OR resume.sex LIKE '%[email protected]%' OR resume.engname LIKE '%[email protected]%' OR resume.thainame LIKE '%[email protected]%' OR resume.lastupdate LIKE '%[email protected]%' OR resume.province LIKE '%[email protected]%' OR resume.STATUS LIKE '%[email protected]%' OR resume.lastrecord LIKE '%[email protected]%' OR resume.other1_typeofbusiness LIKE '%[email protected]%' OR resume.other1_product LIKE '%[email protected]%' OR resume.other2_typeofbusiness LIKE '%[email protected]%' OR resume.other2_product LIKE '%[email protected]%' OR resume.other3_typeofbusiness LIKE '%[email protected]%' OR resume.other3_product LIKE '%[email protected]%' OR resume.other4_typeofbusiness LIKE '%[email protected]%' OR resume.other4_product LIKE '%[email protected]%' OR resume.other5_typeofbusiness LIKE '%[email protected]%' OR resume.other5_product LIKE '%[email protected]%' OR sub_resume.lastrecordbl LIKE '%[email protected]%' ) ) GROUP BY sub_resume.id_resume ORDER BY resume.lastupdate DESC