Untitled

SELECT (SELECT COUNT(*)

  FROM bundles_usage b0_

  WHERE b0_.bundle_id = b1_.id) AS sclr0, b1_.id AS id1, b1_.name AS name2, b1_.username AS username3, b1_.description AS description4, b1_.homepage AS homepage5, b1_.readme AS readme6, b1_.license AS license7, b1_.score AS score8, b1_.scoreDetails AS scoreDetails9, b1_.createdAt AS createdAt10, b1_.updatedAt AS updatedAt11, b1_.lastCommitAt AS lastCommitAt12, b1_.lastCommits AS lastCommits13, b1_.tags AS tags14, b1_.lastCheckAt AS lastCheckAt15, b1_.state AS state16, b1_.nbFollowers AS nbFollowers17, b1_.nbForks AS nbForks18, b1_.isFork AS isFork19, b1_.usesTravisCi AS usesTravisCi20, b1_.travisCiBuildStatus AS travisCiBuildStatus21, b1_.trend1 AS trend122, b1_.composerName AS composerName23, b1_.symfonyVersion AS symfonyVersion24, b1_.indexedAt AS indexedAt25, u2_.id AS id26, u2_.name AS name27, u2_.email AS email28, u2_.gravatarHash AS gravatarHash29, u2_.fullName AS fullName30, u2_.company AS company31, u2_.location AS location32, u2_.blog AS blog33, u2_.createdAt AS createdAt34, u2_.score AS score35, u3_.id AS id36, u3_.name AS name37, u3_.email AS email38, u3_.gravatarHash AS gravatarHash39, u3_.fullName AS fullName40, u3_.company AS company41, u3_.location AS location42, u3_.blog AS blog43, u3_.createdAt AS createdAt44, u3_.score AS score45, b1_.user_id AS user_id46

 

FROM bundle b1_

LEFT JOIN contribution c4_ ON b1_.id = c4_.bundle_id

LEFT JOIN user u2_ ON u2_.id = c4_.user_id

INNER JOIN user u3_ ON b1_.user_id = u3_.id

GROUP BY b1_.id, b1_.name, b1_.username, b1_.description, b1_.homepage, b1_.readme, b1_.license, b1_.score, b1_.scoreDetails, b1_.createdAt, b1_.updatedAt, b1_.lastCommitAt, b1_.lastCommits, b1_.tags, b1_.lastCheckAt, b1_.state, b1_.nbFollowers, b1_.nbForks, b1_.isFork, b1_.usesTravisCi, b1_.travisCiBuildStatus, b1_.trend1, b1_.composerName, b1_.symfonyVersion, b1_.indexedAt, b1_.user_id

ORDER BY sclr0 DESC