SELECT azad.azdname, azad.azdcode, azad.azdfax, azad.azdphone, azad.azdaddress, azad.azdurl, azad.azdemail, azad.azdctcode, ct3.shahrname, ct3.shahrcode FROM (`azad`) LEFT JOIN `ct3` ON `ct3`.`shahrcode`=`azad`.`azdctcode` JOIN `organization` ON `organization`.`ogcode`=`azad`.`azdcode` WHERE `organization`.`markaz_id` = '13401'1