public static function getSitesInfo() { if (null == self::$sitesInfo) { self::$sitesInfo = self::query()->join('Links', 'Links.site_id = Sites.id')->orderBy('linkCounts DESC')->groupBy('Sites.id')->columns(['Sites.id', 'Sites.name', 'Sites.created_at', 'Sites.format', 'linkCounts' => 'COUNT(*)'])->execute(); } return self::$sitesInfo; }