SELECT `project`.`id`, `project`.`publish`, `project`.`type`, `project`.`featured`, `project`.`locations`, `project`.`main_image`, `project`.`area`, `project`.`label_nl` AS `label`, `project`.`description_nl` AS `description`, `project`.`body_nl` AS `body`, `project`.`tags_nl` AS `tags`, `project`.`properties_nl` AS `properties`, `project`.`target_nl` AS `target`, `project`.`location_nl` AS `location`, `project`.`youtube_nl` AS `youtube`, `project`.`related_label_nl` AS `related_label`, `project`.`related_description_nl` AS `related_description`, `project`.`related_url_nl` AS `related_url`, `project`.`media_nl` AS `media`, `project`.`created`, `project`.`modified`, `project_partner`.`role_nl`, `project_partner`.`role_en` FROM `project` LEFT JOIN `project_partner` ON project_partner.project_id = project.id WHERE (project_partner.partner_id = ) AND (project.publish = 1) ORDER BY `project_partner`.`id` ASC