How to convert raw query into Laravel Eloquent way

Question

I have this raw query. How can i convert this one into Laravel eloquent.

SELECT * FROM `results` AS q
INNER JOIN `answers`AS a ON q.question_id = a.question_id 
AND q.team1 = a.team1 
AND q.team2 = a.team2 
AND q.score1 = a.score1

// Table relationships.
results hasMany answers.
results hasMany predictions.
Prediction is another model here.

results hasMany answers,and answers belongs to results. @BalrajAllam — Khirad Zahra
– Khirad Zahra, Commented Jul 28, 2017 at 7:57

Asim Shahzad · Accepted Answer · 2017-07-28 11:28:13Z

1

As far i understood your question,you can't get relationship with joins.

Please try this query.

 Result::join('results as q', function ($join) {
            $join->on('answers.question_id', '=', 'q.question_id')
                ->on('user_answers.team1', '=', 'q.team1')
                ->on('user_answers.team2', '=', 'q.team2')
                ->on('user_answers.score1', '=', 'q.score1')
                ->on('user_answers.score2', '=', 'q.score2');
        })->get();

Now you can run another query to get relational data.

edited Jul 28, 2017 at 11:28

answered Jul 28, 2017 at 10:33

Asim Shahzad

1,60912 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cong Chen · Accepted Answer · 2017-07-28 08:19:17Z

0

Assume that Result is table results's model:

Result::join('answers', function ($join) {
    $join->on('answers.question_id', '=', 'results.question_id')
         ->on('answers.team1', '=', 'results.team1')
         ->on('answers.team2', '=', 'results.team2')
         ->on('answers.score1', '=', 'results.score1');
})->get();

edited Jul 28, 2017 at 8:19

answered Jul 28, 2017 at 7:55

Cong Chen

2,43615 silver badges22 bronze badges

4 Comments

Khirad Zahra Over a year ago

Thank you for the answer,Can i also fetch relationship along with result. Like with('relation') using above query ?

Cong Chen Over a year ago

What's the relationship between them? Append it to your question.

Khirad Zahra Over a year ago

I have updated the questions,secondly i am getting "1066 - Not unique table/alias: 'answers'" while i run the above command.

Cong Chen Over a year ago

I have edited my answer, may be it works. If not, add table alias as to the first parameter of join method.

Collectives™ on Stack Overflow

How to convert raw query into Laravel Eloquent way

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related