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!='')