Ligi Populare
@php
$leagues = DB::select('select s.name as sport_name, s.slug as sport_slug, cc.slug as country_slug, c.* from competitions c inner join sports s on c.sports_id=s.id inner join countries cc on cc.id=c.country_id where c.promoted=1 order by c.sports_id, c.id');
$prev = '';
@endphp
@foreach($leagues as $league)
@if($prev!=$league->sport_name)
@if($prev!='')
@endif
@php
$prev = $league->sport_name;
@endphp
{{ $prev }}