public static function findActive()
{
$pts = PuzzleTemplate::leftjoin('users', 'users.id', '=', 'puzzle_templates.user_id')->selectRaw(self::SELECT_RAW)->where('puzzle_templates.active', 1)->get();
foreach ($pts as $k => $pt) {
$pts[$k]->blackSquares = $pt->blackSquares();
$pts[$k]->clueSquares = $pt->clueSquares();
unset($pts[$k]->id);
}
return $pts;
}
