So, my first question would be... What did you try already, so we have a starting point. Just dropping a "I need a query as described below", is maybe not the best way.
Please share you input, so we actually can help you out.
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I need to query some info in Laravel as per the description below;
Model(Standing) -league_id -team_id -overall_league_position
Model(Fixture) -league_id -fixture_hometeam_id (similar to team_id above) -fixture_awayteam_id (similar to team_id above) -fixture_hometeam_ft_score -fixture_awayteam_ft_score -fixture_date -fixture_status
Variables -$a -$b -$c -$d -$e -$f -$g
Query description
Return fixtures -between two dates -with head to head fixtures -with home team fixtures -with away team fixtures -where minimum overall_league_position difference of $a between the teams -where head to head total scores (fixture_hometeam_ft_score + fixture_awayteam_ft_score) is not less than $b for latest $c fixtures -where fixture_hometeam_ft_score is not less than $d for the latest $e fixtures (for both home and away games) -where fixture_awayteam_ft_score is not less than $f for the latest $g fixtures (for both home and away games) -where total scores for the latest $g fixtures for both home and away teams is not less than $f
Please or to participate in this conversation.