SELECT * FROM commercial01 LEFT JOIN commercial02 USING(comid)  left join lids on (commercial01.comid = lids.propid and lids.type='com') 
			  left join comcontact on (commercial01.comid = comcontact.comid and comcontact.ctype='1')  WHERE  commercial01.`status`='active' AND commercial01.region = 'm'  AND commercial01.location ='26'   ORDER BY ltype ASC, randomOrder LIMIT 40,-3