function _getPcToNamed() { App::import('Model', 'QualifyingCirculation'); $PrintingCenter = new PrintingCenter(); $pc = $PrintingCenter->query("SELECT \n PrintingCenter.id, \n PrintingCenter.printed_at_id, PrintedAt.city_name, PrintedAt.id, PrintingCenter.membership_id,\n Publication.publication_name, Edition.city_name, Edition.id\n FROM qualifying_circulations as `QualifyingCirculation` \n LEFT JOIN printing_centers as `PrintingCenter` on QualifyingCirculation.printing_center_id = PrintingCenter.id \n LEFT JOIN cities as `PrintedAt` on PrintingCenter.printed_at_id = PrintedAt.id \n LEFT JOIN memberships as `Membership` on PrintingCenter.membership_id = Membership.id \n LEFT JOIN cities as `Edition` on Membership.edition_id = Edition.id \n LEFT JOIN publications as `Publication` on Membership.publication_id = Publication.id\n "); foreach ($pc as $k => $v) { $printingCenters[$v['PrintingCenter']['id']] = "{$v['Publication']['publication_name']} - {$v['Edition']['city_name']} Edition - Printed At {$v['PrintedAt']['city_name']} ({$v['PrintingCenter']['id']})"; } return $printingCenters; }