wut

SELECT SQL_CALC_FOUND_ROWS `p`.*, `pd`.`name`, `pd`.`description`, `media`.`mediaImageId` AS `mediaId` FROM `project` AS `p` LEFT JOIN `project_mediaImageLink` AS `media` ON `media`.`projectId` = `p`.`id` AND `media`.`imageOrder` = 0, `projectData` AS `pd`, `project_competenceLink` AS `link` WHERE `p`.`id` = `pd`.`parentId` AND `p`.`active` = 1 AND `pd`.`active` = 1 AND `p`.`published` = 1 AND `pd`.`languageId` = 1 AND `link`.`projectId` = `p`.`id` AND `link`.`competenceId` = 9 ORDER BY `p`.`id` DESC LIMIT 0,4