Cacher is the code snippet organizer for pro developers

<?php
$tasklist_options['joins'] = array(
  array('table' => 'services',
    'alias' => 'Service',
    'type' => 'inner',
    'conditions' => array(
      'Tasklist.service_id = Service.id'
    )
  ),
  array('table' => 'projects_services',
    'alias' => 'ProjectsService',
    'type' => 'inner',
    'conditions' => array(
      'Service.id = ProjectsService.service_id'
    )
  )
);

$tasklist_options['conditions'] = array(
  'ProjectsService.project_id' => $this->params['url']['project_id']
);

$tasklist_options['order'] = array(
  'Tasklist.name' => 'ASC'
);

$tasklists = $this->Task->Tasklist->find('list', $tasklist_options);