SELECT `partner`.`id`, `partner`.`publish`, `partner`.`type`, `partner`.`facebook`, `partner`.`twitter`, `partner`.`linkedin`, `partner`.`url`, `partner`.`main_image`, `partner`.`label_en` AS `label`, `partner`.`description_en` AS `description`, `partner`.`body_en` AS `body`, `partner`.`tags_en` AS `tags`, `partner`.`contact_en` AS `contact`, `partner`.`related_label_en` AS `related_label`, `partner`.`related_description_en` AS `related_description`, `partner`.`related_url_en` AS `related_url`, `partner`.`created`, `partner`.`modified`, `project_partner`.`role_nl`, `project_partner`.`role_en` FROM `partner` LEFT JOIN `project_partner` ON project_partner.partner_id = partner.id WHERE (project_partner.project_id = ) AND (partner.publish = 1) ORDER BY `project_partner`.`id` ASC